How to build acard to show breakdown of revenue by Margin % on transactions
Hi,
I would like to build a card to show how much revenue is generated by sales at different margin % bands.
Is there an easy way to accomplish this? I think I could add a column to the dataset (already over 100 columns) to categorize each transaction. Is there another way to approach this?
I have a Revenue dataset with hundreds of different product types.
Each record has the customer, product, date, sales revenue, cost, Margin & Margin % on it.
What I would like to do is display visually how much of the revenue is generated from sales from each margin band: < 25%; 25% - 50%; 50% - 75%; 75% - 100%
If we had 1m in sales in a month, you could see how much has a margin of < 25%, 25% - 50%...
Thanks
John
PS is the slack domousergroup still open, how do I get an invite to this.
Best Answers
-
Hi @Jobur
You can utilize a beast mode to create buckets for your margin % the following beast mode works since it evaluates the first condition it finds to be true and exits. If you want to sort by these values you can make another beast mode with the same logic but instead of the string (75-100%) you can return a number (2) and use that in your card sort
CASE WHEN `margin_pct` 1 THEN '100%+' WHEN `margin_pct` >=.75 THEN '75-100%' WHEN `margin_pct` >= .50 THEN '50-75%' WHEN `margin_pct` >= .25 THEN '25-50%' ELSE '< 25%' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
this is for the community slack group.
this is for the semi-official Domo slack group.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
Hi @Jobur
You can utilize a beast mode to create buckets for your margin % the following beast mode works since it evaluates the first condition it finds to be true and exits. If you want to sort by these values you can make another beast mode with the same logic but instead of the string (75-100%) you can return a number (2) and use that in your card sort
CASE WHEN `margin_pct` 1 THEN '100%+' WHEN `margin_pct` >=.75 THEN '75-100%' WHEN `margin_pct` >= .50 THEN '50-75%' WHEN `margin_pct` >= .25 THEN '25-50%' ELSE '< 25%' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Thanks Grant - I knew there had to be an easier way to do it. 😀
Do you know if there is a domouser slack channel? I think I saw it mentioned on the forum before
0 -
this is for the community slack group.
this is for the semi-official Domo slack group.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive