I'd love for Ops Dashboard to have the ability to re-order categories in Serial Charts?
Currently, we're able to sort categories. But, unable to categorise them manually.
By sorting ascending as shown in my screenshot, I get bars showing High, Low, Medium or I can switch to a descending sort for Medium, Low, High but neither of those orders is as desirable as the more reasonable order of Low, Medium, High which isn't possible with a text sort.
The data is coming from another business system that my team doesn’t control so editing the schema is not an option.
Status are: High, Medium, Low, however in the dashboard we see
Unfortunately, sorting in charts is not always an option. As shown below, when your categories are from a date field (which does sort appropriately), and the data is split by a field, sorting the series is not an option.
And unfortunately, the order seems to be random. For example, the following two images are the same chart with the fiscal year filtered based on a category selector applied to the page. For one fiscal year, they're sorted one way, with the Total Intake being at the top of the stacked bars (preferred and intuitive ordering), but for another fiscal year, the Owner Surrendered number (which is a separate field and a portion of the Total Intake) is shown at the top of the stacked bars. Being able to sort the series manually or in some logical order would prevent misleading information in the dashboards.
Series sorted appropriately for one fiscal year selected:
Order of series changed in same chart with different fiscal year selected
Expanding on Sarah's reply. I found a way to sort my series data. My first bar chart:
2nd bar chart:
I added another sort feature (and also the only option they gave me for a second sort feature). Now, my categories are already in a good numerical order (0 lowest - 5 highest) so it worked out.
I’m having the same issue...age groups are being machine sorted.... as an example age 4-5 is graphed right next to age group 45-46 ..open to suggestions
Retrieving data ...