8 Replies Latest reply on Sep 4, 2013 11:31 AM by Stanley McLenna

    Show Only First Occurance of Date

    Stanley McLenna

      I have a dataset with data containing UserName (string), LoginDateTime (datetime); is it possible to use a data source filter to select only the first login time per day per user? I know in SQL I'd group by the user name and by the day value of LoginDateTime, then find minimum time for those two groups, which seems simple enough.

      I may be approaching this the wrong way too so I'm open to try other things too. My end result should be a list of the first login datetime for each user, each day.