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!

Technical Workshop Series: Splunk Data Management and SPL2 | Register here!

Hey, Splunk Community! Ready to take your data management skills to the next level? Join us for a 3-part ...

Spotting Financial Fraud in the Haystack: A Guide to Behavioral Analytics with Splunk

In today's digital financial ecosystem, security teams face an unprecedented challenge. The sheer volume of ...

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability

Solve Problems Faster with New, Smarter AI and Integrations in Splunk Observability As businesses scale ...