topic Re: Dashboard Studio Format Values on Chart in Dashboards & Visualizations

Dashboard Studio Format Values on Chart

chrisboy68 — Thu, 03 Jul 2025 13:30:06 GMT

Hi,

I have simple chart visulization, with base SPL

.... | chart sum(cost) AS total_cost BY bill_date

I'm trying to add a "$" format to total_cost to show on the columns. Tried every Google and ChatGPT trick and I can't get it working. Any ideas? Thanks!

Re: Dashboard Studio Format Values on Chart

richgalloway — Thu, 03 Jul 2025 14:33:31 GMT

Do the Google and ChatGPT tricks include this?

... | chart sum(cost) AS total_cost BY bill_date | eval total_cost = "$" . total_cost

I'm not entirely sure it will work, but worth a try.

Re: Dashboard Studio Format Values on Chart

chrisboy68 — Thu, 03 Jul 2025 15:01:41 GMT

Thanks. That was my first try, but still didn't work.

Re: Dashboard Studio Format Values on Chart

livehybrid — Sat, 05 Jul 2025 13:39:03 GMT

I was trying to make this work too but unfortunately @chrisboy68 I'm also a bit of a dead end.

Prefixing by eval-ing the field for me breaks the chart as its no longer a numeric value, there is no option to add a prefix/suffix in the visualisation; I scoured the non-UI based options from the viz docs (e.g. https://splunkui.splunk.com/Packages/visualizations/Column) but also couldnt find any way to do this, sorry!

🌟 Did this answer help you? If so, please consider:

Adding karma to show it was useful
Marking it as the solution if it resolved your issue
Commenting if you need any clarification

Your feedback encourages the volunteers in this community to continue contributing