Select number of rows for every breakdown | Community
Skip to main content
gonzaloc5979070
gonzaloc5979070
Level 2
April 27, 2019
Solved

Select number of rows for every breakdown

  • April 27, 2019
  • 3 replies
  • 6160 views

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

    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 David_Jerome

    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

    3 replies

    David_Jerome
    David_JeromeAccepted solution
    Level 6
    April 27, 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

    Asheesh_Pandey
    Community Advisor
    Asheesh_PandeyCommunity Advisor
    Community Advisor
    April 27, 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

    gonzaloc5979070
    gonzaloc5979070Author
    Level 2
    May 10, 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

      Terms & ConditionsAccessibility statement

      Loading footer...