topic Re: Goal vs Actual line chart in ArcGIS Dashboards Questions

Goal vs Actual line chart

AliciaShyu — Mon, 24 Jul 2023 15:48:05 GMT

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

Re: Goal vs Actual line chart

jcarlson — Mon, 24 Jul 2023 16:39:40 GMT

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?

Re: Goal vs Actual line chart

AliciaShyu — Mon, 24 Jul 2023 18:04:37 GMT

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