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

# Aggregation on Calculated Measures which use Table Functions

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?

• ###### 1. Re: Aggregation on Calculated Measures which use Table Functions

Hello Aneerban,

Do you have a copy of some data in a packaged workbook that can be shared here?  The window_sum() likely needs to be defined using 'specific dimensions' although a LOD calculation may also be an option but I am unable to tell you how to configure the table calculation without seeing the workbook and the dimensions in the view.

Want to Learn Table Calculations? Here’s How! | Drawing with Numbers  is an older post but is also a great place to start when learning more about table calculations.

I hope that helps.

Patrick

• ###### 2. Re: Aggregation on Calculated Measures which use Table Functions

Hey Aneerban,

On top of what Patrick said, you might also want to check out Computing a Table Calculation by a Dimension Not Present in the View | Tableau Software

Essentially if you are using table calculations, then all dimensions needed to correctly compute the table calculation must be in the view. However, the above directions explain how to modify the view to hide the additional detail.

1 of 1 people found this helpful