Jack_Machesky
04-29-2024Cloud Apps
Date filter quarters versus days in calendar
Hello, my organization is having an issue with one of our dashboards. When filtering on the date of invoices, the historical data is sometimes not showing the correct values. We use a date filter, and should be able to see both the current period values as well as the previous period values. The previous period values are found using the PASTYEAR() Function. When we filter by quarter, the previous period shows the correct value. However, when we filter by a date range in the calendar, such as 01/01/2024 - 03/31/2024, this number is now incorrect. Any ideas to what might be going on here?