Former Member

### Request for help with a "Max()" related problem...

Hi all, thanks in advance for spanding time on reading my question!

I am trying to calculate a "max" value for a list of data in WebI however I can't figure out the right combination of Max() with either ForEach or In... I've tried many different combinations but never get what I'm looking for...

This is a heavily simplified example of the data I'm working with:

So, I'm looking to get 1 value (max of 'Duration') for each 'Parent Ticket'...

Thank you very much in advance!

Bernard.

webi-question.jpg (52.7 kB)
10|10000 characters needed characters exceeded

• May 02, 2017 at 06:21 AM

try this.

=max(duration) in (parent ticket)

Makesure your duration object data type should be number.

10|10000 characters needed characters exceeded
• Former Member

And just one more question :-)

If I remove "CHILD TICKET" from the block, the overall result changes because of the missing dimension...

How could I still calculate the same value but by referencing the 'CHILD TICKET' dimension directly in my formula?

Thanks

• May 02, 2017 at 05:45 PM

use Foreach.

=max(duration) foreach( child ticket) in (parent ticket)

10|10000 characters needed characters exceeded
• Former Member

Hi Amit,

with your suggestion, I get the same result as my "duration" result

• Former Member
May 02, 2017 at 05:54 PM

Please ignore my previous comments... It doesn't work...

I get a "172.4" everywhere

I don't understand why - this was the behavior I've seen earlier and why I raised the question here...

Now, I got it to work because (in one of my previous trials) I had created an intermediate column between DURATION and MAX DURATION and added a 'runningmax'.

With the following formula: runningmax(duration;(parent ticket)) in the RUNNINGMAX column, I get:

I'm already happy that it works but I would like to understand why I need that intermediate step...

Any ideas?

10|10000 characters needed characters exceeded
• Former Member

I made a small mistake in my last sample sheet:

the last 2 numbers in Duration should be "8.43333333"

Like this:

• May 03, 2017 at 09:15 AM

Hello Bernard

What happens if you try this:

=Max([Duration] In ([parent ticket]))

Regards

Antonette