date time
2 Topics
Date Calculation is blank if one of the dates blank
I am getting a "Expressions that yeild variant data-type cannot be used to define calculated columns" error" if I change the 0 to "". I know this is simple but need help. I have the below calculated column. Days btw dates = if(ISBLANK(DATE1,0, if(ISBLANK(DATE2),0,NETWORKDAYS(DATE1,DATE2))) Right now it is displaying 0 if the DATE1 or DATE2 is blank. I want it to display "" or nothing if one or both of the dates are missing. Can someone help me tweak this calculated column to do so if one of the dates or both are blank?Solved1.3KViews0likes3Comments
Average answer time for chat messages
Hi, i want to find average answer time for a spesific group. Receivers may be change, i should examine all conversations seperately. Table is like that: sender_id receiver_id date-hour spesific_group 2 1 01.01.2022 09:00 No 1 2 01.01.2022 09.10 Yes 1 3 02.01.2022 10:00 Yes 3 1 02.01.2022 13.00 No 1 3 02.01.2022 13.30 Yes 5 6 02.02.2022 15.00 Yes 6 5 02.02.2022 15.30 No 5 6 02.02.2022 15.40 Yes for ex, sender 1's average answer time is 10 minutes from the conversation with 2 and 30 minutes from the conversation with 3. It means that average answer time for 1 is 20 minutes. And for number 5, average time is 10 minutes. I hope I have been able to explain, thank you If it's too complicated I'm open for another approximate solutionsSolved837Views0likes1Comment