PROGRESS BAR in KPI SCORECARD! Looker Studio NEW Feature! (How to Create Scorecard 2023)
HTML-код
- Опубликовано: 2 авг 2024
- In this Looker Studio (Google Data Studio) tutorial, we explore the exciting new features of the scorecard chart, focusing on the latest update that allows you to create stunning progress bars. This allows you to compare your actual stats vs a target that can be set manually / dynamically in the scorecard chart settings.
Discover the essential steps to create impactful scorecards in Looker Studio, and explore the world of progress bars. Here's what you'll learn in this tutorial:
✅ Creating Scorecards:
✅ Setting Targets for KPI
✅ Create Progress Bars (NO formula Needed!)
✅ Customizing Progress Bar Colors
✅ Bonus Tip (if you stay till the end!)
If you found this video valuable, please give it a thumbs up and subscribe to our channel for more tutorials on data visualization and analytics. Stay tuned for our upcoming videos to create BETTER REPORTS! 💛🙏🏻
Thanks for your support!
▶️ WATCH THIS NEXT: CONDITIONAL FORMATTING IN SCORECARD : • How to Format Scorecar...
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ ko-fi.com/T6T25PD0A
👉 Subscribe to my channel @ ruclips.net/user/Danalyser?s...
👉 Shop Danalyser Templates Collection
@ www.danalyser.com
⭐️ NEW TO LOOKER STUDIO (GOOGLE DATA STUDIO)
Check out our FREE GLS Course here 👉 • FULL Google Data Studi...
We uses practical approach and covers almost everything you need to get started in Google Looker 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.com/danalyser
[ 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.]
#GoogleLookerStudio #Danalyser #GoogleDataStudio
--------------------------------------------------------------------------------------------------------------------------
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... Наука
Hey! Welcome backkkk! 💛I’m so excited for this feature, how do you find the updates so far? Let me know 👇👇
Sooo good, ty for sharing !
Exactly what I needed, thank you! Great instruction and so easy to follow
Hello Dana!!! im new at looker studio and this tutorials are *chef kiss*!!! PLEASE CONTINUE AND NEVER STOP
Your videos are really good nice work Keep making this kind of content. 👍
It was great new feature...thanks for the update.
My pleasure! Thanks for watching Mohd! 🙏🏻😊
Hi, how can we set targets when filters are applied? If I have a target for a whole class to be 1000, but I want that to change when I select a student. How to get it to update. Thank you!
Thankss You are PRO
❤❤ all your videos are amazing
You are so kind, thanks for the lovely comment! 😍✨
Thank you very much :)
You're so welcome Barbara, do continue to support my small channel and let's grow together! :)
Thanks
Hi, what is the cloud calculator you were using in the video? looks cool. Thank you for sharing.
Hello, your vedios are good,
Hello, thankyou for sharing this. i wanna ask something, how the barchart color of the progress responsible can be set based on the progress, e.g. progress 0% to 30% yellow in looker studio? this for my project, so i hope you read my comment
Hai.. Can the comparison value be dynamic depending on a category ? can it dynamic based on data in your sheets?
❤❤❤
Thanks! Great job Kiddo! Your channel has been very helpful for my work! Love the tips and tricks!
Happy to help! 😊
Terimakasih ❤
Sama Sama Farid, Selamat Hari Raya Haji! 🎉
Can we connect directly looker studio to share point with out using other integration tools? Please answer me...
hi, how to add data from cell in to data studio? let say in category column they are best, good, bad. best = 10, good = 8, bad = 6. so i just want choose bad data from that column to add to scorecard in looker studio. please help me. thank you
Hi~ a queation is struggling for me.
What is the difference of the comparison type- full stop/ metric / value?
I try the three types, and they shows differently. Can you help me? Thanks a loooot~!!
Hey!!! Can I create only progress bar without the score card numbers? I wanted to only show the progress bar. No numbers
Can the comparison value be dynamic depending on a category? Thank you!
yes, you can! :)
Love your videos! Could inform how to create visualization in different currency? Having main data as USD, but be able to change all dashboard data in different currency!?
Thanks for your love and support Limonada! Mind explaining more about changing the data in different currency? I have a related video on how to change the currency for individual charts but wasn't too sure if that's what you meant.
Here's the link: ruclips.net/video/6uf4M2gCKW8/видео.html
Best,
SL
@@danalyser thank you for getting back to me. Sure, will try to explain.
I would like to add a control drop-down where options of currency will show up.
Currently I manage region report where each country have different currency.
The report is all presented in USD, however would be great for the user to have a control and see report in their local currency instead of USD to relate more with the results. Does it make sense? Sorry if I was not clear enough.
@@limonadanojapao ah ! You case use formula like case when to give a currency for each region- then use show the currency in the scorecard instead of using the exisitng format available in Looker Studio.
I’m not sure if I can explain this clearly in text, hope this can give you some pointers :)
@@danalyserif you have a time to create this content or if there’s a demand for this topic I would like to look how is done considering there’s no much youtube content covering this.
Thank you for your reply and for taking time to respond to me. Have a great week! 👍🏻
@@limonadanojapao sure if many looks for this tutorial, I might consider making one for you guys! Have a great week ahead! :)
Hi, how to make scorecard from this data
Year Data
2022 50
2022 40
2023 80
2022 60
2023 90
and the target every year is different, for 2022 is 60 but for 2023 is 50
how to show it in scorecard with progress bar
Thank you
How to make scorecard works with target from google sheets, example
Month Target Sales
1 5000 4300
2 3000 3460
3 6000 5345
4 4500
5 7000
Thx a lot
Hey Arfanariyanto, you may blend the data and choose "Metric" for the Comparison type options. then add the target field. Hope this helps :)
@@danalyser Ah I see, i never notice that, Thx u very much. Thx a lot for the reply @danalyser
@@arfanariyanto297 you’re so welcome! 💛 do continue to support my small channel ✨