how to change the tree map plot colors?

[kothamurali08719]

Hi All,

i have been working on this from last two days,i cound not be able to change the treemap plot colors.

for other remaining charts its working but for treemap it not working.

please help me.

Thanks&Regards

K.Murali

[aashnanahar]

Try using color coding in your query based on the data 

example:

CASE 
WHEN record_status_count.rcrd_stts_cd = 'ACPT' THEN '#007480'
WHEN  record_status_count.rcrd_stts_cd = 'RJCT' THEN '#8E1537'
WHEN  record_status_count.rcrd_stts_cd = 'PART' THEN '#E17D00'
WHEN  record_status_count.rcrd_stts_cd = 'RCVD' THEN '#8F489A'
WHEN  record_status_count.rcrd_stts_cd = 'EXTR' THEN '#76777B' 
WHEN  record_status_count.rcrd_stts_cd = 'CRPT' THEN '#7BAED4' 
WHEN  record_status_count.rcrd_stts_cd = 'WARN' THEN '#BBBBBB' 
WHEN  record_status_count.rcrd_stts_cd = 'PDNG' THEN '#20345C'  
END AS color

 

Add expression to your color pallete:

example:java.util.Arrays.asList("#FFFFFF","#8E1537","#20345C","#8F489A","#E17D00","#007480","#76777B","#7BAED4","#BBBBBB","#3F3F3F","#C20430",
"#e1c1c0","#d6f1f3","#B4CDB4","#ff6666","#C39BD3","#12d5ff","#83B43D","#CEC6FF","#ABB2B9","#6666ff","#ff99ff","#46614b","#be2337")

 

add the color filed to the chart data configuration.

 

Let me know if you need more help!!

[kothamurali08719]

this expression doesn't work.