Summary table doesn't aggregate values but skewed it

Hi! I think what you are seeing is that the data for the chart has several numbers for each yearMonth (one number for each serviceMain value). In the second chart, filtered for a single serviceMain value, it’s one number per yearMonth, so everything look correct. In the first chart, there are several numbers, and Grist looks like it’s picking one value to plot – probably the value for the first serviceMain it encounters (but I am not sure).

This has been an issue with charts, which we haven’t found a good way to deal with. The best suggestion I have is to select the “Split Series” option, select serviceMain in the Split Series dropdown, and probably also select the “Stack Series” option.

Then all the different serviceMain values would be stacked in each bar, so the total bar should become correct.

1 Like