Selecting value of field for max(timestamp) (Set Analysis)

[Anonymous]

Hi,

here is my problem. The software version (field Version) for a BoardID (field Board_ID) can be sent several times a day (field(signaltime)) --- see picture.

So for each BoardID i can have more then one version linked and one Software Version can be linked to several signaltimes.

Now I want to have the version for a BoardID which was sent the last time. I couldnt figure out how to do it. I tried Set Analysis with max(signaltime), but id didnt work, since max(signaltime) just gives a max date but not the timestamp and a version can be sent several signaltimes a day.

Does anyone know how to make this work?

Many thanks.

Mila

[fosuzuki]

hi,

Can't see the picture...

Regards

Fernando

[Anonymous]

thanks for the hint. Here is the picture to the problem.

[nagaiank]

You can get this using the FirstSortedValue() function, returning BoardID using -signaltime as sort-weight.

[Anonymous]

I tried the function firstsortedvalue like this

firstsortedvalue(signaltime, version)

and it didnt work, since the field version is not a numeric field, but a text field. 😞

[kaushiknsolanki]

HI,

   I dont know this will work in your case or not, but you can give a try using Maxstring() function.

Regards,

Kaushik Solanki 

[jonathandienst · Accepted solution]

Mila

You nmay have put the parameters in the wrong order. Try:

firstsortedvalue(version, signaltime)

The sort weight is the second parameter.

Hope this helps

Jonathan

[Anonymous]

Thanks Jonathan,

it works now like i wanted.