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
BedrockMission!

Learn More

View all

Sign in to view all badges

Ad Hoc - trying to understand: missing numbers / numbers don't add up in 50k row reports

Avatar

Avatar
Validate 1
Level 1
nickd77376831
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
nickd77376831
Level 1

Likes

0 likes

Total Posts

10 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
nickd77376831
Level 1

20-01-2016

I'm trying to understand the "logic" of how reports are created in order to understand why we having incomplete reports.

I need to run large reports (50k rows by 100 columns), where the actual data set is far bigger than 50k x 100.

Let's say I want doc ids (50k rows) by page views of 100 countries.

Imagine column 1 is doc ids, colum 2 is US page views, column 3 is UK page views etc.

If I then run the same report ONLY for the UK, I discover high-hitting UK docs that are not in the big report.  

Given this, I assume the logic for building the report is:

1 Build the list of the top 50k docs for the country with the highest total page views (eg US) 

2 Display list of top 50k doc ids for US in column 1

3 Display page views of each doc id for the US in column 2

4 Column 3 (UK): for each doc id in column 1, display page views for the UK.

So, I assume that if a very high-hitting doc only exists in the UK but the US has the highest total page views, the high-hitting UK doc won't appear in the list.

If my assumption is right, is there a way to use total page views of all doc ids worldwide as the criteria for building column 1?

nick

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,331 posts

Correct Reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,331 posts

Correct Reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile
jantzen_belliston-Adobe
Community Manager

18-12-2020

Adobe is moving Ad Hoc Analysis to end of life on March 1, 2021. Learn more - https://adobe.ly/discoverworkspace

  

 

Answers (0)