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

Analysis Workspace - Add Trend Line to Day Line Chart

Avatar

Avatar
Give Back 5
Level 5
jeremyl59043873
Level 5

Likes

127 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile

Avatar
Give Back 5
Level 5
jeremyl59043873
Level 5

Likes

127 likes

Total Posts

29 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Ignite 3
Give Back 3
Give Back
Ignite 1
View profile
jeremyl59043873
Level 5

10-04-2018

First a simple idea:

We have a relative volatile business where weekdays volumes are dramatically higher than weekends and the daytime is dramatically higher than the night time  As such when we generate a daily line chart we have a chart that looks like super fast heart beat with lots of peaks and valleys.

We were thinking that it would be great if we could add a 'trend line' to the chart and include the 'equation' for that trend line on the chart.  Very similar to how Excel does it.

more sophisticated idea

I think this is a super valuable tool (the equation) that helps quantify the growth (slope) of the line.  I'm thinking the comparison of two lines (segment a vs. segment b) with two lines and two equations where equation A shows +1% growth while equation B shows a -2% growth.  Proving mathematically that the variance between the two segments is 3%

1 Comment

Avatar

Avatar
Contributor 2
Level 4
jorisdebeer
Level 4

Likes

36 likes

Total Posts

61 posts

Correct reply

9 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 25
Ignite 10
Give Back 10
View profile

Avatar
Contributor 2
Level 4
jorisdebeer
Level 4

Likes

36 likes

Total Posts

61 posts

Correct reply

9 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 25
Ignite 10
Give Back 10
View profile
jorisdebeer
Level 4

10-04-2018

Hi Jeremy,

There are a couple of ways to achieve this already.

1 option is to enable the Show Anomalies, which will display a shaded area representing the upper and lower expected bounds for visits for that day, and a dotted line for the expected number of visits for that day. But if your traffic is very peaky/troughy then the shaded bounds will reflect that as normal.

1462671_pastedImage_0.png

Another option is to create a calculated metric which is an average of visits for the last 7 days.

1462672_pastedImage_1.png

To produce a chart that should look something like:

1462673_pastedImage_3.png