How do I add a Dynamic X axis on a trend Chart that Changes based on filter selection?

AMercier
Tera Contributor

Back Story:
I recently took on a role as my company's ServiceNow Platform Analytics Admin. I've got a few months of experience with ServiceNow in total & come from a PowerBI background. My company has asked me to help unify the many years worth of reports and dashboards that have previously been built for specific teams instead of being dynamic. 

With that, I have a dashboard that has a tab with four trend-over-time chart visuals on it. All four visuals are identical except for the calendar X-Axis (Day, Week, Month, Year). 

My Question:
Is there a way for me to consolidate these four reports into a single report, and based on an Interactive Date Filter selection the X-Axis changes to a pre-determined calendar grouping (example 1)? OR set up a secondary filter/grouping to change the X-Axis (Example 2)?

 Here are Moc ups of what I'm attempting to achieve. 

AMercier_0-1723667946951.png

 

AMercier_1-1723667954838.png

 



1 ACCEPTED SOLUTION

olgaredkina
ServiceNow Employee
ServiceNow Employee

Is not possible indeed in the responsive dashboards, you can only change date range, but you have no option to change aggregation. 

You can achieve this in Technical Dashboards in Platform Analytics Experience. Technical dashboards (UI Builder) would allow you programatically to change values of configuration based on user selection or any logic you want. 
You can learn more about using UI builder here (it does require you have special permissions as well as more technical knowledge as it would require scripting to achieve it. 

 

Alternative for regular dashboards to have separate tabs/widgets for different aggregations.

 

View solution in original post

7 REPLIES 7

AndersBGS
Tera Patron
Tera Patron

Hi @AMercier ,

 

No, this is not possible in ServiceNow. 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Tsura Andreeva
Mega Sage

It seems like the first senario on resolved day can be achieved by creating a new interctive filter on resolved day but I noticed if an incident is cancelled resolved day will be blank so it might slow down performance, I suggest instead of resolved day to use closed day interactive filter - here is what I did on my end

TsuraAndreeva_0-1723740712568.png

TsuraAndreeva_1-1723740749147.png

On the second example you have given you could use the resolved time , or aging cateogory in the additional grouping in the report or resolved as an idea, I know its not perfect but it is work arround 

TsuraAndreeva_2-1723741111891.png

 

 

 

olgaredkina
ServiceNow Employee
ServiceNow Employee

Is not possible indeed in the responsive dashboards, you can only change date range, but you have no option to change aggregation. 

You can achieve this in Technical Dashboards in Platform Analytics Experience. Technical dashboards (UI Builder) would allow you programatically to change values of configuration based on user selection or any logic you want. 
You can learn more about using UI builder here (it does require you have special permissions as well as more technical knowledge as it would require scripting to achieve it. 

 

Alternative for regular dashboards to have separate tabs/widgets for different aggregations.

 

Do we need a special plug in to be downloaded for this?

When i try to check it out in my dev instanse I get this:

TsuraAndreeva_0-1724099011392.png