I am trying to create a heatmap with a custom sort for x-axis values. In this example, the x-axis values are weather conditions and have similar names.
For instance, I want to show "Partly Cloudy," "Cloudy," and "Mostly Cloudy" next to each other, as well as "Light Snow," "Snow," and "Heavy Snow" (preferably in that specific order, although any solution that properly lumps them together would be sufficient).
To do this, I attempted to create a Split Chart with Sub Aggregation "Filters," where I could define values like "Cloudy," "Sunny," "Snow," etc. (think of these like the "root" word or condition). I then attempted to use a "Terms" Sub Aggregation for the X-Axis to show the values.
Unfortunately, it seems I am forced to show all terms for all filters, even when they don't apply. Regardless whether I choose "Rows" or "Columns" for the Split Chart configuration, there's a lot of dead space. ("Columns" seems to be a slightly better fit, as it doesn't force the y-axis to be repeated.)
Is it possible to ONLY show the x-axis labels for terms that are found within the filter subset? Is there another way for me to manually sort the Terms?
In the above picture, I am looking to only show the columns in green.
I also tried to use some sort of modified "Order By" criteria, but they seem to be too limiting for my needs. An alphabetical sort could potentially work if it allowed me to sort on the second word (as defined by a preceding space).