---
urn: "urn:penemure:a9d4275a-656d-4265-b886-dcc5dcb9f8cd"
backend: "pub"
ancestors:
-  <span class="title">📁 Note Logs</span>→ <span class="title">📁 Penemure</span>
-  <span class="title">📓 End Feb Update</span>→ <span class="title">📁 Penemure Development Blog</span>
-  <span class="title">📓 Penemure</span>→ <span class="title">📁 Penemure Development Blog</span>
created: 2025-02-23 12:31:54.355590+00:00
updated: 2025-02-23 12:32:39.146116+00:00

tags:
    status: "backlog"
    priority: "medium"
---

# 📝 select tasks which changed from any State to completed within a specific time period



## User Stories

- I want to be able to keep a monthly journal that is automatically updated with what got done in that time period
- I want reporting to be easier
- I want to be able to do burndowns of tasks, when they were created, when they were closed.

This really feels like all tasks need a "closed on" date where they went to a terminal state. Maybe that's easier than I thought, but it absolutely requires <a href="/penemure/note/ba261586-817e-42a8-a279-946b74f35af4.html"><span class="title">📁 Note Logs</span></a> 

<!-- urn:penemure:gh:hexylena | d7ff3b2a-d3b5-4d3f-a7fc-7e5a29fc5d63 -->


## Work on this Issue

(todo, make this a gantt in the template, and add 'self')

<!-- urn:penemure:gh:hexylena | c17d038f-6aa1-44da-9332-1d1a3bfad6eb -->


```query-table
SQL SELECT
  title,
  CAST(created AS DATE),
  updated - created AS duration
FROM log
WHERE
  parents LIKE '%SELF%'
```

<!-- urn:penemure:gh:hexylena | b86161ea-58d6-4cd3-a4ca-fb53f6e9046a -->