Trend Icon

[Former Member]

How can you tell if you trend is going up or down?

I want to use the trend icon to show up,down neutral.

What output can i use to pass to the trend icon.

Is there an equation to use?

Thanks

Jamie Lill

[Former Member]

Hi all,

I know how to use the trend icon.

What I need to know is how to tell if the trend line is going in the positive direction e.g. 3 degrees

If it is 0 degrees

or if it is going in the negative direction -0.5 degrees

Xcelcius does not support the slope command.

Will I have to find this out manually y=mx+b

or is there another way

Thanks

[former_member182541]

Dashboard doesn't support command, all you need to define the formula manually into a cell and bind that cell to the trend icon data "cell". So whenever you pass the "m","x" & "b" based on the calculated value the trend icon will show you the status.

Got it!!!

[Former Member]

Hi

Can yo tell me how to extract b(slope from equation. See below

[arvind_shukla4]

Hi Jamie,

The "Trend Icon" shows an arrow that can indicate whether values are trending in a positive or negative direction. The icon is linked to a single cell.

If the cell value is positive, the arrow points up.

If the cell value is zero, the symbol is neutral.

If the cell value is negative, the arrow points down.

Thanks

Arvind Shukla

[Former Member]

Hi,

Trend takes up Zero , +ve and  -ve values so you can use some formula to arrive on a result of 1 , 0 and -1 and assign that result to Trend Icon.

Thanks

Manish