Restrict Date Range of the data based on Indicator condition
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2024 02:26 AM
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.
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2024 03:47 AM
You can probably achieve what you want by using "Override collection periods" setting on "Collection periods" tab in your indicator.
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2024 04:52 AM
@Slava Savitsky thanks for reply,
Can you give me an example of how this works?
What should I enter as the value for the time precision condition filter? For example, "This Month," "Last Month," "Last 3 Months," etc. An example would be very helpful.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2024 12:37 PM
What is the frequency of your indicator? If it is monthly, then 3 periods means 3 months. If it is daily, then 3 months would be equivalent to about 90 periods (i.e. days).
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2024 04:56 AM
Hi @JohnDF ,
I agree with @Slava Savitsky , if you don't want to keep the snapshot data on your instance, then you can override collection periods on the automated indicator. If you would like to preserve the snapshots created 12 months back, then it is not possible in analytics hub.
Only solution would then be to set the periods on the widget, but users would still be able to alter the period in analytics hub.
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/