Visualisation of records found in only one of two linked tables
Hello,
I would like to list the articles which are NOT matched when I link two tables (for example, employees who are found in the list of all employee training courses, but NOT in the list of all current employees, when the two are linked by the common employee-ID field).
So far, I see these only as a grey bar with "-" for null. I understand that that bar cannot be used for selection.
I am thinking there must be some way to "select for null" - perhaps using the "replacement" feature, or creating a calculated field with an if(isemptynull()) syntax.
But I thought I would ask whether others have a recommended way to deal with this situation - My goal would be to provide a table to allow further investigation of the offending records - assuming no inactive employees should be listed among those enrolled in trainings.
To assist anyone inspired to reply, here are some approaches I have been considering. Perhaps someone has experience with one or the other, or can suggest a better overall approach:
a) Using a formula in the "dimensions" part of a given visualisation (or as a master element) which "works around" the null value and allows selection by replacing the "null" with a selectable placeholder text.
example: =if([dimension with null values] & [measurement]=[dimension with null values],'selectable placeholder text',[dimenstion with null values])
b) editing the script and/or action for the association of the two tables in the data load editor
