Grabbing record out of each of series that matches a date?

3rd Party Modules
1

Trying to use integration toolkit expressions for the first time in a for fun project to sharpen up my skills after a bit of an absence.

I have a TimeSeries chart with a variable number of Series with data that will look like
image

Left hand are midnighted dated times, right hand side a column with a column name related to a stock. Right now I just want to try to get a single record by matching it to a datetime custom property. When double clicking on a TimeSeriesChart I put the X-Trace value into a custom property
image

Right now I am trying to grab the record from this table via

image
image1081×586 21.5 KB

But I am getting nothing. Not sure why. What am I doing wrong?

2

Make sure your milliseconds are also zero.

Or use >= instead of = and then select from the first row of that subexpression.

1 Like
3

Is the best way to get the first row still using view() or is there a new expression keyword I can use? Tried searching and found this old topic from before the new expression keywords Way to get a whole row of a dataset via an expression? - #9 by pturmel

4

I would try using where([your expression], idx()=0)

2 Likes
5

Just supply row index zero inside the brackets. If you want the whole row, wrap with another where(..., idx()=0).

1 Like