https://community.splunk.com/t5/Dashboards-Visualizations/Can-you-help-me-create-a-visualization-that-shows-a-minute-by/m-p/396919#M25966 <P>I'm wanting to create a visualization that shows the average amount of errors during each minute of the day over a period of time. I can do it for each hour of the day:</P> <PRE><CODE>index=ind sourcetype=sotp "error" | bin _time span=1h | eval date_hour=strftime(_time, "%H") | stats count AS hits first(date_hour) AS date_hour BY _time | stats median(hits) BY date_hour </CODE></PRE> <P>I can also do it for minute of the hour, but not minute of the day. It would be nice to have more granularity. </P> <P>Thanks</P> Tue, 02 Apr 2019 18:57:42 GMT davidlapello 2019-04-02T18:57:42Z https://community.splunk.com/t5/Dashboards-Visualizations/Can-you-help-me-create-a-visualization-that-shows-a-minute-by/m-p/396919#M25966 <P>I'm wanting to create a visualization that shows the average amount of errors during each minute of the day over a period of time. I can do it for each hour of the day:</P> <PRE><CODE>index=ind sourcetype=sotp "error" | bin _time span=1h | eval date_hour=strftime(_time, "%H") | stats count AS hits first(date_hour) AS date_hour BY _time | stats median(hits) BY date_hour </CODE></PRE> <P>I can also do it for minute of the hour, but not minute of the day. It would be nice to have more granularity. </P> <P>Thanks</P> Tue, 02 Apr 2019 18:57:42 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Can-you-help-me-create-a-visualization-that-shows-a-minute-by/m-p/396919#M25966 davidlapello 2019-04-02T18:57:42Z