Welcome back! We have reached 1000 subscribers milestone this week ! Thank you for all the support :) SL
@Iamgroot14344
2 жыл бұрын
Congrats Danalayser. I am fascinated by how knowledgeable you are in GDS and how beautiful you are. I can't help to stare at you.😅
@FilipGusev
6 ай бұрын
Thank you for this video, really really helpful and great useful tip indeed on how to do percentage growth in Looker!!!
@semponmanickam5924
27 күн бұрын
Can you please create Month over Month Report for Clicks?
@aleishh1860
Жыл бұрын
Great tutorial! I just noticed on 7:45, your Total Order on table 2 didn't match the Total Order on table 1 after you added Last Week's Order..for example on Week 25, total order became 45 from 38
@ren.aldamia
2 ай бұрын
Hi this is really helpful thanks a lot. But I have a question, hopefully you can read this comment, what if in our data set has another column for example marketplace in where the order happen, how can I add the marketplace as metric so that it will not be treated as number? I want to include this marketplace so that I can able to use filter button on the charts and table.
@fcortesjp
7 ай бұрын
mind blown... thank you @danalyser. Exactly what I was looking for ... can't wait to trying this out
@danalyser
7 ай бұрын
Naicee! Please let me know if it works for you!! :)
@fcortesjp
7 ай бұрын
it did work, you made my day, thank you! :)
@danalyser
7 ай бұрын
@@fcortesjp 💛💛
@chinmaya_c_m
2 жыл бұрын
You are awesome. Thanks for these insightful tutorials.
@danalyser
2 жыл бұрын
My pleasure! Thanks Chinmaya! :)
@carlaflores3239
Жыл бұрын
Hi, how do you display the dates in that particular week? Like the table at the left "25 Jul 2022 to 30 Jul 2022 (Week 30)" instead of just "202230"
@HungNguyen-990
8 ай бұрын
Hello Ms.@danalyser, I have the same question and how to solve it?
@whiskyjvck
7 ай бұрын
Finding a solution to this would be the cream on top to this great video.
@kennethgarcia1178
29 күн бұрын
❤❤❤
@RelaxingMusicForAllHuman
Жыл бұрын
It was useful!! Thanks!!
@danalyser
Жыл бұрын
Glad to hear that!
@JessePineapple1200
Жыл бұрын
Wow! you're awesome! you just save my job tonight! I was wonder how can I add a "breakdown dimension" with this self join method?
@danalyser
Жыл бұрын
Hey Jesse you can add the dimension in the data blend dimension, and use it as the join key, on top of the existing join key mentioned in the video. However, it does require the dimension to have value in both week - otherwise you might have missing number here and there. Hope the explanation is clear enough :) Thanks for watching my videos :))
@JessePineapple1200
Жыл бұрын
@@danalyser Great!! I will try it! Thanks so much!
@danalyser
Жыл бұрын
@@JessePineapple1200 You're so welcome, hehe have a good day! 🥰
@carlaflores3239
Жыл бұрын
Hello, what if we start our weekly analysis on Sunday instead of Monday? How will the formulas change?
@leonardfernandez3297
Жыл бұрын
Hi, is there a way that I can change the week to week start/week beginning?
@user-xo2ny6ce2t
Жыл бұрын
Thank you
@danalyser
Жыл бұрын
You're welcome Albert! :)
@zawttunoo8778
2 жыл бұрын
Awesome. Wondering any HR analytic , especially for employee turnover Would like to.calculate active headcount of selected date range filter , based on joined date and resigned date.
@danalyser
2 жыл бұрын
Thank you! Would love to cover HR analytics dashboard in my future videos, if you have any sample data / ideas for the analytics, feel free to share with me at my email or instagram: @danalyser8. Thanks alot!
@user-eu1bk7ug1r
Жыл бұрын
WoW % video was very helpful. is there a way to do same exercise without blending the data ? or can you please help me with running sum and slicer after blending the data
@yoray_s
Жыл бұрын
Thank you. tipped
@danalyser
Жыл бұрын
Thank you so much for your generous support! ❤
@niakwon2978
2 жыл бұрын
Hey I loooooooooove your videos and thank you so much and please keep making them!! Do you know how to make the weekday starts from Sunday not Monday as default????
@danalyser
2 жыл бұрын
You're so sweet thank you so much!! Sorry for the late replies as I am not aware that this comment gets moved to "held for review" by KZitem 😅 For your question, I've found a solution from GDS forum that you may adapt to: support.google.com/datastudio/thread/8643969/can-someone-give-me-the-formula-to-change-the-week-day-start-from-monday-to-sunday?hl=en Thanks for the support again!
@niakwon2978
Жыл бұрын
@@danalyser Thank you so much! Do you think it's possible to aggregate 4-5 weeks that start on Sunday to make it a customized month dimension?
@danalyser
Жыл бұрын
@@niakwon2978 You're welcome! ❤ Yes, it's totally possible if we use CASE or IF function, I've covered it in one of my tutorial so I'd put the link below for your reference yea. It's about how to create a custom date filter, but you'll learn how to create the dimension using the calculated field for a few date ranges. Hope this helps! Custom Date Range Filter: kzitem.info/news/bejne/uoqiun93jpWlZZw
@johnho7554
Жыл бұрын
useful stuff! How do you get the week and month instead of a week by year?
@danalyser
Жыл бұрын
Thank you John! Not sure if I get what you mean... any examples for the date format you mentioned?
@johnho3542
Жыл бұрын
Yes! For example is it possible break it out into week 1 - Jan 1 - 7, week 2 - Jan 8 to 16 etc. So in the table we can show it as Jan 1-7 2023, Jan 8 - 16 2023 as columns?
@HEYATIF
2 жыл бұрын
I mail you didn't respond. Please share your mail in about where can share my queries with you thanks
@danalyser
2 жыл бұрын
Hi, I've checked and didn't receive any new email. Kindly check again.
@ElectronicBarta
4 ай бұрын
so difficult.... can you explain easy............. please
@goofylittlebrat
Жыл бұрын
Thank you so much for this! i wanted to ask if it is possible to this with month, i tried with DATETIME_ADD(Date, INTERVAL 1 MONTH) howeever it isnt working :(. Really appreciate if there's a solution for above
@danalyser
Жыл бұрын
You can use MONTH() function instead of YEARWEEK() in the Step #1 if your dataset only contains one year with no repeating months. Or you may use CONCAT(YEAR(date_field),"-", MONTH(date_field)) for the formula. Hope this helps!
@flekysaavedra
Жыл бұрын
@@danalyser Thank you very much for this tutorial! Is kind of weird to have to do al this to have a WoW or MoM growth, but it works. I used this CONCAT(YEAR(date_field),"-", MONTH(date_field)) formula to calculate de MoM but the problem is after that you can´t order ir by month because it recognice only the first digit, so the resulting order is january, october, november, december, february, march, april.... Do you have any clue of how to fix that? Another question is Do you know how to calculate de grow of the week or month compared to the last year? Using Datetime_add 12 MONTH? I really apreciate what you doing. Thank you very much again.
@HungNguyen-990
8 ай бұрын
@@danalyser I'm having the same problem as @flekysaavedra It cannot be arranged by time. Do you have any idea of how to fix that? Many thanks
@JMTibule
5 ай бұрын
@@danalyser Concat will not join the date since it's text. This one should work DATETIME_ADD(Date,Interval 0 Month)
Пікірлер: 47