Ordering Chart's Bars

[jsven7]

I'm charting disk space. Per host my chart has two bars that represent the instance (c: and d:). There is a space between each set that is like a visual delimiter for hosts.

index=os host="host1" OR host="host2" OR host="host3" object="LogicalDisk" counter="% Free Space" instance ="C:" OR instance ="D:" 
| eval percent_used=100-Value 
| chart latest(percent_used) by host, instance

How do I make the chart display a specified static order of hosts (pair of bars)?

[mayurr98]

hey

have you tried looking at the visualisation for | chart latest(percent_used) over host by instance
Also try this

 index=os host="host1" OR host="host2" OR host="host3" object="LogicalDisk" counter="% Free Space" instance ="C:" OR instance ="D:" 
 | eval percent_used=100-Value 
 | stats  latest(percent_used) by host, instance | eval host=host." ".instance | fields- intance

let me know if this helps!