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.
I've tried creating this as a chart in the report studio, but ended up with an empty studio.
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?
I've tried setting the date both as an identifier and as an attribute, neither works. Am I missing a step in there?
A measure should have the Usage in your model set to Fact.
An Identifier is an equivalent to a key column in a database table.
An attribute is just, well, an attribute.
While I suppose if your date is stored as a number, you could treat it as a fact. But that makes no sense. Dates are not measures.