If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filter a list from HeatMap Chart

Started by ashusharma221084, 08 Apr 2017 09:20:29 AM

Previous topic - Next topic

ashusharma221084

Hello,

I've seen some threads where Heatmap chart data is filtered using slidebar or list. But I have just opposite requirement.. Here we want to filter list data using Heatmap chart cell. I have Employee 'overall performance rating' on X axis and their 'potential rating' on Y axis and 'Employee count' is the value to be shown in the heatmap chart cells. This is achieved... But I've a list report which have all employee details. Now the requirement is when I click on any column in the heatmap, it will filter this list and show the details only for those employees who are lying in that category.

Any help is appreciated...

Regards,
Ashish

MFGF

Quote from: ashusharma221084 on 08 Apr 2017 09:20:29 AM
Hello,

I've seen some threads where Heatmap chart data is filtered using slidebar or list. But I have just opposite requirement.. Here we want to filter list data using Heatmap chart cell. I have Employee 'overall performance rating' on X axis and their 'potential rating' on Y axis and 'Employee count' is the value to be shown in the heatmap chart cells. This is achieved... But I've a list report which have all employee details. Now the requirement is when I click on any column in the heatmap, it will filter this list and show the details only for those employees who are lying in that category.

Any help is appreciated...

Regards,
Ashish

Hi,

The approach is exactly the same - the heatmap visualization is used to set the variables which filter the list.

An example based on GO Sales (query) is attached.

Cheers!

MF.
Meep!