Select last distinct value

[piersbatch]

Select most recent distinct value, e.g. hour of log, date, weekday, month