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

Reply
| 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

0 reply Hide replies

This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us

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]