Splunk Search

How to add Currency Symbol ($ dollar sign) to a column with numbers?

tdunphy_
Explorer

Hi all,

I have a column in splunk that I want to use to show totals. I would like for the dollar sign ($) to appear before the numbers in the totals column.

Here's my query:

index=prd_aws_billing (source="/*2017-12.csv") LinkedAccountId="123456678" ProductName="Amazon Elastic Compute Cloud" | stats sum(UnBlendedCost) AS Cost by ResourceId,UsageType,user_Name,user_Engagement

How do I get the numbers in the UnBlendedCost column to appear with a dollar sign in front of them?

Thanks

0 Karma
1 Solution

livehybrid
Builder

Hi,
Try this:

index=prd_aws_billing (source="/*2017-12.csv") LinkedAccountId="123456678" ProductName="Amazon Elastic Compute Cloud" | stats sum(UnBlendedCost) AS Cost by ResourceId,UsageType,user_Name,user_Engagement | fieldformat Cost="$".tostring(Cost)

View solution in original post

livehybrid
Builder

Hi,
Try this:

index=prd_aws_billing (source="/*2017-12.csv") LinkedAccountId="123456678" ProductName="Amazon Elastic Compute Cloud" | stats sum(UnBlendedCost) AS Cost by ResourceId,UsageType,user_Name,user_Engagement | fieldformat Cost="$".tostring(Cost)

tdunphy_
Explorer

That's perfect. Thank you!

0 Karma
Get Updates on the Splunk Community!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

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

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...