One way to look at your issue would be to create a group "APAC" composed of China & Japan.
It will leave the end user the possibility to drill down from an APAC view to a China & Japan view.
Hope this helps,
thanks for your suggestion, unfortunately it does not work in the parameter context.
I cannot use the group in the calculated field and then I cannot link it with the Region parameter that I use as filter.
I have attached the packaged workbook sample to clarify the concept.
If you open it you will see a parameter used as filter with the following Regions:
While APAC is working, unfortunately China and Japan do not work due to the calculated field formula I guess.
Could you please check?
Regions_Sample.twbx 48.8 KB
Ok I understand way better with the workbook. Good use of the parameter to filter across different data sources.
You were really close, you simply need to replace the 'or' condition by 'and' in all your "new region" dimensions. Edited workbook attached.
Regions_Sample.twbx 59.7 KB
Thanks for the edited workbook. The problem with the "and" operator is that the individual regions are working now but not the APAC calculated Region.
So really the issue I see that we can have either the individual Region values or the APAC calculated but not both!
1 of 1 people found this helpful
Indeed. Well I ran out of Tableau ideas to find a way to do that and I'm not sure you can actually. I guess the best Tableau option would be to keep only the APAC option in the parameter and to bring the region dimension onto the color mark in each of the worksheet.
Thanks for the workaround proposed, I will futher check for a more stable solution so any comments are welcome.
Hi Salvatore and Stephane,
I'm on 9.2 so I am unable to open the workbooks you posted but I think there may be fairly simple solution if I understand the issue correctly.
I'm going to refer to your calculated field as Derived Region and I am going to refer to the parameter as Region Parameter. Region Parameter is populated will all values from the region field and APEC
My first step is to create a second calculated field that will switch between Region and Derived Region depending on the parameter values selected. I'm calling this Field Chooser.
Case [Region Parameter]
WHEN 'APAC' THEN [Derived Region]
ELSE [Region] END
My second step is to create a parameter based filter on Field Chooser. I'm calling this field Param Filter
IF [Region Parameter] = [Field Chooser] THEN "True"
Then I drag Param Filter to filters and set to true.
Now I can choose either Japan, China or APEC and get the number of visits for each. Please let me know if you have any questions.
Region worksheet.twbx 10.9 KB
Great Ivan, this is exactly the missing step I had!
With the Field Chooser I can control if the selections is for an existing Region or the "Virtual" APAC one.
Many thanks for your help Ivan, and thanks Stephane too!