Adding Customized Tool Tip in High Charts Heat Map in Jaspersoft Server

Prerequisites:

1. Jasper Server
2. Jaspersoft Studio
3. Sample food mart database

Report Requirements: Creating heat map of store wise sales on a weekday and Show customized tooltip.

Steps:

Created a sample query using food mart database of jasper server.

Query:

select store_name,the_day,round(sum(store_sales),0) Sales from sales_fact_1997 sf

join store st on sf.store_id = st.store_id

join time_by_day td on td.time_id = sf.time_id

group by store_name,the_day

Open jaspersoft studio and create a report, add the query in the main dataset, Drag the HTML5 charts on to the canvas and select heatmap, Add the data configuration, select store on category, day on series and sales as measure.

Preview the report and deploy it in the server. It will look like below.

Hover on a particular element to check the sales on a store on a weekday. Here for store 13 on Sunday how much sales happened? To check this hover on store 13 and on Sunday. Below is the picture

See the tooltip, it is showing as 1,1: 19,195 instead of showing store 13 and Sunday. Actually, a tooltip will take the coordinates of those elements and display the value.

Now we have to change this to “Total Sales of Store 13 on Sunday: 19,195”

Open report in a studio, click on chart properties and open chart data configuration, Edit category and add bucket properties as below.

Edit series and add bucket properties as below

Add those bucket properties to measure advanced properties as below

Add the properties for both category and series in advance properties of a measure, Now click on chart advanced properties and add new tooltip property like below

point.store takes the value from the bucket property store, point.day takes the value from bucket property day and point.value is the measured value. Deploy the report in the server and render the report.

See In above Image tooltip was showing like “Total Sales of Store 13 on Sunday: 19,195” as mentioned earlier.

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download

In case if you have any queries please get us at support@helicaltech.com

Thanks,

Ramu Vudugula,

Helical IT Solutions Pvt Ltd