5 Replies Latest reply: Nov 7, 2016 4:45 PM by Stefan Wühl

# How do aggregate by one dimension, ignoring current selection

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

• ###### Re: How do aggregate by one dimension, ignoring current selection

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)

• ###### Re: How do aggregate by one dimension, ignoring current selection

Hi

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)

• ###### Re: How do aggregate by one dimension, ignoring current selection

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

• ###### Re: How do aggregate by one dimension, ignoring current selection

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.

• ###### Re: How do aggregate by one dimension, ignoring current selection

This may explain set analysis / advanced aggregation.

Set Analysis in the Aggr function

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