topic Get yearstart (and -end) of previous year of the selected year in Visualization and Usability

Get yearstart (and -end) of previous year of the selected year

reporting_neu — Fri, 14 Apr 2023 11:32:37 GMT

Hallo,

I need the yearstart (and "-end", respectively last year today) of previous year of the selected year:

Example:

Current year: 2023
Selected year: 2022
Needed:
Yearstart: 01.01.2021
End: 31.12.2021

So far I have used:
SUM(sales.date = {">=$(=yearstart(today(),-1)) <=$(=date(addmonths(MonthEnd(Today()),-12)))"}>}sales)

But this only applies to the current year (today()) and not to the selected year.

Who can help me?

justISO — Fri, 14 Apr 2023 12:03:24 GMT

Hi, maybe instead today() you can use max(year) as if you select year it will filter your datefield. Expression could look like this:

=sum({<sales.date={">=$(=Date(yearstart(Max(sales.date),-1)))<=$(=Date(yearsend(Max(sales.date),-1)))"}>} sales)

reporting_neu — Fri, 14 Apr 2023 13:17:35 GMT

Perfect! Thank you so much.