Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.

Analysis Workspace - Add Trend Line to Day Line Chart

Avatar

Level 6

4/10/18

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

Level 4

4/10/18

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