topic Re: how to Create column chart against time . in Dashboards & Visualizations

how to Create column chart against time .

vin02 — Tue, 05 Dec 2017 11:31:13 GMT

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.

Re: how to Create column chart against time .

MonkeyK — Tue, 05 Dec 2017 23:41:46 GMT

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

Re: how to Create column chart against time .

MonkeyK — Mon, 11 Dec 2017 15:30:22 GMT

did my answer below do what you needed?

Re: how to Create column chart against time .

vin02 — Tue, 12 Dec 2017 11:16:32 GMT

its not working

Re: how to Create column chart against time .

MonkeyK — Tue, 12 Dec 2017 14:31:55 GMT

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