Hello,
Unfortunately, the bar charts in reports and dashlets are sorted alphabetically.
Is there a trick to sort them by bar size?
Any tips or workarounds would be greatly appreciated!
Thanks
Steffen
Hello,
Unfortunately, the bar charts in reports and dashlets are sorted alphabetically.
Is there a trick to sort them by bar size?
Any tips or workarounds would be greatly appreciated!
Thanks
Steffen
Hi Steffen,
Since sorting bars is a kind of post-processing of reported data, we would consider three options to deliver the expected:
- code - provision of a custom dashlet developed by our team
- nocode - preparing values using calcfields or LogicBuilder flowcharts (the choice depends on the complexity of the calculation) rather then calculating with reports, and then setting a sorting order based on the calculated values prior to using out-of-the-box report dashlets to visualize the results - ensuring the bars appear in the desired order
- other tool - using BI tools instead of out-of-the-box reporting
Best Regards,
Dmytro Chupylka
integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
Thank you very much, Dmytro Chupylka .
With Andre's tip, I was able to implement it very easily.
All the best!
Steffen
Thank you very much, Dmytro Chupylka .
With Andre's tip, I was able to implement it very easily.
All the best!
Steffen