How to create a report with task finished in last 5 days

I am trying to create a report that tells me how many tasks have been completed in the last 5 days. Currently, I have a reporting field called child to make sure I only show children tasks and i also work off the status of blue. In the when I put finished is in the last 5 day(s). When I am looking at the report I don't show any items finished during that time frame when I just completed two today.

I am probably missing something as that seems to be the case 99% of the time.

Thanks,

Dan

Reporting Question.png

Find more posts tagged with

Comments

Dale Murphy

Keep in mind that:

1. "last five days" does not include today, so don't expect tasks completed today in that set;

2. the content of the column called Status actually has to have a text string "Blue" in it

When I build reports I tend to get caught on the simplest things, so I thought I would point out logic traps I have fallen into.

I would try removing the Child condition and see what happens (my teams never mark parent tasks as complete anyway!)

Paul Newcome

@Daniel

You can select multiple sets of criteria for the same range when using the report builder.

Set you date column to look at "in the past 5 days" then use the next dropdown to include "is Today".

See screenshot below.

@DM

The status column does not have to have the text string of Blue in it. If the column is a RYGB type, referencing a Blue status will show as it does in the screenshot attached to the original post.

Jlind

Please and thank you

How do I get to this report builder?

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…