Multiple measures in one card?

NateBI
NateBI Contributor
in Charting

Hi All,

Is there an option for inputting multiple fields into the Pie Name?

My data is structured like this example:

image.png


I would like to:

1) Show the % breakdown of Total Cleans by Clean Type on a Pie/Donut Chart (% examples seen below the table)

image.png


The Pie name option offers one input:

image.png


Answers

  • GrantSmith
    GrantSmith Coach

    Hi @NateBI

    You'll want to use a Magic ETL and Unpivot your data such that you have a column for the different types of clean and then use that column in your Pie Chart. The pie chart only supports a single value for the pie name.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • NateBI
    NateBI Contributor
    edited July 2022

    Hi @GrantSmith, I want to avoid unpivoting the dataset in this scenario for various reasons but thank you. I found a work-around here:

    Update: To achieve a similar result I dragged the Clean Type columns onto a bar chart. I used one of the Clean Type columns as the X-Axis and hid the X-Axis label, then included the Percentage in the data label settings. The card will auto SUM the columns so it works or you can use a SUM() BM for each column.

    Caveats: If you add more value fields it will impact the percentage figures.

Categories