I have a table like this: "Table1".

And I want the records count (Single KPI) between the MIN("Table1"."Posting Date") and TOday-7 and "Table1"."Status"='In Progress'.

I tried following PQL query:

SUM(

CASE WHEN (

DATE_BETWEEN ( ROUND_DAY("Table1"."Posting Date"), ROUND_DAY(MIN("Table1"."Posting Date")), ROUND_DAY(ADD_DAYS(TODAY(), -7)))=1 AND

("Table1"."Status"='In Progress')

)

THEN 1 ELSE 0 END)

Note: Formatting = Rounded Number

But it is giving me following error:

The aggregation function MIN cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

Could anyone please help me out on this?