Improve Sort Options for Chart Widget

276
0
07-21-2022 11:55 AM
Status: Open
Labels (1)
AmyRoust
Occasional Contributor III

I just created a line chart that shows total cases of West Nile Virus by month. Unfortunately, there is no way to sort in month order if my field names are text fields. My choices are to either sort the months alphabetically or by the case count. Neither makes sense - we want to show the summer peak in cases.

AmyRoust_0-1658429671835.png

 

For now, I will use the month numbers, but that's not as friendly to the public. If there were a way to add in aliases, that would resolve the issue.