I'm trying to create a stacked bar chart in which I can see the saving of each project per month.
The data is a pretty straightforward Excel:
ProjectID
DateFinished
Saving
12345
01/09/2020
300
12346
08/09/2020
160
12347
15/09/2020
510
If I use DateFinished as a dimension and the sum of Saving as a measure, it shows a nice graph about savings over time but I'd like to:
See the data per month
See each different ProjectID and their respective saving stacked in each bar
To tackle that first issue I found "=Date(Monthstart(DateFinished),'MMM-YYYY')" to be quite efficient but I can't get the sorting right. And I don't even know how to begin tackling the second issue.
Using Qlik Sense Enterprise September 2019 Patch 6