CODEWITHSUNDEEP
tableau-apidashboard
Tom
Tom

Reputation: 77

Calculating total percent in tableau

I am new to tableau and need to display the total percent for each test officer of all 19 categories combined. for example, test officer 15716 would have a total percent compliant as 47.5 in the picture below.

enter image description here

Upvotes: 1

Views: 619

Answers (2)

Andy TAR Sols
Andy TAR Sols

Reputation: 1735

It sounds like your problem is sub-totals and grand totals. Using discrete values in your table prevents the totals from working. Instead of discrete measures you can use continuous (green) by switching to a measure names/measure values solution instead. That will activate the subtotals (which you need) and also grand totals.

Upvotes: 0

Caleb
Caleb

Reputation: 359

Use a LOD (Level Of Detail) expression

{ FIXED [Test_Officer_SAPID] : SUM([Actual_Total]) / SUM([System_Target]) }

47.5% is the average of averages. I assume you are actually looking for 57.5% (23 divided by 40). Not (63%+33%+66%+n%)/(3+n)

Upvotes: 3

Related Questions