Answers.Body: <p>All right...I did it but just wanted to follow up.</p>
  
  <p>Expand Advances in the View UI, click next to Aggregation on the word No.
  <img src="https://i.sstatic.net/F3D0U.png" alt="enter image description here"></p>
  
  <p>Turn it on.</p>
  
  <p>Now Add the Scheduled Activity Date field.</p>
  
  <p><img src="https://i.sstatic.net/Ia3KI.png" alt="enter image description here"></p>
  
  <p>Click Apply, then the Aggregation options will pop up.</p>
  
  <p>Select Maximum in the drop down list.</p>
  
  <p><img src="https://i.sstatic.net/Nzztd.png" alt="enter image description here"></p>
  
  <p>Then click Apply.</p>
  
  <p>Here is part of my output (with other fields too of course).</p>
  
  <p><img src="https://i.sstatic.net/IUXok.png" alt="enter image description here"></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-18T20:41:03.717Z
Answers.Text: nice share pmoz.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-18T00:57:15.620Z
Answers.LastActivityDate: 2015-06-18T00:57:15.620Z
Answers.UserDisplayName: pmoz
Body: <p>I'm trying to set up a View of Clients, Case Managers and date of last activity.  Most of the clients have many activities, but I only want the most recent one displayed.</p>
  
  <p>Normally, I would use the Multiple Field Settings in Drupal Views, but it isn't an option for the CiviCRM Activity Date or Activity ID fields.</p>
  
  <p>Everything else is working but can't get it to only display the last date.</p>
  
  <p>Any ideas?</p>
  
  <p>Asked this question before here: 
  <a href="http://forum.civicrm.org/index.php/topic,35580/" rel="noreferrer" title="Drupal Views display last activity date.">http://forum.civicrm.org/index.php/topic,35580</a></p>
  
Tags: <activities><drupal-views>
Title: How do I create a Drupal View to display last activity date.
ThreadText: # How do I create a Drupal View to display last activity date.
  
  (Asked by: username_0 on 2015-06-18)
  
  I'm trying to set up a View of Clients, Case Managers and date of last activity. Most of the clients have many activities, but I only want the most recent one displayed.
  
  Normally, I would use the Multiple Field Settings in Drupal Views, but it isn't an option for the CiviCRM Activity Date or Activity ID fields.
  
  Everything else is working but can't get it to only display the last date.
  
  Any ideas?
  
  Asked this question before here:
  [http://forum.civicrm.org/index.php/topic,35580](http://forum.civicrm.org/index.php/topic,35580/ "Drupal Views display last activity date.")
  
  **Tags:** activities, drupal-views
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2015-06-18. Score: 5 | Accepted answer
  
  All right...I did it but just wanted to follow up.
  
  Expand Advances in the View UI, click next to Aggregation on the word No.
  ![enter image description here](https://i.sstatic.net/F3D0U.png)
  
  Turn it on.
  
  Now Add the Scheduled Activity Date field.
  
  ![enter image description here](https://i.sstatic.net/Ia3KI.png)
  
  Click Apply, then the Aggregation options will pop up.
  
  Select Maximum in the drop down list.
  
  ![enter image description here](https://i.sstatic.net/Nzztd.png)
  
  Then click Apply.
  
  Here is part of my output (with other fields too of course).
  
  ![enter image description here](https://i.sstatic.net/IUXok.png)
  
  > **Comments:**
  > **username_1**: nice share username_0.  
  
  ---
  
  