(2) Reports in a Dashboard Showing the same answer?

LLaCosta

I have 2 reports sitting next to each other in a dashboard.

One shows a summary of what was due yesterday.

One shows a summary of what is due in the next 5 days.

"Due Yesterday" report is set to show anything with an End Date in the last 1 day(s)

"Due in the next 5 days" report is set to show anything with an End Date in the next 5 day(s)

If you look at the image I included, there are items that have a due date with today's date that are populating in both reports -- why?? Looks confusing and will look wrong to the general audience that should reference this every day. 

Mike Wilday

Can you share screenshots of each of the report settings so we can make sure that they are set up correctly? 

LLaCosta

Absolutely - 2 report set up images attached!

Mike Wilday

Interesting. It looks like Today is being included in the last 1 day and the next 5 days.

You could add another helper column to determine if the end date = Today and then exclude the item  from whichever report based on is today. See screenshots. 

 

LLaCosta

SUPER Helpful! Thank you!

Mike Wilday

You're welcome.  I am glad I can help you figure out a workaround!