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!
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? :)
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.
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?
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 @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!
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.
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
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.
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.
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 @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?
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 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
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, 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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dsAVSsdYC10.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
