Hey team - on heatmaps, is there a way to add cust...
# gooddata-cloud
s
Hey team - on heatmaps, is there a way to add custom ordering to the items on the X/Y axis, or is alphabetical order the only option at this time?
k
In the GoodData UI, there is no direct drag-and-drop or arbitrary custom ordering option built into the visualization interface [Community Slack]. By default, sorting for visualizations like heatmaps supports alphabetical (A–Z / Z–A), numerical, and chronological options [Sort Data in Visualizations]. However, you can achieve custom ordering for your axis items using data modeling: 1. Add a sort-order/ranking column in your data source: Add a numeric column in your database table that maps each attribute value to your desired sequence (for example,
1
,
2
,
3
, etc.) [Community Slack]. 2. Configure the attribute sort label in GoodData Modeler: In the Data Modeler, click the button next to your attribute, select Sort by…, and choose your numeric sort column (ascending) [Community Slack]. 3. Save and publish the model: The attribute will now display in your exact custom sequence across your visualizations, including heatmaps [Community Slack]. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups. 👀 Our Support team monitors all messages and will jump in if needed.
s
Hi Sam, Heatmaps in GoodData Cloud don't support drag-and-drop reordering directly in the UI - sorting there is limited to alphabetical, numerical, or chronological. That said, you can still get a fully custom order for your axis items: 1. Add a sort-order (ranking) column to your data source 2. In the GoodData Modeler, set that column as the "Sort by" label for the attribute 3. Save and publish the model Once published, the custom order applies everywhere that attribute is used, including your heatmap. More details here: - Sort labels: gooddata.com/docs/…/manage-labels#… - Sort data in visualizations: gooddata.com/docs/cloud/create-visualizations/sort-data-in-insights
gratitude thank you 1