hi All,
Example workbook attached below.
Attached is a sample workbook, here i have a parameter called "Group by" which i want to show only when there are more than 2 states selected.
My calculated field "_ShowGroupByState" does not show up under the "control visibility using" so i created another calculated field called "TestOne" which does show up under the "control visibility using" option but does not work as expected.
The group by parameter does not disappear if I select only a single state.
When you select / deselect states from the filter you see that the title in the dashboard changes along with the value of the "TestOne" calculated field which gets set to "true" if there are more 2 states selected and changes to false if there are less than 2 states selected.
Although "TestOne" changes from true to false, the "Group by" parameter remains unaffected and is always visible.
Any help in this would be really great, Thanks.
Hi @Akshar Jamgaonkar
I think the problem you encounter is that dynamic zone visibility has three conditions to work:
- Boolean.
- Single value.
- Independent of the viz, meaning the field returns a constant value independent of the structure of the viz, such as a fixed level of detail (LOD) calculation.
From the outset, it appears that this is met however, I myself have encountered this issue (see here:https://tableauadventurer.com/2022/12/21/dzv-and-user-permission-to-declutter-your-interface/ ) and Marc Reid has been supplying the same statements here:
https://datavis.blog/2022/10/31/tableau-dynamic-zone-visibility/
There are generally two options on how to overcome this seemingly contradicting issue:
1: as Marc describes and as I also write in my blog post you basically have to wrap the T/F condition in an LOD again. Even if its coming from an LOD already (Marc) or, even more astounding, even if its directly from the data source (as in my case) .
HOWEVER: in your case, I could not get this to work. This will most likely be because the state filtering contradicts the third condition listed above.
2: use a data driven parameter to take the value from your initial "testOne" calculation and then check that parameter in another calculation (make it t/f again).
I am attaching workbook with data driven parameter solution for your reference.
If this helps, kindly select "mark as best" to close the question.
Many thanks
Steffen
