Hello,
Making a chart with date in X axys with the number of tickets may be not really relevant as somedays you have less more tickets (sunday for example) and so it's difficult to see clearly a trend.
The trend with the pandemic and figures related is the 7 day average, for example on Google :
I am trying to do that on Explore (for each day compute an average on the last 7 days) but I did not find a way to do it (don't know if it is possible).
Does someone succeed to do a such metric ?
Thanks
Hi Thibault,
We can confirm on Graeme's comment that there's not a native function in Explore for mapping out a rolling average (e.g. 7 days) as a trendline on queries. We do recommend checking out Date Calculated Metrics, which allows you to create totals for a specified period of time:
https://support.zendesk.com/hc/en-us/articles/360022184194-Adding-time-and-date-calculated-metrics
For example, you can create a metric that returns the AVG of tickets created over the past 7 days. Note that this will be a single, discrete value rather than a continuous trend as shown in your screenshot.
Eric G. Gao | Technical Support Architect | Zendesk