The visualization should show the percent of students in public school and the number of students who are in public school in buildings of different ages. This requires a LOD calculation that I am struggling with.
I want the percent in public school to change based on the school level, size, and region (level is in rows, and region and size are user-exposed filters). I do not want it to change based on the year constructed, or on school type filters.
In the "Target Viz" tab, there should be three different percentage values, and none of them should be 100%.
In the Attempts at Calculation table, the value should be the same for all values of "Constructed" within one value of "Size", but different within each value of "Size".
How can I achieve this? It feels like it should be straightforward.
#Tableau Desktop & Web Authoring
Is this your expected result? Since a FIXED calculation is being used, the filters that should affect it need to be added to context.
