We posted about enhancements done to the pivot table recently in Zoho Analytics. Here’s more. Pivot tables (and charts, filters) now support quarterly and weekly intervals. This adds to yearly, monthly intervals before. This can be best explained in the sales context. What if you want to know how you did in 1Q 2009 Vs 4Q 2008 (previous quarter) or 1Q 2008 (previous year, same quarter)? Or what if you want to know how you did this week compared to last week or see the trends of the earlier weeks? It is easy now to have reports for such scenarios.
The screenshot above is for the Actual Values – Quarter & Year, sales in various quarters of each year. Seasonal/Cyclic – Quarter option differs from this as it will give the sum of Quarterly Sales summed across years.
Similarly, the Weekly option is available too. Sales figures of different regions for the various weeks in 2008 shown as a Pivot table.
The same quarter & week concepts are available in Charts and Summary Views.
You can also Filter the data using Quarter and Week timelines.
Try the new Quarterly & Weekly options in Zoho Analytics and let us know your feedback in the comments.
Related Links
- Screencast : How to create a Pivot in Zoho Analytics
- Screencast : How to create a Chart in Zoho Analytics
- Sales Analysis with Zoho Analytics
Previously I used this fuction but on a recent table, I don't get the Monthly, Yearly (date related) options coming up. It just offer Actual values and displays the data by each date. What do I need to do to have the options come up again? This is table I hade used previously, so the date is in the correct format. Thanks