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

AMercier · ‎08-14-2024

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.

olgaredkina · ‎08-19-2024

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

olgaredkina · ‎08-20-2024

you would need to have either role "admin" or "ui_builder_admin". Then when you go to Platform Analytics -> dashboards and click "Create new" you will have options to create in-line dashboard or "Technical dashboard" - once you select technical dashboard - you can click edit and it will bring you to UI builder where you can add dynamic logic

AMercier · ‎08-20-2024

We just completed our production upgrade to Washington. One of my goals is to clean up all these reports before transitioning them to the new Platform Analytics Experience. I'm likely a couple of weeks out on that, but I'll post back here once we've done that to report how it went.

AMercier · ‎08-20-2024

We just upgraded our instance to Washington. I've got a couple of items on my to-do list before the migration to the new PA Experience (Migrating off legacy score tables, activating Process Mining, & Reporting technical debt cleanup). That will take a couple of weeks. Once we've upgraded to the new PA Experience, I'll post back with my results on how that went.