How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo ?

[shekhar_analyti]

Hi All ,

How to show products with constant improving perceptions , constant degrading perceptions and products which maintained status quo in separate objects ?

products with constant improving perceptions - In one straight table 

products with constant degrading perceptions - Another straight table

products which same perceptions throughout - In a separate straight table

Using the attached data .

Thanks & Regards

Shekar.

[Miguel_Angel_Baeyens]

What happens when one period has two values, how to know which one is the latest one?

At a first glance, you can use the difference between Min() and Max() values for Perception_Coefficient with an If(), and with that get the values you want. Also FirstSortedValue() could help.

Without further elaboration and a closer to real life sample, this is all we can do

[effinty2112]

Hi Shektar,

try these:

Expression:

=if(Max(Aggr(avg(Perception_Coefficient)-Above(avg(Perception_Coefficient)),(Product,text,ascending),(Year,numeric, ascending)))<0,'Y')

Product	products with constant declining perceptions
BAFFLES	Y
CERAMICS
EMP CHIP
EPSILON
FIDGETS
KNEE GUARD
NUTRI DRINK	Y
OXY RICH
ROTOR WIND
SNOW GOGGLES TYPE 2
WIRELESS SET

Expression:

=if(Min(Aggr(avg(Perception_Coefficient)-Above(avg(Perception_Coefficient)),(Product,text,ascending),(Year,numeric,ascending)))>0,'Y')

Product	products with constant improving perceptions
BAFFLES
CERAMICS
EMP CHIP
EPSILON
FIDGETS
KNEE GUARD
NUTRI DRINK
OXY RICH
ROTOR WIND
SNOW GOGGLES TYPE 2	Y
WIRELESS SET

Expression:

=if(Max(fabs(Aggr(avg(Perception_Coefficient)-Above(avg(Perception_Coefficient)),(Product,text,ascending),(Year,numeric,ascending))))=0,'Y')

Product	products with constant perception
BAFFLES
CERAMICS	Y
EMP CHIP
EPSILON	Y
FIDGETS
KNEE GUARD
NUTRI DRINK
OXY RICH	Y
ROTOR WIND
SNOW GOGGLES TYPE 2
WIRELESS SET

cheers

Andrew

[effinty2112]

Hi Shektar,

I should have explained that in considering perceptions I have averaged this out over Regions so I'm considering what you might term global perceptions.

Regards

Andrew

[shekhar_analyti]

Hi Andrew ,

Thanks for reply !!

But expressions are not working .

[Anonymous]

I beleive you need to add the else section.Otherwise, Table will not display all records.

Example: Based on your first expresions:

=if(Max(Aggr(avg(Perception_Coefficient)-Above(avg(Perception_Coefficient)),(Product,text,ascending),(Year,numeric, ascending)))<0,'Y','')

I hope this helps

[effinty2112]

Hi Imad,the expressions shown were copied from functioning straight tables. The tables shown were the results. Believe me the expressions work. Thanks

[shekhar_analyti]

it will be helpful , if you attach qvw with same ..

thank you

shekar

[shekhar_analyti]

imadzidan‌

[shekhar_analyti]

imadzidan           attach qvw