Splunk Enterprise

Data formatting help

johnsasikumar
Path Finder

Hello all,

Below is the sample data of one cycle. Similarly there are several cycles

The data below is from sensor values. Each cycle starts with Spword:0 and ends with SPword 8. How do i group these as cycle1,2,3 based on the SPword field.

The timedifference for all cycles is not same and also when i use transaction command am not able to name it as cycle 1,2.

Please could you help

"_time",FrontFormedHeight,Pot,LVDT,LoadCell,SPWord,LineNumber,cycl
"2020-09-29T14:01:24.000+0000","2.703","67.64","0.198",0,0,1,CycleStart
"2020-09-29T14:01:26.000+0000","2.703","67.63","0.198",0,0,2,CycleStart
"2020-09-29T14:01:29.000+0000","2.703","67.64","0.198",0,0,3,CycleStart
"2020-09-29T14:01:31.000+0000","2.703","67.63","0.195",0,0,4,CycleStart
"2020-09-29T14:01:34.000+0000","2.703","67.64","0.198",0,0,5,CycleStart
"2020-09-29T14:01:36.000+0000",0,"67.64","0.198",0,1,6,
"2020-09-29T14:01:38.000+0000",0,"51.66","0.198",0,,7,
"2020-09-29T14:01:39.000+0000",0,"24.61","1.565",0,2,8,
"2020-09-29T14:01:41.000+0000",0,"24.59","1.59",0,2,9,
"2020-09-29T14:01:43.000+0000",0,"18.3","7.551","1160.9241004669334",,10,
"2020-09-29T14:01:44.000+0000","2.52","67.43","0.195",0,4,11,
"2020-09-29T14:01:46.000+0000","2.52","15.53","1.413",0,5,12,
"2020-09-29T14:01:48.000+0000","2.52","12.1","4.471","472.4265266884365",,13,
"2020-09-29T14:01:51.000+0000","2.52","67.53","0.195",0,7,14,
"2020-09-29T14:01:53.000+0000","2.52","67.59","0.195",0,,15,
"2020-09-29T14:01:56.000+0000","2.52","67.64","0.198",0,8,16,cycleEnd

 

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Would it be more accurate to say that a cycle begins with SPWord = 0 and LineNumber = 1, and ends with SPWord = 8?

Also, can cycles overlap or will it always be

SPword=0 LineNumber=1
...
SPWord=8
SPWord=0 

0 Karma

johnsasikumar
Path Finder

@ITWhisperer : thank you

the Spword field for a cycle always starts with 0 and end with 8. 0 marks start of the cycle and 8 the end

there are no line numbers. That is something we added using accum 

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...