Forum Discussion
Modeling data for Funnel Chart
Hi corbusier,
I test it using your sample table.Please replace the table header using 1,2 and 3. Right click the table->Power Query, select the 1,2 ,3 columns and click the unpivot columns(highlighted in red line).
Click the apply&close on home page, you will get expected result.
Best Regards,Angelia
Hi corbusier,
Have you resolved your problem? If it didn't, is there any chance to post your sample data or .pbix file for analysis? So that we can post solution which is close to your requirement.
Best Regards,
Angelia
Hi v-huizhn-msft, I gave the layout of the data in the question, and would like to actually get the data from a working Funnel visualization so I can see what it looks like, then model my data to behave the same. If you would like to know what the data is like in the source, I can give you that:
The main table contains the Started and Finished dates and current status of the User. We also have an Activity table that contains detailed activity of the User, from which we extract what is meaningful to us. Lastly, we also have an external Email service, from which we extract Clicks and Opens of the Emails that the user has received (one at minimum, two maximum).
I was able to use the UNPIVOT function in SQL Server to get my data in the form that I needed it. I actually Googled "Funnel Chart Tableau" and the first blog had an example of how the data should look.
http://www.evolytics.com/blog/tableau-201-how-to-make-funnel-charts/
The data should look like this:
Gender Step Players Female 1 371,393 Female 2 35,490 Female 3 36 Male 1 412,351 Male 2 36,741 Male 3 77 Whereas my data looked like this:
Gender Step 1 Players Step 2 Players Step 3 Players Female 371,393 35,490 36 Male 412,351 36,741 77 UNPIVOT worked.
Hi corbusier,
I test it using your sample table.Please replace the table header using 1,2 and 3. Right click the table->Power Query, select the 1,2 ,3 columns and click the unpivot columns(highlighted in red line).
Click the apply&close on home page, you will get expected result.
Best Regards,Angelia
Thank you, v-huizhn-msft, I hadn't seen that option!