Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How do i implement 'Color Scales' like excel?

Answered
Waller Jhonatan asked on September 14, 2020

Hello flex team,
I’m trying to do an implementation where you have a color scale according to the values of the rows or columns, type a of Excel’s ‘Color Scales’.
I tried to use the heat map, but it compares the value according to a pre-defined minimum and maximum.
Would flexmonster have any support for this implementation?
thank you very much.

 

Attachments:
color scale.png

2 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster September 15, 2020

Hi Waller,
 
Thank you for posting your question.
 
We think you will find the following JSFiddle sample helpful: http://jsfiddle.net/flexmonster/om72q9ch/
 
Unlike in the other heat map sample you might be referring to, in this one the max & min values are fully dependent on the value in the grid.
 
More specifically, when the data is loaded to the pivot table, the getData() API call is used to set max & min values which are then used by the customizeCell() function to apply the corresponding formatting.
 
Please let us know if this helps.
 
Best regards,
Mykhailo

Public
Waller Jhonatan September 15, 2020

Perfectly,
thank you very much.

Please login or Register to Submit Answer