Support zero-filling for missing time periods in Big Number with Trendline

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

In the Big Number with Trendline chart, users expect the displayed value (especially when using the "Last Value" aggregation method) to reflect the most recent time period, such as the current week. However, if there are no records for that period (e.g., no data for the current week), the chart skips that week entirely — and shows the last period with data instead. This results in misleading metric values.

How are they solving it currently?

Users are forced to create virtual datasets using custom SQL with a date spine (e.g., GENERATE_DATE_ARRAY in BigQuery) and perform a LEFT JOIN with their data table to manually fill in missing weeks with 0s. This workaround requires SQL skills and prevents use of some physical dataset features.

What is the recommended solution by the Customer?

Add a native option in the Big Number with Trendline chart (or at the dataset level) to:

• Automatically fill missing time periods (e.g., weeks with no rows).

• Allow setting a default value (like 0) for these gaps.

• Ensure the Big Number reflects the true current time bucket, even if empty.

This would align user expectations and remove the need for manual date spine queries.