Need help urgently, Wanted to create a Dashboard 1 and 2 below. I know how to create 1... Please guide me how to create a Dashboard 2. Hereby shared sample data.
Received 3 type of instructions every day. Say A, B & C.
Team behaviour
Some days only A instruction came, B & C are NULL
Some days only B instruction came, A & C are NULL
Some days only C instruction came, A & B are NULL
Some days A & B instruction came, C is NULL
Some days A & C instruction came, B is NULL and so on…..
But, I need to create the dashboard for A, B & C as final result. Wherever the instruction not came, those Variable marked as ‘0’.
| Table 1 | | | Table 2 | |
| Variable | Constant | | Variable | Constant |
| A | 1 | | A | 1 |
| A | 3 | | A | 3 |
| A | 5 | | A | 5 |
| B | 1 | | C | 5 |
| B | 2 | | C | 6 |
| B | 3 | | C | 7 |
| C | 5 | | | |
| C | 6 | | | |
| C | 7 | | | |
| | | | | |
| Dashboard 1 | | | Dashboard 2 | |
| A | 9 | | A | 9 |
| B | 6 | | B | 0 |
| C | 18 | | C | 18 |
