Platform Analytics List - Dot-walked field available in Group By but not in List Columns

vincm70
Tera Contributor

3 weeks ago

  • Hello,

 

I am testing Platform Analytics on the alm_hardware table and I found an inconsistency.

 

The following dot-walked field is available in Group By:

 

Configuration Item > Last Start Date [Computer]

 

Technical path:

ci.ref_cmdb_ci_computer.u_last_start_date

 

I can successfully select this field in the "Group By" section of a Data Visualization.

 

However, when using a List visualization and opening "Modify List", this same field is not available in the list of selectable columns.

 

Expected behavior:

If the field is available for Group By, I would expect it to also be available as a list column.

 

Questions:

- Is this a known limitation of List visualizations?

- Is there a configuration to expose dot-walked fields as list columns?

- Is there a maximum dot-walking depth supported for list columns?

- Is this behavior expected in Platform Analytics?

 

Environment:

- Table: alm_hardware

- Field: ci.ref_cmdb_ci_computer.u_last_start_date

 

Thank you.

0 Helpfuls
  • 142 Views
1 REPLY 1

pr8172510
Kilo Sage

3 weeks ago

Hi @vincm70,

 

Group By supports certain dot-walked fields because Platform Analytics can resolve them during aggregation. However, List visualizations have more restrictive column selection rules and do not expose all dot-walked fields that are available in Group By.

For your example:

ci.ref_cmdb_ci_computer.u_last_start_date


the field can be used for grouping, but it may not be available as a list column due to List visualization limitations and supported dot-walk depth.

There is no OOTB configuration to automatically expose every dot-walked field as a List column. If the field is required in the list, a common approach is to:

  • Add/store the value on the base table (alm_hardware) via a derived field or automation.
  • Use that field directly in the visualization.

0 Helpfuls