What is the problem or goal the end user is trying to solve or accomplish?
The user wants the X-axis formatting on charts to dynamically adjust based on the time grain selected in the dashboard's Time Grain filter. For example, when selecting "Quarterly," the X-axis should automatically display aggregated quarters (e.g., Q1, Q2) rather than individual months or other irrelevant groupings.
How are they solving it currently?
The user attempted various configurations in the Time Format field (e.g., `%q - %Y`, `FY %Y Q0%q`) and is using a dashboard Time Grain filter, but none of these approaches dynamically change the X-axis format. The current setup only statically applies one format, regardless of the time grain selected.
What is the recommended solution by the Customer?
Implement a feature where the X-axis dynamically adapts to the selected time grain filter.
For example:
- "Daily" -> X-axis shows specific dates (e.g., "2024-11-01").
- "Monthly" -> X-axis shows months (e.g., "Nov 2024").
- "Quarterly" -> X-axis shows quarters (e.g., "Q1 2024").
- "Yearly" -> X-axis shows years (e.g., "2024").