Group by max date in straight table

[#1]

Hi Guys

I have below table and I only want to get one row per document Id with the last download date and downloaded by.

Sample QVW attached.

[#2]

How about this?

[Digvijay_Singh]

Use Firstsortedvalue smthg like -

Dimension - DocumentId

Exp1 - firstsortedvalue(DownloadedBy,-Download Date])

Exp2 - firstsortedvalue(UploadDate,-Download Date])

Exp3- firstsortedvalue([Download Date],-Download Date])

[#4 · Accepted solution]

Try this.

[sunny_talwar]

Are you looking to get this done in the script or front end?

[#6]

front end

[#7]

Just one more question related to this example...

How to get all the document Ids (even if there is no download date for that document?)

if the document has download date then it should show last download date.. else null