Forum Discussion

corbusier's avatar
corbusier
Icon for Advocate IV rankAdvocate IV
9 years ago
Solved

Modeling data for Funnel Chart

Hi all, I am looking for a way to display a Conversion Funnel for our app. We have 7 different stages, and one user would have to go through the different stages in order to get to the end (sorry if I'm stating the obvious). 

 

Since we have multiple data sources, I've joined them all with a query that also pivots the data so it looks like this: 

 

App Version | User ID | Stage 1 timestamp | Stage 2 timestamp | Stage 3 timestamp  .... etc (with NULLs if the Stage doesn't exist). 

 

I see no way of using this data with the Funnel Chart. Should I model the data differently? We need the App Version to filter the report, but for the rest we just need the counts.

 

The second question is that the data isn't always reliable so you could have a User missing a couple of steps but still having Step 7 completed, for example. How do we deal with that? 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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