7 Replies Latest reply: Jul 25, 2011 3:46 AM by Franziska Schütte RSS

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

    Franziska Schütte

      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