<p>Hi,</p>
<p>assuming I have a data set table like this:</p>
<p>ID Timestamp State</p>
<p>1 2017-06-03 New</p>
<p>1 2017-06-04 Started</p>
<p>1 2017-06-08 Ongoing</p>
<p>1 2017-06-24 Solved</p>
<p>2 2017-05-01 New</p>
<p>2 2017-07-25 Started</p>
<p>2 2017-07-31 Ongoing</p>
<p>3 2017-04-17 New</p>
<p>3 2017-04-25 Started</p>
<p>4 2017-06-01 New</p>
<p>4 2017-06-01 Started</p>
<p>4 2017-06-05 Ongoing</p>
<p>4 2017-07-14 Solved</p>
<p> </p>
<p>But I only want to see the latest entry (ID & State) before a certain key-date.</p>
<p>Assuming, keydate is 2017-06-30</p>
<p>I would like to see the following result in the data set preview:</p>
<p>ID Timestamp State</p>
<p>1 2017-06-24 Solved</p>
<p>2 2017-05-01 New</p>
<p>3 2017-04-25 Started</p>
<p>4 2017-06-05 Ongoing</p>
<p> </p>
<p>Is there a smart way to get this implemented?</p>
<p>The Data Set is bound to a Dynamic Text Field. I only see to run through the complete list in 'On Fetch' and just store the latest entry for an 'ID'. But maybe there is a more smarter way to get this solved already on data set level.</p>
<p> </p>
<p>Thx</p>
<p>Axel</p>
<p> </p>
