Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Presenting SLA performance with Gauge

Dear all,

I need to produce a visual using the Gauge indicator. The sample data which i have is as follows:

 

Ticket IDRequesterStatus Overdue
1234JamesFalse
2345ArrenFalse
3456AliceFalse
4567JohnTrue
5678DonnaFalse
6789MonicaTrue

 

As you can see, the column ' Status Overdue' is in Boolean Type (True or False). I just wanted the gauge to indicate the SLA performance in percentage. The calculation is total number of ticket with status overdue as "False" divided by total number of ticket * 100. 

 

Many thanks for your help.

 

BS

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , if false is boolean 

     

    Measure = DIVIDE(CALCULATE(COUNT('Monthly Data'[Request ID]),FILTER('Monthly Data','Monthly Data'[Overdue Status] =false())), COUNT('Monthly Data'[Request ID]))
     

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Try a measure like

    divide(calculate(count(Table[Ticket ID]), filter(Table,Table[Status] ="False")), count(Table[Ticket ID]))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi amitchandak . Tried this but encountered erro. Do i need to change the data type to Text first. Here is the expression

       

      Measure = DIVIDE(CALCULATE(COUNT('Monthly Data'[Request ID]),FILTER('Monthly Data','Monthly Data'[Overdue Status] ="false")), COUNT('Monthly Data'[Request ID]))
      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        5 years ago

        Anonymous , if false is boolean 

         

        Measure = DIVIDE(CALCULATE(COUNT('Monthly Data'[Request ID]),FILTER('Monthly Data','Monthly Data'[Overdue Status] =false())), COUNT('Monthly Data'[Request ID]))