2 Replies Latest reply: Feb 22, 2017 11:08 AM by Erick Dameron RSS

    Count number of services between 30, and 60 days old.

    Erick Dameron

      HI All,


      Let me thank you all in advance on this. I appreciate any help you can provide.


      I am working with chart expressions and not in the data load editor.


      I need to count the number of services that occurred between 152-182 days ago and am having some trouble.


      Since chart expressions do not allow nested expressions, I am unsure how to solve this.


      What I am trying right now is this:


      SUM({$<visittype={"Strengths and Needs"}>}if((today()-visit_day>152,1,0)

      This gives me a count of everything that is greater than 152 days old but I need to stop counting everything that is 182 days or older for this KPI.