How to use stats or chart by multiple columns while using visualizations?

[AK89]

Here is the sample data set:

ENTITY_NAME	REPLICATION_OF	VALUE
server1	BackupA	59
server2	BackupB	28
server3	backup_noenc_h1	54
server3	backup_utility_h1	96
server4	backup_noenc_h2	40
server4	backup_utility_h2	700

I want to be able to use the number display visualization to display entity_name, replication_of, and latest value for each record. I've tried these:

| stats latest(VALUE) by REPLICATION_OF ENTITY_NAME
| chart latest(VALUE) by REPLICATION_OF ENTITY_NAME
| chart latest(VALUE) over REPLICATION_OF by ENTITY_NAME

Ultimately I want something that looks like this, but not sure if you can display three data series in a number display. If this isn't possible, what would be the best way to visualize a data set like this?

[yuanliu · Accepted solution]

If the main consideration is display, I have this really silly trick:

| eval label = REPLICATION_OF . " - " . ENTITY_NAME
| stats latest(VALUE) by label

[AK89]

This worked great for my number display, but I can't seem to get it to work on the radial gauges like your screenshot. Did you have to do something else to get it to populate multiple gauges? 

[yuanliu]

I'm not aware of any special setting.  I'm using a 9.0.0 installation.  After the stats, Splunk visualization automatically selected "Radial Gauge".  All I did is select trellis.

By default, radial gauge uses the "shiny" skin; another skin (style) is "minimal", like this

[AK89]

I thought of trying something like that last night (combining the values into one field) but couldn't get it to work. Thanks a lot, this accomplishes what I was looking for!