Skip to main content

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 respuestas
  1. 2 feb 2022, 7:40 p.m.

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