Line Charts in Dashboards - Need two lines on one chart
Hi there! I'm building a dashboard from data I'm collecting from and individual and their respective manager.
The individual rates themselves on a metric each week. The manager rates the individual on the same metric each week. I convert the ratings to numbers and put them in a row their own row - one for the individual and one for the manager. Each column is a week with a number to correlate when they performed the rating.
I want to see how the Manager rates the individual compared to how the individual rates themselves on the same chart as it's the same metric. I figured line chart would be the best so we can see the up and down week to week.
However, when I put these rows into a report for a dashboard, it only charts out the top row.
Am I missing something on how to turn it into two lines on a chart?