Please be more specific. What sort of visualization are you trying to build?
We don't know what's your data is about and you currently have 10 calculations there.
From brief look your calculated fields are wrong. You are using ATTR() that works on aggregated data but for Faculty/Disc/WT combination you are getting more than 1 row (in all the cases where formula does not work) and comparison against single string value fails.
Take a look at attached workbook.
If I understand intent correctly - this is how it should be done.
Note than AVG, MIN and MAX are performed on same underlying calculations.
community.twbx 105.2 KB
Thank you so much for your help, it looks good to me. Actually i am using Tableau from last two months and don't know exactly about calculated fields. could you please share workbook with me ?
I got workbook, thanks for the help. I will let you know if i need any further help