I would like to combine 2 different dimensions into a single one. I have 4 fields:
- Expected Amount - Expected Date
- Actual Amount - Actual Date
My aim is to create a single bar graph where to show Actual vs Expected, considering a single Date dimension (obtained as combination of Expected Date and Actual Date).
i.e. 01/07/2021 100€ (actual amount) 15/07/2021 10€ (expected amount)