Sorry All! 🙏🏻 I made a mistake in my OBS export setting 😭 the export quality is set to 1280x720, and not the highest quality. Sorry 🙏🏻 Some of the part in this video might not be super clear, if you have any questions, let me know! :)
Very interesting! I would love to see a dedicated video to working with percentage values in Looker Studio. The software is indeed very powerful, but I find displaying percentage values very tricky. Especially in pivot tables, where I typically would need to show a summed up value side by side with the percentage of that value.
Hi there, thanks for watching! 🙏🏻 I might already have some tutorials for pivot tables - but I'll add your suggestions to my video ideas! Thanks alot! 😊
Thank you so much. It helps me a lot! Btw, how to adjust a column in Looker Studio? Example there are 4 column but when we click a filter, there will shown 5 column. Tia!
Hi Danalyser 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.
Thanks for the explanation, your content is great! Is there a way to put a condition on the button so that it displays or hides a table? Like a button... "show details"... that way I could make my page cleaner
Hey Daniel, thanks for watching! 🙏🏻 Re. your question, while I'd LOVE to have this feature in Looker. Unfortunately, I don't think it's is available at the moment, and this button feature might not be a solution for that as well. But just throwing out my idea, maybe you can have 2 similar pages, one with the table and one without, then you can add a link say "Show details" somwhere so the user can actually navigate to second page through a navigation button? :)
Wow, it is super helpful indeed. It actually solved my questions. But, I got one more question see if you could help, how could I group the existing daily data into weekly basics like 1st to 7th Jul - Week 1; 8th to 14th Jul - Week 2, etc? Which formula should I use?
Filter button can combine more than 1 conditions, where dropdown can only filter to the values in the dimension. Filter button is also more intuitive for users, for example, you can create filters for “last month”, “US and UK only” etc
Can you make a dashboard showing the Engineering KPI? I've been trying to make one but I've encountered many errors and cannot be able to fix it. Thank you in advance.
Good evening, I have a question for our honorable professor. Is it possible, through Looker Studio, that I can enter data into a table as is the case in an Excel sheet? I have another question: Can I hide the Google Sheet file menus and toolbar from the user when entering data and he cannot show the menus such as the File, Edit, or Format menu? Thank you and we apologize for the length
Hi! Qasim Ali thanks for sharing the idea! I'm not the expert in this area, but I might consider your idea :) what are your current struggle with OBS if I may ask?
@@danalyser Thank you so much. I am putting my learning into recordings so that I can refer back to it when I needed, but I am not good at it, that's why I requested you to do a video on this topic. I learned so much of Looker Studio from you. I just want to say Thank You so much my respected TEACHER. GOD bless you.
Hey if i want to break the data like one customer purchased many items can i put customer name in dimension and in drilldown can i put item purchased as one customer can purchase many items
Hi ,i want to make a report for a online store. Here i want to show month wise sells for Individual customer purchased the product. So need to make a report Customer wise product purchased and total sells happened for the individual product in looker studio.Any guidance on this.Which Chart also i can use to show total sells happened by product category wise by individual customer purchased. Please guide me. I need help urgently on looker studio
Hi mam, i want to create a comparison report of conversion rate between new users and returning users. Is this possible? I mean how many users converted from new users count and how many converted from returning user count. Please help
Hi @danalyser. Thanks for fantastic VDO. So, i want to export Data to Excel Template, including my company logo (I created by myself), do you have any ways to do this? If you can do it, please guide me step by step. Thank you so much!
I had the Week inserted as text type in my data. So whenever I applied the Week number as 'Date Range Control', the output result is correct but it lost the comparison data vs the last period for example. How can I resolve this issue to have the flexibility to filter data either by the built-in date range or the Week number (as text type)? If that is even possible? Thanks in advance.
have your tried filter website pages and put a grand total in a table? the total numbers are incorrect if you export and double check it in excel. example total of 3 subpage is 100 in lookerstudio grand total but when double check in excel it be 150. have you experience this and any solutions?
Hi @danalyser i would like to ask you if I want to make a line chart that can compare 2 platforms and with a filter that can change the platform, can that be done in looker studio?
Hi, great video, can you help me with this? Hi I have these values: Product | Sales | Price A 1500 10 B 5000 15 C 250 25 D 1700 30 Leader sales product price is 15 Want to get Product | Sales | Price | Price Diff A 1500 10 -33% B 5000 15 0% C 250 25 67% D 1700 30 100% How do i achieve this in looker studio using all my dimensions values? Thank you!
Hey Devsharma, not sure if I'm getting what you mean. But I guess you're probably confused about the dimension vs metric and where do they go in in a chart. I will suggest you to look into my free course which I've covered this topic in detail: th-cam.com/video/dsAVSsdYC10/w-d-xo.html Thanks alot for your support 🙏🏻💛
@@danalyser i know dimension and metrics from your video. I just wanted to know where shall i put the customer name and date and quantity field in which dimension.
@@danalyser Hey if i want to break the data like one customer purchased many items can i put customer name in dimension and in drilldown can i put item purchased as one customer can purchase many items
![[LIVE] : ONE ลุมพินี 75 | คู่เอก "คมเพชร vs โอมาร์"](http://i.ytimg.com/vi/WugMG7Po8uw/mqdefault.jpg)
![ออกพรรษาน้ำตาหล่น - แอน อรดี [OFFICIAL MV]](http://i.ytimg.com/vi/PFZtOcY9ONA/mqdefault.jpg)
Sorry All! 🙏🏻 I made a mistake in my OBS export setting 😭 the export quality is set to 1280x720, and not the highest quality. Sorry 🙏🏻 Some of the part in this video might not be super clear, if you have any questions, let me know! :)
No one can blame you for the mistake, especially with a cute and adorable girl like you! Sending lots of love and support your way! ❤
@@tienta4424 awww you’re so sweet! Thank you so much 🥰🥰
OMG, THANK YOU SO MUCH FOR SHARING!!!
Very interesting!
I would love to see a dedicated video to working with percentage values in Looker Studio. The software is indeed very powerful, but I find displaying percentage values very tricky. Especially in pivot tables, where I typically would need to show a summed up value side by side with the percentage of that value.
Hi there, thanks for watching! 🙏🏻 I might already have some tutorials for pivot tables - but I'll add your suggestions to my video ideas! Thanks alot! 😊
Really give me a lot of help to know how to start Looker. Thanks for your efforts
Happy to help! and thank you for supporting! 💛
Thank you very much for this new tutorial. Very useful and much easier than advanced filters! :)
You're very welcome Danny! So glad you've find this tutorial useful 🙏🏻💛
Thank you so much for this tutorial, very well explained!
Thank you thank you! :) So glad you've enjoyed this one!
Great tutorial! Thanks for sharing
Welcome back old friend :) Glad it was helpful! Very curious on how you gonna use this feature your work! ✨
Thank you so much, that helped a lot! 😁
So glad it helps :) Thanks for the lovely commment Julianichagas!
thanks so much for this helpful tutorial
You're so welcome!
Love it!!!!!!!!!!!!!!!!
THANK YOU SOOO MUCH Nuno Alexandre! 💛
Nice tutorial 😊❤
Thank you 💛💛🙏🏻 Appreciate your support!
thank you for this technique is so useful
Thanks a lot! It helped me a lot (:
Thank you very much super usefull!
Thank you so much. It helps me a lot! Btw, how to adjust a column in Looker Studio? Example there are 4 column but when we click a filter, there will shown 5 column. Tia!
Hi Danalyser
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.
Thanks for the explanation, your content is great!
Is there a way to put a condition on the button so that it displays or hides a table? Like a button... "show details"... that way I could make my page cleaner
Hey Daniel, thanks for watching! 🙏🏻 Re. your question, while I'd LOVE to have this feature in Looker. Unfortunately, I don't think it's is available at the moment, and this button feature might not be a solution for that as well.
But just throwing out my idea, maybe you can have 2 similar pages, one with the table and one without, then you can add a link say "Show details" somwhere so the user can actually navigate to second page through a navigation button? :)
Wow, it is super helpful indeed. It actually solved my questions. But, I got one more question see if you could help, how could I group the existing daily data into weekly basics like 1st to 7th Jul - Week 1; 8th to 14th Jul - Week 2, etc? Which formula should I use?
Why use filter buttons if you can dropdown? Or is there a difference?
Filter button can combine more than 1 conditions, where dropdown can only filter to the values in the dimension.
Filter button is also more intuitive for users, for example, you can create filters for “last month”, “US and UK only” etc
WoW % video was very helpful.
Hi, it is related to WoW% video can you please help me with running sum and slicer after blending the data
How can i use the button in edit mode? Should i press any key before?
Can you make a dashboard showing the Engineering KPI? I've been trying to make one but I've encountered many errors and cannot be able to fix it. Thank you in advance.
Good evening, I have a question for our honorable professor. Is it possible, through Looker Studio, that I can enter data into a table as is the case in an Excel sheet? I have another question: Can I hide the Google Sheet file menus and toolbar from the user when entering data and he cannot show the menus such as the File, Edit, or Format menu? Thank you and we apologize for the length
Can you do a video on how you use OBS for recording videos, please.
Hi! Qasim Ali thanks for sharing the idea! I'm not the expert in this area, but I might consider your idea :) what are your current struggle with OBS if I may ask?
@@danalyser Thank you so much. I am putting my learning into recordings so that I can refer back to it when I needed, but I am not good at it, that's why I requested you to do a video on this topic. I learned so much of Looker Studio from you. I just want to say Thank You so much my respected TEACHER. GOD bless you.
@@QasimAli-gy3nb I see, will add this in my video ideas list. Thanks for the suggestions!
Hey if i want to break the data like one customer purchased many items can i put customer name in dimension and in drilldown can i put item purchased as one customer can purchase many items
Hi ,i want to make a report for a online store. Here i want to show month wise sells for Individual customer purchased the product. So need to make a report Customer wise product purchased and total sells happened for the individual product in looker studio.Any guidance on this.Which Chart also i can use to show total sells happened by product category wise by individual customer purchased. Please guide me. I need help urgently on looker studio
Is it possible to change a variable from true to false in the BigQuery table by pressing a button in LookerStudio?
Hi mam, i want to create a comparison report of conversion rate between new users and returning users. Is this possible? I mean how many users converted from new users count and how many converted from returning user count. Please help
Hi @danalyser. Thanks for fantastic VDO. So, i want to export Data to Excel Template, including my company logo (I created by myself), do you have any ways to do this? If you can do it, please guide me step by step. Thank you so much!
I had the Week inserted as text type in my data. So whenever I applied the Week number as 'Date Range Control', the output result is correct but it lost the comparison data vs the last period for example. How can I resolve this issue to have the flexibility to filter data either by the built-in date range or the Week number (as text type)? If that is even possible? Thanks in advance.
Hey there! you may try to change the format of the week to date, or use PARSE date to convert it from text to date data type. Hope this helps!
have your tried filter website pages and put a grand total in a table? the total numbers are incorrect if you export and double check it in excel. example total of 3 subpage is 100 in lookerstudio grand total but when double check in excel it be 150. have you experience this and any solutions?
Hi @danalyser i would like to ask you if I want to make a line chart that can compare 2 platforms and with a filter that can change the platform, can that be done in looker studio?
Hi, great video, can you help me with this?
Hi I have these values:
Product | Sales | Price
A 1500 10
B 5000 15
C 250 25
D 1700 30
Leader sales product price is 15
Want to get
Product | Sales | Price | Price Diff
A 1500 10 -33%
B 5000 15 0%
C 250 25 67%
D 1700 30 100%
How do i achieve this in looker studio using all my dimensions values? Thank you!
❤❤❤
Thanks for the love and support! :)
If u want to analyse customer wise product sold and quantity, in which dimension i have to put these field
Hey Devsharma, not sure if I'm getting what you mean. But I guess you're probably confused about the dimension vs metric and where do they go in in a chart. I will suggest you to look into my free course which I've covered this topic in detail: th-cam.com/video/dsAVSsdYC10/w-d-xo.html
Thanks alot for your support 🙏🏻💛
Aww thanks for leaving this awesome comment! :)
@@danalyser i know dimension and metrics from your video. I just wanted to know where shall i put the customer name and date and quantity field in which dimension.
@@devsharma5669 hey there, I dont quite get it. is this question related to this video/topic?
@@danalyser Hey if i want to break the data like one customer purchased many items can i put customer name in dimension and in drilldown can i put item purchased as one customer can purchase many items