Table Creation

[#1]

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.

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

Regards,

Pramod

[jagan]

Hi,

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

Regards,

Jagan.

[#3]

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.

[deepakqlikview_123]

Hi,

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

Please provide more  details.

Thanks

[#5]

currently i have a table like below:

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

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)))))))

[jagan]

Hi,

Attach sample file so that it would be easier to provide solution.  Is it possible to derive those fields as dimensions in script?

Regards,

Jagan.

[#7]

As working on server don't have sample.

I need to create a table with headers and sub headers.

ex: "Existing"  is an header under header tab i need to add sub headers "count" and "Rates".

For these columns i need to apply the measures.