Summary Number - Display % for a member in pie chart

swagner
swagner 🟢
in Dataflows

This may be more of a beast mode question... but here goes.  I have a pie chart that shows business in either "Warehouse" or "DIrect" business.  I'd like to have the summary number for this card show the % the "Direct" business makes up of the total business.  For example, if the card shows Direct at 60% and Warehouse at 40% I would want the summary number to show "60%".

Comments

  • Godzilla
    Godzilla 🟢

    Try something similar to this in beast mode and make sure to check the "Apply to Summary Number" checkbox in the best mode window:

     

    SUM(Case when `LineOfBusiness` = "Direct" then `Value` else 0)/Sum(`Value`)

     

    Replace the `LineOfBusiness` and `Value` with the field names from your dataset

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • user05925
    user05925

    This does not work

Categories