thomasreick
Resolver I

how to... Create Measure to identify "direction" of development ofranking from two periods

‎10-13-2022 07:08 AM

Hello there,

I would like to create a measure to indicate the development of rankings per item from two periods (RankActual=a, RankPrevious=p). Because both values might be <0 or > 0 or = 0, I need a hint how to handle that in a smart way.

 

My approach seems not good. I did some IF-THEN-ELSE-syntax but the resulting indicator -1 | 0 | +1 is not set correctly

IF ( AND( a<0, p<0 ), a | < | = | > p ) is varying the relations only, but anyway there is a positive development indicated, although not positive logically...

 

Example: a=-6, p=-4 leads to a < p the delta is (a-p) = -2, the movement is 2 points DOWN., but it is shown as upward-movement.

 

Actually I am stuck on this and kindly request your input.

 

thank you very much

Thomas

 

 

Labels:
367 Views
0
Anonymous
Not applicable

‎10-13-2022 07:18 AM

Hi,

 

In this case use abs(a)-abs(p) it should give +2

358 Views
0
v-yinliw-msft
Community Support

‎10-14-2022 02:29 AM

Hi thomasreick ,

 

I think you want if a < p, it should be down and if a > = p, it should be up?

May be you can try: IF( a < p, p - a, a - p)

What do you mean "it is shown as upward-movement"?

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

309 Views
0
thomasreick
Resolver I
In response to v-yinliw-msft

‎10-14-2022 03:12 AM
Hello v-yinliw-msft,
thx for your input. I will give it a try.
Upward movement means, that I want to indicate for readability the direction of development with a unichar-character to show the direction also for negative ranks.
According to above example a=-6, p=-4 is a negative development of -2, the direction should be indictated with unichar(11167), an arrow pointing down in a separate field
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
300 Views
0