I am trying to put in the same graph:
- budget figures as a line
- last year figures as a bar chart
- actual sales figures as a bar chart
and I don't manage to do it.
I downloaded the file from Joe year_and_previous_year_sales_by_week_edit.twbx and the result is impressive but I can not reproduce it.
Attached is what I get (in small the results from Joe) and I don't find the trick to put them together. When I drag and drop the measure in the axis then I can only get line or bars.
Could you give me the trick to get your result.
Retrieving data ...