Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you provide some sample data please to work?