Laflet's avatar
Laflet
Cloud Apps
07-03-2025
Status:
New Idea

PASTYEAR function issue with leap years

Hello Sisense Team,

I encountered an issue while using the PASTYEAR function in a column chart with date/month as a category. Specifically, I noticed that there is no data displayed for February 29th from last year. I assume this is because the current year isn't a leap year. Could you please advise on how to resolve this issue?

I'm looking to return the current year's values split by months, alongside last year's values. Last year's values should display regardless of whether or not i have a value this year. Any guidance or solutions would be greatly appreciated!

Thank you.

1 Comment