Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
andre_bento
Contributor III

Filtering date for autocalendar

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?

Labels (2)
2 Replies
Clement15
Partner - Specialist

Hello, does this work?

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

 

andre_bento
Contributor III
Author

Negative.