year to date in bar chart

[Metal-SheetKft]

How can I set a bar chart as year to date chart.

First bar: datas between 1. January this year and today

Second bar: datas between 1. January last year and the same day and month as today in the last year.

[LRuCelver · Accepted solution]

You can use set analyses to restrict the data:

CYTD: {<DateField={"<=$(=Today()) >=$(=YearStart(Today()))"}>}

PYTD: {<DateField={"<=$(=AddYears(Today(), -1)) >=$(=YearStart(AddYears(Today(), -1)))"}>}

You might have to add additional calendar fields to the expression so they can be ignored:

{<MonthField=, YearField=, DateField={"<=$(=Today()) >=$(=YearStart(Today()))"}>}