I extract the year from a date, then I extract the year from current year, then I filter, then I aggregate… is there a shortcut to this?
Hi, could you explain more on what you’re trying to do here?
A little bit confused on the part where you extract the current year from the current date and then perform a filter. Why is it necessary?
If you’re just trying to group by the year in the nci_group_date_year column, that should be possible by directly following up the first “Extract date part” with an “Aggregate”. But I do imagine what you’re trying to do here is slightly more complex – a more detailed description with examples of the data/schema would be great!