Getting Data In

How to have my JSON output data in separate rows and not a single one?

Path Finder

alt text

This is the output of my JSON data. I would want to see it in separate rows and not in a single row.
When I do mvexpand for each time it's taking all the count1 values.

My output should be separate rows with time and count1 value.

0 Karma
1 Solution

SplunkTrust
SplunkTrust

@Nadhiyaa as explained in my previous answer fields count1 and time need to be zipped together using mvzip() evaluation function. Try the following search based on your data:

  <yourCurrentSearch>
 | table count1 time
 | eval data=mvzip(count1, time) 
 | mvexpand data 
 | makemv data delim="," 
 | eval count1=mvindex(data,0),time=mvindex(data,1) 
 | fields - data
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

View solution in original post

0 Karma

SplunkTrust
SplunkTrust

@Nadhiyaa as explained in my previous answer fields count1 and time need to be zipped together using mvzip() evaluation function. Try the following search based on your data:

  <yourCurrentSearch>
 | table count1 time
 | eval data=mvzip(count1, time) 
 | mvexpand data 
 | makemv data delim="," 
 | eval count1=mvindex(data,0),time=mvindex(data,1) 
 | fields - data
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

View solution in original post

0 Karma

Path Finder

Yes it worked .
Now i am trying add a trend in a single value format.

0 Karma

Splunk Employee
Splunk Employee

Hey @nadhiyaa,

Did @niketnilay help solve your problem? If so, would you approve his answer so that other users know it's legit. Also, could you toss him an upvote? MMM... upvotes.

SplunkTrust
SplunkTrust

@Nadhiyaa you can call your time field as _time which should take care of showing data over time.

   <yourCurrentSearch>
  | table count1 time
  | eval data=mvzip(count1, time) 
  | mvexpand data 
  | makemv data delim="," 
  | eval count1=mvindex(data,0),_time=mvindex(data,1) 
  | table _time count1

If you want you can also add timechart command with required aggregating function like

 | timechart sum(count1) as Total
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma