1 Reply Latest reply on Dec 23, 2014 9:47 AM by diego.medrano

    Table Calculation with Filter

    Alex Carr

      Hello everyone,

       

      I am new to Tableau and am trying to accomplish what seems like a simple task but is not succumbing to efforts.  I wish to average Current Rate (which is actually an aggregate using Max) for all rows in a Measure.  Then I wish to average that value, Measure Rating lets call it, across all the measures in each QRS Composite.  Finally I would average all the Composites scores I just calculated to obtain a score for the Domain.

       

      I guess my main issue is if there is a way to not use duplicate values, for instance I only want to use .5822 once when calculating a Behavioral Health QRS Composite, but it shows up twice in the table.

       

      Any help is appreciated.

       

      Hierarchical Calculation.png