2 Replies Latest reply: Feb 23, 2012 9:19 AM by jonahall RSS

    Create new variable in load script with OR

      We have 4 clients, that can be happy by nature or not:

       

      Client IDHappy client
      11
      20
      31
      41

       

      These clients come and leave the service desk of our company as follows:

      (We LEFT JOINed the happiness onto the table).

       

      TimeClient IDHappy client
      1

      1

      1
      2--
      320
      420
      431
      520
      530
      541
      631
      641

       

      If one client is happy, the company has a good time.

       

      TimeGood time
      11
      20
      30
      41
      50
      61

       

      Now, how do I create the "Good time" field in the load script? If it were just in a table chart, we could use "if(sum(Happy_client>0,1))" as expression. But this does not work in the script. How can we do it? (Basically, it's an OR expression over all "Happy_client" at a "Time").

       

      Cheers,

      Jonas