I´m having a problem how to join values of multiple field into one row. I have 3 different kind of fields which all comes from same SQL sourse with different attributes:
Vastaustapa:
LOAD
if(REPORTMEDIAID='FAX', 'Yes', 'No') as FAX,
if(REPORTMEDIAID='PAPER', 'Yes', 'No') as Paper,
if(REPORTMEDIAID='HL7', 'Yes', 'No') as HL7,
W_KEYID1 as Request_number
;
I´m using Request_number as a dimension in table box. One Request_number can have 'Yes' and 'No' values simultaneously in different fields.
I´m not quite sure how to represent this in one chart correctly because it should show only one row.
FAX
HL7
Paper
Request_number
No
Yes
No
28438
Yes
No
No
28438
There should be only one row containing yes in fields FAX and HL7 an noin Paper.
