I am trying to implement Bar Chart & Easy Chart for my logged KWh values. These values have been logged in a mySQL database table and I am trying to extract KWh Consumption on variable time-period basis. For this purpose, I have created a Stored Procedure in mySQL & am trying to Call this Stored Procedure into Bar Chart & Easy Chart with a selectivity on basis of Historical Date/Popup Calendar.
I tested the same with a Table and Column Selector, which worked quite easily. The script which I implemented on my Table & Column Selector is as follows;-
<call = system.db.createSProcCall(“meter_historian.Test”)
<results = call.getResultSet()
How could I use similar script onto my Bar Chart & Easy Chart.