Adhoc Analysis : Get around the 50000 row limit

Avatar

Avatar
Validate 1
Level 2
akshatganja
Level 2

Likes

4 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
akshatganja
Level 2

Likes

4 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
akshatganja
Level 2

12-02-2019

Hi Everyone,

>

I am trying to pull a report which has three breakdown levels: Week > A custom Value > A custom segment. The issue I am running into on Adhoc analysis tools is that it is displaying only 50000 rows in a single instance and if I need to look at all the rows in my data I am having to manually click on each of the buttons to expand for a full view. Even exporting the report displays data in the same fashion.

Is there any way to get around this? I've tried using the report builder, however, I ran into an issue with that tool as well where I cannot add the segments as dimensions in the report.

Any help on this would be greatly appreciated. Please let me know if you need any more info.

Best,

Akshat

Replies

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

538 likes

Total Posts

973 posts

Correct reply

264 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

538 likes

Total Posts

973 posts

Correct reply

264 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

12-02-2019

Hi Akshat,

To have the dimensions broken down by other dimensions without manually clicking on them, you may want to use the table builder configurator where you should be able to set how many lines need to be broken down and how many lines of each dimension should be displayed.

However, if you are looking for a way to export more than 50k rows, AdHoc Analysis is not designed for that. You may want to use Data Warehouse instead.

Avatar

Avatar
Validate 1
Level 2
akshatganja
Level 2

Likes

4 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
akshatganja
Level 2

Likes

4 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
akshatganja
Level 2

13-02-2019

I tried using the data warehouse to get the data needed. However, with data warehouse I am unable to breakdown the data in the same format as I am able to in Adhoc analysis. Also, in Adhoc analysis I am able to track occurrences as a metric but with the warehouse I do not see that option in the metrics.

Avatar

Avatar
Validate 1
Level 2
akshatganja
Level 2

Likes

4 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
akshatganja
Level 2

Likes

4 likes

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
akshatganja
Level 2

13-02-2019

I tried increasing the breakdowns in the Table Builder tool but even if I select the breakdown to be 100 it still only breakdown the first 10. That is the major concern I am having with Adhoc Analysis.

Avatar

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

538 likes

Total Posts

973 posts

Correct reply

264 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile

Avatar
Shape 25
MVP
Andrey_Osadchuk
MVP

Likes

538 likes

Total Posts

973 posts

Correct reply

264 solutions
Top badges earned
Shape 25
Bedrock
Coach
Boost 500
Affirm 250
View profile
Andrey_Osadchuk
MVP

14-02-2019

Could you attach a screenshot with the table builder configuration?