(2) Reports in a Dashboard Showing the same answer?
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.
Comments
-
Can you share screenshots of each of the report settings so we can make sure that they are set up correctly?
-
Absolutely - 2 report set up images attached!
-
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.
-
SUPER Helpful! Thank you!
-
You're welcome. I am glad I can help you figure out a workaround!
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives