How to set up time filtered chart to automatically update when model time period extends?

shiyaoling

We have several dashboards with ~30 charts all have time on the x-axis and a dynamic time filter on (trailing 13 months). The time filter is set up following the recommended steps by many users (set boolean for all time periods as "TRUE" > publish the charts > apply filter logic). However, the time periods for these charts can really only go as far as the time periods that are already part of our model at the time of publish. When we extend our model out for another year and set the time boolean back to "TRUE" for all periods, the dashboard charts still won't automatically update to include the new months even though the saved views do. This makes the maintenance cumbersome because we would have to republish all the charts every year, and we are really trying to only have our model through the current year at any given time with the model size in mind. Is there another way to apply the time filter for these charts so we don't have to republish? 

 

Thanks,

Shiyao

OmkarKoch

Hi Shiyao, 

 

Intially enter true in the formula of filter, then publish your graph and then again enter your correct formula in the filter line item. This workaround worked for me. 

 

Thanks, 

Omkar