1 Reply Latest reply on Aug 19, 2016 4:12 AM by John Sobczak

    Fixed function cannot work with WINDOW_MAX function

    Winson Lui

      Hi,

       

      There are 5 campaign types in my dataset.

      There is also a dimension called email name and a measure called total hard bounceback.

       

      Firstly, I would like to find out which campaign type has the largest amount of hardbounce.

      Then, I would like to see only the emails under that campaign which has the highest number of hardbounce and the hardboucne count of each email.

       

      My though is to firstly fix the hardbounce count in the campaign level, then fidn out the max.

      Then drag email name into column.

      However, the (max + if) function only works without any level restriction.

       

      Is there any alternative I can work for my logic approach?

      Thanks.