how to Create column chart against time .

[vin02]

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.

[MonkeyK]

did my answer below do what you needed?

[vin02]

its not working

[MonkeyK]

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

[MonkeyK]

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")