-
1. Re: How use ACTION filters to filter another chart in dashboard with child members
Kathryn Bridges Sep 1, 2016 11:53 AM (in response to Ramz Aftab)Hey Ramz,
I would actually re-structure your data to get what you need. I've flipped it really quickly, creating a flag for "Parent/Child", and then being able to match on letter.
Workbook attached (Note: Using version 9.3).
Thanks!
Katie
-
Book1.twbx 27.7 KB
-
-
2. Re: How use ACTION filters to filter another chart in dashboard with child members
Ramz Aftab Sep 1, 2016 1:28 PM (in response to Kathryn Bridges)HI Kathy,
Thats cool! I was looking for this view exactly.
Since I dont have an upgraded 9.3 version, can you please define the steps to ensure I fit in the idea that youve plotted ?Ramz
-
3. Re: How use ACTION filters to filter another chart in dashboard with child members
Kathryn Bridges Sep 1, 2016 1:49 PM (in response to Ramz Aftab)Hi Ramz!
Sure thing.
The data structure is a follows:
With this structure, you'll need to create 3 calculations for each Sum:
ASum=sum(if ([Ident A])="A" then ([Figure]) end)
BSum=sum(if ([Ident A])="B" then ([Figure]) end)
CSum=sum(if ([Ident A])="C" then ([Figure]) end)
Then, you can create the Parent sheet as follows (just filter IdentB where it ="Parent", as showin in the Filter shelf):
Do the same for the Child sheet, just filtering IdentB where it = "Child".
And then in the Dashboard menu, just select Action, and then make sure you only select "Selected Fields, and choose that IdentA to filter on.
-
4. Re: How use ACTION filters to filter another chart in dashboard with child members
Ramz Aftab Sep 1, 2016 2:04 PM (in response to Kathryn Bridges)Many thanks!
-
5. Re: How use ACTION filters to filter another chart in dashboard with child members
Ramz Aftab Sep 1, 2016 2:41 PM (in response to Kathryn Bridges)Hi Kathy,
I replicated everything as you've mentioned, but the Action filter says " Missing data in multiple sheets". I've put Ident A to Ident A, but still it shows error. What do you think the issue is ?
-
TestWb2.twbx 22.2 KB
-
-
6. Re: How use ACTION filters to filter another chart in dashboard with child members
Kathryn Bridges Sep 1, 2016 2:52 PM (in response to Ramz Aftab)1 of 1 people found this helpfulHi Ramz!
Make sure IdentA is what you are coloring by, so that it is a detail level in both sheets. Is this the case? If so, could you post a screenshot of one of the sheets or re-post your workbook? Thanks!
-
7. Re: How use ACTION filters to filter another chart in dashboard with child members
Ramz Aftab Sep 2, 2016 6:18 AM (in response to Kathryn Bridges)Hi Kathryn,
Thanks for your quick feedback. The visualizations work for me now.
I've used PIVOT data to turn all Measures into one column. Since my data is inflexible from source, do you think PIVOT columns into rows will auto detect and create columns for me every time I refresh data ?
I tried using version 9.2.1, but it fails to refresh data. What do you think ?
-
8. Re: How use ACTION filters to filter another chart in dashboard with child members
Kathryn Bridges Sep 2, 2016 6:28 AM (in response to Ramz Aftab)Hi Ramz!
Wow, this is really cool. I have never used pivot, and I am just now reading about it. What a cool function.
I'm not too sure about the refresh... are you adding a new data source every time or scheduling an extract refresh from a database? While I've never used this function before, I know other changes I have made to date (i.e. splitting it, making it text instead of integer), have remained after an extract refresh.
The other option you have (depending on the source of your data) is to make custom Custom SQL in Tableau to structure it the way you need.
-
9. Re: How use ACTION filters to filter another chart in dashboard with child members
Ramz Aftab Sep 2, 2016 7:50 AM (in response to Kathryn Bridges)Hi Kathryn,
It seems the ver 9.2 version bug. I have just installed the ver 10.0 and the data refresh seems to work on in spite of pivot.
Thanks,