I hope everyone is well and that you are taking care of your loved ones.
I don't have access to the Analytics extension and I would like to be able to increment a list.
I would like to have a list of the hours [Xo,X1,X2,X3,...,X23] where the values are 0 and that we increment by 1 when the value is between our two dates.
Here is an Example (also in the XLSX file):
We have date (start datetime = 02.02.2021 06:00:00 and end datetime = 02.02.2021 12:00:00)
The values of X6, X7, X8, ..., X12 are 1 and the others are 0.
If we add a second date, it is possible to take this list and increment it again.
Ideally, this would allow us to have a temporal distribution (regardless of the difference between the hours), similar to a heat map.
Thank you in advance for your help.
Hi, Fabien
Please find my solution attached as well as below screenshot of steps
1st, join your data to a calendar time table
2nd, build a calculation and set it as running sum table donw as shown below
Hope this helps
ZZ