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

[rupesh_patil20]

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

[jvarmazis_splun]

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.

[rupesh_patil20]

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

[somesoni2 · Accepted solution]

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.

[rupesh_patil20]

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

[diogofgm]

can you show an example of the csv file?

[rupesh_patil20]

Hello,

I will make you available csv file soon..