Create Pie Chart for Two Columns/Measures with same data type

I have 2 columns in my data with  same data type.

 

The table looks like:

DateWeb RegistrationApp Registrations
Jan-191095
Feb-191472
Mar-191567
Apr-191089
May-191595

 

I want to create a pie chart showing the sum of the Web logins and sum of app logins.

How can the two columns/dimensions and related numbers be brought onto the same pie chart.

 

I went through the related question but the pivot and sql method did not help.

 

Any insights would be helpful.

Best Answer

  • Godiepi
    Godiepi 🟣
    Accepted Answer

    Hi @Akhil 

     

    you can easily create an ETL dataflow using the "Collapse Columns" option setting up up as shown in the picture below to create a new Dataset that allows you to create that Pie chart you are describing

     

    Screen Shot 05-28-19 at 09.49 AM.PNG

Answers

This discussion has been closed.