5 Replies Latest reply on Sep 30, 2018 7:50 AM by Shinichiro Murakami

    Show Null Combinations on a Frequency Matrix

    Ben Peterson

      Working on a Frequency Matrix that will show Member ID counts for combinations of Rules.


      Been able to show combinations of rules that have at least 1 Member ID.


      Can do it with either Table Calcs (which I prefer)


      forum question 1.png


      or with a self join of the dataset


      forum question 2.png


      How to show rules in the matrix that have no Member IDs?


      For example, if I add "Rule 4" to the dataset, with the Member ID field NULL,


      forum question 3.png



      the Table Calc version shows 1 Member ID when it should be 0


      forum question 4.png


      and the self join of the dataset shows no change - no surprise, as the join is on Member ID and Run Date


      I've attached a workbook and dataset.