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
-
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 -
That is brillinat, thank you so much!
Ben
1
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 373 Beast Mode
- 20 Variables
- 484 Automate
- 102 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive