Custom Ordering on Row / Column Headings
Does anyone know if there is a way to do custom ordering on the headings in a row / column? I’m trying to display date-based data with headings of the form ‘month / year’ and I can’t get them in the correct order no matter what I try!
Thanks in advance 🙂
Thank you for your question.
You can get your fields sorted by the date setting their type to
Learn more about data types by the link: Data types in JSON.
Please consider that he input values of dates have to be compliant with ISO 8601 – The International
Standard for the representation of dates and time. For example, “2018-01-10” (date) or “2018-01-10T08:14:00” (date and time).
If you desire to display only the month and year of the date, you can adjust it through the
datePattern property of the
In your case, the object should look similar to the one below:
Please, check out an example we made for you.
Thanks Illia that worked like a charm! Thank you so much 🙂 This is such a wonderful tool!
Up for a slightly more tricky one? In another report I also have a set of Statuses that I’m totalling, and these are Grey, Green, Yellow, Amber and Red. Any way to get them to display in that order, rather than alphabetical? All I can think at the moment is to give them a numerical prefix…
Thank you for your feedback.
The described feature is not implemented in WebDataRocks current version. We recommend checking out Flexmonster Pivot, which is the premium product developed by the same team.
Flexmonster provides custom sorting through the
sortOrder property of the
Find out more about the property by following the link: https://www.flexmonster.com/api/slice-object/.
Ah cool, thanks again for your replies. I’ll have a look at the premium product!