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

LLaCostaLLaCosta
edited 12/09/19 in Using Smartsheet
11/15/19 Edited 12/09/19

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. 

Due Yesterday vs Next 5 days Doesn't make sense_111519.JPG

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    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!

    Report Due Yesterday.JPG

    Report Due Next 5 Days.JPG

  • Mike WildayMike 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. 

     

    enddateEqualToday.jpg

    report-settings.jpg

  • SUPER Helpful! Thank you!

  • Mike WildayMike Wilday ✭✭✭✭✭

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

Sign In or Register to comment.