Hello, I have to create charts for survey data. Normal charts are okey, no problem with them.
To the point...
The survey, have an answer like :
"What do you read newspaper for?" (select all that apply)
This should work withe the ONLINE, using a Live MySQL connection. (the idea, is to not use complex mysql queries to obtain the results, as I would like the client itself be able to make the charts)
See... for this question, the data table from the MySQL looks like this :
|ID||Other Question||Other Question||What do you read newspaper for? (socials)||What do you read newspaper for? (sports)||What do you read newspaper for? (news)||What do you read newspaper for? (politics)||Other Question||Other Question|
So, each "ID" represents a single person who filled the survey. There are other questions, and this multi choice questions, are represented each one in one column, with a Yes/No.
I need to draw, in %, how much % of them use it for news, how much for sports, or how much for news. Like :
Sports [===========] 40%
Social [==============] 50%
News [======] 20%
Politics [=========] 30%
None [====] 15%
The problem, is that, when I try to make the chart, I get like multiple charts... not a single One.
I have read there is a pivot function to like merge the table in some way easy, but it does not work with MySQL... dunno why, when at the end, its a table anyway.
Problem is that, for each ID, I could have multiple selections, so I could not make just a "What do you read newspaper for" column, with a "Sports, Social, News, Politics" options (this would be very easy to chart).
Can anyone guide on how can this be done ?
OR... ANOTHER OPTION....
would it be possible, for the TABLEAU ONLINE, to have a "live" XLS connection to a file in a URL ? (I mean, to use whatever function is available for xls, that is not for mysql, like the pivot?) But I have not seen the option to link to a URL XLS, only to a local file, that is later "extracted" when you publish to the ONLINE.
I cannot change the way the MySQL table is shown, as this would be dinamic, depending on the questions asked... so I cant "pre-process" the MySQL out of tableau, or I cant "pre-process" any XLS in any way, as this would be needed to be REAL TIME ... (chart is being done, while survey is being run, automatically.)
Thanks in advance.