Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, please i am trying to count the worksorder where the actualtime/60 is >= to the setuptime/60. this is the expression i wrote for my kpi chart, but the result is incorrect.
Count(distinct{<[UDEF_VIEW_service_event.WorksOrder]>}
If((TaskActualSetupTime/60) >= (TaskPlannedSetupTime/60), 1, 0)
)
can someone please help me out.
Hi
Try like below
Sum({<[UDEF_VIEW_Ringtons_service_event.WorksOrder]=>}
If((TaskActualSetupTime/60) >= (TaskPlannedSetupTime/60), 1, 0)
)
Hope you have TaskActualSetupTime and TaskPlannedSetuptime are dimension..
I got same incorrect figure i was getting before. they are both separate dimensions
Could you share the screenshot and expected output..
from the table, my count should equal 3, but i am getting 34
When you do count in a KPI you have to Group by on some dimension to get correct results.
Please share mocked up data and expected result.
Hi
So you're using in KPI object..
Sum(Aggr(Sum({<[UDEF_VIEW_Ringtons_service_event.WorksOrder]=>}
If((TaskActualSetupTime/60) >= (TaskPlannedSetupTime/60), 1, 0)
), TaskActualSetupTime, TaskPlannedSetupTime))