Dynamic Charts from MySQL
Looking to purchase this extension but have a question if anyone could answer?
- Is it possible to base a chart on a recordset that has been created to join 2 tables?
- Can it sum a column, for example we have a column holding data for money, we would like the charts to show a summary of this column for each month
We have 10 employee with 10 records each over a year, we would like to chart how much money each staff has made by month. Obviously having 10 staff appear over 12 months would be a massive chart so filtering by employee totals for each month would be great?