Hi all,
I added a picklist value named PTO to the Type picklist field of the Event Object. Users create an event and use the PTO picklist value to schedule PTO on their calendar.
I also created a report that shows all PTO events scheduled for the next 90 days. Then I grouped by the Start Date. Please see attached screenshot for illustration.
I would like to filter the report so it only shows the days when there are three PTO events scheduled.
I have not been able to figure out a solution so far.
I would greatly appreciate any help on this.
Thanks,
Hi Emmanuel,
The standard reporting tool doesn't have any options to filter records based on aggregate information. To achieve something like this you'd need some kind of custom page built, or to have a parent object representing the day, which you won't be able to put on events anyway.
