Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Oct 29, 2021, 10:01 PM

I created a Calculated field for Max & Min, but it's not adapting to my filter (attached file)

Hi.

I am using a NBA dataset just for fun to learn about Tableau.

I created several calculated fields, such as MIN & MAX.

I have a filter that toggles between showing 3 PTA or 3 PTM.

 

When I toggle (filter) between 3 PTA or 3 PTM, the actually observed line is adapting to the filter...

but my calculated field of MIN & MAX is not.

 

I must be missing something.

 

Thanks!

NBA 3PT vMax and Min not working with filters.twbx
1 answer
  1. Jim Dehner - Tableau Visionary HoF (Market Analytics LLC)
    Oct 30, 2021, 11:43 AM

    Hi

    you are using LOD's in your max and min calculations then applying filters - so you should add the dimension filters to Context so they are applied before the lod is calculated - see https://jimdehner2.blogspot.com/2020/06/faq-series-context-filters-what-do-they.html to better understand the use of context filters

    also your numerator/denominator is calculated at the row level and you are using Avg as the aggregation - best practice would be to calculate the % as an aggregate

    Jim

Write an answer...
0/9000