How to create the dynamic hierarchy where the element should change based on the conditions?

1.0K    Asked by Kaalappanshingh in Tableau , Asked on Nov 7, 2019
Answered by Kaalappan shingh

You can achieve this with the help of a parameter, calculated field, and then using all those in the hierarchy. Let’s first create a parameter and enter the values like- “Region ► Customer State ► Zip Code “and “Category ► Sub-Category ► Product Name”.

image

Now create a calculated field like below-

image

Now combine the calculated fields in the new hierarchy like below-

image

And use this hierarchy in the row-shelf and allow the parameter as a user control to see if that is working. You will find the user can now change the dimensions they are looking for in the graph.


Your Answer

Interviews

Parent Categories