Summary Number - Display % for a member in pie chart

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

  • 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

  • This does not work