Hi, I have a table similar to the below:
Id Number | User | Tag Description | Tag Value |
1 | Jack | Country | UK |
1 | Jack | Hair Colour | Red |
1 | Jack | Shoe Size | 41 |
1 | Jack | Profession | Author |
2 | John | Country | France |
2 | John | Hair Colour | Blue |
2 | John | Shoe Size | 45 |
2 | John | Profession | Nurse |
3 | Mary | Country | UK |
3 | Mary | Hair Colour | Green |
3 | Mary | Shoe Size | 38 |
3 | Mary | Profession | Finance |
In my visualisations, I have built pie charts for "Tag Description" column so that each is displayed in a pie chart. However, when I select one of the variables such as "UK" for "Country", all the other pie charts stop displaying since the other rows are ignored.
I currently use =If([Tag Description] like '*Country*', [Tag Value]). How can I use something like an index match to match values and sync across their shared Id Number column?