Want to add year prefix beside month column

Answered
Mohammed Affan asked on February 19, 2024

As you can see, It starts a 12-month cycle when the month aggregator is selected which is correct but we are not able to distinguish which year this month is for. Can we add a year prefix besides the month for example ( January 2023 +Day) based on the data? Just need this flexibility for columns.

Thanks in advance

3 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster February 19, 2024

Hello, Mohammed!
 
Thank you for reaching out to us.
 
Kindly note that it is possible to add a year to the month header captions using our customizeCell API call. Using the year/month/day date formatting, the information about the year on a month level is stored in data.member.parentMember property in your customizeCellFunction.
 
We have prepared the JSFiddle example to illustrate the idea: https://jsfiddle.net/flexmonster/zr0jd6Lo/
 
Hope you will find our answer helpful.
Feel free to contact us if any further questions arise.
 
Kind regards,
Solomiia

Public
Mohammed Affan February 20, 2024

This helps, much appreciated. Just one more thing, this won't reduce the performance, right? 
Best,
Affan

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster February 20, 2024

Hello, Affan!
 
Thank you for getting back to us.
 
Kindly note that the performance shouldn't be impacted while using customizeCell.
If you need an alternative approach to customizeCell, our team can suggest preprocessing your data and adding a year number to the month name before inserting data into Flexmonster.
 
Hope it helps.
Feel free to reach out to us in case of any other questions.
 
Kind regards,
Solomiia

Please login or Register to Submit Answer