Stacked bar + line chart doesn't stack

Options
JonFass
JonFass Member
edited April 11 in Magic ETL

Hi all,

I'm trying to create a stacked bar + line chart that shows revenue amounts as bars broken out by revenue type, and the line as a count of contracts signed / won.

I've used beast modes to break down the revenue amounts into different columns by type and use that as series. However, no matter how I set this up, the revenue amounts won't stack but instead display as adjacent columns, each with the same period on x axis. It sometimes stacks briefly but then goes back to the wrong display when saving the chart. Any ideas on how to fix?

Screenshot 2025-04-10 at 8.08.12 PM.png Screenshot 2025-04-10 at 8.08.32 PM.png

Best Answer

  • JonFass
    JonFass Member
    Answer ✓

    So I was able to make this work by making the beast modes part of the data set - for some reason that did trigger the values to stack

    Thanks everyone for your help!

    Jon

Answers

  • GrantSmith
    GrantSmith Coach

    Try using a Grouped Line + Bar Chart under vertical chart types.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • JonFass
    JonFass Member

    Hey Grant,

    No luck with that either - I just get options for a single bar and 2 lines for series

  • DavidChurchman
    DavidChurchman Coach

    Can we see your BeastModes? I suspect there is some difference in how the two bars are aggregating giving them a hard time combining.

    Another (less likely) guess is something is off with the sort. Try adding date to your sort to see if that does anything.

    Please 💡/💖/👍/😊 this post if you read it and found it helpful.

    Please accept the answer if it solved your problem.

  • JonFass
    JonFass Member

    Hey,

    Sorting didn't help either

    Here you go for beast modes -

    Screenshot 2025-04-11 at 11.38.25 AM.png Screenshot 2025-04-11 at 11.38.45 AM.png

    The formulas reference columns I created in ETL -

    Screenshot 2025-04-11 at 11.41.21 AM.png Screenshot 2025-04-11 at 11.40.58 AM.png Screenshot 2025-04-11 at 11.40.26 AM.png
  • JonFass
    JonFass Member
    Answer ✓

    So I was able to make this work by making the beast modes part of the data set - for some reason that did trigger the values to stack

    Thanks everyone for your help!

    Jon

Categories