I'm hoping someone could advise whether or not it's possible to see in a query running(or rolling) average of tickets created in the past 7 days for example.
Insights do have this feature and it's handy! We have migrated to Explore and now need to use this feature.
Thanks in advance
Hi @..., is it a single figure showing the daily average over the last 7 days that you're looking for?
Yeah, that would be great if we could achieve that. Thanks for looking into this
No problem. You should be able to achieve what you're after using a filter and 'Result metric calculation'. Using the Support - Tickets dataset:
- Add COUNT(Tickets) as your metric.
- Add a filter on Ticket created - Date. Select 'Edit date ranges' and add the following 'Advanced' filter
- Click on 'Result manipulation' and select 'Result metric calculation'.
- Add a new metric, give it a name, then write this formula
Remember to check 'Clear used metrics'.
That should give you a figure showing the total number of tickets created over the last 7 days divided by 7.
That does work, thanks for this again @...
Do you think I can somehow incorporate that into this report as a separate value/metric?
I'm not sure where in that chart the rolling average metric would appear. It might be better to add both to a dashboard and have them displayed side-by-side.
Hello - I'm interested in setting up a metric like this, that would show you the 7-day rolling average of tickets. Looking at the suggestion in this thread, I'm super confused - wouldn't adding a date-range filter for 7-days in the past only ever show you just the most recent 7-day ticket history?
I want to create a time series that would show me a rolling average of tickets created over a 7-day period, by date.
So for the X-axis (date), each day represented would show tickets created for each day within a 7-day block in the past from that date, divided by 7 (to get a rolling average). Is this possible? I feel like you'd need something similar to week-buckets as an attribute like described here: https://support.zendesk.com/hc/en-us/articles/4408834272282 -- only for each day of the week if that makes sense.
Hi Crawford Philleo,
A related topic on rolling average may be found in this other community post, 7-days average. Unfortunately, as indicated in the thread, Explore does not currently have a native method for calculating a rolling average.
You may also want to check at Date Range Calculated Metrics, which allows you to create totals for a certain time period; however, this will only be a single figure, and not a continuous trend.
Vous devez vous connecter pour laisser un commentaire.