Jump to content

over intersect((some conditions),previous(%%)) works unexpectedly. Please help !

Jihye Kim

Recommended Posts


Trying to use over function with previous, I found it didn't work as I expected.

This is what I did and it does't work for the first intersect group.

please let me know which part i did wrong .

Thank you!


calculated column [test2]

= Avg( [VALUE]) over (intersect([iTEM_ID],Previous([time])))

and [test2] works like below


expected result would contain CD1,2020-05-20,1,3

Link to comment
Share on other sites

  • 2 weeks later...

Hi beingolaf,

The problem comes from the fact that your timestamps, are not a continuous scale. If you change the time for the second row from May 30th to May 25th, you will see that your calculated column is exactly working like you expected.

But in the above case, the node gets broken and will not display the value of 3, as you expected.

I don't know yet how you could sort this one out. I will try to come up with something, if any.

kind regards,


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...