I have been looking through the form to solve my max row problem, I think I'm close, but still not getting it! This is what I'm trying to do
I have campus 1, and 2 (column called campus)
I have Units ICC,OR,ER .. many more (each unit may or may not be on both Campuses)
Each Unit has many rows with a update, and a archive_id for a single day.
I can get the max archive_id by using the function =aggr(max(ArchiveSnapshot_ID),campus,Unit_Name) as a Dimension.
What I'm not getting is a expression (I think) that will display the max row, per campus , unit based on the selection. If no selection is made when opening the doc I would like to see all max rows for each campus/ units. Again each campus may or may not have a the same unit.
Campus, Unit, Update, Archive_id
campus 1, ER ,7/29/2012,12
campus 1 , ER, 7/20/2012. 23
campus 1, OR, 7/20/2012 9
campus 2, ER ,7/20/2012, 15
campus 2, ICC,7/20/2012. 34
campus 2, ICC,7/20/2012 36
Display should look something like thisdefault) unless 1 or more units are selected, then only those units will be displayed
Well ok it solved part of the problem, but it looks like it is assigning the max row to the wrong row. I added a comment column to the qvw you posted. One can see that Campus1 and ER unit should say " Bye" and not the word "Hi" in the comments column.