Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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()))"}>}
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()))"}>}