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

Posted on by By Ramu Vudugula, in Data Visualization, Jaspersoft | 0

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

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Get your 30 Days Trail Version

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.

Sales Per Store Per Weekday Report

 

 

 

 

 

 

 

 

 

 

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

Sales Per Store Per Weekday on Hover

 

 

 

 

 

 

 

 

 

 

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.

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Grab The 30 Days Free Trail

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 category and add bucket properties

 

 

 

 

 

 

 

 

Edit series and add bucket properties as below

Edit series and add bucket properties

 

 

 

 

 

 

 

 

 

Add those bucket properties to measure advanced properties as below

Add those bucket properties in measure advanced properties

 

 

 

 

 

 

 

 

 

 

 

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

 

Add the properties for both category and series in advance properties

 

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.

Deploy the report in server

 

 

 

 

 

 

 

 

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

logo

Best Open Source Business Intelligence Software Helical Insight is Here

logo

A Business Intelligence Framework

Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.

Claim Your 30 Days Free Trail

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

Thanks,

Ramu Vudugula,

Helical IT Solutions Pvt Ltd

0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments