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
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!