Skip to main content

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.

3 answers
  1. Feb 2, 2021, 1:07 PM

    Hi, Fabien

    Please find my solution attached as well as below screenshot of steps

    1st, join your data to a calendar time table

    Hi, FabienPlease find my solution attached as well as below screenshot of steps1st, join your data to a calendar time table2nd, build a calculation and set it as running sum table donw as shown belowH2nd, build a calculation and set it as running sum table donw as shown below2021020204Hope this helps

    ZZ

0/9000