oh man! We have reached 500 milestone here on RUclips!! Thank you so much for supporting this channel! I am still trying to find out how I could use the community feature - can't wait for the first post over here and talking to you all 💚
Haha, thanks Sin Ling, again you solving my problem, I am just trying to fix my false calculating percentage on Click / Impression, just blending it and bingo, solved! 😆
Hi there, you're so welcome! Are you using time series chart ? You may refer to this tutorial that I made: ruclips.net/video/xLKNyTB692w/видео.html Hope this is helpful! :) SL
Hi Dana, this is exactly what I'm looking for, thanks so much! The problem I have is that the percentage in my pie chart is different from the percentage calculated using this blend data feature (the blend data shows the correct % tho). Do you maybe have any idea why my pie chart is showing a wrong % even though the input source is correct?
Hey I would recommend checking if there's any filter applied to the pie chart, or if the report date is using the same field. So sorry for the super late replies as I was not in my best state to reply to your questions.
Hi Pentea! So glad you find it useful :) Sure, you'd need to enable the cross-filtering option for the chart. For the step by step guide, you may refer to this video by another GDS educator: ruclips.net/video/hoIRtKeng5g/видео.html
Hey Divya, you may edit the calculated field name or rename the scorecard metrics. Renaming calculated field would help to rename all the charts that have used the field. If you want to rename a particular chart, go for the second method: rename the chart metrics name. Simply hover on the metric (there’ll be a edit icon) click on that and put the new name for the metric. And this would override the name of the calculated field when showing in the scorecard. Hope this is clear :)
Hi Dana, very informative video. May I ask, how do we create a blend between grouped scorecard( grouped with control) and ungrouped scorecard ? Because I my dashboard I want to create a percentage of total from selected values compared to the total number of people
hey Josua! Thanks and glad it is helpful to you! Do you meant you want the percentage of total to calculate dynamically based on what the users select ?
Hi John, I’m not exactly sure about the problem you facing. But if you need to limit it to max 100 - wrap the formula with CASE WHEN or if so that if the output is more than 1, you want to relabel it to 1. Hope this helps!
This doesn't work anymore right? Since they added the new join configuration to the blend data option. Now it does not create a percentage from the two scorecards straight forward...
@@danalyser nope, it doesn't. I do the same as usual: select score card 1 (unique events), select card 2 (unique page views), right click and select Blend Data --> result: a new score card with the same data as score card 1. 🤷♀
@@danalyser I tried, but then I can not apply different filters to each metric. So does it happen to you also? Did Looker Studio changed this? There must be a simple way to do it as simple as before but I don't find it!
@@user-qw9fv7jr1j I actually tried again when you mentioned that it doesnt work, but I can do it using the method in the video. the manual way of adding the metrics and filter to data blend is working as well, so I wasn’t too sure about the issue you’re facing currently.
![FULL Google Data Studio Course (2023) ➡️ rebranded to Looker Studio) [Compilation]](http://i.ytimg.com/vi/dsAVSsdYC10/mqdefault.jpg)
oh man! We have reached 500 milestone here on RUclips!! Thank you so much for supporting this channel! I am still trying to find out how I could use the community feature - can't wait for the first post over here and talking to you all 💚
0:54 0:54 😊😊😊😊😊😮
0:54 0:54 0:54 0:54
Hello Dana, this was exactly what I was looking for! You are a problem solver Ma'am. Cheers
I'm glad to help! :)
Haha, thanks Sin Ling, again you solving my problem, I am just trying to fix my false calculating percentage on Click / Impression, just blending it and bingo, solved! 😆
Hey Rusdi ! Thanks for watching again! You're welcome, so happy that this short video has helped you in your work :)
Really useful, you saved me a lot more searching!
So glad you found my videos! :) Thanks for the comment! :)
This is just what I needed! Thanks.
Glad this video managed to help you out! Thanks for the lovely comment!
Hi Dana, thanks a lot for your video. Could you show me how to sort data according to date, by date/month/year in dynamic chart?
Hi there, you're so welcome! Are you using time series chart ? You may refer to this tutorial that I made: ruclips.net/video/xLKNyTB692w/видео.html
Hope this is helpful! :)
SL
Thanks. Very helpful
You're welcome Ser Kwang!
Thanx SL for sharing….very2 useful 👌🏼
You're very welcome Hadi!
Hi Dana, this is exactly what I'm looking for, thanks so much! The problem I have is that the percentage in my pie chart is different from the percentage calculated using this blend data feature (the blend data shows the correct % tho). Do you maybe have any idea why my pie chart is showing a wrong % even though the input source is correct?
Hey I would recommend checking if there's any filter applied to the pie chart, or if the report date is using the same field. So sorry for the super late replies as I was not in my best state to reply to your questions.
You are the best❤
Hello, thanks for the tutorial. It is very useful to me. Can I ask how you can create a horizontal bar graph which filtering out the countries?
Hi Pentea! So glad you find it useful :)
Sure, you'd need to enable the cross-filtering option for the chart. For the step by step guide, you may refer to this video by another GDS educator: ruclips.net/video/hoIRtKeng5g/видео.html
@@danalyser thanks a lot ^^ I will check it out.
You're welcome! 💚
Thanks 🙏
You’re welcome 😊
Awesome
Can this be done on a table?
how did you change the name of the calculative scorecard?
Hey Divya, you may edit the calculated field name or rename the scorecard metrics. Renaming calculated field would help to rename all the charts that have used the field.
If you want to rename a particular chart, go for the second method: rename the chart metrics name.
Simply hover on the metric (there’ll be a edit icon) click on that and put the new name for the metric. And this would override the name of the calculated field when showing in the scorecard.
Hope this is clear :)
Hi Dana, very informative video. May I ask, how do we create a blend between grouped scorecard( grouped with control) and ungrouped scorecard ? Because I my dashboard I want to create a percentage of total from selected values compared to the total number of people
hey Josua! Thanks and glad it is helpful to you!
Do you meant you want the percentage of total to calculate dynamically based on what the users select ?
@@danalyser Yes, correct
@@pub_scrubs I see. From what I know, if your dataset is similar to my example, this is not possible to do yet in Data Studio.
same percentage in table formate how
What to do if you get a percentage higher than 100%? how can I limit the output data to 0-100% only after blending the data?
Hi John, I’m not exactly sure about the problem you facing. But if you need to limit it to max 100 - wrap the formula with CASE WHEN or if so that if the output is more than 1, you want to relabel it to 1.
Hope this helps!
🔥🔥🔥
❤️❤️❤️
I need 2 column % in table
This doesn't work anymore right? Since they added the new join configuration to the blend data option. Now it does not create a percentage from the two scorecards straight forward...
Hi Susana, This still works from my end, does it not work for you?
@@danalyser nope, it doesn't. I do the same as usual: select score card 1 (unique events), select card 2 (unique page views), right click and select Blend Data --> result: a new score card with the same data as score card 1. 🤷♀
@@user-qw9fv7jr1j i see! I guess you would have to add the fields manually in the data blend configuration in this case :)
@@danalyser I tried, but then I can not apply different filters to each metric. So does it happen to you also? Did Looker Studio changed this? There must be a simple way to do it as simple as before but I don't find it!
@@user-qw9fv7jr1j I actually tried again when you mentioned that it doesnt work, but I can do it using the method in the video. the manual way of adding the metrics and filter to data blend is working as well, so I wasn’t too sure about the issue you’re facing currently.
Thanks very helpful
Nice sticker! Haha thank you for the support 🙏