Splunk Search

Problems with search on chart

kailun92
Communicator

I saw this command and tried to imitate it
sourcetype="wind" | eval intscale="SCALE"+tostring(floor(scale/10)*10) | chart count over month by intscale | sort by month
alt text

What is wrong with my command ? Anybody can guide me ? I would like to show temperature(Y-axis) on monthly (X-axis).

sourcetype="CurrentWeatherSG" | chart count over hour by mean(current_temperature)

I only tried this sourcetype="CurrentWeatherSG" | chart max(current_temperature) as Max, min(current_temperature) as Min over _time but the _time is all ... ... ... I wanted to show the numbers on X-axis.

1 Solution

martin_mueller
SplunkTrust
SplunkTrust

Charting over time usually calls for a timechart, something like this:

... | timechart span=1mon max(current_temperature) as Max, min(current_temperature) as Min

View solution in original post

martin_mueller
SplunkTrust
SplunkTrust

Charting over time usually calls for a timechart, something like this:

... | timechart span=1mon max(current_temperature) as Max, min(current_temperature) as Min
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...