5 Replies Latest reply: Mar 6, 2017 10:40 AM by Dave Melillo RSS

    Evaluate Date Per Row

    Dave Melillo

      The set analysis below successfully calculates UPSELL ARR ($) closed AFTER a campaign date in Salesforce. There is one slight issue - This only works when I have ONE CAMPAIGN selected. When I have multiple campaigns selected, it calculates based on the aggregate campaign start date and I get inaccurate measures.


      count({<[Close Date]={"= [Close Date] > [Campaign Start Date]"}, [Upsell ARR (converted)] = {">0"}>}distinct([Opportunity ID]))


      GOAL: I want to be able to evaluate this expression accurately with several campaigns chosen, so I need this expression to compare ALL close dates vs the specific campaign start date on each row.


      Hopefully this makes sense. Thank you in advance for your help.


      - dave