Reply
Highlighted
Visitor
Posts: 3
Registered: ‎02-12-2017
Accepted Solution

Summing a field based on filter criteria

I am trying to create a summary number showing the percentage of the total that is "open" (as opposed to closed lost or closed won). I have been playing with beast modes and have not been able to figure out how best to display this.

 

As an example, we would have 400 accounts that we are displaying trends in a card, but the summary number I want to say "42% Open", as in 42% of the total is still in play.

 

Any ideas?

 

Thank you!


Accepted Solutions
Solution
Accepted by topic author Tuliprush
‎02-16-2017 05:18 PM
Blue Belt
Posts: 176
Registered: ‎07-17-2015

Re: Summing a field based on filter criteria

A beastmode should do the job. you mentioned you have been playing with beastmode but have not been able to make it work. Can you share the beastmode code you are attempting to create so we can take a look and tell you if it has something wrong, and how to correct it?
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'

View solution in original post

Solution
Accepted by topic author Tuliprush
‎02-16-2017 05:18 PM
Yellow Belt
Posts: 42
Registered: ‎12-01-2015

Re: Summing a field based on filter criteria

@Tuliprush, I am glad that I was able to help you. Thank you for calling into Domo Support.

View solution in original post


All Replies
Solution
Accepted by topic author Tuliprush
‎02-16-2017 05:18 PM
Blue Belt
Posts: 176
Registered: ‎07-17-2015

Re: Summing a field based on filter criteria

A beastmode should do the job. you mentioned you have been playing with beastmode but have not been able to make it work. Can you share the beastmode code you are attempting to create so we can take a look and tell you if it has something wrong, and how to correct it?
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'
Solution
Accepted by topic author Tuliprush
‎02-16-2017 05:18 PM
Yellow Belt
Posts: 42
Registered: ‎12-01-2015

Re: Summing a field based on filter criteria

@Tuliprush, I am glad that I was able to help you. Thank you for calling into Domo Support.

Announcements
Customize your Dojo Handle! You can update your Dojo screen name by clicking on My Settings. click here! Thanks!