When creating a pivot table in Looker I can’t seem to include a null column for either axis in the visualization.
Here’s the scenario: On a certain cadence we get new credit bureau scores for loans. However, there could be loans which are not selected to get this new refreshed score in the next round. Or loans which were not selected for refresh in the previous round. I would like to get the count of loans for each credit grade where the axes are the different time periods and also have a display of the count of loans which have a certain grade during one time period but not the other.
Right now I have the same table without the null row and null column:
| Count for credit grade in Period 2 | Count for credit grade in Period 2 | |
|---|---|---|
| Count for credit grade in Period 1 | A | B |
| A | 12 | 3 |
| B | 2 | 11 |
But I would like to see something like the below:
| Count for credit grade in Period 2 | Count for credit grade in Period 2 | Count for credit grade in Period 2 | |
|---|---|---|---|
| Count for credit grade in Period 1 | A | B | Null |
| A | 12 | 3 | 24 |
| B | 2 | 11 | 6 |
| Null | 5 | 4 | 1234 |
How can I get this visualization with null column and null row counts?