Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have monthly data on our product
I would like to find the average per year for each product. But only if i have a full years data.
I need this as both a KPI and in a Scatter.
Here is what i have so far. I am not getting the expected results.
Avg({<productID={=Age >1}>}aggr(sum(Value),reportingYear,ProductID))
Im happy to do this in the load script as a new yearly values table, although it would be great to be able to drill down.
Perhaps this?
Avg(TOTAL <reportingYear> Aggr(Sum(Value), ProductID))
Since, there is a restriction factor. We need to think like below
Avg({<productID={"=Age>1"}>} TOTAL <reportingYear> Aggr(Sum(Value), ProductID))
That's not valid syntax
Sorry. It is actually valid. Ive not used the <> I'd anything other than set Analysis. What exactly are these brackets used for.
Ps. I am still not getting the expected value in the KPI box and it does not work at all in the Skatter with ProductID as the dimension
When you say data is not valid. We can't promise since I don't have your data handy. Now, Time to share sample and expected result we will get it for you?
TOTAL <Fieldname> will do based on Aggregate field per Year since your sentence like that "I would like to find the average per year for each product. But only if i have a full years data."
Can you try this?
Avg({<productID={"=Age>1"}>} TOTAL <reportingYear> Aggr(Sum({<productID={"=Age>1"}>} Value), ProductID))