topic Re: Dynamically using a dimension inside an aggregate (aggr) in App Development

Dynamically using a dimension inside an aggregate (aggr)

pierreolivier — Sat, 16 Nov 2024 06:09:09 GMT

Hi everyone , I am currently trying to change the column used in a aggregate based on a variable.

Here is what I have tried so far :

=AVG(
    	total Aggr(
        	sum(Total),
           	if(Place = 'Country', Country, State)
       )
    )

and

=AVG(
    	total Aggr(
        	sum(Total),
           	if('$(Place)' = 'Country', Country, State)
       )
    )

Where Total, Country and State are columns, and Place a variable.

Note that if I remove the If and use specifically Coutry or State, there is no problem.

I have made sure that the variable has a value.

Is there any way to dynamically specify the dimension in the aggregate function?

Re: Dynamically using a dimension inside an aggregate (aggr)

Digvijay_Singh — Thu, 04 Apr 2019 14:32:43 GMT

Not tried but what if you try like this by moving if condition in the Place variable. - 

=AVG(
    	total Aggr(
        	sum(Total),'$(Place)'
              )
    )

Re: Dynamically using a dimension inside an aggregate (aggr)

pierreolivier — Thu, 04 Apr 2019 14:50:03 GMT

We ended up renaming the columns to be the exact name that we used in the variables. Heres what ended up working :

=
AVG(total 
  Aggr(
    sum(Total),
    [$(Place)]
  )
)