Downloading more than 400 rows for a freeform with breakdowns?

[JaniceAk]

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!

[juliusonyancha]

Hi @JaniceAk I have explored this as well but currently not feasible.

Worth trying data warehouse extract.

[Jennifer_Dungan · Accepted solution]

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]

Another option to consider is using dynamic drop-down feature. However, this will work if you are managing the report within the analysis workspace or as a shared link but not via an extract. For example, set dimension A as a drop-down and then drop B to the table. You can then share the report with anyone to access.