# Generating a burndown chart from completed checkboxes? **URL:** \ **Category:** Ask the Community\ **Created:** [March 24, 2023, 12:51am UTC](https://connect.superhuman.com/t/generating-a-burndown-chart-from-completed-checkboxes/38677 "2023-03-24T00:51:30Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Jono\_Bacon](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jono_bacon/32/44997_2.png) [@Jono\_Bacon](https://connect.superhuman.com/u/Jono_Bacon)\ **Post date:** [March 24, 2023, 12:51am UTC](https://connect.superhuman.com/t/generating-a-burndown-chart-from-completed-checkboxes/38677/1 "2023-03-24T00:51:30Z")
Hey, Everyone, This is a bit of a strange one. So, I have a page with a bunch of checkboxes that I cut and paste from elsewhere, like this: ![Screenshot 2023-03-23 at 5.45.28 PM](https://global.discourse-cdn.com/coda1/original/3X/d/8/d853c091054dd153191f02eeb5f64022e6618938.png) First question is, **how do I count the number of checkboxes in total and then how do I count the number of checkboxes that have been checked?** This leads to the second question. I want to show a burndown chart that displays where they are in the progression of checking off the checkbox items as the month progresses, and how that relates to the trend line. Something like this: ![image](https://global.discourse-cdn.com/coda1/original/3X/0/7/070dd7e41b0c617c8e677159dbab0e4d4ca11122.png) The red line would be the trend line, and I would like to update the burndown every day to indicate how many checkboxes are left to be completed and how that relates to the trend line. How can I do this in Coda? Thanks! ---
**Author:** ![Math\_24](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/math_24/32/48382_2.png) [@Math\_24](https://connect.superhuman.com/u/Math_24)\ **Post date:** [March 24, 2023, 9:30am UTC](https://connect.superhuman.com/t/generating-a-burndown-chart-from-completed-checkboxes/38677/2 "2023-03-24T09:30:59Z")
For example ๐Ÿ‘Œ you can use 2 tables. https://coda.io/embed/H_43fX-gaQ?viewMode=embed ---
**Author:** ![Jono\_Bacon](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jono_bacon/32/44997_2.png) [@Jono\_Bacon](https://connect.superhuman.com/u/Jono_Bacon)\ **Post date:** [March 24, 2023, 4:36pm UTC](https://connect.superhuman.com/t/generating-a-burndown-chart-from-completed-checkboxes/38677/3 "2023-03-24T16:36:20Z")
Thanks, @Math_24! Is there a way I can clone this page so I can play with it? A few questions: What is the purpose of the Last Update column in the first table? Is there a way to automatically update the second table to update every day with the total number of completed items? I would like this to be as automated as possible as I am implementing this for a large number of different Coda docs. Thanks! ---
**Author:** ![Math\_24](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/math_24/32/48382_2.png) [@Math\_24](https://connect.superhuman.com/u/Math_24)\ **Post date:** [March 24, 2023, 5:52pm UTC](https://connect.superhuman.com/t/generating-a-burndown-chart-from-completed-checkboxes/38677/4 "2023-03-24T17:52:54Z")
OK i send. You can duplicate. Last Update change if u check the row. And table Chart count row check by day ---
**Author:** ![Jono\_Bacon](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jono_bacon/32/44997_2.png) [@Jono\_Bacon](https://connect.superhuman.com/u/Jono_Bacon)\ **Post date:** [March 24, 2023, 10:21pm UTC](https://connect.superhuman.com/t/generating-a-burndown-chart-from-completed-checkboxes/38677/5 "2023-03-24T22:21:42Z")
Thanks, @Math_24! A few other questions: - In `Chart Day`, how do you calculate the _Target_ column. It seems that this should be the total number of checkboxes broken out across the month. Is there a formula you can use to calculate this for the the full table to break down the daily target equally across the month? - Is there a way to convert the day number at the bottom of the chart to a date within a date range. For example, if I expand this to 90 days, and I specify in the doc that Month 1 is โ€˜Aprilโ€™ and Month 3 is โ€˜Juneโ€™, can I display that day 35 would be 5th May? - Finally, is there a way to flip the chart so the trend line goes from the top left down to the bottom right? Thanks! ---
**Author:** ![Math\_24](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/math_24/32/48382_2.png) [@Math\_24](https://connect.superhuman.com/u/Math_24)\ **Post date:** [March 25, 2023, 6:46am UTC](https://connect.superhuman.com/t/generating-a-burndown-chart-from-completed-checkboxes/38677/6 "2023-03-25T06:46:48Z")
I update doc. If you have any question ๐Ÿ˜‰ ---
**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\ **Post date:** [June 23, 2023, 6:47am UTC](https://connect.superhuman.com/t/generating-a-burndown-chart-from-completed-checkboxes/38677/7 "2023-06-23T06:47:36Z")
Closed on June 23, 2023, 6:47am UTC This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.