Answers.Body: <p>Membership Summary report doesn't provide the information you're looking for out of the box.  Is there a reason that using the Membership Detail report or Activity report and just using the "Statistics" section at the bottom doesn't meet your needs?</p>
  
  <p>If you're committed to this path, you can write a custom report based on the existing Membership Detail or Activity report that doesn't show any results, just the "Statistics" section.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-25T17:53:47.993Z
Answers.Text: I want to use the Dashboard in CiviCRM like a dynamic "report builder" and have reports produce "statistic field dashlets" so my org can get the data it needs really quick upon logging into CiviCRM. Any tips on how to make a custom report with just the statistics section? Would be nicer if any user in Civi could make this, "just show statistics" feature.
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-24T16:47:36.170Z
Answers.LastActivityDate: 2015-06-24T16:47:36.170Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>When a Membership changes Status an Activity of type "Change Membership Status" is created, and for your example, has the Subject of "Status changed from Grace to Expired". These factors can be used either in Find Activities, or Report civicrm/report/instance/3, or in Drupal to make a View, and if we use Aggregation, to get summary statistics as requested in the question. </p>
  
  <p>I decided to give the latter a Proof of Concept and have attached it. IF this is useful to you (or anyone) please consider 'giving back' (and forward) by chipping in to our project to get CiviCRM working fully with Drupal 8 ;-) <a href="http://www.fuzion.co.nz/civicrm/contribute/transact?reset=1&amp;id=4" rel="nofollow">http://www.fuzion.co.nz/civicrm/contribute/transact?reset=1&amp;id=4</a>.</p>
  
  <p>Hmm can't see how to attach file so have put in the Fuzion Treasure Chest at <a href="http://www.fuzion.co.nz/blogs/getting-summary-stats-membership-status-changes-view" rel="nofollow">http://www.fuzion.co.nz/blogs/getting-summary-stats-membership-status-changes-view</a></p>
  
  <p>And in order to fully answer the question, if you use the Views CiviCRM Dashlet module described here you should be able to set it up on your dashboard <a href="https://civicrm.org/blogs/brandonferrell/drupal-views-civicrm-dashlets" rel="nofollow">https://civicrm.org/blogs/brandonferrell/drupal-views-civicrm-dashlets</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-25T22:15:31.343Z
Answers.Text: Thank you. Can I ask you something slightly off topic? Wouldn't it be cool if the Dashboard used Panels / or a layout builder so we could make "Custom Reports" with it, which are summaries/views/totals from elsewhere (Dashlets / Views)? Then we could save these. In my experience using CiviCRM people have to piece together a few reports to get the data they need.
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-25T22:55:16.993Z
Answers.Text: I think piecing together will always be required since everyone's needs are different. unless i misunderstood your point. If you mean using Drupal Panels, well CiviCRM is multi-CMS and even lots of the Drupal versions would probably not be using Panels. I have been wondering about pulling together a batch of Drupal Views as a starting point for Drupal users to get some Reports that civi may not yet do as easily, but the real solution is to contribute back custom Reports for CiviCRM to include imo.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-27T04:17:56.447Z
Answers.Text: I think it would be great if we could customize the layout of the Dashboard at the bare minimum with a "Panels like interface" (add regions / rows / columns as needed) so I could take various Civi Dashlets / Drupal Views-as-Dashlets and place them there, to make a custom "Dashboard". Then, one could save Dashboards and there would be a tab at the top or something to switch between them, to consolidate views of different things. Food for thought for myself mostly.
Answers.UserDisplayName: Zachary
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-07-24T21:14:11.517Z
Answers.LastActivityDate: 2015-07-25T22:56:26.057Z
Answers.LastEditDate: 2015-07-25T22:56:26.057Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>What is the best way to use CiviReports to show how many members changed from grace -> expired in a given month (summary), not detail report.</p>
  
Tags: <civireport>
Title: CiviCRM Membership Status Change Summary Report
ThreadText: # CiviCRM Membership Status Change Summary Report
  
  (Asked by: username_0 on 2015-06-23)
  
  What is the best way to use CiviReports to show how many members changed from grace -> expired in a given month (summary), not detail report.
  
  **Tags:** civireport
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2015-07-24. Score: 4 | Accepted answer
  
  When a Membership changes Status an Activity of type "Change Membership Status" is created, and for your example, has the Subject of "Status changed from Grace to Expired". These factors can be used either in Find Activities, or Report civicrm/report/instance/3, or in Drupal to make a View, and if we use Aggregation, to get summary statistics as requested in the question.
  
  I decided to give the latter a Proof of Concept and have attached it. IF this is useful to you (or anyone) please consider 'giving back' (and forward) by chipping in to our project to get CiviCRM working fully with Drupal 8 ;-) <http://www.fuzion.co.nz/civicrm/contribute/transact?reset=1&id=4>.
  
  Hmm can't see how to attach file so have put in the Fuzion Treasure Chest at <http://www.fuzion.co.nz/blogs/getting-summary-stats-membership-status-changes-view>
  
  And in order to fully answer the question, if you use the Views CiviCRM Dashlet module described here you should be able to set it up on your dashboard <https://civicrm.org/blogs/brandonferrell/drupal-views-civicrm-dashlets>
  
  > **Comments:**
  > **username_0**: Thank you. Can I ask you something slightly off topic? Wouldn't it be cool if the Dashboard used Panels / or a layout builder so we could make "Custom Reports" with it, which are summaries/views/totals from elsewhere (Dashlets / Views)? Then we could save these. In my experience using CiviCRM people have to piece together a few reports to get the data they need.  
  > **username_2**: I think piecing together will always be required since everyone's needs are different. unless i misunderstood your point. If you mean using Drupal Panels, well CiviCRM is multi-CMS and even lots of the Drupal versions would probably not be using Panels. I have been wondering about pulling together a batch of Drupal Views as a starting point for Drupal users to get some Reports that civi may not yet do as easily, but the real solution is to contribute back custom Reports for CiviCRM to include imo.  
  > **username_0**: I think it would be great if we could customize the layout of the Dashboard at the bare minimum with a "Panels like interface" (add regions / rows / columns as needed) so I could take various Civi Dashlets / Drupal Views-as-Dashlets and place them there, to make a custom "Dashboard". Then, one could save Dashboards and there would be a tab at the top or something to switch between them, to consolidate views of different things. Food for thought for myself mostly.  
  
  ---
  
  ### Answer by username_1 on 2015-06-24. Score: 1
  
  Membership Summary report doesn't provide the information you're looking for out of the box. Is there a reason that using the Membership Detail report or Activity report and just using the "Statistics" section at the bottom doesn't meet your needs?
  
  If you're committed to this path, you can write a custom report based on the existing Membership Detail or Activity report that doesn't show any results, just the "Statistics" section.
  
  > **Comments:**
  > **username_0**: I want to use the Dashboard in CiviCRM like a dynamic "report builder" and have reports produce "statistic field dashlets" so my org can get the data it needs really quick upon logging into CiviCRM. Any tips on how to make a custom report with just the statistics section? Would be nicer if any user in Civi could make this, "just show statistics" feature.  
  
  ---
  
  