Can you combine 3 different columns in a pie chart?

Katie_Forrest_2022
Katie_Forrest_2022 Member
in Charting
image.png

Hi, I'd like to display the percentage of hard, medium and easy clients per PM in a pie chart. Is it possible to write a beast mode which can be used to combine the data? Thanks, Katie

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    If I am understanding you correctly, you could make a percentage beast mode for each type, like this:

    Easy Client Pct: Easy Clients / Easy Clients + Medium Clients + Hard Clients

    Medium Client Pct: Medium Clients / Easy Clients + Medium Clients + Hard Clients

    Hard Client Pct: Hard Clients / Easy Clients + Medium Clients + Hard Clients

    You might also consider using the Unpivot tile in Magic ETL, so that your data is restructured to something like this:

    PM Client Type Count

    Jim Easy 53

    Jim Medium 23

    Jim Hard 11

    John Easy 12

    ....

    Here's the KB article on the Unpivot tile if you haven't used it before.

    https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#3.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories