Display folder level trend lines of several different folders in one reportlet graphic. Possible? | Community
Skip to main content
F
fcizmar001
November 9, 2016
Solved

Display folder level trend lines of several different folders in one reportlet graphic. Possible?

  • November 9, 2016
  • 3 replies
  • 1096 views

Hi; I am just learning my way around Adobe Analytics and am looking for a way to display folder level trends of several different folders in one reportlet graphic. Is this possible, and if so, where can I get the steps to do this? Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Gigazelle

There might be a way to do this in Analysis Workspace, but honestly it would probably be easiest to do it in Excel using Report Builder. If you haven't used Report Builder before, it's a connector that lets you pull Analytics data into Excel. It does not require advanced Excel skills (though it does require basic experience).

  1. In Adobe Analytics, create a segment for each of the 5 directories
  2. Open Excel and create a Report Builder request for each of the 5 directories, using their respective segments
  3. Once you have all 5 requests trended, use the Excel formula =AVERAGE(cell range) to get the average of the 5 directories

3 replies

TanmayMathur
Adobe Employee
TanmayMathurAdobe Employee
Adobe Employee
November 10, 2016

Hi Francis,

Welcome to the Analytics Community!

Could you elaborate a bit more on what kind of data you want to display? What kind of 'folder level trends' you want to show in the reportlet?

F
fcizmar001Author
November 10, 2016

Hi Tanmay!

Thank you for welcoming me, and for responding to my question. Let me try to clarify; please forgive any incorrect or imprecise terms I may use to describe what I am trying to accomplish.

I have a dashboard that displays reportlets on monthly page views and visits for five specific folder directories on my company's website, plus a sixth cross-folder reportlet that captures the aggregate of page views and visits for the afoermentioned five directories. What I am trying to do in this cross-folder reportlet is to display trend lines that track page views for each of the five reportlets, plus one more that displays the average of all five directories. (As an aside, I am not an Excel wiz, but I really need to understand whether what I want is possible in Adobe Analytics, or whether I need to enlist the help of someone with Advanced Excel skills to build a solution for me.

Does that help? Thank you for any assistance and guidance!

Francis

Gigazelle
Adobe Employee
GigazelleAdobe EmployeeAccepted solution
Adobe Employee
October 30, 2018

There might be a way to do this in Analysis Workspace, but honestly it would probably be easiest to do it in Excel using Report Builder. If you haven't used Report Builder before, it's a connector that lets you pull Analytics data into Excel. It does not require advanced Excel skills (though it does require basic experience).

  1. In Adobe Analytics, create a segment for each of the 5 directories
  2. Open Excel and create a Report Builder request for each of the 5 directories, using their respective segments
  3. Once you have all 5 requests trended, use the Excel formula =AVERAGE(cell range) to get the average of the 5 directories
Terms & ConditionsAccessibility statement

Loading footer...