Hi, I have a straight table with following dims and expressions:
Dims: Project, Priority
Expression: Breach
eg:
Project Priority Total Breach
A Severity1 10 5
A Severity2 20 10
A Severity3 15 12
B Severity1 8 2
B Severity2 9 5
B Severity3 8 2
The expression "Breach" is calculated as below:
count(if(upper([Response SLA])='MISS', Key))
Note: Key and [Response SLA] are 2 fields from the source.
My requirement is to see all Keys(in a table box) when any "Breach" cell is selected in the above chart. The issue I am facing is I am not able to drill down on the "Breach" field - when I select any cell on Breach field, it gives me all Keys for that specific Project and Priority(i.e the "Total" field)
Thanks
Sam
