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.

       

       

      Thoughts?

       

      Best,

       

      Erick