Calculating average within limits

[tcjwpeeters]

Hi all,

I'm trying to create an overview of our company's average cycletime per area.

sometimes we have unreliable cycles or errors which lead to short or long cycletimes.

I would like to calculate the average cycletime between 50 en 70 seconds, so exclude everything below 50 and above 70.

How should I go about that?

Thanks in advance for your time and advice.

Regards,

Tom

[tm_burgers · Accepted solution]

Do you get cycletime  in the DataSet? 

if so then a set anaylsis would work:

AVG( {< cycletime  ={">=50<=70"}>} cycletime )

if cycletime is calculated in app, then I would suggest scripting this measure into your data set. 

[tcjwpeeters]

Hi tm_burgers,

that worked thanks!

The Cycletime is an output in the dataset.

I thought it should be possible like that somehow but I couldn't get it to work.

Thanks!