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:
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?