I made the column chart like this images.
I want to change the color of particular column specified by field "No." , that is as "token" by other graph.
My ideal is third image.
I'm sorry if my English is wrong.
Not a straight forward answer, but you can move that particular value to a different field (new field) and have all the other values as 0.
Something like below,
| makeresults
| eval field1="10,12,11,13,14,12,25,16,15,11,14"
| makemv delim="," field1
| mvexpand field1
| eval SNO=1
| accum SNO
| eval _time=_time+(100*SNO)
| table _time field1
| eval newfield2=if(field1>20,field1,0)
| eval newfield1=if(field1>20,0,field1)
| table _time newfield1 newfield2
Not a straight forward answer, but you can move that particular value to a different field (new field) and have all the other values as 0.
Something like below,
| makeresults
| eval field1="10,12,11,13,14,12,25,16,15,11,14"
| makemv delim="," field1
| mvexpand field1
| eval SNO=1
| accum SNO
| eval _time=_time+(100*SNO)
| table _time field1
| eval newfield2=if(field1>20,field1,0)
| eval newfield1=if(field1>20,0,field1)
| table _time newfield1 newfield2
I understand.
Thanks for reply 🙂