I don't seem to have the right dimensions and measures set up to allow for the line chart option to be selected. Can anyone suggest how I can create a line chart showing date on the x-axis with a separate line for the % values of each subcode?
The % values in my workbook below are a "percentage of row" table calculation.
I would create a combined field between Year and Week so the output would be 20181, 20182 etc.
Put this on the columns and can be either continuous or discrete.
Then have your %age field on Rows.
Finally your sub code on detail or on colour.
Hope this helps,