How do I create a report that filters on a particular date field and returns any records equaling that highest date value within the field?
So if the date field has 5 records with 10/1/2016, 8 other records with 10/10/2016, 10 other records with 10/25/16 ... I want the report to only show the the 10 records with 10/25/2016. I was thinking some type of MAX function.
On your dares table make a formula field Ruth a formula of 1.
Make a relationship based in that field.
Summarize max date.
Lookup max date Dian to dates table.
Filter where max dates = [my date field]
What he wanted to type was;
On your date table you will need to make a formula relationship field to connect ALL records to the new 'Parent' table.
This is what will drive your relationship to drive the summary field, and subsequent lookup field.
Can you describe the current relationships to your table in questions. We might be able to do this without adding a new table and relationship to accomplish one goal.
The app is for planning activities with customer care specialists.
The activities table is related to the specialists table (each specialist can have many activities)
The activities is also related to an attendees table for enabling multiple specialists selection for group activities. (each activity can have many attendees)
This attendees table is also related to the specialists table. (each specialist can be many attendees).
I would like to be able to show in a report the last activity that was conducted with a specialist, and the date of this last activity (Maximum start date).
To begin try to accomplish this, I edited the relationship as such:
But I'm not sure if this is the right start; where to put the formula, and what is a formula of 1, are unclear to me.
Thanks again for all your help!
Yes, only dates that have past, so that team leaders can at a glance see which activity was last conducted with a certain specialist, and when that was.
So the two columns I'd like to create don't need any data from future activities. Now that you ask this question, I realize this indeed adds a challenge; because if an activity with a specialist is planned somewhere in the future, I'd like it to not show up in those columns.
So if those columns don't exclude an upcoming activity, it's for the team leader a clear token that something has been planned with that specialist if they see an upcoming activity, and no more need for the oops-reaction.
So if there's a big difference in the feasibility of the two options, it's not worth the hassle of enabling reporting of only past dates...