Hi,
I have a dataset with current date and YTD values, which are calculated at a daily interval:
| Calendar Date | Current Date | YTD |
| 01/05/2019 | 10 | 10 |
| 02/05/2019 | 15 | 25 |
| 03/05/2019 | 23 | 48 |
| 04/05/2019 | 46 | 94 |
| 05/05/2019 | 90 | 184 |
| .. | 240 | 424 |
| 31/05/2019 | 20 | 444 |
| 01/06/2019 | 23 | 467 |
| 02/06/2019 | 12 | 479 |
| 03/06/2019 | 32 | 511 |
| 04/06/2019 | 89 | 600 |
| 05/06/2019 | 90 | 690 |
| .. | 500 | 1190 |
| 30/06/2019 | 10 | 1200 |
I would like to create a chart showing YTD values, which would have month (rather than calendar date) as dimension - so for May 2019, the value should be 444 (value as of 31/05/2019), for June 2019 - 1200 (value as of 30/06/2019). However, because of different granularity, using month on X axis sums all calendar date values for that month - so e.g. for May 2019 I get 1229 which is incorrect.
Is there a way to show YTD values on a monthly chart so that the values are not mis-summed?
Many thanks,
Laura
