Calculate the change % of a curve

[Anonymous]

If there was a trend line on the charts how would I be able to determine the improvement or degradation over a specific time period (here it is 52 weeks).

I have a line chart that shows me my safety calculation over 52 weeks (each week I have a new file).

the chart works great and that is not the problem.  The problem is I need to create a straight table that has my center (that is easy) my safety calculation (got that), the slope (cant get this to work), and then the rank by the slope (not sure how to do that after I can get the slope to work)

For the slope I tried to follow something I have seen online but all I get is dashes.  Any help as to what I need to do to get this working and then how I would get a rank bast on the slope. 1 being the highest number?

I tried this for slope:

LINEST_M(aggr(nodistinct sum(Safety), FileDate, Center), FileDate)

To get the safety I have this and it works.

Avg( {<FileDate = >} ([Total Miles] / (Speeding + Brake + Seatbelt + Accel)))

How do I get the slope to show up in my chart? and then how do I rank by the slope?

[Anonymous]

Nevermind I mistype d something.  This last one worked.  How how would I get the ranking?

[sunny_talwar]

How how would I get the ranking?

I am not sure what you are ranking here May be this

Rank(Avg( {<FileDate = >} ([Total Miles] / (Speeding + Brake + Seatbelt + Accel))))

[Anonymous]

Thanks!