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


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

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'


This discussion has been closed.