Hey Guyz,
Facing one complex issue and need your help in order to resolve it.
Please check attached tableau workbook.
I am trying to find out eligible employees based on tags.
Meaning -
For ID 123, respected tags are male, and veg and their respected employees are 2131,122312,8686. The task is to find out all users in this data for each ID who are eligible.
E.g., for ID 123 (with its tag male, veg) find all the employees in this data who has either male Or veg tag in its employee_tag column. So for Id 123, along with its respected employees, 2131,122312 and 8686 der is another employee 333 who also has 'veg' in its employee tag. So total number of eligible employees for 123 has to be 4. (2131,122312, 8686,333) similarly for 124 it will be 2 (8689 and 122312 ),
for 1255 it will be 4 (8689,6656,332,333) and for 1256 *** will be 4 again (8689,6656,332,333).
statecityIDtagemp_id employee_tagnevadavegas123male,veg2131male,vegnevadavegas123male,veg2131male,vegnevadavegas123male,veg122312male,diabeticnevadavegas123male,veg122312male,diabeticnevadavegas123male,veg8686vegnevadavegas124Female,diabetic8689diabetic,italiannevadavegas124Female,diabetic8689diabetic,italiannevadavegas124Female,diabetic8689diabetic,italiannevadavegas124Female,diabetic8689diabetic,italiannevadavegas1255Italian,carowner6656carownernevadavegas1255Italian,carowner6656carownernevadavegas1255Italian,carowner6656carownernevadavegas1255Italian,carowner332italian,carownernevadavegas1255Italian,carowner332italian,carownernevadavegas1255Italian,carowner332italian,carownernevadavegas1256Italian,carowner333italian,veg
In attached workbook I tries doing it but not successful.
I used Haitham Farouk Sheet to complete what you need. Great Thinking by Haitham on this. So finally you have this:
Thanks
Deepak
