No data displaying on Todays Metrics

Question & Answer
,
1

Hello all,

Issue: The dashboard was showing “No data” for all the visuals, even though there is data. It was supposed to show today’s metrics. The dashboard uses start and end date parameters to filter the entire sheet. The start and end parameters are set correctly. I also referred to the solution in this post: No data showed on the dashboard - #8 by DylanM

It was working fine until 4 PM PST, but when I checked again at 5 PM PST, the metrics were back to showing “No data.” Is there a resolution for this kind of issue?

The data in the datasets is in PST.

I thought this is the rare case but i faced it twice now. Any suggestion helps, please let me know.

Thank you,
Shravya

2

Hi @shravya

It appears that the timezone is playing a role.

image
image408×268 12.2 KB

What is your timezone for the Analysis? If it is UTC may be what is today changes at the 5 PM PST?

Regards,
Giri

3

Hi @Giridhar.Prabhu

So, all my datasets were converted to PST already. So do i need to change it in the Analysis setting as well? Because the analysis setting says it only makes sense to turn on this timezone settings when your data is in UTC timezone.

or is there a chance that parameter might use UTC timezone ?

Thank you,
Shravya

4

Hi @shravya

Most databases (including SPICE) store timestamps in UTC time. The default time zone for all analyses is UTC .

So your assumption that the parameter is using UTC is right. So, your attempt to store date in PST in dataset is probably not useful. What is stored is treated as UTC datetime.

Regards,
Giri

5

@Giridhar.Prabhu - So finally the suggestion is to change the Analysis settings to PST? - I will try this and check.

Also if i change analysis settings to PST, will the parameters use PST too? just to confirm

Thank you, please let me know if you have any more ideas happy to try.

Thank you,
Shravya