Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Display Week Dates on x-axis instead of Week Number in Performance Analytics Dashboard

Arjun Reddy Yer
Mega Sage

Required help on the below requirement @Ankur Bawiskar @Vasantharajan N @Ahmmed Ali 

As in Performance Analytics, is there a way to show the dates of weeks on an x-axis instead of the week number. 

As I had selected duration as 1 month but still it's not displaying the Week Dates.

Tried with Break Down but didn't get the result

 

Result Graph: 

ArjunReddyYer_0-1759238926007.png

Widget:

ArjunReddyYer_1-1759238987233.png

 

ArjunReddyYer_2-1759239028780.png

ArjunReddyYer_3-1759239137972.png

ArjunReddyYer_4-1759239240836.png

ArjunReddyYer_5-1759239338543.png

ArjunReddyYer_6-1759239611740.png

ArjunReddyYer_7-1759239655063.png

 

1 ACCEPTED SOLUTION

RaghavSh
Mega Patron

@Arjun Reddy Yer what is the "Valid for frequency" in your indicator source. Try changing that to monthly to see monthly data.

 

Also showing dates instead of week numbers wont be possible as per me.


Please mark the answer correct/helpful accordingly.


Raghav
MVP 2023
LinkedIn

View solution in original post

12 REPLIES 12

Bhuvan
Giga Patron

@Arjun Reddy Yer 

 

As far as I know, it is not supported for weekly, monthly and other data collection intervals. Only for daily data collection, it automatically plots the dates based on interval selected between from and to dates.

 

Bhuvan_0-1759242849191.png

Bhuvan_1-1759242880613.png

If this helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan

When I try to change it's showing below error

ArjunReddyYer_1-1759251122020.png

 

@Arjun Reddy Yer 

 

You cannot change the frequency when you have scores collected for the indicator. You have to either delete collected scores or create a new indicator with desired frequency.

 

Go to indicator configuration, from related link access 'Scores for this indicator' and use option 'Delete all scores'

Bhuvan_0-1759251317534.png

 

If this is development environment and data is non-critical, delete the scores and change frequency. If indicator is in Production, do not delete any scores, create a new indicator.

 

If this helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan

ArjunReddyYer_0-1759251844119.png

ArjunReddyYer_1-1759251893695.png

After deleting the scores also still same error

Steps:

1. Delete scores.

2. Change the frequency field on "Indicator" to monthly, if field is not present on form change it from list view.

3. Change the frequency field on "Indicator Source".

 

This works, have done this multiple times in past.


Please mark the answer correct/helpful accordingly.


Raghav
MVP 2023
LinkedIn