I can seem to figure out what how to set up a way to graph the following table into a graph with multiple lines. I have the following table:
I would like each row of the SRReportName be a different line and each column from ProcessingMinsYesterday and the rest (not SRReportName column) to be an value in the X-axis and the Y-axis to be that numerical value within the tables. So it would look like this:
You can represent each report by a line in the chart, just add SSRSReportName
to the Series
pane. However to get the desired x-axis you have to unpivot your ProcessingMins
columns from the query.