Running/rolling average

5 コメント

  • Chris Stock
    Community Moderator

    Hi Vladimir Petrushenka, is it a single figure showing the daily average over the last 7 days that you're looking for?

    0
  • Vladimir Petrushenka

    Hi Chris Stock 

    Yeah, that would be great if we could achieve that. Thanks for looking into this 

    0
  • Chris Stock
    Community Moderator

    No problem. You should be able to achieve what you're after using a filter and 'Result metric calculation'. Using the Support - Tickets dataset:

    1. Add COUNT(Tickets) as your metric.
    2. Add a filter on Ticket created - Date. Select 'Edit date ranges' and add the following 'Advanced' filter
    3. Click on 'Result manipulation' and select 'Result metric calculation'.
    4. 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.

    0
  • Vladimir Petrushenka

    That does work, thanks for this again Chris Stack 

    Do you think I can somehow incorporate that into this report as a separate value/metric? 

    Many thanks 

     

     

    0
  • Chris Stock
    Community Moderator

    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.

    0

サインインしてコメントを残してください。

Powered by Zendesk