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.

Restrict Date Range of the data based on Indicator condition

JohnDF
Mega Sage

Hi everyone,

 

I have a historical snapshot of 12 months of incidents with SLAs captured from a table. I then created multiple indicators with conditions like "created this month," "created last month," "created in the last 3 months," etc. to visualize trends of the selected time period on the dashboard.

 

JohnDF_0-1722244687111.png

However, my problem is that the indicator trend displays the entire historical trend line going back 12 months. I want to see only the last full 3 months when I click on the "last 3 months" indicator, just like when I manually select this time period in the analytics hub in the screenshot.

JohnDF_1-1722244985212.png
How can I remove the unnecessary months from the trend line that are blue and before April 1st? Since the condition on my indicator is "last 3 months," it would be helpful to remove the confusion for customers by only showing the relevant trend data.

Thanks for your help.

 

5 REPLIES 5

JohnDF
Mega Sage

@AndersBGS

I need a snapshot of the incident SLA for the last 12 months, but with different filters. Look at my first screenshot. I'm using the process widget as a time period filter. I need record filters for: current month, last month, last 3 months, last 6 months, and last 12 months. This is needed of course to see the trend in Performance Analytics.

That's why I created a single historical snapshot of the last 12 months. However, I don't need to see the entire 12 months in the indicators, for example, when the condition of one Indicator is "incident created last 3 months."

So, my question is: how can I use the override collection period? Does this mean I need to enter, for example, "3" for the indicator with the "3 months" condition for both "periods to keep score" and "snapshots to keep score"?

Or, how can I achieve this using the solution you provided?