Here's what seems to be a simple common thing in excel/sheets that I can't seem to be able to google in the right way (for hours). three columns: timestamp, email, things_done.

I want a chart with time as the X axis, things_done as the Y axis, and a line for each email.

The things_done could be grouped by week or even month and that would be pretty good.

Ideally I would be able to point some tool at this data and be able to do various things with it like choose weather to group by week or month, look at 5-week moving average, etc.

I've been able to sort of achieve this with multiple sheets to get to a pivot table, but the resultant "smooth" chart doesn't want to consistently connect the dots. And in general my setup is very inflexible.

Is there a way (or third-party tool) to go straight from my source data described above to a nice looking chart with the time aggregation of my choosing (and bonus points for ability to add moving average)?

Here's what seems to be a simple common thing in excel/sheets that I can't seem to be able to google in the right way. three columns: timestamp, email, things_done.

I want a chart with time as the X axis, things_done as the Y axis, and a line for each email.

The things_done could be grouped by week or even month and that would be pretty good.

Ideally I would be able to point some tool at this data and be able to do various things with it like choose weather to group by week or month, look at 5-week moving average, etc.

I've been able to sort of achieve this with multiple sheets to get to a pivot table, but the resultant "smooth" chart doesn't want to consistently connect the dots. And in general my setup is very inflexible.

Is there a way (or third-party tool) to go straight from my source data described above to a nice looking chart with the time aggregation of my choosing (and bonus points for ability to add moving average)?