Forum Discussion
Solved
Create matrix with static columns
I have a data table that follows the following format:
| Source | Status | Count |
| A | Completed | 10 |
| A | TO-DO | 2 |
| B | In-Progress | 5 |
| B | TO-DO | 5 |
| B | Completed | 10 |
| C | COMPLETED | 6 |
There are 4 possible values in status: "COMPLETED", "IN-PROGRESS", "TO-DO", "FAILED"
Sometimes one of the above status values will not be in the data table. In this example, "FAILED"
I want to create a matrix with static columns for the status values.
So for the above table, I want to create a matrix that looks like the following
| Source | COMPLETED | IN-PROGRESS | FAILED | TO-DO |
| A | 10 | 0 | 0 | 2 |
| B | 10 | 5 | 0 | 5 |
| C | 6 | 0 | 0 | 0 |
| D | 0 | 0 | 0 | 0 |
Currently my matrix displays the above table without the "FAILED" column since this value doesn't appear in the data table.
How can I create a matrix with static columns to display "COMPLETED", "IN-PROGRESS", "FAILED", "TO-DO" ?
