AUTOMATE your CUSTOM URL LINKS Generation with Calculated Field (Formula: HYPERLINK, CONCAT)
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- In Part 1 tutorial last week, you've learned how to generate a custom bookmark URL link with one or multiple filter conditions MANUALLY. In this video, you'll use simple formula to AUTOMATE the link generations for you!
Watch to learn the trick! 🎉
About BOOKMARK URL
SEE PART 1 VIDEO HERE: • SAVE your FILTERED REP...
Special Thanks to @Vision-Labs for sharing the solution in their video - • Use URL Parameters To ... (I stumbled upon JJ's tutorial while researching about this topic, he offered the way to replace the field in URL to help us generate unlimited reports which is super genius!! Big Thanks to them for sharing such a good solution!) 💚🙏🏻
Enabling custom bookmark links for a report allows viewers to save their filter settings as a bookmark. This means that the filter settings are included as parameters in the URL of the bookmark, and when the viewer clicks on the bookmark in the future, the report will be loaded with the same filter settings that were saved. This feature provides a convenient way for viewers to quickly return to their preferred view of the data.
Read more about this Looker Studio feature: support.google...
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ ko-fi.com/T6T2...
👉 Subscribe to my channel @ www.youtube.co...
👉 Shop Danalyser Templates Collection
@ www.danalyser.com
⭐️ NEW TO GOOGLE DATA STUDIO
Check out our FREE GDS Course (2022) here 👉 • FULL Google Data Studi...
We uses practical approach and covers almost everything you need to get started in Google Data Studio! Take the course now and shine ✨
F R E E B I E S
I used Canva to make graphics for my educational videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!
Try Canva Pro FREE for 30 days: partner.canva....
[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.]
#GoogleDataStudio #Danalyser #LookerStudio
--------------------------------------------------------------------------------------------------------------------------
A B O U T M E
👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.
---------------------------------------------------------------------------------------------------------------------------
💌 W A T C H N E X T
⚈ Show current date in dashboard
👉 • Display TODAY's DATE a...
⚈ Export Data from Data Studio
👉 • How to Export Data Fro...
⚈ Automation in Data Studio (Email Delivery)
👉 • How to automate data s...
I REALLY appreciate your content, I just started using Google Studio 4 months ago and learning more about it everyday.
I couldn't really find good tips and tricks like the ones you are showing they're like small secrets. Keep doing what you're doing, and thanks alot!
This is so great! Thanks for sharing your journey, I wish you all the best and I'll continue to do my best in helping more people like you to get started with Looker Studio! 💛
Super helpful! Thank you!!! 🥰
Thank you Arcia!! So glad you found it helpful! :)
Super useful 🎉
Thanks mate! 🙏🏻
¡Gracias!
Thank you for your great support Héctor!
Keep the good work going 👏👍
Thank you Mukesh! 🙌🏻
ERES MUY BUENA, GRACIAS POR TU APORTE ME SIRVIO MUCHISIMO
Thanks SL..
No problem 👍
Awesome 😱
So glad to hear Vinit! :)
thank you for making great videos, can you guide me to add the weather forecast to the report?
Master Ling:)
Thx a lot for this video,
i try to excercise on mywork but i see some exception, espicially in minute 5:07.
If country use "&", it will not work. Luckily there is no "&" in country, but in my data, honestly there is "&".
Example "Cat & Dog meal products"
Mysolution is make case when to some products thats use "&" in calculated field
Is it possible to look which pages / keywords have lost ranking after algorithm update in this data looker?
By the way good work.❤
Hello!
I am trying to have a dynamic title as suggested in my own use case. But I am unable to implement it. The formula
IF(COUNT_DISTINCT(COUNTRY)>1,"MUKTIPLE",MAX(COUNTRY)) is not working. Can you help
@Danalyser , Can we have a topic of RLS(Row Level Security) in looker studio.
how to create a filter that views urls containing for example domain/en?
is there a way to do this in Power BI?
شكرا
Hi mam i have created one report using looker but it contains multiple pages from multiple data source how can i automate the same for that report
Hi, is there a way to get the user selected filter values from the drop-down control to be used in a dimension field ?
Hi thanks:), is there a way to open in the same tab and not a new page ?
Yes there is! Just untick the Open in the same tab option, but that doesn't work well for Bookmark Link.. but for a normal link, it should works well! :)
Can we connect directly looker studio to share point
I have embedded url with labels, and I want google studio to allow users to click on those links, how can I accomplish this?
Hi! I have covered in this video :)
Maybe this is a better video: SAVE your FILTERED REPORT with Custom Bookmark (URL LINKS) - Looker Studio Tutorials/Data Studio
th-cam.com/video/lNME-EeWJ-4/w-d-xo.html
@@danalyser thank you I’ll check it out