BAR CHART Showing incorrect Y axis

Ask for Help
1

HI
I installed Grist Localhost and imported the data. I wanted to show status of service.

As you can see the Bar chart widget created the Chart but the Y axis is incorrect.

i have attached the screen shot. 4 Statuses exist.
First status has 12 record
Second status has 2190
Third has 51
Fourth one has 72

But if you look at the Bar chart all four has similar Y axis height and number.

Can any one explain how to fix this?

1111
1111631×549 21.6 KB

2

The main configuration for a chart is in the “Widget” part of the creator panel. A chart shows single records actually (i.e. each bar is a record that say for this x-axis label, show a bar with this height), and when you intend to add up across records, you should check the “Aggregate values” option. It automatically creates a summary table to serve as the chart’s data source.

The “Aggregate value” option is available right under the “X-axis” setting (shown here Chart - Grist Help Center). Usually it gets turned on automatically, but I am guessing it’s off in your case.

Two other suggestions:

  1. Keep in mind that the filter dropdown is showing a count of values, while the chart is showing the value of S.number field.
  2. The best way to understand what’s wrong with a chart’s data is look at “Show Raw Data” for it (the option available from the widget menu, as shown here 2022/08 - Grist Help Center).