Looker Studio Buttons & Filters Explained For ULTIMATE Usability

[@mendyzeiger3624]

de-pressed un-pressed 🤣🤣🤣 I'm IMPRESSED by your videos!

[@Vision-Labs]

LOL! Hey Ill take it! Thanks for watching Mendy! - JJ

[@KrystynaMykhaylova]

Finally great video to the topic! small tip: using quotation mark with true/false makes STRING out of it, so dropping them will help Looker Studio to parse it as Boolean :)

[@Vision-Labs]

Thanks! I normally got it down pat, but for some reason in tis video I completely missed that 😆.

[@elielconegero]

Nice video, thanks for supporting!

[@Vision-Labs]

Glad we can help! - JJ

[@DylanBianchi-y3k]

Hi, do you know how to make blended data work with separate filters? E.G. Chart for Page path x Total Users blended with a chart for Event Name x Total Users. Both Event Name and Page path charts are controlled by separate filters...

[@Vision-Labs]

Hey there! You should theoretically be able to group everything together in LookerStudio to do this. It will depend on the underlying data set.

[@HaimoBasumatary-k8k]

hi can we create export button in looker studio

[@Vision-Labs]

Yes! You can download a PDF or the data behind the chart

[@HaimoBasumatary-k8k]

@@Vision-Labs Hi, Thanks for your reply. Can we add a custom button in Looker Studio to export table data to Excel, similar to the reset button in your video? I know about the three-dot menu export, but I'm looking for a way to add a dedicated export button for the table.

[@BrianGarnick]

Super helpful videos, thank you! Was wondering if you know of a way to do a blend to calculate the difference between two scorecards when one scorecard is within the button control field grouped filter and the other isn't. In this case both scorecards are for the same metric, just illustrating the difference between non-filtered and filtered metric. (ie; (Active Users in USA)/(Active users) = some%)

[@Vision-Labs]

Hey Brian! I don’t think that will be possible. Buttons apply to the visual not the underlying function There might be some way to hack it using parameters but I’m not 100% sure

[@BrianGarnick]

Thanks!!!

[@fernandolisboa]

Hi, there are a way to block in date selector control a period that end user can not put ? like i like thar my user don't set date select more then a month ago.

[@DharmaSureshReddyBoini]

i want date clear date range control when click on button in looker studio.

[@Vision-Labs]

Sounds like a fun challenge! -JJ

[@sssthgg]

I have made buttons for filtering, but facing difficulty while making custom bookmarks for button filters. If you have done it before, please let me know how to do it.

[@Vision-Labs]

hmmm, i'm not sure what you mean by this.

[@sssthgg]

@@Vision-Labs There is an option in report setting for custom bookmark link, that helps the viewer to save the filtered report as bookmark. It seems to work on dropdown and other kinds of filters, but not working on button filter.

[@mohamed.montaser]

what version of looker studio you are using? because i don't have this publish button that you have on the top right or the draft version with the yellow circle on the top left

[@Vision-Labs]

To add this, Go into File & Publish settings. Then turn on publish versions! Best of luck - JJ

[@pletealavinia4830]

Is it possible to change a variable from true to false in the BigQuery table by pressing a button in LookerStudio?

[@Vision-Labs]

Technically it is possible to write things back into bigquery from looker studio, but I would not advise it as the end users usually don't know what they are doing. What is your usecase? - JJ

[@pletealavinia4830]

@@Vision-Labs It's for a project and from what I understand I have to create a Cloud Function in LookerStudio that changes data from "true" to "false" in BigQuery when a button is pressed. Do you have any idea how to do this? Thanks for the reply!

[@Vision-Labs]

​@@pletealavinia4830 I havent't had success with this :( If you figure it out, please let me know! - JJ

[@C3DPrinting]

How do I set a boolean value to a date? Or better question is, how to I create a button that automatically sorts the date to a specific range? Ie. "Last Year" "This Year" and "All Time"

[@Vision-Labs]

Unfortunately it’s not possible :( -JJ

[@getyousome321]

@mendyzeiger3624 you forgot to mention how we are now Groupiddy Grouped 🤣🤣🤣

[@Vision-Labs]

Exactly! 😉 -JJ