Tip of the Week : Moving Calculation

Tip of the Week : Moving Calculation

With some datasets, you may find it difficult to comprehend the general trend. This is because the data points can fluctuate widely. Take for example website page visits, ad impressions, or stock prices. They vary continuously, and this is where Moving Calculation can help you see the trend more easily. 



Moving Calculation averages the values over a specified time span, with a more smooth curve. The below recording shows how you can create a 30 day moving average curve.



The summary function selected will be taken as the base for calculation. You can choose the usual Sum, Average, Minimum and Maximum functions for Moving Calculation too, with Average being the most used function.



      Zoho SalesIQ Resources



            Zoho TeamInbox Resources

              Zoho DataPrep Resources


                  Zoho CRM Plus Resources

                    Zoho Books Resources


                      Zoho Subscriptions Resources

                        Zoho Desk Resources

                          Zoho Projects Resources


                            Zoho Sprints Resources


                              Qntrl Resources


                                Zoho Creator Resources


                                  Zoho WorkDrive Resources




                                      Zoho Campaigns Resources

                                        Zoho CRM Resources

                                                    Design. Discuss. Deliver.

                                                    Create visually engaging stories with Zoho Show.

                                                    Get Started Now


                                                      Zoho Show Resources


                                                        Zoho Writer Writer

                                                        Get Started. Write Away!

                                                        Writer is a powerful online word processor, designed for collaborative work.

                                                                  有料プランをご利用の方