Line chart on sum of group

Table with 2+ columns: amount, date, month. Month is a number like 2401 for Jan 24

Trying to create a line chart showing 1 point per month, which will be the amount sum of the month.

E.g. for 2, 2024/1/2; 3, 2024/1/3; 2, 2024/2/2; 1, 2024/2/4; 1, 2024/3/1; 4, 2024/3/3;
it will sum up in 5, 2401; 3, 2402; 5, 2403
and will show a line with the above 3 points.

Any idea how it can be done?

Hi @Chris_Korakidis and welcome to the Coda Community,

It’s much easier for me and others to help you if you share your doc with us. We can take a look into the formulas and everyone can make a copy of the document so we don’t get in the way of each other.

Please follow this guide to share your doc with us:

Sincerely
Jannis

@Chris_Korakidis I put together a simple demo for you–it’s easier to show than explain.

The columns are Order Time, Amount and Month. I grouped them by Month so you can easily see the totals next to the chart.

3 Likes

Thank you very much for your help. The results weren’t looking very good because the yyMM column was number, so it was adding more horizontal points in between. Once changed it to text, I could see something like the above, where only the months on the available data would be shown.