Get counts in time

[johnan]

Hi ,how can i get the sum of counts if a time is more than 20 minutes beetwen the post?
Example:

10:10
10:04
10:10
10:31
10:40
11:01
Here is 2 post that is 20 minutes or more

[Saravanan_Desingh]

Try this.

=Count(Aggr(If(Interval(Time-Above(Time),'mm')>=Time#(20,'mm'),Time),Time))

[johnan]

Hi, thanx 🙂

Got this result: It seems not to be right?

[Kushal_Chawda]

try below. if not post us the expected output

=Count(Aggr(If(Interval(Time-Above(total Time),'mm')>=Time#(20,'mm'),Time,anv.flytt),Time))

[Saravanan_Desingh]

@johnan  My expression should be used in a Text box. Not in a Chart.

Please try it in a Text box and let me know.

[johnan]

Aha, is it possible to get it a chart?

[Saravanan_Desingh]

You can try the expression like.

If(Time-Above(Time)>=Time#(20,'mm'),1)

Dimension is: Time

[Saravanan_Desingh]

Output.

[johnan]

Hi ,here is my result

The Start and Stopp is based on Min and Max (Tid) per User and the tot tid is bases on  (Interval(Stopp-Start,'hh:mm'))

If i just do a simpled table based on user P452 i got this and it's correct:

And the expresssion is:

So i want this to shown in my first table above 🙂

if([Anv. flyttar gods]='P452', If(Tid-Above(Tid)>=Time#(20,'mm'),1))