Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v

PeterG

I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past.  For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future.

When viewing the report directly, the report is correctly showing 8 rows.  

I have a dashboard link to this report, but when viewing via the dashboard link only the 4 rows that are in the past are showing.   

My user ID and the Site are all set in AEST (Sydney, AUS) Timezone.   

If I change the rows that have today's date to yesterday, then they show on the dashboard report link.  However this is not acceptable as we have to maintain the date published accurately.

It appears that that the dashboards is not performing date/timezone calculations correctly.  Any one else finding this, or any advise on how to resolve?

sean59916

Hi Peter - 

I tried to recreate what you described, but, i'm able to see all 8 rows as expected! See images below - I created a sheet, report and dashboard - the link opens to the report displaying all 8 rows. 

Can you check the dashboard link is linked to the correct report? Or share more details.

Thanks

Sean

PeterG

Hi Sean,  thanks for your effort.  Sorry I did realise when looking at your response that I forgot to mention the Dashboard is being globally published as we have many people who need to access this info who are not on Smartsheet.  

If I look at the Dashboard as a singed in user then the report displays the 8 rows correctly.  If I go there via the global published link the only the 4 rows show.  

In the examples attached  ID 1 & 2 have a date in the past, and items 3 and higher have a date of today.

sean59916

Thanks for clarifying - As it's just ticked over midnight in the US, I'll check tomorrow, our time and see if there is any change because at the moment I'm still seeing the 8 rows. 

Andrée Starå

Hi Peter,

I'd be happy to take a look!

Can you maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

PeterG

Hi Guys,  thanks.  you will need to wait for about another 8-12 hours or so until SYD is on a different date than the US based servers where Smartsheet is hosted.  As for the past few hours it is working( I am assuming this is because AUS and US are on the same date right now). 

I have shared you both to a workspace with the examples.

if you follow this published link to the main dashboard 

https://app.smartsheet.com/b/publish?EQBCT=dad27fe517ad484ea6624c3780c10b8c

then clink on the link to FAQ which is a dashboard with the embedded report you will see what I mean.  

If you follow these as a singe din use then its all good, but using the published links not so.  

The underlying sheet has 10 rows of data 2 will a past date, 4 with a date of 4th May 2019, 2 with a date of the 8th May2019 and 2 with no date.

 

appreciate your help  

cheers, Pete

 

Andrée Starå

Hi Pete,

Thanks for sharing!

I found these community post that might help explain the issue.

https://community.smartsheet.com/discussion/wrong-date-showing-seems-be-4-hours-difference-between-gmt-and-my-time-zone

https://community.smartsheet.com/discussion/created-time-displaying-pacific-time-dashboard

Best,

Andrée

 

Andrée Starå

Hi Pete,

How did it go? What's the conclusion?

Best,

Andrée