Misalignment of chart y-axis values and x-axis groups

Questions
1

I am trying to create some seemingly simple charts in my application, have tried multiple chart plugins but keep hitting the same problem. My “events” data set has multiple fields. For the x-axis of my chart I want to use field “status”, of which there are 8 variations. On the y-axis I want a count or sum of another field dependant on the type. using dynamic expressions I can generate a chart (line or bar) that has the correct y-axis values for each of the eight groupings on the x-axis.
However, the “statuses’” on the x-axis are displayed in alphabetical order but I need them in a specific order. I can use a static list or option set to successfully order the x-axis. but when I do this the y-axis values are misaligned.

Can anyone help?

2

You can add a index field in the database and then you can sort with those values.

3

Thanks for the reply. I have tried using an index field in the database and in an option set without success.

4

I can help you if you share your app

5

I appreciate your offer of help. I am testing the feature outside of my app but will share the feature test area with you.

1 Like