Goal vs Actual line chart

[AliciaShyu]

I need to create a line chart with two lines: one with actual numbers and another one that represents a downward trend to 0.  Like this:

Dashboard has the option of converting bar charts to line but is there a way to show two different lines? instead of one bar and one line, like below

[jcarlson]

Yes, of course! Set your chart to grouped values with the date as the category field. Then choose "split by field" and choose the field that differentiates between "actual value" and "goal". The two series should display as separate lines.

This assumes a certain structure to your data. Is everything in the same table?

[AliciaShyu · Accepted solution]

Thanks Josh! but I figured it out. I just needed to update the "Series" tab for the actual value from column type to line 😅