Using a Rollup Field to add Last Activity Date to a Case

Using a Rollup Field to add Last Activity Date to a Case

It’s important to maintain communication with your customers and keep to your published SLA’s.  Knowing the date of the last activity of a case will give you the ability to respond before it is too late.

In this scenario, we want to know when the last activity was completed for each of my open cases.  We are going to use a rollup field to aggregate the regarding activities and display the Actual End date of the latest (MAX) activity.  Here are the steps to make this happen:

  1. First of all, log in to Dynamics 365 as a system administrator or system customiser.
  2. Navigate to Case in the customisation area and create a new field.
  3. 1
  4. Give the field an appropriate name and set the Data Type as Date and Time.
  5. Set the field type as Rollup and click Edit.
  6. 2
  7. Click Add related entity and pick Activities (Regarding).
  8. Click Add condition and pick If Activity Status Equals Value Completed. You can add more filters if needed but this will do for now.
  9. Click Add aggregation and pick MAX (Activity Actual End).
  10. It should look something like this.
  11. 3
  12. Click Save and Close, and publish your changes.

Now you can add your new field to the case form or any of your views.

Updating the field

By default, the rollup field will update 12 hours after creating the field.  This can be changed in system jobs to a minimum of 1 hour.  Go to System Jobs and change the view to All Rollup Field Calculation Jobs.  Look for the calculated rollup field for the field you have just created.  Open the system job and from the Actions menu click on Modify Recurrence.