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.
did my answer below do what you needed?
its not working
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
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")