cancel
Showing results for 
Search instead for 
Did you mean: 

Customized Hover for Area Map

rahuldhomane
10 - ETL
10 - ETL

Hi,

When hovered over a region/state in an Area map, can we add extra lines of details [column values] in the tooltip that pops-up after hovering?

Also, it would really be helpful if we can achieve it for other chart type as well.

Thanks!

6 REPLIES 6

harikm007
13 - Data Warehouse
13 - Data Warehouse

@rahuldhomane ,

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
	
	})
})

harikm007_0-1647367703717.png

-Hari

 

 

jamnikej
7 - Data Storage
7 - Data Storage

I've noticed that when the filters change, the extra information vanishes. My script is:

widget.on("beforequery", function (se, ev) {
	
	var newJaql = {
		jaql  : {
				agg:'count', //enable this if you need to display aggreated value
				column: "ID", //Column name
				datatype: "numeric",
				dim: "[Table.ID]", //table + column name
				table: "Table", //table name
				title: "Volume"
		}
	}
	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 + ', Loads: ' + value[2].text //replace 'Region' with label you want
	
	})
})

Any thoughts on how to keep the tooltip after filtering?

harikm007
13 - Data Warehouse
13 - Data Warehouse

@jamnikej ,

Minor change has been made on the script. Here is the updated script:

 

widget.on("beforequery", function (se, ev) {
	
	var newJaql = {
		jaql  : {
				//agg:'max', //enable this if you need to display aggreated value
				column: "Region", //Colum 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("render", 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

 

Thanks! That fixed it.

Thanks for this code.

1. How to show the multi-line values on hover as my column gets more than one row of values.

2. How to add another column of data to get value[3].text

Ashfaq

TJT
7 - Data Storage
7 - Data Storage

Can we hide just one item in a tool tip - specifically the color by field in the scatter Map.

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email community@sisense.com