Hello,
I am trying to count the Max number of PIC that exceed the average during a range of 10 days in a variable date range.
The objectives is to found wich Date Range of 10 days, contain number of PIC > 7 .
Exp: From Jan 2021 to Sep 2021, I want to count Max PIC, exceeded Average, during range of 10 days.
I get the count of PIC during the last 10 days following this expression :
Count(distinct
{<
FabricationDate =
{">=$(=Date(Max({<StartDATE = {[<$(vEndDatel)]}>} StartDATE,9), 'DD-MM-YYYY'))<=$(vEndDate)"}
>}
If(
(PIC)>AGGR(NODISTINCT $(AVG),DESCRIPTOR)
,
PIC))
Thanks for your reply