6 Replies Latest reply: Feb 11, 2016 4:08 AM by Kumar Pramod RSS

    Table Creation

    Kumar Pramod

      Hi all,

      jagan

       

      I need to create a table with 3 different header rows. as in the attached image. can any one help on this.

       

      table.png

       

      How can i use inline load to load the above values as dimensions?

       

      Regards,

      Pramod

        • Re: Table Creation
          jagan mohan rao appala

          Hi,

           

          Can you explain what you want?  3 different header rows means?  Attach some sample file.

           

          Regards,

          Jagan.

            • Re: Table Creation
              Kumar Pramod

              In the attached image you can see the headers i need a header like that.

               

              1st Row --          Existing                                   New

              2nd Row--  Count          Rates                Count          Rates

              3rd Row -- values..................................................................

               

              The fields in 1st row and 2nd row is names we don't have any fields with that name.

            • Re: Table Creation
              Deepak Tibhe

              Hi,

               

              In short you need to create 3 different tables based on ranges you have specified.

               

               

              Please provide more  details.

               

               

              Thanks

                • Re: Table Creation
                  Kumar Pramod

                  currently i have a table like below:

                  table1.png

                  In Header i have 25 Existing Count has name instead, I need to display like below

                   

                  table - Copy.png

                   

                  For the table i am using dimension as "Metrics" which is loaded using inline:

                   

                  LOAD * INLINE [ 

                        Metrics 

                      List Size

                      Emails Delivered (total)

                      Unique Opens (total)

                      Landing Page Hits

                      Sign Ups

                      Final Test Passed (Completed)

                  ];

                   

                   

                  Measure for column 25 Existing Count:

                   

                  IF(match(Metrics, 'List Size'),only({$<email_type_id ={'44'}, campaign_group_id={'2'},batch_meta_data_id={'23'},

                  expiration_date = {"$(=date(max({$<batch_meta_data_id={23}>}expiration_date)-7))"}>}delivered),

                  IF(match(Metrics, 'Emails Delivered (total)'), sum({$< expiration_date = {"$(=date(max({$<batch_meta_data_id={23}>}expiration_date)-7))"},batch_meta_data_id={'23'},campaign_group_id={'2'}>}delivered),

                  IF(match(Metrics, 'Unique Opens (total)'), sum({$< expiration_date = {"$(=date(max({$<batch_meta_data_id={23}>}expiration_date)-7))"},batch_meta_data_id={'23'},campaign_group_id={'2'}>}opened),

                  IF(match(Metrics, 'Landing Page Hits'),only({$<email_type_id ={'44'}, campaign_group_id={'2'},batch_meta_data_id={'23'},expiration_date = {"$(=date(max({$<batch_meta_data_id={23}>}expiration_date)-7))"}>}landing_page_hits),

                  IF(match(Metrics, 'Sign Ups'), only({$<email_type_id ={'44'}, campaign_group_id={'2'},batch_meta_data_id={'23'},

                  expiration_date = {"$(=date(max({$<batch_meta_data_id={23}>}expiration_date)-7))"}>}sign_up),

                  IF(match(Metrics, 'Final Test Passed (Completed)'),  only({$<email_type_id ={'44'}, campaign_group_id={'2'},batch_meta_data_id={'23'},expiration_date = {"$(=date(max({$<batch_meta_data_id={23}>}expiration_date)-7))"}>}completions)))))))