Hi, i just upgraded to cn-ce-2.2.1 to take advantage of the new features (FIRST_VALUE, LAST_VALUE) which is a welcomed addition… but have hit a bit of a snag, our data spans multiple years, our data range for example is 2019.01.01 - 2020.12.31, when i use

WITHIN ({…/*.year})

the first value is partitioned by

year

as you would expect… but what i need is the “first_value” to be 2019.01.01 and to use that for all subsequent calculations through 2020 and beyond, is there any way to do this? I tried changing the

WITHIN (...)

to a broader partition without luck

@Jakub Sterba?

Hi @hunger regnuh, try

WITHIN (ALL OTHER)

aaah DOH! forgot about that, my maql is rusty, i’ll try that later, thanks!

It should create one big partition. Use ALL with date attributes if you want non-date attributes to partition the results. I jope it is going to work for you

i think it will, i’ve used similar in other queries, i’ll report back later if it works - thanks again 😄