🗃️Working With Large Data

Arcwise connected data tabs can have millions, or even billions, of rows. If you went through the process in Connecting data and the result had more than 200,000 cells then your Arcwise connected data tab will only display 100 rows. This data is a preview.

You can work with large data in nearly the same way as normal data. You can use all the functionality available for Arcwise connected data tabs. See Overview.

Adding ColumnsFilteringSorting📊Pivot Tables📉Creating Manual Visualizations

Suggestions for working with large data

The easiest way to work with large Arcwise data is to use the AI analyst. The AI analyst works especially well when your data is large.

When working with large data you can only see a 100 row preview in the sheet. It is useful to add sorting and filters to observe different values of the data. Additionally, you can apply pivot tables to aggregate the data and make it small enough to fit within a standard spreadsheet tab.