Have a dashboard, showing 3 views. Each view I would like to be filtered by the Calculated Field called Rank which is Index()
It is not allowing me to select "Apply to Worksheets", the option doesn't show. Any thoughts on how to get round of this?
I attached the image of the available options.
Thank you.
See the attached, I used a parameter and a calculated field using [Rank]<=[Rank Parameter] instead of the Rank value directly.
While Shawn's point is correct that the *values* of a table calculation are entirely dependent on the pills in the view and their settings, there are cases where we have measures that return some set of values out of different worksheets that we want to filter across. Tableau already lets us do this, we can set up a continuous measure like SUM(Sales) and filter that across worksheets that have entirely different levels of detail (like country and item in this view from superstore sales):
There are definitely challenges with returning a valid range of values for the domain of a measure, and I think it's possible for them to be worked out, which is why I created the following Ideas:
http://community.tableau.com/ideas/2190
http://community.tableau.com/ideas/2413
Hope this helps!
Jonathan
