Data visualization does not show any data.

[Garvia]

Hello everyone, I’m having an issue when trying to display data in a Data Visualization. I’m building one from the cmdb_rel_ci table, and when I try to show any data from the parent field related to cmdb_ci_business_app, the data shows up as null or empty. Does anyone know why this happens? I’m attaching an image of the issues the table is giving me. Thanks a lot.

[GlideFather]

@Garvia I have read it once again and it mentions missing reference... so it might be the problem that it expects some value but it's empty. I'm not much familiar with this module, but try to check that all the data are populated correctly  

[Garvia]

For these two specific fields, they are reference fields from the cmdb_ci_business_app table that point to the sys_user table. Not all business apps have an owner or an IT application owner, but the issue is that it doesn’t manage to retrieve any of them.

[Bhuvan]

@Garvia 

Your reference looks misconfigured. Explain how you are creating data visualization and provide more information if below does not work. 

See below for sample data visualization on cmdb_rel_ci table where parent class is Business Application, 

Add Columns as per your requirement and dot walk on Parent and Child tables,

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[Bhuvan]

@Garvia 

Did you try to check this in your instance ?

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Mark Manders]

You have added parent.ref...... fields. Why not simply parent.sys_class_name, etc? Your filter should just be on the class, so you always have the business apps.