I am so sorry I missed the premiere! 😅😅😅 was working on some interesting project 😅😅 sorry for those waiting! Let me know if you have any questions in the comments! ☺️☺️
I have a column formatted as "%d/%m/%Y %H:%m If I use TODATE(Create Date, "%d/%m/%Y %H:%m", "%Y/%m/%d"), the time series charts show a lot of points in the future that don't exist. I tried different solutions but nothing works. Did you ever havve this very EU problem?
Hey there, glad to meet again. I learned about timestamp as a date data type. My question is, if i where to record timestamps of every record entered into the database. Would the sql server generate two identical timestamps given the records where run simultaneously..is that case a hypothetical one or would it happen? Thanks for taking care of this.
hi Danalyser, is it possible to restrict the day only from Monday to Friday? I dont want to put Saturday and Sunday since there wont be any input in the weekends. tks
Hi there! Thanks for the great question! assuming you're using time series chart, you may go to STYLE and change "X-axis" range to "Range by Date Range".
I tried hours in looker studio reports with GA4 the below formula, but it is not working FORMAT_DATETIME("%H:%M", Date) It is returing 00:00 Can any one can help me what it is not working in looker studio with GA4? And why it is returing 00:00
Hey Danalyser, could you please demo, how can I show date time which changes continuously in dashboard and not only page is refreshed in data studio? I've already gone through below video of your but it changes time only when page is refreshed. th-cam.com/video/NGdUPKjMei0/w-d-xo.html
Thank you so much for the time you spend making this video you saved me :D
Gracias!
I am so sorry I missed the premiere! 😅😅😅 was working on some interesting project 😅😅 sorry for those waiting! Let me know if you have any questions in the comments! ☺️☺️
Estaba buscando esto! Muchisimas gracias, te ganaste un suscriptor
Thank you for this!
You're so welcome! :)
I have a column formatted as "%d/%m/%Y %H:%m
If I use TODATE(Create Date, "%d/%m/%Y %H:%m", "%Y/%m/%d"), the time series charts show a lot of points in the future that don't exist. I tried different solutions but nothing works. Did you ever havve this very EU problem?
me sirvio gracias
Hi Danalyser, can you show me how to break the time per 30 minutes. it will help thanks
Hey there, glad to meet again.
I learned about timestamp as a date data type.
My question is, if i where to record timestamps of every record entered into the database. Would the sql server generate two identical timestamps given the records where run simultaneously..is that case a hypothetical one or would it happen?
Thanks for taking care of this.
Hi Hasan, nice to meet you! Yes, logically this would happen. Usually database would have a auto-generated ID to make sure each records is unique. :)
awsome thanks!!!!!!
Hi Danalyser, can you create a tutorial in making side by side bar chart of current week and previous week?
Hey 👋 thanks for the suggestions! I’ll consider it for future content ! :)
good day, is there a way for us to convert isoweek to weekdate starting monday.
the result will be String. Any way to create the result to be datetime?
hi Danalyser, is it possible to restrict the day only from Monday to Friday? I dont want to put Saturday and Sunday since there wont be any input in the weekends. tks
Hi there! Thanks for the great question! assuming you're using time series chart, you may go to STYLE and change "X-axis" range to "Range by Date Range".
danalyser how to put month in short name?
I tried hours in looker studio reports with GA4 the below formula, but it is not working
FORMAT_DATETIME("%H:%M", Date)
It is returing 00:00
Can any one can help me what it is not working in looker studio with GA4?
And why it is returing 00:00
i have the same problem
Hey Danalyser, could you please demo, how can I show date time which changes continuously in dashboard and not only page is refreshed in data studio? I've already gone through below video of your but it changes time only when page is refreshed.
th-cam.com/video/NGdUPKjMei0/w-d-xo.html