# File app/controllers/fusioncharts/db_example_controller.rb, line 48 def multiseries response.content_type = Mime::HTML @chart_attributes={:caption=>'Factory Output report', :subCaption=>'By Quantity', :xAxisName=>'Factory',:yAxisName=>'Units', :rotateValues=>'1', :formatNumberScale=>'0', :animation=>'1' } #Get data from factory masters table @factories = Fusioncharts::FactoryMaster.find(:all,:include=>"factory_output_quantities") #select distinct DATE_FORMAT(factory_output.DatePro,'%c-%d-%Y') as DatePro from factory_output order by DatePro @factory_dates_of_production = Fusioncharts::FactoryOutputQuantity.find(:all,:select=>"DISTINCT date_pro",:order=>"date_pro asc") end