Using Field Overrides with "Nested Table" Transformations

Grafana
1

Hi all

Is it possible, do you know, to use field overrides within sub-tables when using “group to nested table” transformations in a table panel?

I’ve been trying to get this to work but, so far, not successful. I’m wondering if this is possible?

In my case, I have a table with 2 overrides (one column with value mappings to change the zeros and ones into something informative - and another column changing the cell-type to ‘image’) which works fine as a single table.

What I would like to do is present this in a nested table. The issue I find is that, once I’ve grouped-by a specific field, only that field (from the head table) shows in the overrides. All the non-grouped fields (which are in the nested sub-table) aren’t listed in the overrides field selector. In fact, if they were already selected in an override, they now have a “(not found)” label next to them.

I do see one field (called __nestedFrames) which appears to refer to the entire sub-table - but my overrides don’t seem to work with that. I’d kinda like to be able to override __nestedFrames.field1, __nestedFrames.field2, etc. but that notation doesn’t seem to work. But that’s what I’m aiming to do anyway.

Any ideas if there’s a way to make this work?

Thanks

1 Like
2

I’ve discovered one other curious (slightly problematic) issue / feature with the nested table transformation….

It also seems to collapse any expanded child-tables on each dashboard refresh (which is annoying if there’s a periodic refresh set on the dashboard). I’m not sure I can see a way to avoid this. I think this might rule out using these transformations in my case :cry:

Let me know if you know any way to avoid this (other then telling users to deactivate the dashboard refresh before expanding nested tables - which wouldn’t be a great user experience).

Thanks :crossed_fingers: