Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 5

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!

1 Accepted Solution

Avatar

Correct answer by
Level 5

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.

View solution in original post

4 Replies

Avatar

Employee Advisor

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

Avatar

Level 5

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

Level 3

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

Correct answer by
Level 5

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.