column chart for closed tickets

Comments

3 comments

  • Avatar
    David Hertzberg

    Hi Akondi,

    I guess you need the number of opened tickets, then you can add a formula like COUNT(Closed Tickets) / COUNT(Opened Tickets). Depending on our data structure, you can then add filters/split by severity in various ways to calculate different KPIs. I would rather import that kind of datas. If you import directly SLAs you will have less flexibility for working on different KPIs and let your users slice the data.

    Best, David.

    0
    Comment actions Permalink
  • Avatar
    Akondi sudheer

    I want number of closed tickets. I am getting the numbers for closed tickets, but I want SLA. It is not coming directly from data base. We have to calculations. I am using the calculation as (count(severity tickets)/count(total closed))*100. But that percentage is not correct.

    0
    Comment actions Permalink
  • Avatar
    Nathan Giusti

    Hey Akondi

     

    Start by looking at the numbers for  count(severity tickets) and count(total closed) independently and see whether one or the other or both values is off and then troubleshoot from there. I can't offer more help without additional details. 

    0
    Comment actions Permalink

Please sign in to leave a comment.