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

Select number of rows for every breakdown

Avatar

Avatar
Validate 1
Level 2
gonzaloc5979070
Level 2

Likes

5 likes

Total Posts

9 posts

Correct Reply

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

Avatar
Validate 1
Level 2
gonzaloc5979070
Level 2

Likes

5 likes

Total Posts

9 posts

Correct Reply

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

27-04-2019

Does anybody know if it's possible to select the number of rows you want for every breakdown in Workspace? For example, I have 400 rows from a prop and I need to breakdown using another one, but I need 25 rows for every item (from the 400 rows). By default it's five, I think. It's really annoying to do do it one by one.

Any advice?

Thank you so much

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile
David-123
Level 5

27-04-2019

I don't believe this is possible.

However If I had 400 rows that I wanted to break down by 25 I would most likely use report builder and pull a top 400 and top 25 values.

Thanks

Dave

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 2
gonzaloc5979070
Level 2

Likes

5 likes

Total Posts

9 posts

Correct Reply

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

Avatar
Validate 1
Level 2
gonzaloc5979070
Level 2

Likes

5 likes

Total Posts

9 posts

Correct Reply

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

10-05-2019

Ok thanks asheeshp and davidj85759080 Anyway, I needed to do it in Workspace because it's much quicker than Ad Hoc or Report Builder (Data Warehouse is not even an option). I hope this functionality comes quickly to Workspace

Avatar

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

129 likes

Total Posts

334 posts

Correct Reply

144 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

129 likes

Total Posts

334 posts

Correct Reply

144 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile
Asheesh_P
MVP

27-04-2019

Hi,

I don't see if the workspace has a setting to set the number of rows in a breakdown. However, following Ad Hoc Analysis functionality are being moved to Analysis Workspace which can help you do this in the workspace in the future.

  1. Build advanced queries with many breakdowns, all at once (similar to Table Builder in Ad Hoc)
  2. Download up to 50,000 rows/breakdown from a freeform table
  3. Remove repeat instances from Flow

For now, you can choose either of Adobe tools to do it. i.e. Adobe Report Builder or Data Warehouse or Ad Hoc Analysis ​(Ad Hoc Analysis will go into end-of-life - The current target end-of-life date for Ad Hoc Analysis is Q2 2020)

Use Full Links: Analytics Product Comparison and Requirements

Thanks,

Asheesh