SM-01 Most Recent Info Needed

[Gregory Young]

I am working on a project and am interested in identifying spaces and bringing in the survey date that the information was tied to.

I have an ad-hoc query that I can share that pulls in room information and am getting rows for all the spaces (over time rooms have had different information related).  I'd like to be able to see when each row was added (via the survey) so that I can filter later on during my analysis.

I tried to use the running count function and it provided a count for each row, but then when I applied a filter to only see the value of '1' in that column, it only left the very first entry in the whole table, not the first one of each instance.

I'm happy to share the query I built as needed.  Or if anyone has any ideas (perhaps I'm not approaching from the right angle), I'm open to all suggestions!

I've attached the SQL for the queries (there are 3) and an Excel extract of the report as it is now, for reference.

Thanks!

Greg

[Gregory Young]

Just an update.

Thanks for Srinivas, Sam, and Jason for reaching out.

There was a simple addition to my query (fiscal year) that allowed me to continue with my analysis!  

Thanks for the quick replies and help!

Greg