Help with Bar Chart formatting

ColinHaze

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?

MarkSnodgrass

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.

ColinHaze

That solved it. Thank you

ColemenWilson

Do you have any fields set in your sorting for the card? Also, is your total opportunities beastmode an aggregate function (sum, max, etc…)

MarkSnodgrass

I would also check to make sure the Y-Axis is set to Sum (or the appropriate aggregation type).

ColinHaze

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 BY LastdayofMonth)

And ive also removed all the filters. I am still getting this.

ColemenWilson

ColemenWilson

I believe it is because of the OVER (PARTITION BY LastdayofMonth).

ColinHaze

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)

MarkSnodgrass

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.

ColinHaze

That solved it. Thank you

MarkSnodgrass

Which suggestion solved it? If you can mark that response as an accepted answer that will help others in the community.