Skip to main content

Hello everyone

 

I'm working in RRHH data for global absenteeism rate and i did few table calculations on measures to get the sum of TGA by City

 

Sum of an aggregate field

17,39% is the Columns Grand Totals by default in Tableau ussing "Sum"

TGA is a Calculated Field and i can“t aggregate it again

TGA = (SUM([Horas_Ausentismo])/(AVG([Total Empleados])*SUM([Jornada Laboral ]))) where Jornada Laboral is an LOD expression

 

What can i do to create a field which result in 17,39%?

10 answers
  1. Aug 25, 2017, 4:59 PM

    I don't know what next you need. But See Screenshot

    I don't know what next you need.

0/9000