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:

Date	Web Registration	App Registrations
Jan-19	10	95
Feb-19	14	72
Mar-19	15	67
Apr-19	10	89
May-19	15	95

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.

Find more posts tagged with

Accepted answers

Godiepi

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

All comments

Godiepi

Hi @Akhil

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

Akhil

Thank you @Godiepi

That worked like a charm !!!