1 of 1 people found this helpful
When you're using the Advanced Compute Using to set addressing on specific dimensions, those dimensions have to be in the view.
When you're using a hierarchy to drill down or up, it makes dimensions come and go from the view so those table calcs break, as you've found out. Sometimes there might be a solution via a relative compute using, to know whether that is the case we'd need to see a packaged workbook with some sample data and the desired results.
The alternatives are to not use the hierarchy drill-down, and instead use a parameter for controlling the hierarchy level such as using this technique Dynamic Hierarchies with Tableau - Clearly and Simply, or use a parameter to swap worksheets Creating a Sheet Selector for a Dashboard | Tableau Software.
I tried the Dynamic Hierarchies suggested in the article, but that didn't seem to accomplish what I'm look for.
The Sheet Selector idea technically gets the job done, but from a performance standpoint there are a lot of other filters and table calculations being repeated across the sheets causing the performance to move slow.
In what way?
Every time I switch between Sheets with the parameter, or apply a filter, I get the pop-up stating that the query is executing. This takes up to a minute, whereas before the hierarchy would split the dimensions almost instantaneously.
I can only assume this is because all other filters are being applied again for each additional sheet I added to the Dashboard.
What did you mean previously by a "relative compute using"?
Not sure if you figured this one out...it's been awhile since your original post. I thought that I'd take a crack at your issue.
I've attached an example using a parameter to select the level you want to see.
First create a parameter as a string with the levels you want to show (i.e.; Region, State, City, etc..) then 'show the parameter control'.
Create a calculated field (let's call it 'Select Level') that looks something like this:
when "Region" then [Region]
when "State" then [State]
when "City" then [City]
when "Zip Code" then [Customer Zip Code]
Place the 'Region' pill then the 'Select Level' pill on the rows shelf.
You will get an error for your '% Sales' pill. You will need to edit the table calculation.
The Calculated Field: should be 'Total Sales' and Compute Using: will now be 'Select Level'
I hope this helps someone who may be looking to do something similar.
Advanced Partitioning.twbx 1.2 MB