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
Hi @shravya
It appears that the timezone is playing a role.
What is your timezone for the Analysis? If it is UTC may be what is today changes at the 5 PM PST?
Regards,
Giri
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
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
1 Like
@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
@Giridhar.Prabhu - I changed the timezone in the analysis, but still my todays metrics are not available.
Hi @shravya
Can you share some details if your dataset and same data from analysis?
Regards,
Giri
1 Like
Thank you for your insights. @Giridhar.Prabhu Yeah its same data.
I identified the root cause yesterday, made changes to the query, and am now monitoring the dashboard. To me it was showing data yesterday after 5PST correctly. So i assume now its working fine, i will keep monitoring today as well to make sure.
The issue stemmed from how the date field was extracted in the Custom SQL:
CAST(SUBSTR(CAST(contact_record.initiation_timestamp AT TIME ZONE 'US/Pacific' AS VARCHAR), 1, 10) AS DATE) AS day
This line takes a timestamp from the initiation_timestamp column in the contact_record table, converts it to the ‘US/Pacific’ time zone, and extracts the date as a substring. However, since the original timestamp is likely in UTC, converting it to PST sometimes shifted the date. The analysis expected UTC dates somehow, so the results were inconsistent after 5 PM PST.
- Example 1: No Date Change
UTC: 2025-03-18 07:30:00
PST (UTC-8): 2025-03-18 03:30:00
Extracted Date: 2025-03-18 (matches UTC date)
- Example 2: Date Changes
UTC: 2025-03-18 00:00:00
PST (UTC-8): 2025-03-17 05:00:00
Extracted Date: 2025-03-17 (differs from UTC date)
I hope this explanation helps anyone who faces a similar problem.
Thank you,
Shravya
1 Like