That PU_COUNT will return the number of Account ID's per each account number. That is, no a single value but a collection.
So if the first value in that collection is 0, then you will get 0 as output.
Maybe there is the problem as the filter seems ok.
Also try to remove the filter to see if you get values. Just in case.
HTH
That PU_COUNT will return the number of Account ID's per each account number. That is, no a single value but a collection.
So if the first value in that collection is 0, then you will get 0 as output.
Maybe there is the problem as the filter seems ok.
Also try to remove the filter to see if you get values. Just in case.
HTH
Hi Guillermo,
Thank you for the clarification.
I tried without the filter and got values for 1.00 only.
Anyway, I reworked my approach and this works for me.
A. I put the time period filters at the table level.
component filter:
FILTER "Account"."CreatedDate" >= ADD_DAYS(TODAY(), -90);
B. and then used Global values to calculate a fixed average for the data being viewed.
kpis: (gives straight line avg for the table filtered time period)
average over 90 day period:
GLOBAL (COUNT("Account"."Id"))
/90
average of daily counts:
GLOBAL (COUNT("Account"."Id"))
/ GLOBAL (COUNT(DISTINCT ROUND_DAY("Account"."CreatedDate")))
90 day Avg (PQL):