Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Gurus,
Can you please help me this, I've shucked here.
I created one variable like below
eLoadFactor = (Sum ([# Transported Passengers]) / Sum ([# Available Seats]))
Now, I want to create interaction match with the field of "Carrier Name". Please help me
Especially Sunny, Suehl and Gysbert or any thing else.
Try This, Sunny does this metric is correct? I am not sure if that helps to Deepa Agarwal. Try Luck
=Aggr(Class($(eLoadFactor) * 100 ,10), [Carrier Name], '<= x <', ' - ')
OR
=Replace(Aggr(Class($(eLoadFactor) * 100 ,10), [Carrier Name]), '<= x <', ' - ')
OR
=Replace(Aggr(Class('$(eLoadFactor)' * 100 ,10), [Carrier Name]), '<= x <', ' - ')
Interaction match? Do you mean Interval Match or something else? Would you be able to share a sample to demonstrate what you are trying to do?
Hi,
Please share some sample data and output you are expecting. that will help us to provide the soultion
Hi,
Please, add your qvw file or other, so we can see what you want to do.
Deepa Agarwal,
I've read few months back about interaction match. Does it related to Bucket like 0-10, 0-20, 0-30 .....
Can you please elaborate more?
Sunny, Might be i am not the good exaplainer. Might be this best way to approach i've tried this
Aggr(If($(eLoadFactor) <20,'0-20', If($(eLoadFactor) >20 and <40 ,'21-39', If($(eLoadFactor) >=40 and <60,'40-59', >= 59,'59-100', [Carrier Name])
Anil - you are correct
Krishnapriya & Filip, This is not possible because i am working for secured project. If i released sample data might be stakeholder will frustation on me. I know how to scramble data. In fact, i don't want to take risk. For ref, please follow the above expression
So you above provided expression worked for you?
Hi Deepa,
You Can you Class function to create Buckets.
class(aggr(eLoadFactor,[Carrier Name]),10,'X')
Instead of trying in expression, Create your 'interaction match' or Bucket in the script, in this way you don't complicate your expression and its easy to handle.
Deepa Agarwal,
I've taken Nitin Expression. Try this too
=Aggr(Class($(eLoadFactor),10), [Carrier Name], '<= x <', ' - ')