Help with Bar Chart formatting
Hi,
Quick question. Im having an issue where every time I remove the 'Series' part of my chart, it adds multiple values on the X axis that are the same. When I add the 'Series' it has two bar charts (Which is what I want) but it doesn't look visually appealing. I want the two normal Bar charts with the total Value (658,739 & 477,743)on top and nothing else(6,472 / 6,148 /etc…). Any Tips?
Best Answers
-
You might need to apply an aggregation to your Dat Avg CPL field. Based on the field name, try adding the AVG() function around it.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
That solved it. Thank you
0
Answers
-
Do you have any fields set in your sorting for the card? Also, is your total opportunities beastmode an aggregate function (sum, max, etc…)
If I solved your problem, please select "yes" above
0 -
I would also check to make sure the Y-Axis is set to Sum (or the appropriate aggregation type).
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Here is the beastmode that is being used
SUM(CASE
WHEN SUM(Loads
) * (SUM(carrier pay
)/ SUM(Loads
)-Dat Avg CPL
) > 0 THEN SUM(Loads
) * (SUM(carrier pay
)/ SUM(Loads
)-Dat Avg CPL
)
Else 0
END)OVER (PARTITION BYLastdayofMonth
)And ive also removed all the filters. I am still getting this.
0 -
If I solved your problem, please select "yes" above
0 -
I believe it is because of the OVER (PARTITION BY
LastdayofMonth
).If I solved your problem, please select "yes" above
0 -
When I drop the 'OVER (PARTITION BY LASTDAYOFMONTH) I get stuck with this "This calculation contains an error."
SUM(CASE
WHEN SUM(Loads
) * (SUM(carrier pay
)/ SUM(Loads
)-Dat Avg CPL
) > 0 THEN SUM(Loads
) * (SUM(carrier pay
)/ SUM(Loads
)-Dat Avg CPL
)
Else 0
END)0 -
You might need to apply an aggregation to your Dat Avg CPL field. Based on the field name, try adding the AVG() function around it.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
That solved it. Thank you
0 -
Which suggestion solved it? If you can mark that response as an accepted answer that will help others in the community.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive