Is there a way to get the target value dynamically fetched from the data, say when different projects have different target values and we want to track the project progress basis that project's target value.
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
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~!!
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!
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: ua-cam.com/video/6uf4M2gCKW8/v-deo.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! 👍🏻
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, 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
Hey! Welcome backkkk! 💛I’m so excited for this feature, how do you find the updates so far? Let me know 👇👇
Hello Dana!!! im new at looker studio and this tutorials are *chef kiss*!!! PLEASE CONTINUE AND NEVER STOP
Sooo good, ty for sharing !
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! 🙏🏻😊
❤❤ 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! :)
Thankss You are PRO
Is there a way to get the target value dynamically fetched from the data, say when different projects have different target values and we want to track the project progress basis that project's target value.
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
Hi, what is the cloud calculator you were using in the video? looks cool. Thank you for sharing.
Hai.. Can the comparison value be dynamic depending on a category ? can it dynamic based on data in your sheets?
Can the comparison value be dynamic depending on a category? Thank you!
yes, you can! :)
Thanks
Terimakasih ❤
Sama Sama Farid, Selamat Hari Raya Haji! 🎉
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~!!
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!
Can we connect directly looker studio to share point with out using other integration tools? Please answer me...
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: ua-cam.com/video/6uf4M2gCKW8/v-deo.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 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
Hey!!! Can I create only progress bar without the score card numbers? I wanted to only show the progress bar. No numbers
❤❤❤
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 ✨
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