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?

  • Have you tried Aggregation which is a feature under Advanced on the View. – petednz - fuzion Jun 21 '15 at 20:26
  • 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. – pmoz Jun 21 '15 at 21:56
  • 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 – petednz - fuzion Jun 22 '15 at 19:49
  • 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. – pmoz Jun 23 '15 at 0:11

One option might be to create a UNION in your view. Here are instructions for doing so. The top answer says to use custom code, but farther down is a link to the Extra Views Handlers module which may be able to do it.


In the end, we decided against this approach and went with a simple view with a Case Status exposed filter.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.