topic Re: Quick Question: Chart Scale in Dashboards & Visualizations

Quick Question: Chart Scale

wyang6 — Thu, 31 Mar 2011 04:39:23 GMT

I have a chart with a column that totals up the individual columns. However, when I plot it on a bar graph, the vertical axis is always scaled with respect to the "Total" column and that greatly distorts and misrepresents the data.

     A   B   C  Total
Yes 10  27  50     87   : This chart will have a maximum value of ~87
No  20  18   7     45



     A   B   C
Yes 10  27  50          : This chart will have a maximum value of ~50
No  20  18   7

How can I plot a bar graph scaled correctly? Thanks.

Re: Quick Question: Chart Scale

southeringtonp — Thu, 31 Mar 2011 07:23:57 GMT

The simplest thing would be to just get rid of the 'Total' column. Try piping your results through:

| fields - Total

before passing the search to your chart commands.

Re: Quick Question: Chart Scale

wyang6 — Fri, 01 Apr 2011 23:34:48 GMT

"Total" is done with addtotals after the chart command.

Re: Quick Question: Chart Scale

wyang6 — Thu, 07 Apr 2011 03:27:06 GMT

How do I find the maximum number in the 2D chart above?