Time series X-axis inconsistent date formatting

AijaRe
Kilo Sage

Hello!
I am using Time Series Data Visualization in HR Agent Workspace.
The X-axis labels are inconsistent - some show full month names and other are abbreviated (e.g., November 2024 - Dec 2024...).
It doesn't even seem related to available space, if I squeeze or stretch the report, the labels stay the same.
Is there any way to fix this to be more uniform and show all the labels abbreviated?
Or is this an SN bug and there is nothing to be done?

AijaRe_1-1738260362508.png

Thank you!

 

 

1 ACCEPTED SOLUTION

AijaRe
Kilo Sage

Apparently there is a solution.
Report X-axis texts are stored in the table sys_ui_message
And it is missing some records OOTB, also others are not correctly configured.

For example, adding a record with key "sep" and value "Sep" fixed the september display.

AijaRe_0-1739439390217.png


For some reason November is mapped to "NOV", also probably depends on the instance version.
But anyways the X-axis texts are there and it is possible to change them (be mindful that this impacts the whole instance in other places).

View solution in original post

4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @AijaRe 

 

Look like it is bug, i tried by changing the properties but it did not work:

AGLearnNGrow_0-1738265402045.png

 

Alternative instead of standard calendar use the Georgian calendar.

AGLearnNGrow_1-1738265455584.png

 

 

Else log a case.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG , than you for the comment and suggestions.
Could you please indicate how I can switch the calendar in UI Builder Data Visualizations?
I checked all UI Setup docs for Timeseries and can't find a word about calendars.
Thank you!

Hi @AijaRe 

 

Greetings!!

 

Correct, there is no way to change the calendar in Data visualization. Need to take this as it is. Or log a now support case.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

AijaRe
Kilo Sage

Apparently there is a solution.
Report X-axis texts are stored in the table sys_ui_message
And it is missing some records OOTB, also others are not correctly configured.

For example, adding a record with key "sep" and value "Sep" fixed the september display.

AijaRe_0-1739439390217.png


For some reason November is mapped to "NOV", also probably depends on the instance version.
But anyways the X-axis texts are there and it is possible to change them (be mindful that this impacts the whole instance in other places).