cancel
Showing results for
Did you mean: Regular Visitor

## 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 ID Requester Status Overdue 1234 James False 2345 Arren False 3456 Alice False 4567 John True 5678 Donna False 6789 Monica True

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.

BS

1 ACCEPTED SOLUTION  Super User IV

@bahare76 , 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]))

Proud to be a Super User!

3 REPLIES 3  Super User IV

@bahare76 , Try a measure like

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

Proud to be a Super User! Regular Visitor

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]))  Super User IV

@bahare76 , 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]))

Proud to be a Super User!    