I’m calculating a YTD filed with the function “periodToDateSumOverTime”.
It works fine and I represent this as a line with months in the X axis.
The problem comes when I apply a time filter to the visual. The YTD measure just take into consideration the values inside the time filter. For example if my filter start data is September, the YTD doesn’t count with the months from January to September.
Is there a way to change this behavior?
Why do you want to filter this?
If you always want the year to date and don’t want to filter out the data, then why do you filter it?