3 Replies Latest reply on Nov 19, 2018 6:31 AM by Andrew Horiates

I want to display the latest score for each Facility, Floor and Type of Exercise. (workbook attached)

I want to show the latest score. I feel like this should be easy, but I cannot figure it out. I can get it to show me the last date, just not the Score. The max score by floor should be a 1-3.

I am using this for the last date: { FIXED [Facility],[Type of Exercise],[Building Floor]: MAX(DATE([Date of Exercise]))}

• 1. Re: I want to display the latest score for each Facility, Floor and Type of Exercise. (workbook attached)

Hi 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

1 of 1 people found this helpful
• 2. Re: I want to display the latest score for each Facility, Floor and Type of Exercise. (workbook attached)

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)

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!