Splunk Search

How to join normalized data into a single timechart?

kuali_brandon
New Member

We have normalized data where multiple rows represent a single point in time, but attributes within the row represent the type. For example:

time=1 metric=ReadIOPs Average=0.01
time=1 metric=WriteIOPs Average=0.02

And so forth. There are multiple metric types beyond what is shown here. We would like to have this appear in a single timechart overlayed. We can get it to work in separate time charts by simply doing:

metric_name=ReadIOPs | timechart values(Average) as ReadIOPs

Is it possible to get this to join both Read and Write together into a single timechart?

0 Karma
1 Solution

sundareshr
Legend

Try this

 metric_name=* | chart values(Average) as IOPs over _time by metric_name

View solution in original post

sundareshr
Legend

Try this

 metric_name=* | chart values(Average) as IOPs over _time by metric_name
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...