Splunk Search

Transforming tables without hacky chart(first) usage

doweaver
Path Finder

I have some data I'm trying to rearrange into an appropriate table for visualization. It starts out like this:

  Group Subgroup    Value
    1   A   100
    1   B   300
    2   A   500
    2   B   700
    3   A   1000
    3   B   2000

I want to transform it to look like this:

    1   2   3
A   100 500 1000
B   300 700 2000

(Where the column headers are the group, and the rows are the subgroups)

I can accomplish this by calling:

chart first(Value) BY Subgroup, Group

...but that doesn't seem like the right approach. i'm calling an aggregation method when I'm not actually DOING any aggregating, just transforming. Is there a better way to handle this?

Tags (2)
0 Karma
1 Solution

cmerriman
Super Champion

try adding this instead of the chart:

|xyseries Subgroup Group Value

it worked for me with this:

 | makeresults |eval data="group=1 subgroup=a value=100, group=1 subgroup=b value=300,group=2 subgroup=a value=500,group=2 subgroup=b value=700"|makemv data delim=","|mvexpand data|eval _raw=data|kv|table group subgroup value|xyseries subgroup group value

View solution in original post

cmerriman
Super Champion

try adding this instead of the chart:

|xyseries Subgroup Group Value

it worked for me with this:

 | makeresults |eval data="group=1 subgroup=a value=100, group=1 subgroup=b value=300,group=2 subgroup=a value=500,group=2 subgroup=b value=700"|makemv data delim=","|mvexpand data|eval _raw=data|kv|table group subgroup value|xyseries subgroup group value

doweaver
Path Finder

Thank you! Exactly what I was looking for!

0 Karma
Get Updates on the Splunk Community!

Is there an add-on for the Cisco Meraki devices?

We have many Cisco Meraki devices sending data via syslog to Splunk. Is there an add-on for ...

Should our Deployment Servers have the Search Head server role on them?

all of our stuff is on premcurrently our dedicated Deployment Servers also have the Search Head role on them, ...

Why am I unable to create dropdown static option that is "All" static options ...

Hi, I am trying to get a static option that is "All" the individual static options combined.  The mCode ...