Reporting - Chart Colors

[SN_Learn]

Hi All,

I am working on a reporting chart colors but it is not reflecting the correct color instead of defining it in the [sys_report_chart_color] and selecting in the reports 'chart color if defined'.

The table on which the reporting is done > [cmdb_ci_database]

In the pic1, the colors are showing up as per the attached screenshot but I am not sure where it is defined becasue when I check in the chart color table I cannot find them(screenshot attached). So, I defined one for that table and dot walked to that field but it is also not reflecting on the report.

Could anyone please help me to find out the root casue of this issue? Thanks

[AndersBGS]

Hi @SN_Learn ,

I can see from your screenshot, but have you verified the value that you're searching in the report chart colors?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[SN_Learn]

Hi @AndersBGS ,

Yes I have dot walked as per the report but it is not working. Please have a look at the screenshot below. Thanks

[AndersBGS]

Hi @SN_Learn ,

Ok, which table are you dot-walking (table name):

• Software Model
• Software Support Status (I guess this is on sys_choice) right?
• Which options have you created on the sys_choice table? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[SN_Learn]

Hi @AndersBGS ,

• The table is [cmdb_ci_database]
• Then there is attribute called Database Software[model_id] > values of this field is stored in the table [cmdb_software_product_model]
• In [cmdb_software_product_model] this table there is a custom field called Software support status

Please have a look at the attached screenshots. Thanks

•