Why I can not add checkboxes? I get the the error despite my data/configuration being OK (at least I think so). Any idea why it does not work?
2 Likes
Is it possible that there are values other than ‘true’ or ‘false’ in the field (Financing) that you are filtering on? Are there any dimensions or measures with a red background in the ‘Chart’ setup area on the right? You will need to check each chart.
I created a new parameter (see picture below) and inserted it on the blank page. I immediately got this error. Then I created a calculated field that considers this parameter and inserted a table. The table is calculated based on the ON/OFF property of the field, but the checkbox still gives me an error. So, to answer your questions there are no red dimensions or measures.
Thanks for the context - if you update the data type of the parameter to ‘string’, does the error go away?
No, the error does not go away. In fact, it is now red (see the attached picture) so I assume this is an incorrect data type for checkbox.
And I get this error
If you click on ‘see details’ in the actual parameter box on the dashboard, is there anything helpful there?
Also, I am wondering what are you seeking to achieve with the parameter here?
If I click on “see details” there is nothing helpful. Just a below error message
I want to build cash flow scenarios. One scenario would be if the financing is enabled, it would change the amounts. The calculation works (see the images below - if I set the parameter’s default value and save it, the calculated amounts change). Still, I can not get a checkbox working for any boolean parameters.
Did you manage to solve this or found some work-around? I’m having the same problem. I want the user to be able to select some boolean parameters that I then use in my big query data source.
EDIT:
My workaround was to use a text-parameter instead, setting two allowed values true/false strings. Then use a drop down list control instead. Then in my big query data connector I cast it to a boolean value like CAST(@my_string_param AS BOOL).
I did notice that the checkbox works if I connect to a big query view instead of using a custom query though.. But then I can’t use my parameters.
No, I did not find a solution. I gave up and did the same workaround as you.
Is this the only work around? I am having the same issue, and just assumed it would be fixed after 6 months…
this seems to tackle the problem:
https://www.optimizesmart.com/how-to-work-with-boolean-data-type-in-google-data-studio/
But the difference is that I am making a parameter directly in Looker Studio vs bringing in a String from a data source and treating it like a Boolean.
Hey all,
It is definitely a bug with the new instances of checkbox controls, fed with boolean parameters.
This configuration was possible in the past and I’ve got several reports based on it. You can duplicate former same combinations of components but not create new ones for months. it provokes a “chart configuration incomplete” error.
To reproduce the problem
- create a report
- create a data source
- add a boolean parameter to the data source
- add a checkbox control on the page
- use the boolean parameter as the control field of the checkbox
Workaround
In the past, when this problem appeared, it was possible to replace the checkbox by a dropdown menu but it is no more a workaround (same error).
Now, as the current workaround, you need to create a text list parameter with true/false text value and use it as on a dropdown menu.
Voila. I hope it helps.
Mehdi Oudjida
Thanks for the reproduction steps! I’ve passed this on to the developer team.