Grafana 7: How to hide table column but still use its value in a data link

Question

Please note this is for Grafana 7

Just upgraded to version 7 and now I can not work out how to hide a column in a Table Panel but still use its value in a Data Link.

I select 3 columns, the first being ID that I do not want to display but instead use its value in a link on one of the displayed columns. For the data link I use the following '/d/ddsds/dashboard-name?var-id=${__data.fields[id]}' which works when the ID field is displayed. If I use a Transform rule to hide the column then the link no longer works as the ID value does not get placed in the URL.

Also tried using '${__data.fields[id]:raw}'

Answer 1

You can do this by add Organize felds in Transform, which only support one single frame so if you have two query, you should join them first.

Answer 2

try to use ${__data.fields[id]} insted of ${__data.fields[id]:raw}

Answer 3

This is already solved but will be released in 7.2.

Issue: https://github.com/grafana/grafana/issues/24092

Comment: https://github.com/grafana/grafana/issues/25289#issuecomment-652566179

Answer 4

It seems that the fix or functionality may be delayed until version 8.0.0:

@torkelo torkelo modified the milestones: 7.4.0, 8.0.0 on Jan 18.

Until then I use the following workaround; Basically what I do is set the width to 1.:

Even using this workaround, the column will still look a minimum of pixels. You can reduce the visibility of this by moving the column you want to hide to the last position: