I am trying to create a gauge where the green, yellow, red are dynamically adjusted using average and percentages for similar traffic over the past 30 days. The 30 day search takes a while so what I would like to do is run it overnight and dump it to a csv. I would then like to run todays numbers on the fly and apply the results (the needle in the gauge) to the csv results.
This is where I am with it:
index=msad "EventCode=4624" earliest=-1d@min |stats count as today| append[|inputcsv start=29 max=1 YsForGauge.csv] | table today average Eighty Ninety-Five
This results in a table:
today average Eighty Ninety-Five
1255.633333 2016 2257
So the results are in two rows of the resulting table. What I would like to do is replace the table with