Splunk Search

How do you format a table row as currency but not the column field only a specific row?

EmEdwards
Path Finder

I have a table that has various columns of Totals. However, the CurrentYear can represent different information.

I only want to Format the row Category = Money as a currency value = £100000

EG

Category                          CurrentYear
Money                              100000
Cases                                    10
Visits                                     20

I'm unsure how to format a row without formatting the entire column of CurrentYear.

thanks

Tags (3)
0 Karma
1 Solution

renjith_nair
SplunkTrust
SplunkTrust

@EmEdwards,

Does this help?

|eval CurrentYear=if(Category=="Money","£".CurrentYear,CurrentYear)

You may add "£".tostring(CurrentYear,"commas") as well

Happy Splunking!

View solution in original post

0 Karma

renjith_nair
SplunkTrust
SplunkTrust

@EmEdwards,

Does this help?

|eval CurrentYear=if(Category=="Money","£".CurrentYear,CurrentYear)

You may add "£".tostring(CurrentYear,"commas") as well

Happy Splunking!
0 Karma
Get Updates on the Splunk Community!

Sending Metrics to Splunk Enterprise With the OpenTelemetry Collector

This blog post is part of an ongoing series on OpenTelemetry. The OpenTelemetry project is the second largest ...

What's New in Splunk Cloud Platform 9.0.2208?!

Howdy!  We are happy to share the newest updates in Splunk Cloud Platform 9.0.2208! Analysts can benefit ...

Want a chance to win $500 to the Splunk shop? Take our IT Incident Management Survey!

  Top Trends & Best Practices in Incident ManagementSplunk is partnering up with Constellation Research to ...