Hi All
I am trying to display overall rank using sum(sales) of the State. I have action filter on dashboard when I select any State on Map 1, the Map 2 is changing but it is not displaying correct rank of the state.
Any help would be greatly appreciated.
Please find attached twbx file.
Thanks!
Vani,
I got this to work by placing a Set Action within a Table Calculation - lookup() function. I'm sort of surprised to get it working but check out the attached updated workbook and let me know if you have questions. Set Actions are a new function in Tableau and unlike an Action filter, the Set Action can be used in a Calculated field so in this case, I wrapped the function in a lookup() function and defined the Table Calc manually using the Advanced calculation settings. Now be aware that any change of the Dimensions in the view will break the table calculation and it will have to be redefined.
I have not been able to find a way to retain the color from the left hex graph into the right graph so maybe someone else smarter than me figures that out.
Jonathan Drummey - have you embedded a set action into a table calc like this? Pretty cool functionality that I have not been able to do before.
Regards
Patrick
Tableau Community Manager
