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

    Using a Code Table - data blending

    Tricia O'Keeffe



      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



          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.



          • 2. Re: Using a Code Table - data blending
            Tricia O'Keeffe

            Hi Mahfooj,

            Thank you so much for taking the time to help me out with this problem. This is exactly what I needed and have spent today successfully incorporating into my workbook.

            I have learnt alot today so thank you! I work for a regional hospital and this piece of work will help us understand our patients better.

            many thanks Tricia

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

              Thanks for your kind words Tricia! Much appreciated such compliments really encourage me to help you guys! Have a good day ahead.