Hello, thank you for the great video! I need to display the name of the previous month, but couldn't come up with the right formula... :( Tried so many times... Can you help, please?
Hi Dana I want to ask that if I can show the today's count data for the all viewer's so they can see the daily performance like day by day the count & numbers
Hi there, yes you can add a date range filter and set the default to "Today" then the performance metrics would be 1-day rolling report. I've covered this topic in one of the chapter of my course: th-cam.com/video/_P-3TbBGNXA/w-d-xo.html Feel free to take a look :)
I would like to apply two advanced date ranges or time series: -TIME - TODAY and - last 7 DAYS; without using the Default date range of the GDS but the calculated fields, applied to the same graph and using the same metric for both, eg 'uniquescreenview'. Could you show practical examples of how to do it and which functions and formulas are correct?
@@danalyser Because I need to apply time as a dimension and then apply it to a calculated field, in this case, current hourly conversion rate and another conversion rate from 7 days ago. On the same graph but on different Y-axis.
good, how can I count the max values of 1 day to a constant value, but in the datetime column the records are every 15 min, and I need to count by year... for example 1/1/22 00:15 38 1/1/22 00:30 39.2 ...... 1/1/22 01:45 39.3 1/1/22 00:15 38 1/1/22 00:30 39.2 ...... 2/1/22 01:45 38 2/1/22 00:15 37.5 2/1/22 00:30 38.5 ...... 1/31/22 23:45 25 1/1/22 = max = 39.3 2/1/22 = max = 38.5 ....... account x month === 2 but if I take those values where 39 is greater, there are more values because it takes all the values and not the max How could this calculation be done in a field?
Hey Paromita, not quite sure about that as I have no idea on how you track your monthly budget (i.e. the data structure) . Do provide more info so I can provide any help if I could.
@@danalyser Hey, thanks for replying so soon. So I have a budget tracker which needs to have the cost for the number of days that have passed in the month (for example: 1st - 11th July) and cost for 11th July. Can I have that in one table?
![ประสบการณ์ จ้าง Developer ที่ผมจะไม่มีวันลืม [ภาค1]](http://i.ytimg.com/vi/bzivN4KDg-k/mqdefault.jpg)
Heloo all! Do you think I can stick to this video format in my future videos? Please help me out by voting my recent poll! THANK YOU ⭐️
For more resources on date topics, do check out the video description for all the quick links! :)
Good sharing..
Thank youuu! ❤️❤️
Thank you for this video. Definitely helped me out.
Hello, thank you for the great video! I need to display the name of the previous month, but couldn't come up with the right formula... :( Tried so many times... Can you help, please?
Let me check and I’ll get back to you when I have the formula ready!
Hi Dana
I want to ask that if I can show the today's count data for the all viewer's so they can see the daily performance
like day by day the count & numbers
Hi there, yes you can add a date range filter and set the default to "Today" then the performance metrics would be 1-day rolling report. I've covered this topic in one of the chapter of my course: th-cam.com/video/_P-3TbBGNXA/w-d-xo.html
Feel free to take a look :)
how to conditional formatting for date to get today, this week or this month by using colour
I would like to apply two advanced date ranges or time series:
-TIME - TODAY
and
- last 7 DAYS; without using the Default date range of the GDS but the calculated fields, applied to the same graph and using the same metric for both, eg 'uniquescreenview'.
Could you show practical examples of how to do it and which functions and formulas are correct?
Hey elen 👋 thanks for the comment! Mind explaining why the default option is not applicable for your use case ? :) thanks!
@@danalyser Because I need to apply time as a dimension and then apply it to a calculated field, in this case, current hourly conversion rate and another conversion rate from 7 days ago. On the same graph but on different Y-axis.
🔥
🙌🏻🙌🏻🙌🏻
good, how can I count the max values of 1 day to a constant value, but in the datetime column the records are every 15 min, and I need to count by year... for example
1/1/22 00:15 38
1/1/22 00:30 39.2
......
1/1/22 01:45 39.3
1/1/22 00:15 38
1/1/22 00:30 39.2
......
2/1/22 01:45 38
2/1/22 00:15 37.5
2/1/22 00:30 38.5
......
1/31/22 23:45 25
1/1/22 = max = 39.3
2/1/22 = max = 38.5
.......
account x month === 2
but if I take those values where 39 is greater, there are more values because it takes all the values and not the max
How could this calculation be done in a field?
Hi Luis, you meant ""count by day" ? You can set the aggregation method to "MAX" instead of using the filter shown in the video :)
@@danalyser It worked, thank you very much, surely later I will consult you again, thank you very much again
@@luiscardozo1419 you’re welcome! 🤍
How can I add yesterday cost in a monthly budget pacing tracker?
Hey Paromita, not quite sure about that as I have no idea on how you track your monthly budget (i.e. the data structure) . Do provide more info so I can provide any help if I could.
@@danalyser Hey, thanks for replying so soon. So I have a budget tracker which needs to have the cost for the number of days that have passed in the month (for example: 1st - 11th July) and cost for 11th July. Can I have that in one table?
@@paromitaraychoudhury9443 yes, you can have the running sum in one column and the cost for that day itself in another column.
how to show tomorrow date?
You may use datetime_add formula :)