Count value in a Date Range

[JBE]

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