How to create a linear trend line (calculated metric?)

Avatar

Avatar
Validate 25
Level 3
laetizia_w
Level 3

Likes

32 likes

Total Posts

91 posts

Correct reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 3
laetizia_w
Level 3

Likes

32 likes

Total Posts

91 posts

Correct reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
laetizia_w
Level 3

11-05-2018

I am having a question maybe someone can help me out on this.

I have created a line graph of couple weeks visits and see the behaviour. Now I would like to see a trend line in there. I have tried to caluclate this but somehow was not able to do so. Does anyone know a solution on this.

For example these are the visits of my week:

5

3

3

2

With this information I would like to create an own trend line to see how the behaviour is going. Does anyone know a solution on that?

The most important part is to get a trendline by using maybe a calculated metric

I would be more than thankful!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 25
Level 3
laetizia_w
Level 3

Likes

32 likes

Total Posts

91 posts

Correct reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 3
laetizia_w
Level 3

Likes

32 likes

Total Posts

91 posts

Correct reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
laetizia_w
Level 3

24-05-2018

I found also another way:

1494618_pastedImage_0.png

I have tested also with our data and typical Excel trendlines and the values are correct.

Answers (3)

Answers (3)

Avatar

Avatar
Boost 5
Level 2
JimKultgen
Level 2

Likes

15 likes

Total Posts

15 posts

Correct reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
JimKultgen
Level 2

Likes

15 likes

Total Posts

15 posts

Correct reply

2 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
JimKultgen
Level 2

24-05-2018

I would think there would be a method to use the "Cumulative Average" function, but I wasn't able to get it to work.

Does the attached get you close enough?  This would be a rolling average trend line.

1494203_pastedImage_0.png1494204_pastedImage_1.png

Avatar

Avatar
Validate 25
Level 3
laetizia_w
Level 3

Likes

32 likes

Total Posts

91 posts

Correct reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile

Avatar
Validate 25
Level 3
laetizia_w
Level 3

Likes

32 likes

Total Posts

91 posts

Correct reply

2 solutions
Top badges earned
Validate 25
Validate 10
Validate 1
Boost 5
Boost 3
View profile
laetizia_w
Level 3

23-05-2018

No this is not what I want. I would like to have a regular line with visits for example and trend line. Just like this:

1493113_pastedImage_0.png

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

22-05-2018

If you shift+click the numbers you want to trend, then right click > trend selection, you should get exactly what you're looking for.