Value to text on table panel V2.6

[Samuel1989]

Hey Guys,

I was wonder if value to text transformation is already available for tables or potentially planned into a future release?

Part of what I am using Grafana for is to keep track of active services, so I merely have a active state of 1 or a down state of 0, I then transform these into "Active" or "Inactive" via the single stat value to text functionality. As more and more services become available it would actually be really nice to just have a table of Active/Inactive with cell colours of green or red.

Sam

[KenBridgeman]

I have been trying to do the same. My work around is to build a dashboard that combines Text and SingleStat boxes in a row, then have it repeat using variables:

Create Variable: processName Check ALL
Row Editor: Row Height: 100px Repeat Row: select
Add Panel: Text Panel Title: $processName
Add Panel: SingleStat Query: processName:$processName Metric: State
Options: Value to Text Mapping: 1 -> UP 0 -> DOWN

then you can use the selector to choose a specific service, some, or all services to get a service panel.

[henry-spanka]

+1 Would appreciate this feature ;)

[vitorboschi]

+1

[evandro-portugal]

+1

[mattttt]

This would be quite valuable for worldPing events table as well.

[slsims03]

+1 Would definitely be a very useful feature

[kirang20]

+1

[ocervell]

+1

[glutzm]

+1

[trojanc]

+1

[slsims03]

Any traction that on this?

…

On Dec 12, 2016, at 2:43 PM, Charl Thiem ***@***.***> wrote: +1 — You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

[Kaauw]

+1

[gabosvk]

+1

[lelando]

+1

[delgod]

+1

[jazzerjazzer]

+1

[mtehonica]

+1

[sharedansi]

+1

[westofariver]

+1

[szymic1]

+1

[TomasMFranco]

+1.
Would be really useful to us as well.
I'd prefer to give the user a simple string rather than a code to look up.

[mjtrangoni]

+1

[ngrangeia]

+1

[cloudbehl]

+1

[defenestration]

This seems doable if you set the Cell Type to a 'String'. The 'Value Mappings' options then become available. I'm using Grafana 5.3.2.

[Willis0826]

@defenestration Thanks, I found it. However, I was wonder is that possible to change the color of the text which been converted?

[defenestration]

If you use the range/threshold setting it should be able to color the text.

[Willis0826]

Thanks again! I got it : )
It seems like if we want to show the value to text and change the color of text we will need to use Range to text and Thresholds both.

[torkelo]

7.0 table panel supports value to text mappings