How to manage leap years in a dataview?

Davenyr Fajutag
Davenyr Fajutag Active Partner
Second Anniversary Name Dropper First Comment Board Developer
edited March 10 in Platform

Imagine a dataview displaying a sales-related cube: the first column represents the current sales values, while the second corresponds to the previous year's (PY) sales values. I want to compare sales from January and February 2025 with those from the same months in 2024. However, the PY data is incorrect because Board does not account for February 29, 2024, in its calculations.

How can I resolve this issue? I’ve already tried setting the offset to -366, but it didn’t work.

Let me know.

Thank you in advance!

Answers

  • Hamza Mesbahi
    Hamza Mesbahi Employee
    5 Answers Second Anniversary 10 Comments Board Advanced Developer

    Hi @Davenyr Fajutag,

    What Board Version and revision (XX.X) is your application currently on?

    I know that starting from 12.4, there were updates made to specifically handle issues with data not showing correctly for leap months/years, where workarounds were needed previously to get that displaying correctly (see Board manual snippet below).

    image.png


    Kind regards,

    Hamza

Categories