1

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 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.

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?

Improve this question
3
  • 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. – Lesley Carter - BackOffice Nov 30 '15 at 14:25
  • I am not familiar to PHP, so any tip is much appreciated – Flying Nov 30 '15 at 14:29
  • 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) – liblogger Dec 2 '15 at 12:10
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?

Improve this answer
2
  • 1
    It will probably not, the issue is not so much in the dashboard caching unfortunately – ErikH - CiviCooP Dec 1 '15 at 8:11
  • @ErikH you are perfectly right, it is more complex than just a caching issue – Flying Dec 1 '15 at 8:54

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.