Set up a weekly and running report for pomodoro tracker

Ask for Help
1

I’m new to Grist, and trying to get my bearings. For my first projekt, I’m trying to import a Pomodoro-tracker I have had in Google Sheets.

In G-Sheets each pomodoro had a date, time (by nearest half hour), and project. From project, it then derived an area and a context (work, creative, private, volunteer). From date it derived the week number, as well as the day of the week.

I’d like to make a weekly report, where I can see how many pomodoroes I worked on which projects, sorted by context. Is there a smart way to do that?

Also, I’d like to track how productive I am at which point in the week, making a heat map of when I work in different contexts.

I found a “pivot table” custom widget, but that’s just recreating the spreadsheet mentality. Is there a better way to do it?

2

It sounds like you want a summary table.
Assuming your pomodoros are in one table, the summary table could just be summary project and context.
For the heatmap, there are a few ways I can think of off the top of my head. The simplest is to bucket the pomodoro timestamps in the main table and create a summary table by that.

https://docs.getgrist.com/9RM3qARV57q8/Untitled-document?utm_id=share-doc

3

Here’s a chat about creating a heatmap. It’s not super clear, but it can be figured out

4

Thanks for the reply!

I guess my big question would be how to get that weekly review. How do I efficiently restrict it to showing me data for one week?

The liked document seems to be restricted, so I can’t see it.