Using hidden field for data link with pie chart

Grafana Data Links
1

Hi,
I’m having 2 datasource.

  1. Data Source that gets the protocol ID and total bytes.
  2. Data Source that maps protocol ID and protocol name.

I combined this 2 table with transformation and displayed using Pie Chart. I want to hide the protocol number beside the naming, but if i hide it, i can’t do the data link with protocol id.

image

Any help or advise on this would appreciated!

2

Are those two (protocol and protocol id) two different fields or one? Can you share how your data looks in table format (toggle above the chart Table view). If there are some sensitive data, you can blur them out.

3

Hey,

Table A (from ntopng via clickhouse)

image
image1462×325 10.3 KB

Table B (mapping csv)

image
image1483×335 11.7 KB

Both are different field, but I join this 2 table with field “Protocol”

This is the transformation used

image
image1883×664 78.4 KB

4

Alright, I think I know how (at least I hope so :smile:). Can you try changing the field with protocol name (I think it’s Protocol_Name protocolname) to something more accessible (like Name). Then in the display name config (Under standard options), paste ${__data.fields["Name"]} and it should change the legend, leaving the protocol id intact.

image
image1900×825 108 KB

(I was too lazy to write every protocol mapping thus undefineds and three mails :smile:)

1 Like
5

This worked! I didn’t know the data field can be used this way in display name. Thanks you so much!

1 Like