How to Set Default Parameters in Report Accessible from Looker Studio's Home Page

[kevin-shen]

Hello Looker Studio Community,

I'm encountering an issue with setting default parameters at the report level and need assistance on how to ensure these defaults are applied when accessing the report from Looker Studio's home page. Here's a detailed description of the problem:

1. Issue Description:

   • Previously, we could set default values for parameters at the report level without any issues. However, since last week, this functionality seems to have disappeared.
   • The option to set default values for parameters is no longer available, and I haven't seen any announcements regarding this change.
   • As an alternative, we tried using a controller to set these values. While this appears to work during the setup (the default values are visible in edit mode), the defaults do not apply when the report is accessed from Looker Studio's home page. However, the link shared with parameters does work correctly.

2. Steps Taken:

   • Attempted to set default values directly at the report level, but the option is no longer available.
   • Used a controller to set and verify the values in edit mode.
   • Accessed the report from Looker Studio's home page, but found that the default values are not being applied.
   • Shared a link with parameters, which works correctly and applies the default values.

3. Current Behavior:

   • The controller in the report displays 'please enter the value' in gray instead of the default values that were set when accessing the report from Looker Studio's home page.
   • Links shared with parameters correctly apply the default values.

4. Expected Behavior:

   • The controller should display and apply the default values as set in the edit when accessing the report from Looker Studio's home page.

Question: How can we set default parameters at the report level that are applied when the report is accessed through Looker Studio's home page?

Any insights or solutions would be greatly appreciated.

Thank you!

[ArkadyZagdan]

Hey @kevin-shen 

It looks just fine for me when i setup a defaultt parameter value in the parameter section (and not in the chart I am using it).

When i switch it to 1.

Its being adjusted in thheh dashboard. I am using Input box field.

So perhaps instead of chhaning it in the properties section chhange itt in theh parameter set-up section.

Arkady Zagdan

[kevin-shen]

Hi @ArkadyZagdan ,

Thanks for your reply. I understand that you're adjusting the default parameter value in the data source. However, in our scenario, the data source is shared with other reports. Therefore, we're looking for a solution at the report level rather than adjusting it in the data source.

Thanks again for your help!

Best,
Kevin Shen

[chanar]

I can confirm as well that Parameters block has disappeared from from the Properties view. I was using Parameters to control data on different pages (using it in custom SQL and to avoid creating multiple filters). I don't understand the reason for removing this functionality? 

[kevin-shen]

Hi Everyone,

We discovered that the "Parameters" block becomes visible in the Properties view only when all parameters are included in the data source query. If any parameters are missing, the block will not appear.

To resolve the issue, we added the missing parameters to our query, and now the "Parameters" block shows up correctly in Looker Studio. We also found that including the parameters in comments within the data source query (e.g., --@parameter1) works as well.

All Parameters Included in Query

Missing Parameters in Query

Hope this helps anyone facing a similar issue!