I am trying to create a visualization that will show the number of IDs that are missing a certain field. For example, I may have 10k IDs of which 8k do not have an OpenDate. Users want to see this number of IDs missing an OpenDate segmented by a dimension called Product. They also want to be able to see the number of IDs missing other fields as well in the same visualization so that they can look across each Product and see which fields are well populated and which aren't
Currently, I have a pivot table that has Product as a Row and then I have added about 8 measure of which all of them do Count (if(field='', ID,null()) where field is one of the fields that I want to check if it is populated or not (e.g. OpenDate). I put these measures as columns in the pivot table. This works as it shows the number of missing IDs for a bunch of fields all in 1 table.
But I would like to be able to add a drill down for the specific IDs that are missing a field. For example, I would like to be able to click on the data point that says 8k IDs missing OpenDate and have a pop-up of the 8k IDs. This pop-up could be in a separate table. Is it possible to create a Master Item Measure with a drill down? Or could I have a pivot table or table that can have a measure that has an interactive action that would trigger a pop-up of another table?
Thank you,
Brian
Please let me know if this is not the path you are looking for.
