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

    How do aggregate by one dimension, ignoring current selection

    Jayden Fan

      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