topic Re: Count with condition in App Development

Count with condition

ClareChinonye — Fri, 15 Mar 2024 08:49:23 GMT

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.

Re: Count with condition

MayilVahanan — Wed, 13 Mar 2024 09:17:58 GMT

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..

Re: Count with condition

ClareChinonye — Wed, 13 Mar 2024 09:29:34 GMT

I got same incorrect figure i was getting before. they are both separate dimensions

Re: Count with condition

MayilVahanan — Wed, 13 Mar 2024 09:36:25 GMT

Could you share the screenshot and expected output..

Re: Count with condition

ClareChinonye — Wed, 13 Mar 2024 09:47:16 GMT

Re: Count with condition

ClareChinonye — Wed, 13 Mar 2024 09:48:23 GMT

from the table, my count should equal 3, but i am getting 34

Re: Count with condition

Dataintellinalytics — Wed, 13 Mar 2024 12:08:32 GMT

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.

Re: Count with condition

MayilVahanan — Fri, 15 Mar 2024 02:08:21 GMT

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))