Support date functions in OVER context

We need to summarize data in expression by Month(Date) ... but unfortunatly we currently cannot use MONTH function inside OVER context.

Attach files

Enter a subject

Guest

Oct 3, 2016

We are trying to implement Normal Quantile Plots using expression as follows:

NormInv (1 - (Rank(${Axis.X.Expression},"asc","ties.method=first",Minth([START_TIME])) / (Count(${Axis.X.Expression}) OVER (MONTH([START_TIME]))+ 1))) As [Quantile]

But this breaks if we use MONTH inside OVER

Reply
Hide replies
Like

The material provided is for informational purposes only, and should not be relied on in making any purchasing or investment decision. The information is not a commitment, promise or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at our sole discretion. © 2026 Cloud Software Group, Inc. All rights reserved

Please enter your email address

RELATED IDEAS

Support date functions in OVER context

NormInv (1 - (Rank(${Axis.X.Expression},"asc","ties.method=first",Minth([START_TIME])) / (Count(${Axis.X.Expression}) OVER (MONTH([START_TIME]))+ 1))) As [Quantile]