2 Replies Latest reply on Feb 21, 2018 11:03 PM by Esther Aller

    Aggregation on Calculated Measures which use Table Functions

    Aneerban Bhattacharjee

      I have a Case wherein we're using Tableau to create 3 Calculated Metrics:-


      In The above Formulae, Sequence Parameter and Min # of Contacts are User Driven Parameters and [D-T] is a measure. All these Measures are also to restart Calculation at a particular Dimension.

      The final Measure of New Calc is expected to give a 0 or 1 value based on the Parameter.


      While the Worksheet works with the logic, The required Dashboard needs a Aggregate Sum(New Calc) across all the dimensions but a creation of such a measure shows an error that New Calc is already an Aggregate and cannot be aggregated further.


      Using Windows_Sum(New Calc) gives erroneous results when trying to aggregate across levels( ex when we remove certain dimensions)


      Any idea on how to aggregate such measures?