Time frame control

Data Studio Data Studio Q&A
1

Hi!

I created a time frame control for a time series chart in looker studio with the help of this article https://how.withlookerstudio.com/advanced-controls/20241104-time-frame-control-for-looker-studio-series-chart/. It is working fine but when I try to add another dimension in the blend source looker studio displays error. Any idea how to add another dimension

image
image295×442 15.2 KB

image
image1132×410 24.1 KB

1 Like
2

Hi @Suresh_Gopalachary When you add another dimension to a blended data source in Looker Studio, the most common cause of a system error is a join mismatch or a change in aggregation level.

In a blend, all dimensions used in the chart (X axis, breakdown dimension, filters, and calculated fields) must exist in the blended source and be compatible with the join keys. If you add a new dimension such as project_name but it is not included consistently in all blended tables or not part of the join configuration, the blend can break and trigger a system error.

Check the following:

  1. Open the blended data source and verify that the new dimension is added to every relevant data source in the blend where needed.

  2. Confirm that the join keys remain valid and that adding this dimension does not change the grain of the data (for example, from date-level to date+project-level).

  3. Make sure aggregation types (SUM, etc.) are still correct after the grain change.

  4. Test by creating a simple table chart using only the blended source with Date, the new dimension, and one metric to see whether the error reproduces outside the time series chart.

Often the fix is to explicitly include the new dimension in the blend configuration and ensure the join keys reflect the new level of detail.