How do I show a 2 bar chart using 2 different columns?

PJG
PJG Member
in Charting

I'm sure I'm going to be embarrassed with how easy this is, but I can't figure it out. Made hundreds of cards, and I'm surprised I've never encountered this scenario before.

In my dataset, I have a column for PlannedHours, and a column for ActualHours.

I'm simply looking to make a 2 bar chart with each of those represented by one of the bars

Do I need to first combine them into a single Beast Mode attribute to plot on an axis? What's the code I need?

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    In the chart types, choose Grouped Bar. In your chart, drag PlannedHours into your y-axis and set an aggregation type. Next, drag Actual Hours into the series and set an 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.
  • PJG
    PJG Member

    Hi Mark,

    Thanks for the reply, but what you described is exactly what I have so far with SUM aggregation set for both.

    The issue is that Grouped bar also asks for Category (X-axis). In some other cards, I might use Date here, and plot by month, but in this case, I just want to show the total that matches my filters.

Categories