Downloading more than 400 rows for a freeform with breakdowns?

Question

Hi everyone,

A use case recently came up in CJA that requires querying unique pairings of two different dimensions for csv download in Workspace; i.e. breaking down each dimension A value by dimension B.

Aside from the full table export option for workspace tables, and the 50k row download for single dimension items, is there a way for regular users to download more than 400 items for a freeform with breakdowns? I've been trying to explore if it's possible to download up to 50K rows for fields along with their breakdowns, but because the UI row limit is 400, the csv download ('Download data as csv' option) only returns 400 max items for each dimension. E.g. Dimension A may have 2000 values, each with 500 Dimension B items-- but the download only returns 400 distinct Dimension A values, and 400 Dimension B values per Dimension A.

Are there any ideas on how to work around this UI limit? Temporary solution has been concatenation into one field, but still curious if there are any other routes to take.

Thanks!

Jennifer_Dungan · Accepted Answer

Data Warehouse Exports might work, but the segments still apply for the whole export, and I don't believe you get breakdowns (it's more like a flat table export... which still might work).

Depending on how much data you need, you might be able to us if you need a little more control over each breakdown, or the metrics.

I know by default Report Builder shows Top 10, but I think you can increase those limits.. I am not sure how far, but it's worth checking?

juliusonyancha · Answer

Hi @janiceak I have explored this as well but currently not feasible.Worth trying data warehouse extract.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded