This content has been marked as final. Show 7 replies
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?