Splunk Search

How to format a graph to use a different color for each weekday

Explorer

I am using the timechart command to create a graph with one bar for each day in the month, and I would like each day of the week to display in the same color, so I can easily identify week-over-week changes.
For example, Mondays would be blue, Tuesdays would be green, etc.
Is this possible?

Thanks in advance!
Jonathan

0 Karma

SplunkTrust
SplunkTrust

What's your current query??

0 Karma

Explorer

index=my_index earliest=-1mon "Order Submitted" |

timechart count(IP) as SuccessfulOrders

0 Karma

SplunkTrust
SplunkTrust

Color of bars (or columns or line) are differentiated based on series (column being charted0. Since you've single column being charted, they all of same color. You can try this workaround (create a series for each day of week, so you get 7 series and 7 different bar color, you will lose SuccessfulOrders from legend if that's ok with you)

index=my_index earliest=-1mon "Order Submitted" 
| eval dayOfWeek=strftime(_time,"%A") | 
timechart count(IP) as SuccessfulOrders by dayOfWeek
0 Karma