I have 2 tables -
Table1
ID | Name
12 | Rohan
13 | Siddhi
14 | Rob
Table2
ID | Subjects
12 | Hindi
12 | English
14 | German
These tables are associated using ID in data manager.
When I create a Vizlib table using these fields, I get the following table -
ID | Name | Subject
12 | Rohan | Hindi
12 | Rohan | English
13 | Siddhi | -
14 | Rob | German
I want to create a vizlib pie chart that will allow me to find ID's present in Table1 but not in Table2 (If we are looking at it from vizlib table perspective it should give information about entry 3 (ID -13)).
I want to use it in a way that if I select 'N' in my pie chart it will only show "13 |Siddhi |- " in my vizlib table and if 'Y' is selected it should show -
12 | Rohan | Hindi
12 | Rohan | English
14 | Rob | German
Apart from this there are some other filters that I am also using in form of a set expression (Status - canceled) which only applies to table1.
I was thinking If there's some way in which I can get information about which Id corresponding to table1 are present in table2 and which is not. If somehow i can calculate this , I can use this to split the data. But I am not able to figure it out.
Right now I created a calculated field in table2 (let's call it Check) and set it to 'Y'. And in the pie chart, I used -
Measure - Count({&< Status = {'Canceled'}>} distinct ID)
Dimension - Check
This gives me a pie chart where the total values shown are 3; 2 value appear in slice 'Y' and 1 value appear in slice '-'.
I can select the slice 'Y' but not '-'. my guess is since it's not a value that exists in table 2. hence I cannot select this. But I want this functionality, where I can obtain these records and filter other components existing in the sheet to update also accordingly.
What should be used as 'measure' and 'dimension' in pie chart?
Please help !!
