Skip to content

    • Archive

    Archive

    Using calculated fields in Card Summary

    Member
    in Archive

    We have two series listed on a stacked bar graph. Both series use a calculated field. We would like to show the totals across a time horizon as a summary number for the graph. However there seems to be no way to show values. Also it seems we can't select a calculated value. Is there another way to achieve this? Thank you.

    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

    Comments

    • Member

      Is anyone able to help out with this request?

    • Contributor

      @user07065 You should be able to put any of your calculated fields in the Summary Number. One thing to note is that they don't display with the "=" before the name when you're looking for them in the Summarry Number "Field & Function" dropdown. If you are still not seeing it in there, send a screenshot of the name of the beast mode and where it should appear in the dropdown.


      Thanks,
      Jake
      **Say "Thanks" by clicking the "heart" in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    • Contributor

      Can you share youre beast mode/calculated field?

      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

      @Godzilla I don't know what your column names and values are, but I've done it with all kinds of crazy stuff in my own cards. Here's an example of one I've done in a card on my instance:

       

      CONCAT('My Closed Cases this Week: ', SUM(CASE WHEN `Owner.Name`='Jake Harris' THEN 1 END),' / ',
      ' Agent Avg: ', ROUND(COUNT(`Owner.Name`) / (COUNT(DISTINCT`Owner.Name`)))
      )

       

      Do you have a specific beast mode that you are not able to use in the summary number? If so, share it and I can see if I can do something similar.

       

      (Unless your real question was wanting to know if it's possible to share Beast Modes, in which case, the answer is: Yes. You just need to check the box to share it on the DataSet when editing the Beast Mode.)


      Thanks,
      Jake
      **Say "Thanks" by clicking the "heart" in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    • Contributor

      @Godzilla @user07065 Something I realize I didn't clarify here that may be the issue you are running into: Summary numbers can only be aggregated fields. If you try to just stick a string in a Beast Mode, it won't allow you to use it by itself.


      Thanks,
      Jake
      **Say "Thanks" by clicking the "heart" in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    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