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

clara-fication
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
Solution Clara-fied!

View solution in original post

clara-fication
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
Solution Clara-fied!

doweaver
Path Finder

Thank you! Exactly what I was looking for!

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...