Solved: Year filter new charts

Mounzor · 01-02-2025 04:33 AM

Hello,

I'd like to solve a problem, but I don't know if it's feasible.

We've just moved to 2025 and my charts still show 2024 in terms of data.

What I've done is to add this expression to the corresponding slice in the conditions

AND(
YEAR([start_date]) <= YEAR(TODAY()),
YEAR([end_date]) >= YEAR(TODAY())
)

It shows me the data for 2025, but if I filter on 2024, it doesn't show me any corresponding data...

Thanks

Steve

Oooooh! You want the filter pre-filled with the current year but the user may choose to change it. OK, that makes sense.

The challenge you have is that there's no way to pre-fill the built-in search & filter feature. To get what you want, you'll have to implement your own filter feature. These search results should give you some ideas on how to do this.

View solution in original post

Steve

Your statements are somewhat contradictory. You've configured your slices to only include 2025 but are confused why they don't include 2024?

Mounzor

I understand that it's contradictory, but I can't find the right wording to indicate that by default it should display the current year, but that if I use my filter to filter the previous year, for example, it displays data for 2024.

Steve

Oooooh! You want the filter pre-filled with the current year but the user may choose to change it. OK, that makes sense.

The challenge you have is that there's no way to pre-fill the built-in search & filter feature. To get what you want, you'll have to implement your own filter feature. These search results should give you some ideas on how to do this.