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

markb

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.

GrantSmith

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`)

markb

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?