Splunk Search

How to transpose or untable one column from table with 3 columns?

sarit_s
Communicator

Hello
I have a table with 3 columns : 

 

DomainEnvironemnt%of deployments
helloqa12
hello1dr13
hello2prod13
hello3dev15

 

And I would like to achieve this..

Domainqadrdevprod
hello12131415
hello11234
hello23246
hello31357


While the numbers in the cells are the % of deployments for each environment and domain

I've tried this but it is not working as expected :

| eventstats count by SERVERS 
| eventstats dc(SERVERS) as Total_Servers by Domain Environment

| eventstats dc(SERVERS) as Total_Servers
| eval "% Of deployments by domain&env" = (Deployed_Servers/Total_Servers)*100
| search Sprint!=*required AND Sprint!=*deleted* AND Sprint!="?"

| eval SH_{Environment}=count
| eventstats values(SH_*) as * by Domain
| dedup Environment Domain 

| table Domain SH* "% Of deployments by domain&env"
| rename SH_dr as DR SH_production as Production SH_qa as QA SH_staging as Staging
Labels (1)
Tags (1)
0 Karma

yuanliu
SplunkTrust
SplunkTrust

Are you just making up numbers in the example?  You have four numbers in first table, but 16 in the second.  There is no logic between the two.

0 Karma
Get Updates on the Splunk Community!

Say goodbye to manually analyzing phishing and malware threats with Splunk Attack ...

In today’s evolving threat landscape, we understand you’re constantly bombarded with phishing and malware ...

AppDynamics is now part of Splunk Ideas

Hello Splunkers, We have exciting news for you! AppDynamics has been added to the Splunk Ideas Portal. Which ...

Advanced Splunk Data Management Strategies

Join us on Wednesday, May 14, 2025, at 11 AM PDT / 2 PM EDT for an exclusive Tech Talk that delves into ...