Multiple measures in one card?

NateBI
NateBI ⚪️

Hi All,

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

My data is structured like this example:


I would like to:

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


The Pie name option offers one input:


Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    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 ⚪️
    edited July 26

    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.