calculate % of field
Hi,
I am new to Domo and wondering how I can calclate the % of a field based on one of its values. I can essentially do this in excel using the following function, can I replicate this in Domo?
=COUNTIF(F2:F500, "Closed Won")/COUNTA(F2:F500)
The field that I am trying to count from is titled Stage (Column F) and I am looking to return the % of how many of the stage values are 'Closed Won', and show this in a bar chart for a month by month comparrison.
Would really appreciate it if someone could point me in the right direction.
Thanks
Ben
Best Answer
-
Hey Ben,
So assuming you have your data imported from Excel. When you're in the analyzer building your new card, hit the "Add Calculated Field" button in the bottom left to create a BeastMode.
Here's the way you would code this (Domo uses MySQL):
COUNT(CASE WHEN `Stage` LIKE 'Closed Won' THEN 1 END)
/
COUNT(`Stage`)
* 100The * 100 at the end is optional depending on how you format the field. But that will give you the percentage of Closed Won found for your range.
Since you're wanting to show this in a bar graph, you'll want to set your X axis field to your date field, and then use your new BeastMode as your Y axis.
Let me know if you run into any issues and I'll be glad to help you out.
Sincerely,
ValiantSpur**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2
Answers
-
That is brillinat, thank you so much!
Ben
1
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有