Getting Data In

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

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

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

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

Path Finder

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

0 Karma

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

Path Finder

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

0 Karma

Motivator

can you show an example of the csv file?

------------
Hope I was able to help you. If so, an upvote would be appreciated.

Path Finder

Hello,

I will make you available csv file soon..

0 Karma