Hi Guys,
I expect my case is a bit confusing.
This is the data that I have
| City Id | Modality | Q1 | Q2 | Q3 |
| Auckland | KI | 23 | 35 | 65 |
| Auckland | HH | yes | no | yes |
I created dashboard for this sort of data, alright! My issue is when I select Auckland from the filter pane, I got 2 records which is fine, I wanted to show in two different tables : Data for KI, and the data for HH according to the modality, the issue is I always get the data for the KI right but I could not write correct equation to get the yes and no displayed correctly for HH. Could you please help me if I can choose which record I need to get from the filter selection without adding filter with KI/HH.
I tried this but never worked for me: in KPI
IF(count(if([0.KI/HH] ='KI',1,0)) > 0 and ([27.Security issue] = 'Yes' or [27.Security issue] = 'No' ) ,[27.Security issue], 'No Answer')
Please note that I don't want to let the user select KI or HH, I wanted to do this in the code behind & I want to show the output as KPI. Otherwise it will be easy to use tables.
Thanks, -H
