How do I draw a Sparkline from data that comes from a metrics index (ie accessed via the mstats command)?
I've tried various combinations of:
| mstats span=5m latest(LogicalDisk.%_Free_Space) as FreePercentSpace WHERE index=metrics_index host=HOSTYMCHOSTFACE instance="*:"
| stats sparkline count by instance
And tried adding "prestats=true" to the end of the mstats command but still nothing happens. I assume there is some sort of intermediate command I need to put between the two lines to make the data palatable for stats (or chart) to process?
Thanks
Eddie