Creating a chart, based on tasks per date
Hi all!
Grateful for any help that can be offered.
I have sheet that is a simple list of tasks. One row per task, with a created date column. There's other columns such as status, assigned to etc etc.
Can someone please help me with creating a chart from this? I want a bar chart which shows number of new tasks per day.
The x axis of the chart should contain all possible dates, from the 1st January 2024 as I want to be able to visualise days where number of tasks = 0.
Any suggestions, links to documents etc would be gratefully accepted.
Thanks, Johnny.
Answers
-
You would create a second sheet that has every date listed in a single column. You would then use a COUNTIFS with a cross sheet reference to the created date column of the first sheet to count how many dates in that range are equal to the date column "@row" in your second sheet.
-
Hi Paul, Many thanks for this. Great, so like creating a calendar table in PowerBi or similar.
Last question to get me started - is there a function for creating a series of dates from a given date?
Thanks again! :-)
-
There are a number of ways to automate date creation from a start date. The complexity increases with the need for flexibility, but the basic idea would be a column that is manually filled with the numbers zero through however many days, weeks, etc. that you need (copy/paste/drag-fill gets thousands of rows populated pretty quickly) then a formula (that can vary based on your specific needs) that will output the date based on the start date and incrementing as needed.
If daily, you could put the start date in a Sheet Summary field and use something like this as a column formula:
=[Start Date]# + [Number Column]@row
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!