Dashboards & Visualizations

Creating a visualization from a table

tdebonee
Engager

Hello,

I used the following search to convert the Date field in the CSV so Splunk could read it. I would like to create a chart using the Date and Amount fields but am having no luck.

source="graph info-csv.csv" host="Tom1-PC" sourcetype="csv" | convert timeformat="%m/%d/%Y" mktime(Date) as numdate | reverse | table Date Amount

Any help would be appreciated.

 

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try something like this

source="graph info-csv.csv" host="Tom1-PC" sourcetype="csv" 
| convert timeformat="%m/%d/%Y" mktime(Date) as _time
| table _time Amount
0 Karma

tdebonee
Engager

Thanks for the quick response.

It displays the data properly.

I still am unsure how to create a bar graph using the Date (_time)  and Amount fields. 

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...