Bar Chart Beastmode
Hi,
This problem has been given me issues for awhile now and I am completely lost. I have a bar chart that uses a specific beast mode.
CASE
WHEN SUM(Loads
) * (SUM(carrier pay
)/ SUM(Loads
)- avg(DATAllinAvgCPL
)) > 0 THEN SUM(Loads
) * (SUM(carrier pay
)/ SUM(Loads
)-avg(DATAllinAvgCPL
))
Else 0
END
The issues arises on the bar chart if I don't include a series. (This chart is calculating an incorrect number of 41,162.14
However when I add a series it calculates the correct number but the bar chart is not a solid color. I ideally want a solid bar chart. What might be causing this issue?
Answers
-
What fields do you have in the filter and sort columns?
If I solved your problem, please select "yes" above
0 -
ColemenWilson No filters, And sorted by date field.
0 -
If you remove all filters and sorts does it resolve the issue?
If I solved your problem, please select "yes" above
0 -
Removing all sorts and filters (while removing the series) results in the same problem.
0 -
This means most likely that you don't really want your beast mode to calculate over the raw totals of your dataset (which is doing now), but rather to SUM the cases in which this happens, for that you'll need to turn this into a WINDOW function, so it'll work the same way it does when you have Series, but without the series actually being present in the chart. It might end up looking something like:
SUM(CASE WHEN SUM(Loads) * (SUM(carrier pay)/ SUM(Loads)- avg(DATAllinAvgCPL)) > 0 THEN SUM(Loads) * (SUM(carrier pay)/ SUM(Loads)-avg(DATAllinAvgCPL)) Else 0 END) OVER (PARTITION BY `Lane`)
Hope this points you in the right direction.
0 -
marcel_luthi I thought so too. When I use the formula you provided I get a chart that looks like this.
0 -
I dont know if this might be the cause of the issue but the DATALLINAVG is calculated in the ETL using a formula tile. The formula for that is
PC-Miler Practical Mileage
*(Contract Avg Linehaul Rate
+Contract Fuel Surcharge
)0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive