Hi,
I have created a calculated field which shows count of employees.
//Employee Count
ZN({FIXED : SUM(IF [EMPLOYEE_REQUEST]='Leave' then 1 ELSE 0 END) })
and after that i have created 2 calculations to trigger the dynamic zone visibility (dzv)
//Red
{FIXED : MAX([Employee Count]) > 0}
//Green
{FIXED : MAX([Employee Count]) = 0}
I have imported two boxes from powerpoint - red and green , and applied the above calculations to them in the dzv options.
But, only the box which has red calculation applied is visible in all the cases of employee count i.e., if the employee count is 0, green box should be visible, if it is 0+, red box should be visible.
But even when the count is 0, red box is visible and for 0+, same red box is visible.
And if the apply the red color logic to green box, it is also visible. It seems that somehow the green color calculation is getting ignored or not reaching the correct place.
PS- I have put both the boxes in the same container , the filters applied on the dashboard are added to context.
can someone please help in this ??
Thanks a lot
#Tableau Desktop & Web Authoring
Reason being that any filter even evaluating before anything is part of your view. DZV does not like dependencies. I recently observed same situation but good news is still keep your Lods but use sheet swapping in a single container using your calculations as measure and it will work.