5 Replies Latest reply: Jan 26, 2012 11:30 AM by esepulveda RSS

    Nested Set Analysis question

      Hi I was debuging an issue with some set analysis and found out that when I use fields on inner expressions QV does not like it, here is an example, SLA is a field and QV does not figures it out when I use is like the following:

       

      Count
      (
        {$< 
          IsAbandon         ={0},
          ContactIDSkillNo  ={"=Sum({$<test={1}>}Duration) < (SLA*1000)"}

        >}
      DISTINCT ContactID
      )

       

       

      But when I use a straight number, it works:

      Count
      (
        {$< 
          IsAbandon         ={0},
          ContactIDSkillNo  ={"=Sum({$<test={1}>}Duration) < (30*1000)"}

        >}
      DISTINCT ContactID
      )


       

      I tried to replace the expression with:

       

      $=(SLA)

      max({}SLA)

      num(SLA)

       

      Any idea on how can I use a field inside the string so it can work?

       

       

      Thanks in advande for you time.

       

      -ed

        • Nested Set Analysis question
          Stefan Wühl

          Does your field SLA only have one single value?

           

          The set expression is only evaluated once, not per record / dimension value (if you use the set expression in a chart),  so if SLA is ambiguous, QV won't know which value to put in.

            • Nested Set Analysis question

              Thanks for the help swuehl, SLA has multiple values, but since I am using it inside a Pivot table chart, I asumed that each one of the subgroups will only evaluate its own subset of data, and then the value in SLA field would be unique, for example:

               

              If the hierarchy that the pivot tale is the following:

               

              Dimension1     Expression1

              Customer         Count(....)

               

              Then I was expecting that the Dimension1 will spilt the data and when Expression1 will execute against the subset of data, since SLA as a 1 to 1 relation with Customer then the value for SLA when evaluated will be unique.

               

              That's why I dont know why its not working.

               

              -ed

                • Nested Set Analysis question
                  Stefan Wühl

                  Try something like:

                   

                  Count
                  (
                    {$< 
                      IsAbandon         ={0},
                      ContactIDSkillNo  ={$(=concat(aggr(if(Sum({$<test={1}>}Duration) < (SLA*1000),ContactIDSkillNo),Customer),','))}

                    >}
                  DISTINCT ContactID
                  )

                   

                  Not sure if this is better performing than not using a set analysis, i.e. traditional record based comparison (probably also using aggr() ) instead. I hope I haven't forgot a bracket or so, please check.

                   

                  --Stefan


              • Nested Set Analysis question
                Richard Pressanti

                If the field SLA has only one value for each value of the dimension, you could perhaps try Only(SLA) instead of SLA .