1 Reply Latest reply: Apr 27, 2017 9:14 PM by John Cavoulas RSS

    Move calculations from expressions to the load script

    Jose de la Cruz

      I need some help to move 13 calculations from a pivot expressions to the load script and to create the 14th calculation that will add the results of previous 12. The formulas works with previous loaded fields and will then be used to create visualizations. I'm attaching some dummy data as reference. Any suggestions will be greatly appreciated.

        • Re: Move calculations from expressions to the load script
          John Cavoulas

          Hard to say but it looks like you might just take each expression, such as AA below,

           

          =IF(

          IsNull([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]), '',

            IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Meets', 14,

            IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Missed', 0,

            IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='NA',''))))

           

          and place it into the script in a preceding load statement to your table and give it a field name, one for each expression, a la;

           

          IF(

          IsNull([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]), '',

            IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Meets', 14,

            IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='Missed', 0,

            IF([calls - Identifies Reason for Call/Clarifies and Probes (Weight 14pts) *]='NA','')))) as AA

           

          Then, in a preceding preceding load add the new fields together, a la;

           

          AA + Ab + AC... as Combined

           

          I would start this way.