So, I'm trying to create the simplest of line graphs.
The table has 3 columns, the date, a number (yyyymm), and total in sales.
So, to test my data, I put the data in the query studio. In my query studio I see all 3 columns with the proper data. However, when I click to change layout to a chart, I get an error that the report must contain at least one measure. I assumed that the date in yyyymm should me a measure and the total price as well no?
When I'm doing it in report studio the whole thing is empty, and x & y axis' are empty.
I've tried setting the date both as an identifier and as an attribute, neither works. Am I missing a step in there?
drag the date in the Categories(x-axis) and sales in Default Measures(y-axis) or series.