cancel
Showing results for 
Search instead for 
Did you mean: 

Date getting stuck in story reports data queries

AislingC
Explorer
0 Kudos
165

Hi 

Quite often the dynamic date of 'today' in my story report gets stuck and doesn't refresh every day as expected. 

When I investigate the data query, I confirm that all data tables are filtered to the time setting of - dynamic date - as of today. It is not obvious to me what could cause the date to be getting stuck. 

To fix the issue, I take the filter off and reapply and then the data refreshes to show what I would expect to see. 

This date issue is affecting all story reports but not consistently. Example, one report with dynamic date as today will get stuck but a similar report on the same day will be fine. The reports are all structured in a similar way with most of them beginning with 'Job Information'. 

Please can I get advise on how I can ensure my story reports with dynamic dates do not get stuck ? 

Thanks 
Aisling

View Entire Topic
MissZP
Explorer
0 Kudos

Hi AislingC,

Could be down to the settings in the Tools section of the Story report.

1. Go to Tools, and click on the query title (e. g., 'Job Information').

2. Check if the box 'Keep last saved values for dynamic variables' is ticked. If it is untick it and save the report.

MissZP_1-1736788058239.png

I hope this helps.

Thank you,

Zaklin