Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
key | amount | dept | passfail |
key1 | 100 | IT | PASS |
key2 | 200 | CSE | PASS |
key3 | 300 | EEE | PASS |
key4 | 400 | ECE | PASS |
key5 | 500 | COMP | PASS |
key1 | 100 | IT | PASS |
key2 | 200 | CSE | PASS |
key3 | 300 | EEE | PASS |
key4 | 400 | ECE | PASS |
key5 | 500 | COMP | FAIL |
key1 | 100 | IT | FAIL |
key2 | 200 | CSE | FAIL |
key3 | 300 | EEE | FAIL |
key4 | 400 | ECE | FAIL |
key5 | 500 | COMP | FAIL |
key1 | 100 | IT | FAIL |
key2 | 200 | CSE | FAIL |
key3 | 300 | EEE | FAIL |
key4 | 400 | ECE | FAIL |
key5 | 500 | COMP | FAIL |
Hi above is my data.
In this I need to show bar chart for the dept for the FAIL ,in order to show the key count and amount .
so how to use the calculated dimension and for the dept for the FAIL and then the expression how to toggle between the record and dollar value
Check the attached
Expressions used:
1) =Count({<passfail = {'FAIL'}>} key)
2) =Sum({<passfail = {'FAIL'}>} amount)
When viewing count
When viewing Sum of amount