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

[jbrenner]

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

[somesoni2]

What's your current query??

[jbrenner]

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

timechart count(IP) as SuccessfulOrders

[somesoni2]

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