Hello,
Working on a Column Chart.
Right now, I have on the horizontal axis the names of schools, and on the vertical parameter, how many students they signed up.
I would like to do the opposite. Names of schools on the vertical axis (listed one under the other).
How can I do that?
Initalial query with list of schools at the bottom:
SELECT q.provider_name AS name, count(r.id) AS n
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_providers as q ON(s.providers_id=q.id)
LEFT JOIN #__admincrm_enrollments AS e ON(e.sessions_id=s.id)
LEFT JOIN #__admincrm_results AS r ON(r.enrollments_id=e.id)
WHERE p.id IN(2,7,16,17) AND s.session_format='Classroom' AND YEAR(r.date_event)='2017'
GROUP BY q.id ORDER BY n DESC;
Tried to achieve what I wanted with this query:
SELECT count(r.id) AS n , q.provider_name AS name
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_providers as q ON(s.providers_id=q.id)
LEFT JOIN #__admincrm_enrollments AS e ON(e.sessions_id=s.id)
LEFT JOIN #__admincrm_results AS r ON(r.enrollments_id=e.id)
WHERE p.id IN(2,7,16,17) AND s.session_format='Classroom' AND YEAR(r.date_event)='2017'
GROUP BY q.id;
Not sure what I am getting wrong.
Thanks!
Julien
