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
Contributor

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
Contributor

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

tdunphy_
Explorer

That's perfect. Thank you!

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.