Percentage in visible series selection

Stephanus Adisuprijanto shared this question 5 years ago
Answered

Can someone explain it to me how Yellowfin calculate the percentage number displayed when we activate the visible series selection?

I notice that it also changes whenever date slider is updated by users.0fc2dc38a55fc49a79d79d86048c58e5

Replies (2)

photo
1

Hi Stephanus,


let x = first metric in time frame indicated by the date slider

let y = last metric in time frame indicated by the date slider

then the formula is as follows:


( ( y - x ) / x ) * 100


regards,

David

photo
1

Hi David,

Can you explain to me what you meant by first metric and last metric?

Is the value of the first day/week/month/quarter/year (whatever time unit we chose) the first metric and the value of the last day/week/month/quarter/year (whatever time unit we chose) the last metric?

photo
photo
2

Hi Stephanus,

sorry, I should have said "value" instead.

Here is an example:

/AAAAAElFTkSuQmCCAA==


thus for the Passengernum series it is:

( ( 2 - 4 ) / 4 ) * 100

= ( -2 / 4 ) * 100

= -0.5 * 100

= -50%


regards,

David

photo
1

OK got it thanks David.

Regards

Stephanus

photo
Leave a Comment
 
Attach a file