Stacked chart with 2 separated variables

[Anonymous]

Hi friends,

Please help me with idea how to make stacked chart with 2 separated variables.

Please find my QV file.

Thanks,

[Nicole-Smith · Accepted solution]

Change your load script to:

CrossTable(Type,Answer,2)

LOAD respondentID, surveyID, [qID_16630_128092_Business travel] as Business, [qID_16630_128093_Leisure travel] as Leisure;

SQL SELECT [respondentID]

      ,[surveyID]

      ,[qID_16630_128092_Business travel]

      ,[qID_16630_128093_Leisure travel]

FROM [aaa_787];

Then on your chart:

Dimension 1: Type

Dimension 2: Answer

Expression: count(Answer)/count(total <Type> Answer)

Example file is attached.

[Anonymous]

Thanks Nicole.