Custom Ordering on Row / Column Headings

Answered

Hi there
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 🙂

4 answers

WebDataRocks Team WebDataRocks November 22, 2019

Hello, John,
 
Thank you for your question.
 
You can get your fields sorted by the date setting their type to date string.
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 options object.
In your case, the object should look similar to the one below:

options: { 
datePattern: "MM-yyyy"
}

Please, check out an example we made for you.
 
Kind Regards,
WebDataRocks Team

John Main November 22, 2019

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…

WebDataRocks Team WebDataRocks November 25, 2019

Hello, John,
 
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 slice object.
Find out more about the property by following the link: https://www.flexmonster.com/api/slice-object/.
 
Regards,
WebDataRocks Team

John Main November 26, 2019

Ah cool, thanks again for your replies. I’ll have a look at the premium product!
Cheers 🙂