3 Replies Latest reply on Dec 15, 2016 4:59 PM by Kristian Wilson

    Calculating 'new' campaigns within a table-

    Kristian Wilson

      Hello,

       

      I have an table which is refreshed daily from ingested partner reporting which includes:

      date

      value

      name of campaign

       

      I'd like to be able to create a calculation where I'm able to highlight 'new' campaigns, or values that were previously 0 or Null as well as highlight campaigns that have stopped. The output I'm looking to create is a dashboard with data table as well as a list of highlighted 'new campaigns' and 'stopped campaigns' for the month, or week or previous day. I've tried to use a table calculation like this:

       

      if ZN(([Agency Spend]))>0 and LOOKUP(ZN(([Agency Spend])), -1)=0 then "New" else "old" END

       

      This works most of the time, but only then allows me to use the color to highlight the table. Ideally, I'd like to output a list of the campaign names which are 'new' as well as campaigns that have 'stopped' (meaning the spend value has gone back to 0 or null.

       

      I've added a screen shot here: Apologies that I'm not able to upload a packaged workbook. Any advice would be appreciated!

       

      Screen Shot 2016-09-14 at 4.03.08 PM.png