Level 1

0% to

Level 2

Tip /

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

View all

## Analysis Workspace - Add Trend Line to Day Line Chart

jeremyl59043873
Level 5

Likes

127 likes

Total Posts

29 posts

0 solutions
View profile

jeremyl59043873
Level 5

Likes

127 likes

Total Posts

29 posts

0 solutions
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

jorisdebeer
Level 4

Likes

36 likes

Total Posts

61 posts

9 solutions
View profile

jorisdebeer
Level 4

Likes

36 likes

Total Posts

61 posts

9 solutions
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.

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

To produce a chart that should look something like: