Hello, Anyone know if you are able to have attributes stay ordered by their original values rather than switching to the order of their label values. For example, I want the "date label" chart on the bottom to be in the order of the "date" chart on top. Otherwise, months appear in the wrong order. I know I could change "date label" to be numbers like "2024-01" instead of "Jan 2024", but it wouldn't look as nice. Primary goal is having the ability to use a drop-down to switch all trend charts from quarterly to monthly or vice version. I know we could use the "visualization switcher" but if there are numerous charts in a dashboard you'd have to switch each of them manually. The only other solve for this would be if the "visualization switcher" also saved the charts selected based on what option was selected when the "view was saved" but that currently isn't a feature/capability within GoodData.

Hello, you can use “Sort by” in modeler to select column for an attribute which will be used for ordering of attribute values. See https://www.gooddata.com/docs/cloud/model-data/evolve-your-model/manage-labels/#sort-labels. Note that columns with date or timestamp type can be mapped to date dimensions with date attributes for which their textual representation is available and chronological ordering is working out of the box.

@Jakub Zigardy oh awesome. that was easy. thank you! working as I was wanting now.

Thanks for the praise, but it should have been @Jakub Sterba 😄

doh 🤦 thank you @Jakub Sterba!

I was referring to use of date datasets for which attributes like Month or Quarter are ordered chronologically and which support also comparison with the same periods in previous year etc. I suppose that is what you have used in the second visualization (GoodData Date). This however does not solve the problem of choosing attribute for breakdown (Month or Quarter) dynamically based on user input. Visualization switcher is probably the only option or you would need to use not only custom attributes but also custom transformation in ETL to calculate previous period values. Btw. would it make sense to you to have option ‘auto’ for “group by” of Date and automatically chose the Date attribute based on applied date range filter? E.g. to use attribute “Month” for filter “Last 12 months” or attribute “Quarter” for filter “Last 4 Quarters” or attribute “Date” for filter “Last 30 days” or “Date” for filter “Last Month”, etc.?

thank you for clarification. think that will be the route we go. it would make sense that it would 'auto' group by based on the date attribute from the date range filter or at least have some setting to select this.

Maybe also dashboard tabs on our roadmap can help with this use case in future. You would be able to create one tab with breakdown per month and other with breakdown per quarter for example.

🎉 New note created.

@Jakub Sterba is there a way to see where the dashboard tabs request is in the roadmap? Our account rep mentioned it was coming soon, but I haven't heard any updates. Thank you.