Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have 3 variables (Platinum, Gold and Club) with answers Yes or No.
Is it possible to create chart with 3 variables (only who said Yes) in dimension and expression for them?
Or your other issues.
I created this chart with 1 variable (consist all 3 variables), but sometimes they have answers at the same time (Yes). And my chart shows wrong results, because I have different sample size.
Please find attached the file.
If you have any questions , ask me.
Thanks in advance,
Hi have you tried changing the format of your daa, something like this?
Thanks
Steve
Hi,
Thank you for your help.
I tryed your file and applyed to my file.
But I got multiplied sample size ( maybe I did wrong something) and result in chart should be 100% for each.
My current file has ID and other variables.
I take my data from SQL. Then I load
New:
noconcatenate load 'Platinum' as Attribute , Platinum as Response,* resident OLD;
concatenate(New) load 'Gold' as Attribute , Gold as Response,* resident OLD;
concatenate(New) load 'Club' as Attribute , Club as Response, * resident OLD;
DROP Table OLD;
Please find my file. and fix selection for a chart.
If you have questions, please ask me.
Thanks,
Any thought?
any ideas?