Hi!
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.
