Dashboards & Visualizations

Is is possible to add $ in data values of a bar or column graph?

Path Finder

Hi is it possible to add $ in my data values in my bar or column graph? Below is my code and screenshot of my bar graph.

|inputcsv all_data.csv
| search ("Booking Type"="Air" OR "Booking Type"="Hotel" OR "Booking Type"="Car") "Host Region"="*" "Host Country"="*"
| eval fy_mon=if("Fiscal Year"="Fiscal Year",FY,month)
| stats sum("Total Paid") as "Total Amount" by fy_mon "Booking Type"
| xyseries fy_mon "Booking Type" "Total Amount"

alt text

Tags (4)
0 Karma

Path Finder

hello @katrinamara,

could you try with new eval ? example : .... | eval TotalAmount = "$ "+ "Total Amount"

0 Karma

Path Finder

I already did that by when I'm clicking the visualization it doesn't show the values. because the values became string.

0 Karma

Path Finder

could you try this ?

...| fieldformat TotalAmount="$".tostring(Total Amount)

0 Karma

Path Finder

I also did that before and after the xyseries and it didn't add.

0 Karma