topic Re: dynamic span in Dashboards & Visualizations

dynamic span

wcleong — Thu, 02 Jan 2014 06:58:13 GMT

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)

Re: dynamic span

dwaddle — Thu, 02 Jan 2014 16:01:47 GMT

You might try instead of setting a specific span= to use bins= in order to tell the chart command that you want it to use (up to) a set number of bins, and let it figure out an appropriate size.

Re: dynamic span

wcleong — Thu, 02 Jan 2014 22:58:51 GMT

The problem is when using bins, it will tend to not bucketise the 0 value, and cause the graph to be non linear on the x-axis.. I need to see the overall graph shape.

Re: dynamic span

wcleong — Thu, 02 Jan 2014 22:59:04 GMT

The problem is when using bins, it will tend to not bucketise the 0 value, and cause the graph to be non linear on the x-axis.. I need to see the overall graph shape.