Hi everyone 🙂
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
