topic Re: How to display count of zipcodes that have been visited by the number of users per day in a bar chart? in 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 — Tue, 25 Aug 2015 13:32:32 GMT

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

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

diogofgm — Tue, 25 Aug 2015 14:18:56 GMT

can you show an example of the csv file?

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

somesoni2 — Tue, 25 Aug 2015 15:38:27 GMT

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.

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

jvarmazis_splun — Tue, 25 Aug 2015 16:42:17 GMT

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.

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

rupesh_patil20 — Wed, 26 Aug 2015 03:54:11 GMT

Hello,

I will make you available csv file soon..

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

rupesh_patil20 — Wed, 26 Aug 2015 03:55:19 GMT

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

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

rupesh_patil20 — Wed, 26 Aug 2015 03:56:56 GMT

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