Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
i want the below format
Current matrix report | |||||
stage 1 | stage 2 | stage 3 | stage 4 | Count | |
camp1 | 5 | 1 | 8 | 14 | |
camp2 | 1 | 1 | 1 | 1 | 4 |
camp3 | 2 | 2 | |||
camp4 | 1 | 2 | 3 | 6 | |
camp5 | 2 | 4 | 6 | ||
I want vaues of stage 3 against camp in report | |||||
stage 3 | Count | ||||
camp2 | 1 | 4 | |||
camp4 | 3 | 6 | |||
camp5 | 2 | 6 |
Solved! Go to Solution.
You can do one thing.
After Placing data on to the matric table. You go to the Visual Filter secton, there under Stage 3, select Is not blank.
You could simply ignore other stages in Matrix columns?
excludin other stages impacting the total count.
any way thanks for you though.
I see that you edited your Question. In the First version, there are blank included in the Stage3 (expecting result).
yes.. as there is no values for stage 3 i ahve removed those camps intentinally.
even if they display also no matters.
You can do one thing.
After Placing data on to the matric table. You go to the Visual Filter secton, there under Stage 3, select Is not blank.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |