Average of Averages

[#1]

Hi,

How can I calculate the average of  averages? I have a dimension "Type" with the categories Periodic and Tansactional. I want to calculate the average of the average per month. Avg(Avg (Transactional) & Avg(Periodic).

I have been trying to do it with aggr functions and set analysis but I cannot manage to get it. Attached is the qvw.

Can you please help me please?

[preminqlik]

hi once try this

avg(aggr(<avg expression>,Dimension1,Dimension2))

[Clever_Anjos · Accepted solution]

Check if

RangeAvg(avg({<Type={'Transactional'}>}Score),avg({<Type={'Periodic'}>}Score))

fits your needs

[swuehl]

Not sure what you need here.

An average of two averages, maybe like

(avg({<Type={'Periodic'}>}Score) + avg({<Type={'Transactional'}>}Score)) / 2

[hic]

See also: http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/29/averages

HIC