Getting Data In

How to display count of zipcodes that have been visited by the number of users per day in a bar chart?

rupesh_patil20
Path Finder

I want to assign the count of users on the X-axis where series of Zipcode on Y-axis. I have one .csv file which has the two columns as Time, Zipcode and Users.

Can you please help me with this?
Thanks

0 Karma
1 Solution

somesoni2
Revered Legend

Try something like this

your base search to get data from csv file | stats count(Users) as count by Zipcode 

On the visualization, select Bar chart.

View solution in original post

0 Karma

jvarmazis_splun
Splunk Employee
Splunk Employee

Assuming you load the csv file into Splunk, you could get the users per day by zipcode in a bar chart with something like this:

source="zipcodetest.csv" sourcetype="csv" | timechart span=1d count(user) by zipcode

Then choose the "Bar" visualization.

0 Karma

rupesh_patil20
Path Finder

Thanks jvarmazis, I will make the changes and will update you..

0 Karma

somesoni2
Revered Legend

Try something like this

your base search to get data from csv file | stats count(Users) as count by Zipcode 

On the visualization, select Bar chart.

0 Karma

rupesh_patil20
Path Finder

Thanks somesoni2, I will make the changes and will update you..

0 Karma

diogofgm
SplunkTrust
SplunkTrust

can you show an example of the csv file?

------------
Hope I was able to help you. If so, some karma would be appreciated.

rupesh_patil20
Path Finder

Hello,

I will make you available csv file soon..

0 Karma
Get Updates on the Splunk Community!

Routing Data to Different Splunk Indexes in the OpenTelemetry Collector

This blog post is part of an ongoing series on OpenTelemetry. The OpenTelemetry project is the second largest ...

Getting Started with AIOps: Event Correlation Basics and Alert Storm Detection in ...

Getting Started with AIOps:Event Correlation Basics and Alert Storm Detection in Splunk IT Service ...

Register to Attend BSides SPL 2022 - It's all Happening October 18!

Join like-minded individuals for technical sessions on everything Splunk!  This is a community-led and run ...