calls ring less than 1min

Hi ayoubb,

Create a calculated column that will act as flag for identifying if time is under 1 minute and then take a count of this new calculated column with filter on flag.

Achieve the below:

In the above:

1. Make sure your Ring duration column is having 'Time' datatype

2. Ring_Time_Flag = Calculated column to identify if duration is less than 1 minute; If duration < 1 minute, then flag=1, else flag=0

3. Take the count of column created in step 2 and Filter on flag = 1 to get desired count

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query  !!!