0 Replies Latest reply: Jan 13, 2014 4:28 AM by Byron Van Wyk RSS

    Set Analysis - String Search

    Byron Van Wyk

      Hi All,

       

      I am having great difficulty figuring this one out. My table has 2 fields

       

      Date,

      CLI, {Caller Line Identity}

       

      If I select the 5th of this month, I want to count all calls on the 1st where the CLI appears in both the 5th and the 1st. I want to be able to write this using a chart with a synthetic dimension i.e.

       

      Dimension - Valuelist('FCR','Non-FCR')

      Expression - Pick(Match(Valuelist('FCR','Non-FCR'),'FCR','Non-FCR'),count(DISTINCT {<Call={"$(=Concat(DISTINCT {<Date={'$(=Date(Max(Date)-4))'}>}Call,','))")}>}Call),the opposite of the FCR query)

       

      I tried using the implicit set analysis as so count(DISTINCT Call = p(1<Date={'$(=Date(Max(Date)-4))'}<})Call) but this did not work either.

       

      Please this is urgent, hope you guys and gals can sort me out

       

       

      Cheers,

      Byron