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

Akhil
Akhil Member

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

Answers

  • 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'
  • Akhil
    Akhil Member

    Thank you @Godiepi 

    That worked like a charm !!!

This discussion has been closed.