Forum Discussion
Solved
Duration Troubles
Hey, I'm trying to calculate and filter duration colum, My formula is: CALCULATE(COUNTA(CTI[end type]), FILTER(CTI,CTI[end type]="ABANDON"),FILTER(CTI,CTI[wait time]<"00:00:15")) There is ...
solution:
CALCULATE(COUNTA(CTI[end type]), FILTER(CTI,CTI[end type]="ABANDON"),FILTER(CTI,SECOND(CTI[wait time])+MINUTE(CTI[wait time])*60>15))
solution:
CALCULATE(COUNTA(CTI[end type]), FILTER(CTI,CTI[end type]="ABANDON"),FILTER(CTI,SECOND(CTI[wait time])+MINUTE(CTI[wait time])*60>15))