From Alpha I'm successfully using the google charts api to display line charts.
I need to create a chart that has intervals as described at https://developers.google.com/chart/...lery/intervals
I'm unsure how to create the dataset so it conforms to the google DataTable format as it looks to me like you need to define a role of interval as shown here.
var data = new google.visualization.DataTable();
data.addColumn('number', 'x');
data.addColumn('number', 'values');
data.addColumn({id:'i0', type:'number', role:'interval'});
data.addColumn({id:'i1', type:'number', role:'interval'});
data.addColumn({id:'i2', type:'number', role:'interval'});
data.addColumn({id:'i2', type:'number', role:'interval'});
data.addColumn({id:'i2', type:'number', role:'interval'});
data.addColumn({id:'i2', type:'number', role:'interval'});
This is my Alpha code for the data that is passed into the google api to then display a line chart. Any help on how to create the dataset for Intervals is much appreciated.
dim sql as c
sql = <<%txt%
SELECT Ax, Average
FROM qryChartHipReplacementOHSMain
%txt%
dim cn as sql::Connection
cn.open("::Name::TheBoneStudio")
dim flag as l
flag = cn.Execute(sql)
dim rs as sql::ResultSet
rs = cn.ResultSet
dim template as c
'debug(1)
template = "['{js_escape(ds.data("Ax"))}', {ds.data("Average")}],"
dim txt as c
txt = a5_mergedataintotemplate(template,rs)
txt = rtrim(txt,",")
txt = "[['Ax', 'Average']," + txt + "]"
dim js as c
js = "{dialog.object}._data = " + txt + ";"
e.javascript = js
I need to create a chart that has intervals as described at https://developers.google.com/chart/...lery/intervals
I'm unsure how to create the dataset so it conforms to the google DataTable format as it looks to me like you need to define a role of interval as shown here.
var data = new google.visualization.DataTable();
data.addColumn('number', 'x');
data.addColumn('number', 'values');
data.addColumn({id:'i0', type:'number', role:'interval'});
data.addColumn({id:'i1', type:'number', role:'interval'});
data.addColumn({id:'i2', type:'number', role:'interval'});
data.addColumn({id:'i2', type:'number', role:'interval'});
data.addColumn({id:'i2', type:'number', role:'interval'});
data.addColumn({id:'i2', type:'number', role:'interval'});
This is my Alpha code for the data that is passed into the google api to then display a line chart. Any help on how to create the dataset for Intervals is much appreciated.
dim sql as c
sql = <<%txt%
SELECT Ax, Average
FROM qryChartHipReplacementOHSMain
%txt%
dim cn as sql::Connection
cn.open("::Name::TheBoneStudio")
dim flag as l
flag = cn.Execute(sql)
dim rs as sql::ResultSet
rs = cn.ResultSet
dim template as c
'debug(1)
template = "['{js_escape(ds.data("Ax"))}', {ds.data("Average")}],"
dim txt as c
txt = a5_mergedataintotemplate(template,rs)
txt = rtrim(txt,",")
txt = "[['Ax', 'Average']," + txt + "]"
dim js as c
js = "{dialog.object}._data = " + txt + ";"
e.javascript = js