4

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}'

nigeu
  • 133
  • 2
  • 8
  • did you get the solution for this? I am also looking for the same. – Naveen Aug 03 '20 at 08:38
  • I placed the column last and set the column width to 1 (0 doesn't work). This is of course a hacky solution, and it doesn't look perfect, but good enough – Tobias D Nov 04 '20 at 15:34

4 Answers4

1

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.:

enter image description here

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:

enter image description here

Hugo L.M
  • 1,053
  • 17
  • 31
0

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

Shubham Choudhary
  • 115
  • 2
  • 9
  • it's not fixed: https://github.com/grafana/grafana/issues/24092#issuecomment-717602484, but you could make data column less visible by placing it as last and with `witdth=1` – jjuraszek Dec 01 '20 at 13:14
-1

enter image description here

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.

Mateusz Myślak
  • 775
  • 6
  • 16
walkerxk
  • 1
  • I had already tried that, like I mentioned in my question if I hide that field then the variable replacement in the URL does not work – nigeu Jun 01 '20 at 20:49
  • It hides the column but again the value replacement in the link stops working. Maybe there is another string that I use in the link instead of ${__data.fields[id]}, after all the field is nolonger displayed – nigeu Jul 29 '20 at 19:56
-1

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

Tuki
  • 51
  • 1
  • 2
  • once you remove it in transform there is no field in the data object, so using raw or not doesnt matter – kkoolpatz Jun 09 '21 at 14:20