Min and max value

Marcio Leandro asked on October 23, 2018

I would like to get min and max value from cells to use it as a parameter for the heatmap feature. I wonder wether I am able to do so by API resources or not.
How can i get the min and max value for the heatmap feature without using fixed values?
The goal is to search for min and max values, so it change accordding to the values.

2 answers

Tanya Gryshko Flexmonster October 24, 2018

Hello, Marcio,
Thank you for your interest in Flexmonster Pivot.
The functionality you described can be achieved with the help of API resources.
Please have a look at the following demo: http://jsfiddle.net/flexmonster/om72q9ch/
Min and max values are changed here according to the values. How it works: when all data source files are loaded successfully and the grid is rendered, Flexmonster fires reportcomplete event. Inside of reportcomplete handler (line 17), getData API call is used to find min and max values. Then the grid is colorized using these values.
Hope the information above is helpful. Please let me know in case of any other questions.

Marcio Leandro October 24, 2018

Perfect, that’s what I was looking for.
Thanks Tanya!

Please login or Register to Submit Answer