Skip to content

    • Charting

    Charting

    Help with Bar Chart formatting

    Member
    in Charting

    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?

    With Series .png
    Without Series.png

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • Coach
      Answer ✓

      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 <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Member
      Answer ✓

      That solved it. Thank you

    Answers

    • Coach

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

      Screen Shot 2023-10-06 at 10.39.18 AM.png

      If I solved your problem, please select "yes" above

    • Coach

      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 <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Member

      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.

      image.png
    • Coach
      edited October 2023

      If I solved your problem, please select "yes" above

    • Coach

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

      If I solved your problem, please select "yes" above

    • Member

      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)

    • Coach
      Answer ✓

      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 <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Member
      Answer ✓

      That solved it. Thank you

    • Coach

      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 <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories