- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2024 01:40 PM
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.
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 06:15 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2024 10:26 PM
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2024 09:58 AM
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 06:15 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 01:23 PM
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: