Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have created a table which displays the stats of 30 days, 7 days etc...
In the above pic, 30/60 days variance is dependent on 3rd and 4th column. I am using the below expression:
Num(if(Metrics='Invitations',((count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-30))<=$(=date(Max(CanonicalDate)))"}, DateType= {'invitation'},
client_id= {'20'}>} invitation_id))
-
(count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'invitation'},
client_id= {'20'}>} invitation_id)))
/
(count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'invitation'},
client_id= {'20'}>} invitation_id)),
if(Metrics='Landing Page Hits',((count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-30))<=$(=date(Max(CanonicalDate)))"}, DateType= {'accessed'},
client_id= {'20'}>} invitation_id))
-
(count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'accessed'},
client_id= {'20'}>} invitation_id)))
/
(count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'accessed'},
client_id= {'20'}>} invitation_id))
Now i need to display 100% in the last column if the 3rd column value is zero.
How can i achieve this?
Regards,
Pramod
Wrap an alt() around the expression: alt( ...your_expression_here... , 1)
Wrap an alt() around the expression: alt( ...your_expression_here... , 1)
Is what i am doing is correct?
Num(if(Metrics='Invitations',alt(((count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-30))<=$(=date(Max(CanonicalDate)))"}, DateType= {'invitation'},
client_id= {'20'}>} invitation_id))
-
(count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'invitation'},
client_id= {'20'}>} invitation_id)))
/
(count({$<CanonicalDate={">$(=date(Max(CanonicalDate)-60))<=$(=date(Max(CanonicalDate)-30))"}, DateType= {'invitation'},
client_id= {'20'}>} invitation_id)),1)
I need to use alt for each expression right?
Thanks It worked fine...