How to show dates for timeseries line graph trend by date? (In platform Analytics Dashboard)

Navaneeth1
Tera Guru

I had a core UI Report, which was a Time Series Line graph where the trend was done based on CRs Opened date, and the trend would be by week.

In the Core UI report, this would show the beginning of each week on the x-axis and show each week where tickets were created.

I tried to create a similar report in platform analytics, and instead of the date of the starting week, it's showing W1 2026, W2 2026, etc. on the x-axis. I tried the trend by date instead of week, but then the x-axis shows varying dates, and that too it's also showing dates whenCRs were not even created. 

Is there a way to trend by week in the platform analytics report and it show starting of the week instead of W1, W2 etc and is there a way to not show anything in the x-axis for times when no CRs was created. In the Core UI reports only weeks where tickets were created would be shown in the x-axis. Has anyone found a way around this problem?

I've added two screenshots, The new one defines my problem of showing weeks as W1, W2 etc and the old one shows week beginning dates and also doesn't show weeks where no new CRs were created. 

Thank you in advance! 

8 REPLIES 8

Hey @Dr Atul G- LNG 

In the configuration, there will be a section for Trend by where you select the date field that will be used in the graph. We have the option to trend by date, week, day, month etc. What you have shown is a trend by date (it's good, but you see dates that don't have any tickets are also shown, and thereby cluttering your chart towards the right side of the x-axis. What I'm looking for is a way to not show the empty axis points like before. (Compare the two attached images of the same chart in my post)

W1, W2 appears when you trend by week instead of date as shown below:

Navaneeth1_0-1769755294423.png

For you, I believe, instead of week it's showing dates. If you look at the old graph image that's attached to this post, instead of W1, W2 it would show starting dates of the week, and it will ONLY Show the weeks where tickets were created. 

Hi @Navaneeth1 

Thanks for the update and for pointing me in the right direction. I explored the option and tried a few things, but it looks like this is new functionality in data visualization and currently shows empty results. It would be better to log a case with the SN support team to get guidance and share feedback.

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Hey @Dr Atul G- LNG ,

I've modified the post and attached two screenshots referring to the problem. Please review and let me know if you have any questions based on that.

Navaneeth1
Tera Guru

Hello @Ankur Bawiskar ,

I hope you're doing well. I've seen that you've helped me out on a lot of community posts, and I was wondering if you could please take a look at one of my latest posts: 
https://www.servicenow.com/community/developer-forum/how-to-show-dates-for-timeseries-line-graph-tre...

It's an issue related to the Platform Analytics Dashboard. Any help at all would be much appreciated. 
Thank you!