Splunk Search

How to convert multiples data field using xyseries and sort data Month wise?

Ashwini008
Builder

Hi,

My data is in below format

Ashwini008_0-1654523200616.png

I am trying to add the total of all the columns and show it as below

Ashwini008_1-1654523243482.png

Please help me on how can i achieve this and also i am trying to sort by rename 1 2 as JAN FEB so on but after renaming it is sorting by alphabetical order. How can i sort based on month wise?

Labels (3)
0 Karma
1 Solution

PickleRick
SplunkTrust
SplunkTrust

1. Use addttotals. Since you probably don't want totals column-wise, use col=false

2. At the end of your search (after rename and all calculations), add

| table CURRENCY Jan Feb [...] Total

 

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Depending on the number of rows you have, transpose might be another solution

| transpose 0 header_field=CURRENCY column_name=CURRENCY
| sort 0 CURRENCY
| eval CURRENCY=strftime(strptime("2022-".CURRENCY."-1","%Y-%m-%d"),"%b")
| transpose 0 header_field=CURRENCY column_name=CURRENCY
| addtotals col=f

PickleRick
SplunkTrust
SplunkTrust

1. Use addttotals. Since you probably don't want totals column-wise, use col=false

2. At the end of your search (after rename and all calculations), add

| table CURRENCY Jan Feb [...] Total

 

Ashwini008
Builder

@PickleRick Thank You, it worked fine.

Could you please help me with one more solution

I am appending the 3 results and now how do i add the total of 3 results.

Ashwini008_0-1654526811335.png

 

0 Karma

PickleRick
SplunkTrust
SplunkTrust

Now you do need the column-wise totals. So just do col=true (or don't specify it at all - true is the default setting if I remember correctly)

Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...