Chart issue with line bar chart: line is showing up as dots

markb
markb Member
in Charting

Hi - I am trying display a line bar chart combo but the line is displaying as dots and I want it to show up as a line. The dates for the line are at a lower frequency / longer duration (yearly) than the bar (monthly). Thanks for all the assistance.

Answers

  • GrantSmith
    GrantSmith Coach

    This is because you don't have data on a monthly basis so it's not plotting the data. You could possibly use a window function to calculate the max value in the year for your line to get a straight line across for each year.

    MAX(MAX(`value`)) OVER (PARTITION BY `Year`)

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

    So I'm already using a beast mode:

    CASE WHEN id='Constant_Variable' THEN 0 ELSE SUM('value') END

    How would I combine that in without a syntax error?

Categories