Thanks David and Jeff. After several emails, I have a solution that does not require extra formulas or metric sets, just a few odd configurations. Also, due to the data set type, there isnât really any quantitative measures to set Sum formulas on, as it is text records.
The data set is a list of quality issues for the company. I wanted to create a stacked bar that showed the number of issues by type with colors showing the different divisions.
Essentially, this:
Started with a simple bar chart
Then go to Visualization, and add Division to Color. Revisualize as a Stacked Bar, and Delete Division from Horizontal Axis (which is auto added when you add it to Color).
Now I can sort on Count Measure as expected.
The last bit is the Total label. I have to go to the Properties, Count Measure, Text, and add a Data Point Label.
For Text, there is an auto-generated [Total] field now. This adds a cumulative total running up the bar. Which is a step in the right direction, but I just want to have the totals.
In order to do this, I needed to configure some of the Layout setting for the data label. Change Placement to Outside, Outside Alignment to Top, Max Move Distance to 0, and ensure âCan Overlap Dataâ is not checked. This essentially forced the subtotals to be hidden by the data.
Hopefully this helps some other folks in the future.