Hello, I have a question about Looker Studio as mentioned in the title.
Background:
The data source contains a field called "target_month." The "target_month" field contains monthly data as shown below:
- 2024-01-01
- 2024-02-01
- 2024-03-01
- 2024-04-01 ...
Minimum Goal:
- I want to set a specific default date.
- Example: I want the default to be set to March 2024.
Ideal Goal:
- I want the default to be set to the previous month.
- Example: When viewing data in October 2024, I want September 2024 to be selected by default.
Issues:
- Even if I set a fixed value like "2024-03-01" in "Default selection," it is not selected by default, and I don't understand the reason.
- I am not sure if it is possible to set a variable instead of a fixed value in the "Default selection."
Is there a way to achieve this?