Hi Community,
I would like to do something like this (just AI generated and other context): Goal is to show the whole range of a variable, the IQR as 25% and 75% percentile and one country.
I managed it to create the reference lines, but as soon as I try to filter one country ("Land"), it does not keep them. I assume the calculation is changed to the visible country. But I would like to keep it to all the countries. Is this possible in tableau? See my workbook attached.
Many thank for any help!
Kind regards, Sarah
#Tableau Desktop & Web Authoring
Hi, in this case you may:
a. Create a set on Land, and select Use all:
b. Select a box plot viz, right clic on the axis, configure the reference line as:
c. Create a Detailed calc:
IF MAX([Land Set]) THEN SUM([tt_investment_per_emp_usd]) END
d. Drag beside your current tt_investment pill in the rows shelf, dual axis and sinchronize axis
e. Right clic on the set in the data pane, and select show set.
f. In the set control select one country.
Finally, it would be more a format challenging (Add a custom shape, add color, label, etc).
The custom shape I used:
The final outcome:
If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Tableau Ambassador