Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
×
Join the Conversation
Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Find Answers
- :
- About vijay_datla
vijay_datla
Loves-to-Learn Lots
Member since:
07-19-2020
07-25-2020
Community Statistics
| Posts | 7 |
| Solutions | 0 |
| Karma Given | 0 |
| Karma Received | 0 |
| Member Since | 07-19-2020 |
Activity Feed
- Posted Re: How can I join unique fields from 2 different sourcetypes to one column and its values to 2 different columns? on Splunk Search. 07-24-2020 11:28 PM
- Posted Re: How can I join unique fields from 2 different sourcetypes to one column and its values to 2 different columns? on Splunk Search. 07-21-2020 03:49 PM
- Posted Re: How can I join unique fields from 2 different sourcetypes to one column and its values to 2 different columns? on Splunk Search. 07-20-2020 05:58 PM
- Posted Re: How can I join unique fields from 2 different sourcetypes to one column and its values to 2 different columns? on Splunk Search. 07-20-2020 05:42 AM
- Posted Re: How can I join unique fields from 2 different sourcetypes to one column and its values to 2 different columns? on Splunk Search. 07-19-2020 09:44 PM
- Posted Re: How can I join unique fields from 2 different sourcetypes to one column and its values to 2 different columns? on Splunk Search. 07-19-2020 09:42 PM
- Posted How can I join unique fields from 2 different sourcetypes to one column and its values to 2 different columns? on Splunk Search. 07-19-2020 07:56 PM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 |
07-24-2020
11:28 PM
Any advices?
... View more
07-21-2020
03:49 PM
Hi @bowesmana , Unfortunately still no luck. index=customdata | eval p90-01=if(sourcetype="Impala_NewWLM", effective90Percentile, null) | eval p90-02=if(sourcetype="Impala_OldWLM", effective90Percentile, null) | stats values(p90-01) as p90-01 values(p90-02) as p90-02 by elementName | rename p90-01 as "90th Percentile (Impala_NewWLM )", p90-02 as "90th Percentile (Impala_OldWLM )" elementName as Transaction Its populating the transaction fields in the table but not the 90th Percentile values 😞
... View more
07-20-2020
05:58 PM
Hi @bowesmana , Here is the query , and yes i have updated the sourcetypes but no luck: index=customdata | eval _raw="sourcetype,elementName,effective90Percentile" |multikv forceheader=1 | eval p90-01=if(sourcetype="Impala_NewWLM", effective90Percentile, null) | eval p90-02=if(sourcetype="Impala_OldWLM", effective90Percentile, null) | stats values(p90-01) as p90-01 values(p90-02) as p90-02 by elementName | rename p90-01 as "90th Percentile (Impala_NewWLM )", p90-02 as "90th Percentile (Impala_OldWLM )" elementName as Transaction Thanks, Vijay
... View more
07-20-2020
05:42 AM
Hi, Every element has only one "effective90Percentile" value in each sourcetype. For example in the above pic elementname: "1.AboutUs: History" has one value of effective90Percentile in source type01 and another value in sourcetype02. Inother words elementname fields are identical in both the source types but has different effective90Percentile in each of sourcetypes. So im looking for a table to have all elamentnames in column01 and its corresponding 90Percentile values from sourcetype01 to column02 and from sourcetype02 to column03. Sorry, If i have confused you.
... View more
07-19-2020
09:42 PM
Unfortunately, I have around 100 elements from each source type which are identical. but the values of 90percentile are different in both the sourcetypes for the same elements. I tried the above but did not work. Any Ideas?
... View more
07-19-2020
07:56 PM
Hi, I am trying to create a table from 2 different sourcetypes. Fields in both source types are same but has different values. I need the uniques fields in 1st column and sourcetype01 field values to column2 and sourcetype02 field values to column3. Sourcetype: 01 Field01 elementName: SelectSKU elementType: transaction metrics: { TotalHtmlPageResponseTime: 78163 TotalHtmlPageTTFB: 6834 effective90Percentile: 1246 Field02 elementName: SelectProduct elementType: transaction metrics: { TotalHtmlPageResponseTime: 187545 TotalHtmlPageTTFB: 187285 effective90Percentile: 104 Sourcetype: 02 Field01 elementName: SelectSKU elementType: transaction metrics: { TotalHtmlPageResponseTime: 59545 TotalHtmlPageTTFB: 1285 effective90Percentile: 209 Field02 elementName: SelectProduct elementType: transaction metrics: { TotalHtmlPageResponseTime: 187545 TotalHtmlPageTTFB: 187285 effective90Percentile: 756 Field03 elementName: PDP elementType: transaction metrics: { TotalHtmlPageResponseTime: 4546 TotalHtmlPageTTFB: 2455 effective90Percentile: 256 I want to rename the elementName to Transaction and effective90Percentile to 90thPercentile and have a below table: Transaction 90th Percentlile (Sourcetype01) 90th Percentlile (Sourcetype02) PDP 256 SelectSKU 1246 209 SelectProduct 104 756 Any advice is appreciated. TIA
... View more
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
07-25-2020
03:52 AM
|
