ABPro + Plotalot

You can use ABPro together with the data plotting component Plotalot to visualized ABPro data.

 


 

Query for above..

SELECT
    #__sv_apptpro3_resources.name,Count(*)
FROM
   #__sv_apptpro3_requests INNER JOIN #__sv_apptpro3_resources
   ON #__sv_apptpro3_requests.resource = #__sv_apptpro3_resources.id_resources
WHERE startdate>='2014-01-01' and startdate<='2014-01-31'
AND request_status = 'accepted'
GROUP BY
   #__sv_apptpro3_resources.name;


 

  

Query for above..

SELECT
    #__sv_apptpro3_resources.name, sum(booking_total) as Revenue
FROM
    #__sv_apptpro3_requests INNER JOIN #__sv_apptpro3_resources
    ON #__sv_apptpro3_requests.resource = #__sv_apptpro3_resources.id_resources
WHERE startdate>='2013-12-01' and startdate<='2013-12-31'
AND request_status = 'accepted'
GROUP BY
    #__sv_apptpro3_resources.name

 


Require a specific query ?

For a quote, email details of your requirement to This email address is being protected from spambots. You need JavaScript enabled to view it.