Tutorial 5: HPCC Platform Workunit Data + Column Chart
Fetching data from a HPCC Platform Workunit and rendering it in a Visualization:
1 - Create an empty Column chart and render it:
var columnChart = new Column()
.target("placeholder")
.columns(["Location", "Males", "Females", "Total"])
.yAxisTitle("Population")
.render()
;
2 - Attach to an existing Workunit:
var wu = Workunit.attach({ baseUrl: "https://play.hpccsystems.com:18010" }, "W20160918-054119");
3 - Fetch a list of the Workunit results (returns a Promise
)
wu.fetchResults().then(results => { ... });
4 - Pick the first result and fetch its content (returns a Promise
)
results[0].fetchRows().then(rows => {...});
5 - Map
the rows to a data array:
var data = rows.map(row => [row.location, row.males, row.females, row.total]);
6 - Update the Column chart with the mapped data:
columnChart
.data(data)
.render()
;