Answers.Body: <p>If you turn on dashboard caching with a long duration it might mitigate the performance issues enough for you to use the Advanced Fundraising reports?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-01T08:11:36.800Z
Answers.Text: It will probably not, the issue is not so much in the dashboard caching unfortunately
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-01T08:54:11.493Z
Answers.Text: @ErikH you are perfectly right, it is more complex than just a caching issue
Answers.UserDisplayName: Flying
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-01T07:56:53.157Z
Answers.LastActivityDate: 2015-12-01T07:56:53.157Z
Answers.UserDisplayName: eileen
Body: <p>I want to display a dashlet showing growth percentage YTD this year, comparing with the same period last year.</p>
  
  <p>I used the extension <a href="https://civicrm.org/extensions/advanced-fundraising-reports/102" rel="nofollow">Advanced Fundraising reports</a> to achieve this, but that extension gave me performance issues related to other site-specific features.</p>
  
  <p>Now I am looking into Drupal Views, in the combination with this extension <a href="https://www.drupal.org/project/civicrm_views_dashlets" rel="nofollow">Drupal Views as CiviCRM dashlets</a>.</p>
  
  <p>However, I am struggling with how to use Drupal Views to calculate percentage growth of YTD CiviCRM contributions amount.</p>
  
  <p>How to show the difference between YTD total contribution amount, and the same period last year as percentage, in a CiviCRM Dashlet?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-11-30T14:25:49.930Z
Comments.Text: Do you use Views PHP?  If you do, and if you're somewhat familiar with PHP, you may be able to use PHP to calculate that in a view.
Comments.UserDisplayName: Lesley Carter - BackOffice
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-11-30T14:29:28.003Z
Comments.Text: I am not familiar to PHP, so any tip is much appreciated
Comments.UserDisplayName: Flying
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-12-02T12:10:57.500Z
Comments.Text: There's also the Views Calc module (I'm afraid I don't know whether it'll produce what you're looking for, but it should handle the calculations)
Comments.UserDisplayName: liblogger
Tags: <extension><drupal-views><dashlet><custom-reports>
Title: YTD growth as a dashlet
ThreadText: # YTD growth as a dashlet
  
  (Asked by: username_0 on 2015-11-30)
  
  I want to display a dashlet showing growth percentage YTD this year, comparing with the same period last year.
  
  I used the extension [Advanced Fundraising reports](https://civicrm.org/extensions/advanced-fundraising-reports/102) to achieve this, but that extension gave me performance issues related to other site-specific features.
  
  Now I am looking into Drupal Views, in the combination with this extension [Drupal Views as CiviCRM dashlets](https://www.drupal.org/project/civicrm_views_dashlets).
  
  However, I am struggling with how to use Drupal Views to calculate percentage growth of YTD CiviCRM contributions amount.
  
  How to show the difference between YTD total contribution amount, and the same period last year as percentage, in a CiviCRM Dashlet?
  
  **Tags:** extension, drupal-views, dashlet, custom-reports
  
  > **Comments:**
  > **username_1**: Do you use Views PHP?  If you do, and if you're somewhat familiar with PHP, you may be able to use PHP to calculate that in a view.  
  > **username_0**: I am not familiar to PHP, so any tip is much appreciated  
  > **username_2**: There's also the Views Calc module (I'm afraid I don't know whether it'll produce what you're looking for, but it should handle the calculations)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2015-12-01. Score: 1
  
  If you turn on dashboard caching with a long duration it might mitigate the performance issues enough for you to use the Advanced Fundraising reports?
  
  > **Comments:**
  > **username_4**: It will probably not, the issue is not so much in the dashboard caching unfortunately  
  > **username_0**: @username_4 you are perfectly right, it is more complex than just a caching issue  
  
  ---
  
  