topic Re: Aggr over class with variable in App Development

Aggr over class with variable

Tim_G — Fri, 10 Feb 2023 09:40:09 GMT

Hello there,

I am trying to aggregate over a class which depends on a variable, such like this:

aggr(nodistinct SALES, PRODUCT_LEVEL, class(PRODUCT_PRICE,$(v_PRICERANGE)))

The values should be shown in a simple table. Aggregation on PRODUCT_LEVEL works fine. But I further want aggregation on Price Categories which I set with a variable which is chosen via a slider. The variable works fine for other visualizations, such that I suppose there is a problem with aggregation on classes or variables respectively.

Other board discussions did not help. I would be greatful for any advice.

Re: Aggr over class with variable

jbhappysocks — Fri, 10 Feb 2023 10:20:46 GMT

You don't need to use aggr, just use

class(PRODUCT_PRICE,$(v_PRICERANGE)) as dimension

and sum(Sales) as measure

Re: Aggr over class with variable

Tim_G — Fri, 10 Feb 2023 11:16:45 GMT

Hi,

thanks for the reply! However, this is not quite it. Maybe I did not explain it properly.

I also have PRODUCT as the lowest dimension and for each PRODUCT I want to have sum(SALES) in its specific PRODUCT_LEVEL and PRICE_RANGE. So I thought aggregation over the dimension would be the way to go.

Like this:

Maybe I am on the wrong lane here trying to solve this with an AGGR function. But for PRODUCT_LEVEL it works.