sarahi6

The connector is CallRail @MichelleH. Above is the duration set up. Currently I have it updating through yesterday's date.

in How do I set up the append option for updating data correctly? Comment by sarahi6 May 2023

in how to the find difference between dates ( in days ) that are in one column? Comment by sarahi6 December 2022

@RobSomers , did I set this up right? I clicked the link you provided but I am having a hard time understanding what I should put as my preceding and following values. thanks!

in Avg. Time between purchase orders Comment by sarahi6 August 2022

@RobSomers Yes, I want each and average time between purchases for all customers. Will I keep the group by function that I listed above, and then add the rank & window?

in Avg. Time between purchase orders Comment by sarahi6 August 2022

Yes @mhouston , I do want to find the average time between purchases. After changing the group by set up - I did notice that the value for the new 'avg. time between purchase' is returning the same value as the original 'time between purchase' column.

in Avg. Time between purchase orders Comment by sarahi6 August 2022

Sure @MichelleH ! Here is how I set up the group by function

in Avg. Time between purchase orders Comment by sarahi6 August 2022

sarahi6 Member

Comments