Being able to embed lag of days in Table Time Series Chart when using Weekly/Monthly Time Grain

What is the problem or goal the end user is trying to solve or accomplish?

The customer needs to analyze cost trends over a rolling week or month but with a lag of a few days because their cost data takes time to populate. For example, if today is March 25, the most recent full data is from March 23. They need to compare March 17-23 to March 10-16 instead of the default rolling week/month.

How are they solving it currently?

Manually adjusting the date range each time they query the data.

Using workarounds with time filters in other visualizations, but this is not possible in the Table Time Series Chart.

Extracting data externally and shifting time periods manually.

What is the recommended solution by the Customer?

Add a "Lag" parameter in the Table Time Series Chart settings that allows users to specify a custom delay (e.g., "Lag by X days") before computing the rolling week/month.

Ensure this works dynamically so users do not have to adjust the filters manually each day.