Dashboards & Visualizations

Quick Question: Chart Scale

wyang6
Path Finder

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.

Tags (1)
0 Karma

wyang6
Path Finder

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

0 Karma

southeringtonp
Motivator

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.

0 Karma

wyang6
Path Finder

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

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.