Multiple Series in a Line Graph

Question

Hello,

I am trying to create a line graph in ArcGIS Dashboards that shows a monthly crime trend. I am trying to make each line a different year with month on the x-axis and incident count on the y-axis, similar to this chart:

However, in Dashboards the closest I can get is this:

Is there a way to format it like the first chart? Any help would be appreciated. Please let me know if you need additional information.

Thank you

JA7 · Accepted Answer

You cannot use a date field to get the look you want. If you reformat your data to include the following fields: Month, Year, and Value.

Then use the month field as your category field and split it by year.

To ensure the order of the months is correct, I would recommend using the numeric value and then using the categories label to set the month text.