One of my reports doesn't have the option to add a date range dimension for any chart that I use. Is this some sort of bug?

I have another similar report and it shows date range dimension. Please check below.

CodePudding user response：

If you have several date columns in the data source but do not see the date range dimension selector for the graph/table, it is probably because the data source in question has enforced the date range filter to apply to the partitioned column.

You can check and fix this by editing the data source -> Edit connection, and check if the

Use xxx as date range dimension

setting is on. Set it to off and then you can select the date column the date range filter applies for each graph.

CodePudding user response：

When using certain connectors such as Google Sheets, BigQuery, etc, the Date Range Dimension is explicitly stated, thus allowing users to choose the Date Range Dimension (useful in cases where there are a number of different Date Fields).

When using connectors such as Google Analytics, Google Ads, etc, the Date Range Dimension is automatically detected, selected, applied, and is implicitly stated; One way to manually select a Date Range Dimension on these Data Sources is to create a Data Extract.

CodePudding user response：

In your Connector Script (google app script), set the config like this.

function getConfig() {
  return {
    dateRangeRequired: false
  };
}

For me, I set the date range required to FALSE and the date range dimension section appears in GDS.