We are seeing a sorting issue with the Flexmonster/Highcharts integration. Please see the attached screenshots. We need the "Prospect Status" rows to be in the order set by the "Total Min of Prospect Status Stage Order" column. Flexmonster seems to have the correct order, however Highcharts: Funnel chart sets the order alphabetically. Is this behavior expected?
Hello, Harry!
Thank you for reaching out to us.
Our team agrees that having the chart updated when the columns of the grid are sorted would be useful. Our Dev teem will have a look at the described behavior and will be back to you with an update by the ETA October 27th.
We will notify you about any updates on the matter.
Kind regards,
Solomiia
Hi Solomiia,
Thank you for the update on this issue. After looking further into the problem, I believe it is an issue with setting the active measure and not a sorting issue.
Switching between measures is reflected in the flexmonster chart, but not in the highchart. I found this thread on your forums that seems related to our problem: https://www.flexmonster.com/question/chart-measure-change-event/
We are updating the slice with the active measure based on the dropdown value, however we lose our sort order when do we do this. If this is not something that is supported out of the box could you provide an implementation to get this working? We require this functionality for consistency across our charts.
Thanks!
Harry
Hello, Harry!
Thank you for getting back to us.
Could you please modify the following JSFiddle to make the described case reproducible: https://jsfiddle.net/flexmonster/7aswc931/. With this information, we'll be able to test the case on our end and provide you with further guidance.
Looking forward to hearing from you.
Kind regards,
Solomiia
Thank you for the update! Please see our implementation here: https://jsfiddle.net/htnuxgzo/
You can reproduce the issue by:
1. selecting a chart from the Charts dropdown
2. Switching the Measure from "Sum of Primary Email" => "Min of Prospect Status Stage Order"
3. Switching the Measure back from "Min of Prospect Status Stage Order" => "Sum of Primary Email"
You will see that the Funnel chart no longer has the correct order and the sort order is now Alphabetical. "Admitted" datapoint is now on top. Please see the attached screenshot.
Thanks!
Hello, Harry!
Thank you for providing a JSFiddle and steps to reproduce the case.
Our Dev team will take a look at the described behavior and get back to you within the mentioned ETA, October 27th.
We will notify you about any updates on the matter.
Kind regards,
Solomiia