topic Counting between two dates not working in App Development

Counting between two dates not working

alex-wb — Tue, 14 Dec 2021 19:16:26 GMT

Hi,

For some reason when I am trying to counts all incidents the occurred between two dates it always misses the dates that have the week ending the max IR_WEEKEND, what is wrong with my code?

Thanks,

if(

Sum(
Aggr(Count({$<
IR_WeekEnd={">=$(=WeekEND(max(IR_WeekEnd),-51))<=$(=WeekEND(max(IR_WeekEnd)))"}
>}Incident_ID)
,IR_WeekEnd))
>0
,
Count({$<
IR_WeekEnd={">=$(=WeekEND(max(IR_WeekEnd),-51))<=$(=WeekEND(max(IR_WeekEnd)))"}
>}Incident_ID))

Re: Counting between two dates not working

abhijitnalekar — Tue, 14 Dec 2021 19:44:11 GMT

Hi @alex-wb ,

Please modify your expression as below.

if(

Sum(
Aggr(Count({$<
IR_WeekEnd={"='>=' & $(=WeekEND(max(IR_WeekEnd),-51))& '<=' & $(=WeekEND(max(IR_WeekEnd)))"}
>}Incident_ID)
,IR_WeekEnd))
>0
,
Count({$<
IR_WeekEnd={"='>=' & $(=WeekEND(max(IR_WeekEnd),-51))'<='$(=WeekEND(max(IR_WeekEnd)))"}
>}Incident_ID))

Re: Counting between two dates not working

alex-wb — Wed, 15 Dec 2021 09:34:50 GMT

@abhijitnalekar thanks for the response, unfortunately that doesn't work. It doesn't return anything for me.