Is there a way to have a pyramid visual sort by the name of the value instead of the quanitity value itself? For example, we want to show that for a top level metric, we are out of what should be the normal. (Our top level value is higher than the ones below it, which is not how it should be.) I essentially want the order to be ordered, level 1, level 2, level 3, level 4, level 5 regardless of the actual quantities of each of those.
Is that possible?
Please refer to the below answer.