Skip to main content
Gabrielle LeBoeuf ha fatto una domanda in #Records

Good Morning,

 

I have a calculated field which divides #Records/Trays. The view is filtered by Location. When I drill down to Location, each individual location rate is correct. However, when I pan out to include all Locations, tableau is adding up each rate by location, rather than calculating a rate for all locations combined.

 

Any tips would be appreciated!

2 risposte
  1. 2 feb 2022, 19:40

    SUM( [#Records] ) / SUM( [Trays] )

0/9000