Forum Discussion
harikm007
03-15-2022Data Warehouse
Please try below script :
widget.on("beforequery", function (se, ev) {
var newJaql = {
jaql : {
//agg:'max', //enable this if you need to display aggreated value
column: "Region", //Column name
datatype: "text",
dim: "[Records.Region]", //table + column name
table: "Records", //table name
title: "Region"
}
}
ev.query.metadata.push(newJaql)
lastIndex = ev.query.metadata.length - 1
})
widget.on("beforedatapointtooltip", function (se, args){
$.each(args.widget.queryResult.$$rows, function(index, value){
value[1].text = value[1].text + ', Region: ' + value[2].text //replace 'Region' with label you want
})
})
-Hari