Conditional expression- 2 ifs and aggr

Sun, 02 Nov 2014 08:30:59 GMT

Hi Community,

I've been struggling with this for quit some time now and I can really use your help..

I need to perform the following calculation that is based on several ifs and functions.

The granularity of the data is by AspectId and ReviewId and I need to return the AspectName id the bottom 2 conditions apply.

1- If the below calculation is smaller than 0.5 than continue to calculation #2

Aggr(

(Sum( Aggr( max( {<PostQuarter= {'20143'}>} Sentiment),AspectId, ReviewId) )

/Count( Aggr( Count(distinct {<PostQuarter= {'20143'}>} AspectId) ,AspectId ,ReviewId) ))

,[Aspect Name])<0.5

2- Return the AspectName when Rank = 1

rank( Aggr( Count( Aggr(Count(distinct {<PostQuarter= {'20143'}>} AspectId) ,AspectId ,ReviewId) ),[Aspect Name]))=1,[Aspect Name])

Thanks for your help!

-Hila.

Re: Conditional expression- 2 ifs and aggr

MK_QSL — Sun, 02 Nov 2014 10:34:55 GMT

Can you provide some sample data please to work?