CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • What is the future of Charts in CiviReport?
Pages: [1] 2

Author Topic: What is the future of Charts in CiviReport?  (Read 3579 times)

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
What is the future of Charts in CiviReport?
March 11, 2013, 01:54:05 pm
I have created a new report for PTP using the stacked bar chart & have been kicking the tyres on Open Flash Chart quite a bit.

One thing that concerns me is that it is no longer maintained & even patches that have been submitted 2 years ago have not been incorporated. (although I note that it has had recent donations). I'm assuming that there is perhaps an alternative that has taken the lead - perhaps Google Charts?

Does anyone have any knowledge on the likely direction here?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: What is the future of Charts in CiviReport?
March 11, 2013, 02:27:11 pm
Lobo passed me this link

http://javascripted.me/top-5-free-javascript-chart-libraries.html#.UT5KUnE-sak

I think the 2 most likely in there are
JQPlot  http://www.jqplot.com/
Google Charts https://developers.google.com/chart/
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: What is the future of Charts in CiviReport?
March 12, 2013, 04:22:45 am
The library the cool kids use to do sexy infographic is D3 (but not that easy to learn, I'm discovering the hard way).

Fortunately, there is nvd3, a more high level library built on the top of it that makes it easy(ier) for mere mortals to generate nice graphs

http://nvd3.org/ghpages/examples.html

not sure if it's what you need, but:
http://nvd3.org/ghpages/multiBar.html
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: What is the future of Charts in CiviReport?
March 12, 2013, 01:13:41 pm
Apart from adding to our street cred are there advantages of that package over the google one?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: What is the future of Charts in CiviReport?
March 15, 2013, 12:40:35 am
1) You are not sending data to google. Not saying they do analyse the contribution amount you send them for the graphs, but hey, it's google.

2) Some users (eg. wikimedia) don't want to rely on external services

3) They seem to shut down services on a regular basis (cf. their google rss reader or caldav). Graph might be the next one to fall.

I'll look soon at report and datavisualisation of contributions and will try the d3 road, will let you know.

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: What is the future of Charts in CiviReport?
March 15, 2013, 10:53:07 am

in response to 1, i think the new versions are all on the client side and does not involve talking to the google servers

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: What is the future of Charts in CiviReport?
March 15, 2013, 11:23:57 am
Hi,

Tested with the demo of pie chart, doesn't seem to send data on the server indeed. Now, where did I leave my tin foil hat?

X+
« Last Edit: March 15, 2013, 01:42:09 pm by xavier »
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: What is the future of Charts in CiviReport?
March 17, 2013, 01:49:01 pm
2) Some users (eg. wikimedia) don't want to rely on external services

Is this a somewhat similar situation to jquery UI?  I mean we package it as part of Civi - but lots of sites prefer to use the google version because browsers have often already cached it & it reduces hits on their sites.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Andrew Perry

  • I post occasionally
  • **
  • Posts: 98
  • Karma: 1
  • Building empowering tools that comply with rules
    • Community Builders Australia
  • CiviCRM version: 3.x, 4.x
  • CMS version: Joomla 1.0.x, 1.5.x -> Drupal 6.x, 7.x, WordPress
  • MySQL version: 5.1, 5.5, 5.6
  • PHP version: 5.2, 5.3, 5.4
Re: What is the future of Charts in CiviReport?
April 19, 2013, 02:57:17 pm
We're using flot charts in our Online Membership Management System that talks to Civi - you can see some examples here: http://www.flotcharts.org/flot/examples/

At a glance it seems to have some similarities with nvd3 but I haven't looked at a coding level.  I'll ask one of our team to compare d3/nvd3 with it.
Community Builders Australia Pty Ltd
www.communitybuilders.com.au

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: What is the future of Charts in CiviReport?
September 25, 2013, 02:15:47 pm
Andrew - do you know if you had difficulties with printing on flot charts (a google showed it as a possible issue  = which is also the case with google charts )
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: What is the future of Charts in CiviReport?
September 26, 2013, 12:01:38 am
Hi,

I have been using d3 for the past few months on various projects. Getting into the framework is a bit harder compared to "pre-made" graphs frameworks, but they are now several re-usable charts on the top of d3 that makes it almost as easy.

There is nothing that beats the flexibility and expressiveness of d3 and its geo framework is amazing. I'd suggest we try using it as the go to graph framework if we go custom.

Might be something for me on the sprint to do some graph on d3.

d3 uses svg, I don't think it's a problem to print. Eileen, have you heard about problems with some browsers?

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

jamie

  • I post occasionally
  • **
  • Posts: 95
  • Karma: 6
Re: What is the future of Charts in CiviReport?
September 27, 2013, 06:32:10 am
I'd prefer not to depend on an external service - the beauty of CiviCRM is that you can host it yourself, entirely.

From the Google Charts FAQ, it seems that ]you can't download the google code to your server (https://developers.google.com/chart/interactive/faq#localdownload), you must include it. That means Google keeps a record of everyone who uses your database. If they are logged into their gmail account, then their access is tied to their gmail identity.

I don't have much experience with either flot or d3, but both seem to have a free license and can be hosted, so I think we should pick the one that best meets our needs. If d3 can solve print problems Eileen identified than it seems like a good candidate.

jamie

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: What is the future of Charts in CiviReport?
September 27, 2013, 05:22:01 pm
Xavier have you used d3 with CiviReport yet?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Owen

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 2
    • Leukaemia & Lymphoma Research
  • CiviCRM version: 4.3.4
  • CMS version: Drupal 7
  • MySQL version: -
  • PHP version: -
Re: What is the future of Charts in CiviReport?
September 28, 2013, 12:51:32 pm
+1 on d3

Another possibility is CCC which is an high level abstraction of D3's predecessor Proto Viz. It's part of the Pentaho Ctools dashboard suite but useable standalone http://www.webdetails.pt/ctools/ccc.html

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: What is the future of Charts in CiviReport?
September 28, 2013, 04:37:29 pm
BTW - if you are interested it is the double pie chart in this pic I'm currently looking at

http://wiki.civicrm.org/confluence/display/CRM/CiviEngage+Enhancements+for+fund-raising

Having done the stacked bar charts in OpenFlashChart I was pretty clear that I didn't want to try to tackle extending it to getting 2 pie charts from one report & trying to handle the hard-coded assumptions. Getting a google report onto the main screen was easy but I haven't tackled getting it onto the dashboard or print screens yet (which was always going to be the hard part).
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • What is the future of Charts in CiviReport?

This forum was archived on 2017-11-26.