One challenge I frequently encounter is the need to create multiple versions of the same report—one for yearly data, another for quarterly data, another for monthly, and so on. While this works, it leads to unnecessary duplication, making maintenance cumbersome. A simple tweak to a report requires updating all versions individually, adding to the workload.

To streamline this, I propose a User Filter for Date Dimensions, allowing users to dynamically switch between different time granularities (e.g., Year, Quarter, Month) within a single report.

The Current Challenge

1. Report Duplication and Maintenance Overhead: Currently, to view the same data at different time levels (e.g., yearly vs. quarterly), multiple reports need to be created and maintained separately across all variations.
2. User Experience: Switching between time granularities requires opening different reports instead of simply toggling within the same report.
   

Zoho should introduce a User Filter that allows users to dynamically change the time granularity within a report. The filter would function similarly to existing user filters but would control the aggregation level of the date field.

1. Dropdown Selection: Users can select the desired time granularity (Year, Quarter, Month, Week, Day) from a predefined filter.
2. Single Report Maintenance: One report can serve multiple needs, reducing duplication and simplifying updates.
   
3. Consistent Data Presentation: Users can interactively explore data at different levels without navigating between reports.
   

Imagine a sales performance dashboard where users typically view revenue by Year but occasionally need to drill down to Quarterly or Monthly trends. Instead of maintaining separate reports, a single report could include a “Date Granularity” filter, enabling seamless toggling between time periods.