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.
Thanks for providing the screenshot. You'll be more likely to receive a response if you provide a workbook with sample data so users can recreate the issue and play around with solutions. If you've already figured it out, we'd also love to hear.