topic Aggr monthly data by year in App Development

Aggr monthly data by year

Tee_dubs — Sat, 16 Nov 2024 05:08:52 GMT

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.

Re: Aggr monthly data by year

saminea_ANZ — Mon, 29 Jul 2019 06:19:22 GMT

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))

Re: Aggr monthly data by year

Tee_dubs — Mon, 29 Jul 2019 09:05:47 GMT

That's not valid syntax

Re: Aggr monthly data by year

Tee_dubs — Mon, 29 Jul 2019 09:32:04 GMT

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

Re: Aggr monthly data by year

saminea_ANZ — Mon, 29 Jul 2019 09:41:35 GMT

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))