3 Replies Latest reply on Sep 26, 2018 11:49 PM by Mahfooj Khan

    Using a Code Table - data blending

    Tricia O'Keeffe

      Hi,

       

      Wondering if anyone can help me with this query:

       

      I have tried to used Data Blending to set up a Code Table as a secondary source, but the results I am getting are not what I expect. I have attached spreadsheet to explain simply what I am trying to achieve. If anyone is able to help that would be much appreciated, cheers Tricia O'Keeffe

        • 1. Re: Using a Code Table - data blending
          Mahfooj Khan

          Hi,

           

          Is that what you wanted?

          First connect both the sources and blend with Client ID field

          Now for the first output just drag the fields from Primary source first then Amount from secondary source.

          For the final output you need to create few table calculation and set the data partition based on Client ID

           

          Drag Number of Records and apply running sum to get the total records

          Total amount: WINDOW_SUM(SUM([Secondary].[Amount]))

          Total Avg: WINDOW_AVG(AVG([Secondary].[Amount]))

           

          Drag these fields in canvas

          You need to create one final calculation and filter some unwanted values to get the final output

          Filter: LAST()=0 and compute using Client ID

          Workbook attached for your reference. Let us know if this help.

           

          Note: Edit the aliases of the measure names as per requirement.

           

          Mahfooj