0 Replies Latest reply: Oct 19, 2016 3:09 AM by Jeroen Aelen RSS

    KPI objects - use other variable in filtering

    Jeroen Aelen

      Hi guys and girls,

       

      In my spreadsheet I have a table which counts per weekday the the average open rate, click rate and the numbers of e-mails sent. Below the table I would like a wall of fame, which should contain the following KPI-items:

       

      - Best weekday in terms of average open rate

      - Best weekday in terms of average click rate

      - Worst weekday in terms of average open rate

      - Worst weekday in terms of average click rate

       

      Could you help me going in coding the formula? I'm stuck for some time now and could really use some help. Thanks in advance!

       

      Jeroen