What exactly would you like for an interaction and result? eg if you select Algeria in Sheet 2, and then hover over a mark in sheet 1, what would you like the contents of the tool-tip to be?
Hope you doing good.
I have filtered Algeria from sheet 2 and on map i want to show number of department present in country Algeria.
The tooltip should show 3Department i.e Furniture
But in Toottip it is showing only one Department. i.e Furniture which is incomplete information
Each mark gets a tool-tip, meaning the data displayed in a tool-tip can only be the values for a single mark, and a mark is defined by the combination of dimension pills.
On your Sheet 1, you have Custom Name as a Dimension pill. It did not seem like you need it so I removed it, and used a calc field to concatenate all the the departments together, and filter to keep only the last mark.
Tooltip jm edit.twbx.zip 941.8 KB
Thank you Joe
This is what i was looking for.