Bar chart dashboard sorting broken

🔧 Bugs & Issues
1

Hi all,
I just want to report a bug I found regarding the dashboard bar chart report. The Field order sort option is not working properly (it is not showing the proper field order).

I found this doing the following.
I created a Single select field with six options (initially). Let’s say:

  1. option 1 = 100
  2. option 2 = 200
  3. option 3 = 300
  4. option 4 = 400
  5. option 5 = 500
  6. option 6 = 600

Then I created a bar chart dashboard report. I chose these options:

  • View = specific view
  • Field = Single select field mentioned above
  • Group by = another Single select field with three options
  • Sort = Field order
  • Group limit = 15 to allow for some room (just in case)
  • Hide empty records unchecked
  • Include empty records checked
  • Group others unchecked
  • Subgroup by Single select field mentioned above
  • Orientation Horizontal
  • Bars Grouped

Everything works as expected.

I then added a couple of options to the initial Single select field. Let’s say:

  • option 4.5 = 450
  • option 5.5 = 550

I reorder properly the original Single select field. So the Single select field that I originally created now looks like this:

  1. option 1 = 100
  2. option 2 = 200
  3. option 3 = 300
  4. option 4 = 400
  5. option 4.5 = 450
  6. option 5 = 500
  7. option 5.5 = 550
  8. option 6 = 600

Now, even if I create again the report again or if I change vertical and horizontal orientation the field order is not respected getting this:

  1. option 1 = 100
  2. option 2 = 200
  3. option 3 = 300
  4. option 4 = 400
  5. option 5 = 500
  6. option 6 = 600
  7. option 4.5 = 450
  8. option 5.5 = 550

I get this both in the graphs themselves and in the label.


Thanks a lot.
Best,
R.J.