Pie chart

Hello,
Yeah, I know we wrote Database query for you. And I hope that is working perfectly fine as per your requirements. Now, do you want us to modify the same Query for another Chart or want us to write a different Query? In both the cases, it would be chargeable ( It won't be chargeable only if It's not working as per your previous requirements ). Please contact our Sales team.

Hello Daniel,

We had already pay for help last month...

Best Regards
Chris

Hello,
Okay, Please let us know if you want us to assist you in writing the Database queries? Please contact our Sales team for the purpose via Contact us -> Request a Quote form.

Hello,

I try to create a pie chart in percentage with

SELECT sum(col1) AS passed, sum(col2) AS failed
FROM ( SELECT count(*) FROM #__admincrm_programs AS p
LEFT JOIN #__admincrm_versions AS v ON(v.programs_id=p.id)
LEFT JOIN #__admincrm_sessions AS s ON(s.versions_id=v.id)
LEFT JOIN #__admincrm_enrollments AS e ON(e.sessions_id=s.id)
LEFT JOIN #__admincrm_results AS r ON(e.id=r.enrollments_id)
WHERE r.score>=75 AND p.id IN(2,7,16,17) AND YEAR(r.date_event)="2017" ) AS col1
UNION ALL
(SELECT count(*)
FROM #__admincrm_programs AS p
LEFT JOIN #__admincrm_versions AS v ON(v.programs_id=p.id)
LEFT JOIN #__admincrm_sessions AS s ON(s.versions_id=v.id)
LEFT JOIN #__admincrm_enrollments AS e ON(e.sessions_id=s.id)
LEFT JOIN #__admincrm_results AS r ON(e.id=r.enrollments_id)
WHERE p.id IN(2,7,16,17) AND r.score>0 AND r.score<75 AND YEAR(r.date_event)="2017") AS col2

Thanks
Chris