0 Replies Latest reply: Aug 8, 2016 12:54 PM by Supriya R RSS

    Load Inline:How to show only required row from Inline Table

    Supriya R

      Hi,

       

      i am Loading inline function as shown below

       

       

      MetricsDimsMTD:

      LOAD * INLINE [ 

            MetricsMTDRevenue 

          Invitations

          Landing Page Hits

          Sign-Ups

          Partial Completions

          Completions

          Completions Rate

          Revenue

      ];

       

       

      code in front end is:

      I am using Dimension : MetricsMTDRevenue 

      Expression:

       

      Num(if(MetricsMTDRevenue ='Invitations',Count({$<DateType = {invitation},client_id={'1'}>}invitation_id),

      if(MetricsMTDRevenue='Landing Page Hits',count({$<DateType = {accessed},client_id={'1'}>}invitation_id),

      if(MetricsMTDRevenue='Sign-Ups',sum({$<DateType = {signed},client_id={'1'}>}user_signed),

      if(MetricsMTDRevenue='Partial Completions',(sum({$<DateType = {signed},client_id={'1'}>}user_signed)-sum({$< DateType = {completion},client_id={'1'},final_test_status={'passed'}>}course_completed)),

      if(MetricsMTDRevenue='Completions',sum({$< DateType = {completion},client_id={'1'},final_test_status={'passed'}>}course_completed)

      ))))),if(MetricsMTDRevenue='Completions Rate','#,##0.0%', '#,##0'))

       

      If i use above code it shows  Completions Rate and  Revenue  rows with empty data(or no data in that row).I want those rows to be hided or not shown. I need to show rows whatever the rows name i mention in expression.

       

      How to do this.?