search query:
inutlookup orderStatus.csv
| timechart count(value) as Orders
| eval P_bypass = round((bypassCandidates/Orders)*100,1)
| eval Goal = 50
| table _time Orders P_bypass Goal
with the above search, I make a column chart to represent count of orders over time.
I make P_bypass as overlay to show on a different axis (%).
My ask is that, I either need to add 'Goal' as a line chart without the overlay or need to show different colors for orders based on value (order<20-Red, order>21 Green).
is any one of that doable?