hi, I have a area chart as below search command
index=index_rv TAG="*" CELL_NAME=* TAG!=TAG CELL_NAME!=CELL_NAME | eval Diff_Percentage = max(Metal_I_diff) | eval Current = Metal_I_1 * 1 | chart min(Diff_Percentage),max(Diff_Percentage) by Current span=0.01
however, my data range for x axis might be varied, and I would like to have the spanning to be max(Current)/1000 so that I can span it to 1000 plot only, can I know how to do it? I tried below but it is not working
index=index_rv TAG="*" CELL_NAME=* TAG!=TAG CELL_NAME!=CELL_NAME | eval Diff_Percentage = max(Metal_I_diff) | eval Current = Metal_I_1 * 1 | chart min(Diff_Percentage),max(Diff_Percentage) by Current span=eval(max (Current)/10000)
... View more