topic Re: Filtering date for autocalendar in Data Movement & Streaming

Filtering date for autocalendar

andre_bento — Wed, 19 Mar 2025 22:11:20 GMT

Good afternoon,

I created a line chart to verify trends, seasonality and patterns and I am using as dimension Year.Month from autocalendar, I am trying to filter my date in order that only the values from January 2021 onward are plotted on it, I used the following expression "= {<[DATE.autoCalendar.YearMonth] = {"$(='>=2021-01')"}>} [DATE.autoCalendar.YearMonth]" but values prior to 2021-01 are still being shown. How can I update my set expression in order to achieve this?

Re: Filtering date for autocalendar

Clement15 — Wed, 27 Mar 2024 15:12:58 GMT

Hello, does this work?

= only({<[DATE.autoCalendar.YearMonth] = {">=$(='2021-01')"}>} [DATE.autoCalendar.YearMonth])

Re: Filtering date for autocalendar

andre_bento — Wed, 27 Mar 2024 15:58:32 GMT

Negative.