Skip to main content
Gabrielle LeBoeuf 님이 #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개
  1. 2022년 2월 2일 오후 7:40

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

0/9000