Dashboards & Visualizations

how to Create column chart against time .

vin02
Path Finder

i have 3 field (a,b,c) and i have calculated resuld d = ((a+b+c)*30)/100
I want to represent the output in column chart against time. Graph is like
monday 20%
tuseday 30 %
webnesday 50%

Could you please suggest query for the same.

Tags (2)
0 Karma

MonkeyK
Builder

did my answer below do what you needed?

0 Karma

vin02
Path Finder

its not working

0 Karma

MonkeyK
Builder

must be frustrating. What do you have so far, and what are you seeing? I have verified the end part of my query if I assume that the value for "d" has already been calculated. I am not able to share a picture, but the query results in a chart like this:

date    pct
Sun 9
Mon 22
Tue 20
Wed 20
Thu 20
Fri 17
Sat 12

(admittedly, pct is not really percent in my case though) which visualizes into a bar chart by weekday

0 Karma

MonkeyK
Builder

Vin02, I think that you are asking for a chart of value "d" by weekday.
Try this:

base search |bin _time as date span=1d| eval x="pct"  | xyseries date x d | eval date=strftime(date,"%a")
0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...