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