Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
hi,
Can't see the picture...
Regards
Fernando
thanks for the hint. Here is the picture to the problem.
You can get this using the FirstSortedValue() function, returning BoardID using -signaltime as sort-weight.
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. 😞
HI,
I dont know this will work in your case or not, but you can give a try using Maxstring() function.
Regards,
Kaushik Solanki
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
Thanks Jonathan,
it works now like i wanted.