Please find attached my sample data and QVF file. All requirements were implemented as expected:
Users can only select one time frame (Year, Month-Year, Week, Day) using the interactivity setting, allowing removal and selection flexibility.
On opening the sheet, the Month-Year filter automatically selects completed months (e.g., July-2025).
The chart displays a 12-month rolling period using completed months by default, with dynamic dimension switching based on selected time frame. The lowest granularity chosen by the user drives the chart dimension, handled via calculated dimensions and set analysis expressions.
Current Issue: After a user logs in and selects a month (e.g., July-2024) in chart, chart logic works correctly. However, if they clear filters and select a new month (e.g., February-2024) in the chart, the chart dimension reverts to a cached value (week start date of July-2025) instead of updating properly. Please advise on resolving this caching issue.
