Creating a bar + line graph
I am having the hardest time just creating a simple card. My data is in the screenshot below. X-axis should be month, Y-axis should be commission, bars should represent the SUM of commission per month, and I would like the line to be a count of buyers.
I am unable to toggle between COUNT and SUM when I put Commission in the Y-axis position. Did I set up something incorrectly within the excel spreadsheet? Excel can create the exact graph I want in about 5 seconds, I'm not sure why I'm having so much trouble doing this in Domo.
Best Answer
-
Hi,
Is your Commission field a numeric field? Does DOMO report it in the measures group?
If not you can use this BeastMode to convert your Commission field to numeric and then you can add it to your y-axis and select SUM.
BeastMode:
TRIM(`Your_Commission_Field`)+0
You can also check your excel spreadsheet and make sure the column is formatted as a number...
Hope this helps
Ricardo Granada
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.1
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 134 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 52 Domo Everywhere
- 2K Charting
- 994 Ideas Exchange
- 894 Connectors
- 236 Workbench
- 342 APIs
- 76 Apps
- 18 Governance & Productivity
- 233 Use Cases & Best Practices
- 49 News
- 473 Onboarding
- 570 日本支部