5 Replies Latest reply: Nov 26, 2013 5:16 AM by Thomas Jensen RSS

    Set Analysis, Bookmarks and Alerts

      Hi,

      I'm trying to create a sales drop alert that also show which merchants experienced the sales drop. I'm able to create a simple alert using this expression:

      =Sum(Aggr(If(Sum(Sales)>1, 1), Merchant)) > 0

      However, this won't allow me to display the merchant with the sales drop in the alert. What I need to do is create a bookmark that selects merchants whose sales are below a certain level, for instance:

      Sum(Sales)<90

      Then I can create an alert with the condition along with a display message to show the affected merchants:

      =Count(Merchant) > 0

      My question is: how do I save a bookmark for this expression: Sum(Sales)<90?

      I've attached a sample doc I've been working out of. Any help would be greatly appreciated.

      Best,

      Matt