Skip to content

    • Charting

    Charting

    Using a Beast Mode Calculation in Summary Number

    Member
    in Charting

    I created a simple beast mode calculation to calculate a ratio out of 2 other columns in my dataset.  Is there any way to use this ratio in my Summary Number?  The option is greyed out; I assume because it's not an aggregation?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • Contributor
      Answer ✓

      you're correct. It has to be an aggregation for you to be able to use it as the Summary Number. 

      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'
    • Contributor
      Answer ✓
      so I assume your beastmode is something like: `column1`/`column2`? Next question is "average vacancy" if one building is 100% full and one is 50% full is the answer 75% (simple average) or is it a weighted (actual vacancy) based on size of building? I assume the second is preferable. Make the beastmode: Sum('column1')/Sum(`column2`) This should allow you to use it as a percentage in the summary number and it will work as a column calculation as well.
      Dojo Community Member
      ** Please like responses by clicking on the thumbs up
      ** Please Accept / check the answer that solved your problem / answered your question.

    Answers

    • Contributor
      Answer ✓

      you're correct. It has to be an aggregation for you to be able to use it as the Summary Number. 

      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'
    • Contributor
      There are ways to make it an aggregation depending on what you are trying to do. For example if Column 1 has three values: 1, 5 and 10 and Column two has three values of 1, 10 and 40 then I assume your besatmode is a calculation making percentages like: 100%, 50% and 25%? OR: are you making it something like 1:1, 5:10 and 10:40? in either case, you could create a beastmode that would let you show the calculation in the summary such as 31.3% or 16:51. what are you trying to accomplish?
      Dojo Community Member
      ** Please like responses by clicking on the thumbs up
      ** Please Accept / check the answer that solved your problem / answered your question.
    • Member

      Hi Shevy,

       

      My beast mode calculation is just a percentage like you mentioned.  My two columns represent the capacity of a building and the number of occupants, and the calculation is the % vacancy of the building.

       

      It's represented as a percentage, which is how I want it, but it's not considered an aggregation so I can't use it in my Summary Number.  What I would like to do is to show average vacancy for all buildings.

       

      Armen

    • Contributor
      Answer ✓
      so I assume your beastmode is something like: `column1`/`column2`? Next question is "average vacancy" if one building is 100% full and one is 50% full is the answer 75% (simple average) or is it a weighted (actual vacancy) based on size of building? I assume the second is preferable. Make the beastmode: Sum('column1')/Sum(`column2`) This should allow you to use it as a percentage in the summary number and it will work as a column calculation as well.
      Dojo Community Member
      ** Please like responses by clicking on the thumbs up
      ** Please Accept / check the answer that solved your problem / answered your question.
    • Member

      Thank you!  This worked.

    • Member

      Hi @Shevy , 

      What would I do to show the highest ratio in the summary? In your ex above, I'd want the summary to show 100%.

       

      Thanks!

       

    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories