I would like to get the number of tickets created last month (that is easy to do) but also compare it against the monthly average number of created tickets (based on the last 12 months) - show it as a trendline.
How to get the monthly average number of tickets created (over the last 12 months)?
1) I tried to create a Date range calculated metric first (for 12 months in the past)
2) Then created a Standard calculated metric: divided the metric from above by 12 (months).
I get an error "Only partial results are visible for this query because the underlying SQL query returns more than 50,000 rows. To limit performance issues, each delegated SQL query is restricted to 50,000 rows" and the trendline shows some crazy numbers (in millions).
Would appreciate any help. Thank you!