Running Average of Created Tickets of the last 30 days

6 Comentários

  • L M
    Ações de comentário Permalink

    Glad you asked this! I've been having a doozy of a time myself trying to figure out how to get a trendline.

    In ZD Insights there was a cute "preceeding rows" but in Explore, I can't seem to figure out how to get a metric that looks at a range. 

    1
  • Frank Pinto
    Ações de comentário Permalink

    Hopefully one of the experts will be able to give us a hand!

    0
  • Frank Pinto
    Ações de comentário Permalink

    I'm sharing what I've done so far (that hasn't worked) in case somebody views this and corrects my mistake.

    1) Created a "Date range calculated metric" like so:

    Then I took this measure and went to the Standard Calculation and wrote this formula

     

    `SUM([Last 30 Tickets])/30`

     

    But it doesnt work. When I add this Metric, an error message says "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"

    0
  • Jon Daniels
    Ações de comentário Permalink

    Hey Frank!

    I have posted the answer to that query you mentioned that wasn't answered previously:

    Month to date this year vs. MTD LY


    I hope this tip helps get you started, please let us know if you still have questions about this kind of report!

     

     

    0
  • Frank Pinto
    Ações de comentário Permalink

    Hi Jon,

    Thanks for getting back to me but I think your answer does not apply to what I'm talking about. My idea is to add a trend line that points to the last 30 day ticket creation average. So, for example, down below you are seeing two trend lines: one for the "Tickets Created - Daily Average" (yellow, and this metric is already built in) and the ticket creation of last week (in red). Also, you're seeing the ticket creation numbers of the current week as it continues to unfold in the blue bars:

     

    What I would like to add is another trend line that's going to indicate the rolling 30 day average. I tried using what you did:

    This is what is getting displayed in the bottom of the screen:

     

    0
  • Frank Pinto
    Ações de comentário Permalink

    I also wanted to point out that I tried building the same query from your answer in the other thread (both replicatin step by step and by using a different timeframe of comparison) and in both cases I got the same error: 

    0

Por favor, entrar para comentar.

Powered by Zendesk