Hello, general enquiry here about adding graphs and charts to the Wordpress dashboard.
I'm doing a website for a charity that needs to report some stats. I can run them off reports from the database, but I wondered if anyone has experience of creating nice graphs and charts directly in the dashboard?
I'm using wpjobmanager which creates two CPTs - job_listing and resume.
It'd be good to report things like a count of job_listing post types created in the past 30 days, or by month, as well as counting about five different post statuses that these post types could have.
I'm guessing I have to use something like chart.js and then generate a query in the widget that stores the results as variables the chart.js framework can use.
I've created widgets before, but never something using complex queries that generate charts. Does anyone have any idea where to start? Is there a big performance hit using this method? Should the results be stored in transients?
Could anyone provide an example of the code I'd need to get the count of job_listing posts with a status of of published that were published for each of the past 6 months?
Thanks for any advice!