-
1. Re: I want to display the latest score for each Facility, Floor and Type of Exercise. (workbook attached)
Paul Wachtler Nov 16, 2018 12:00 PM (in response to Andrew Horiates)1 of 1 people found this helpfulHi Andrew,
You're almost there! You just need to compare the Exercise date (in your viz this is already at the Facility > Type of Exercise > Building Floor level of detail) against the max date that you already calculated. If the dates match then return the exercise score. Here's the calc (including the piece you already wrote):
if [Date of Exercise] = { FIXED [Facility],[Type of Exercise],[Building Floor]: MAX(DATE([Date of Exercise]))}
then [Exercise Score]
end
-
2. Re: I want to display the latest score for each Facility, Floor and Type of Exercise. (workbook attached)
Paul Wachtler Nov 16, 2018 7:27 PM (in response to Paul Wachtler)Hey Andrew - did this work out for you? If so, can you mark my answer as correct, and click "yes" for "This Helped Me"?
If you have any questions about the solution though, let me know.
Best,
Paul
-
3. Re: I want to display the latest score for each Facility, Floor and Type of Exercise. (workbook attached)
Andrew Horiates Nov 19, 2018 6:31 AM (in response to Paul Wachtler)ahhh so close. I am happy that I was on the right track though. I am getting better at this.
Thank you for the help!