1 2 Previous Next 15 Replies Latest reply on May 3, 2018 3:25 PM by Okechukwu Ossai

    how to iterate a parameter?  - Is that even the right word?

    John Matyasovsky

      HI All,

      I have an issue

      I am trying to figure out how I can take the parameters on this dashboard and make them iterate out to the current month.

      Here is what I mean.  I have two court cases listed in this dashboard.  I am trying to figure out during what months from (parameters Year and Month) to current date (datetimenow()) these cases were active.  The TDE i am using has the data in rows by case status spans.  For example, Case 01701724 was active from 1-9-2017 to today 5-8-2017.

       

      Matter_ID         CaseStatus    Status FROM Date         Status TO Date  

      701701724    Active              2017-01-09 10:08:00    2017-05-08 09:51:00  

       

      i want to make a dashboard that iterates this out month by month so I get an active count in January, February, March, April, May.

       

      Any Ideas how to do that?

       

      JOhn

        1 2 Previous Next