Sorting Fields in a Serial Chart
%20-%20Copy.png "JasonCyphers"){kind=avatar}
Is there a way to sort a dashboard's series chart that contains categories from fields?
I have a Survey123 form with a multi select field called Hazards. I then created an attribute in the database for each selection. Within the Survey123 form, I hid those attribute fields and created calculations to populate them with a 1 or 0, based on the Hazard being included in the Hazards selection. I then created a dashboard to show those individual attribute fields and the number of times they were included in the multi-select Hazards. I'd now like to be able to sort them by record count (highest to lowest) and alphabetically, but don't see any sort option in the chart's configuration. I'm assuming there isn't one, and the sorting is just based on what order you add the fields?
