AVG Tickets per Organisation and % Difference from Average

2 댓글

  • Graeme Carmichael
    댓글 작업 고유 링크

    Kerry

    This sounds like fun. 

    Try this:

    Filter

    • Ticket Created Date> In your preferred period

    Rows

    • Ticket Organisation Name

    Metrics

    • D_Count(Tickets)

    To get the missing metrics, we create some special calculations.

    Go to Calculations>Fixed Calculated Metric> Use the advanced tab.

    First count all tickets for the duration of your query.

    Next find the count of organisations in your query.

    Add these metrics to your query:

    Finally, make your computation:

    Result Manipulation>Result Metric Calculation:

     

    You can modify that last calculation to follow your original format once you are happy that the figures are as expected.

    You can then hide the workings columns from your final table in  Chart Configuration>Columns

     

     

    0
  • Kerry
    댓글 작업 고유 링크

    Hi Graeme,

    Thank you for this, you have made my afternoon :)

    0

댓글을 남기려면 로그인하세요.

Zendesk 제공