CiviCRM Community Forums (archive)

Moreover (and it might well be outside the scope of the GSoC project) it would be super useful to indicate if a difference is statistically significant.

For instance, on sid's contact dashboard you have a pie of the split by gender and you see they are 53% of women, you can then select to see only the contacts that have been created last year, it adjusts the gender graph and you can see that you have 55% of women.

What is doesn't say is if this 2% is significant or if it's random changes. what it doesn't do either is to make it easy to compare the contacts created this year (48% of women) vs. last year 55%.

I don't have a smart solution to solve that, yet.

Might require two defined groups rather more open exploratory crossfilter. Z-scores are interesting for subsets and groups too.

I theory you can render any civireport using the  {crmReport ...} - here's an old attempt of mine - it uses {crmAPI} but I think {crmReport} wraps that https://gist.github.com/eileenmcnaughton/8660920

The difficulty is that there are loads of reports available in CiviCRM. I tried using output from https://github.com/eileenmcnaughton/net.ourpowerbase.reports.advancedfundraising & also from a report in https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport

I'm not sure how to best encourage you here. I would love to see people able to render existing CiviCRM reports using d3 graphs on dashlets BUT I'm not sure to what extent that's a diversion. I would encourage you to start by just understanding a bit about the existing reports in CiviCRM (possibly just explore them through the UI at this stage).

Sid, It's certainly the intention to replace the Open Flash charts in the built in reports (& extensions based on them) with d3 charts & obviously whatever you can contribute to that is great. However, I think that is not the full potential of d3 charts - so it might not be your focus.

Yes, I agree that using d3 with the existing reporting framework involves patching core rather than adding code to CiviVisualise.

Re the gist - it is hard-coded to pull from reports 51, 52 etc - these reports are not terribly typical in that they return a table that is already aggregated. However, if you create other report instances you should be able to load the data from them in that way
{assign var='instance_ids' value=','|explode:"51,52,59,54,55"}

But yes, if you think you should learn the other aspects of CiviCRM go ahead - we are pasting ideas on this thread but you should only take them on board as much as they are helpful to your project because you are the one who is responsible for pulling it together into something coherent

Thanks Erik

Looking at your query highlights that you are
1) not currently excluding deleted contacts &
2) not applying ACLs to what is viewed - doing #2 is likely to add the sql for #1

Not sure you should tackle adding that sql just yet - maybe just make a note of it & ping me later when you are up to looking at that

Can you please suggest me what is ideally the number of events an average organization has?

This will vary quite a bit, your query brings back 2303 events for our org. I suspect we'd be toward the higher end as we do a lots of sports events. You might want to consider filtering by event date and/or event name.

At the same time, what do you think is more important information, number of events of particular kind or number of participants for event of a particular type. I can even put both.

For us participants, reporting on events is often for us seeing how an event is doing to compared to the same event last year.

or simply being able to choose two different event ids?

Two different event ids.

@Sid

Here's one of our event dashboards, the production version has a few tweaks but this is what we use. A lot of this is specific to our event but these are the kind of metrics and dimensions that we look at for a fundraising event (NB lots of orgs events won't be fundraising events)

http://demo.webdetails.org:8080/pentaho/content/pentaho-cdf-dd/Render?solution=Leukaemia&path=&file=leukaemia.wcdf

Hi,

The events page now has event count based on type, duration of the event, and contribution. I have also added the number of participants as one filter. I am trying to make a pie chart where there can be slabs like 100-200, 200-300 etc. I am not sure whether this will really help as these slabs will be dynamic. Tell me if we can define such number or should i use a division model, where i divide the maximum number and make ranges.

Also, xavier can a database be arranged. My dataset has just three events and I am not able to get a proper visualization of whatever I am trying.