2 Replies Latest reply: Mar 31, 2016 8:05 AM by Jan Hagelauer RSS

    Aggregation in dimension ignores previous dimensions

    Jan Hagelauer

      I have recently come across an issue with aggregations in chart dimensions that I have been able to resolve, but don't really understand the for.

       

      My understanding of chart dimensions so far was that they are evaluated based on the restrictions of the preceding dimensions (so if the first dimension in on FieldA, then the second dimension will be calculated based only on those records with the respective FieldA value).

       

      When using aggregation in a chart dimension (using aggr), the restrictions of previous dimensions seem to be ignored however if those dimensions are not included as aggregation dimensions for aggr.

       

      Here is a short example that is also contained in the demo dashboard - it is based on the following source table:

      demo-table.png

      Now I create a chart with the following dimensions:

      1. Dim1
      2. Dim2
      3. =aggr(sum(Value), Dim1)
      4. =aggr(sum(Value), Dim1, Dim2)

      And one very simple expression:

      1. sum(Value)

       

      My expectation would have been that aggregated columns return the same value (equal to the expression value), since there already is a restriction on Dim1 and Dim2 from the first two dimensions.

       

      The actual output however is this:

      demo-chart.png

       

      Can someone explain to me why it is necessary to include all the previous chart dimensions as dimensions in aggr in order to get the same result as the expression?