AVG( CASE WHEN "EventLog_UPLOAD_csv"."REPAIR_IN_TIME" = 1 THEN 1.0 ELSE 0.0 END)
Unfurtonately, it counts rows, not cases. So the result isnt exact.
Can someone help?Question
Count Cases when Value in Column “Repair in time” = 1
Hello
Please send help! Im desperatly trying to count all cases with repair in time = 1 (true)
If not repaired in time theres 0. SUM doesnt work, because there is more than one activity per case, so there are many rows matching the same case id in the data base.
Im looking for the percentage of cases repaired in time (of total cases) carried out by one service point.
My KPI:
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.