Skip to Content
avatar image
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'...

Could anybody on this community please help me out?

Thank you very much in advance!

Bernard.

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

  • Get RSS Feed

4 Answers

  • May 02, 2017 at 06:21 AM

    try this.

    =max(duration) in (parent ticket)

    Makesure your duration object data type should be number.

    Add comment
    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)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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?

    Add comment
    10|10000 characters needed characters exceeded

  • May 03, 2017 at 09:15 AM

    Hello Bernard

    What happens if you try this:

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

    Regards

    Antonette

    Add comment
    10|10000 characters needed characters exceeded