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
SplunkTrust
SplunkTrust

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
SplunkTrust
SplunkTrust

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!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...