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.?