how we can just add the date month arrespective of date range. If I just wants to add data from jan , march, dec 2023 only. irrespective of Jan-Dec date range how we can just pick silective month data in column
You can use truncDate to group your dates to months, then cast it to a string and use that field as your filter.
The calculated field would look like this:
toString(truncDate('MM',{snapshotdt}))
1 Like