How to create a pie chart from two columns (Fee A and Fee B)?

Q&A
, ,
1

In my dataset, I have two columns: Fee A and Fee B. I want to create a pie chart to compare the percentage of Fee A in the total (A+B) and Fee B in the total (A+B).

2

Hi @chanhlm,

Hope this message finds you well! Quick Sight’s pie chart visual does not currently support adding two fields, as it does not know how to interpret which partitions are for A or B (as shown below):

image
image1920×699 92.8 KB

You can most likely work around this though in two ways:

  1. Making two different pie charts, one in which A is compared to the total, and the other in which B is compared.

  2. Reworking the dataset in a way that Fee A and B values are combined into one column, and then adding in each row the distinction of A or B so that the comparisons can be done automatically while consolidated into one field.

Let me know if this helps!