How do aggregate by one dimension, ignoring current selection

[#1]

Hi all,

I have a chart with two dimensions - Device platform and age. And in one of the measures, I want to display total user count for each age dimension for the month, no matter what my device platform selection is.

So my expression is : COUNT(    {1<month_id = P(${month_id})>}   TOTAL <age>   user_id).

The problem is that this expression still respect device platform selection.

Any suggestions? 

Thanks

[swuehl]

What do you want to achieve with

COUNT(    {1<month_id = P(${month_id})>}   TOTAL <age>   user_id)

Do you maybe need something like

COUNT(    {1<month_id = P( month_id )>}   TOTAL <age>   user_id)

[#3]

Hi

Thanks for the reply.

This is used to calculate a denominator in my metrics. Basically I want this number to be the number of users for every age, ignoring my selection (keep the month_id selection though)

[swuehl]

If device platform selection alters the possible values of month_id, this will also alter your expression result.

[#5]

in the data I imported, the platform selection won't alter month_id value.

I tried to do SUM(AGGR()). But the i don't know if there is anyway to ignore selection in AGGR(). The set Analysis before AGGR() won't work.

[swuehl]

This may explain set analysis / advanced aggregation.

Set Analysis in the Aggr function

Could you post a small sample application that demonstrates your issue?