Answers.Body: <p>In the end, we decided against this approach and went with a simple view with a Case Status exposed filter.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-10T20:28:16.387Z
Answers.LastActivityDate: 2016-04-10T20:28:16.387Z
Answers.UserDisplayName: pmoz
Answers.Body: <p>One option might be to create a UNION in your view. <a href="https://drupal.stackexchange.com/questions/31786/how-to-create-a-union-of-two-views">Here are instructions for doing so</a>. The top answer says to use custom code, but farther down is a link to the <a href="https://www.drupal.org/project/views_extra_handlers" rel="nofollow noreferrer">Extra Views Handlers</a> module which may be able to do it.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-20T19:05:24.243Z
Answers.LastActivityDate: 2015-06-20T19:12:57.253Z
Answers.LastEditDate: 2017-04-13T12:47:16.150Z
Answers.UserDisplayName: Coleman
Body: <p>Goal is to recreate the CiviCRM Summary of Involvement Dashlet in Views.</p>
  
  <p>Problem arises when I try to count both open and resolved Cases in one View.</p>
  
  <p>Table should look like:</p>
  
  <p><strong>Columns:</strong> Case Type/Open Cases/Resolved Cases</p>
  
  <p>Row 1 (Case Type 1)</p>
  
  <p>Row 2 (Case Type 2)</p>
  
  <p>Row 3 (Case Type 3)</p>
  
  <p>with the number of open cases and resolved cases for each case type in the corresponding row.</p>
  
  <p>I can accomplish it with a view and an attachment view, but not a single view.</p>
  
  <p>Anyone have any ideas?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-21T20:26:11.827Z
Comments.Text: Have you tried Aggregation which is a feature under Advanced on the View.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-21T21:56:02.747Z
Comments.Text: I have and it's working tremendously with cases that are either open or resolved, which is an exposed filter on the form.  Ideally, I'd like it to show both without the filter.
Comments.UserDisplayName: pmoz
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-22T19:49:33.933Z
Comments.Text: other idea that i have no experience with but often wonder if it might help in such situations, is the ability to include a view in a view. sorry i don't have any pointers on how to do this
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-06-23T00:11:59.227Z
Comments.Text: I appreciate the ideas.  I've already got the functionality, this is just me trying to clean house a bit.  I've been trying to stay away from Views Field View module due to overhead, but may give it  try just to see.
Comments.UserDisplayName: pmoz
Tags: <civicase><drupal-views>
Title: How to create a Drupal View of Open and Resolved Cases
ThreadText: # How to create a Drupal View of Open and Resolved Cases
  
  (Asked by: username_0 on 2015-06-19)
  
  Goal is to recreate the CiviCRM Summary of Involvement Dashlet in Views.
  
  Problem arises when I try to count both open and resolved Cases in one View.
  
  Table should look like:
  
  **Columns:** Case Type/Open Cases/Resolved Cases
  
  Row 1 (Case Type 1)
  
  Row 2 (Case Type 2)
  
  Row 3 (Case Type 3)
  
  with the number of open cases and resolved cases for each case type in the corresponding row.
  
  I can accomplish it with a view and an attachment view, but not a single view.
  
  Anyone have any ideas?
  
  **Tags:** civicase, drupal-views
  
  > **Comments:**
  > **username_1**: Have you tried Aggregation which is a feature under Advanced on the View.  
  > **username_0**: I have and it's working tremendously with cases that are either open or resolved, which is an exposed filter on the form.  Ideally, I'd like it to show both without the filter.  
  > **username_1**: other idea that i have no experience with but often wonder if it might help in such situations, is the ability to include a view in a view. sorry i don't have any pointers on how to do this  
  > **username_0**: I appreciate the ideas.  I've already got the functionality, this is just me trying to clean house a bit.  I've been trying to stay away from Views Field View module due to overhead, but may give it  try just to see.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2016-04-10. Score: 0 | Accepted answer
  
  In the end, we decided against this approach and went with a simple view with a Case Status exposed filter.
  
  
  ---
  
  ### Answer by username_2 on 2015-06-20. Score: 1
  
  One option might be to create a UNION in your view. [Here are instructions for doing so](https://drupal.stackexchange.com/questions/31786/how-to-create-a-union-of-two-views). The top answer says to use custom code, but farther down is a link to the [Extra Views Handlers](https://www.drupal.org/project/views_extra_handlers) module which may be able to do it.
  
  
  ---
  
  