Working with data can sometimes be a daunting task. Luckily, CARTO Builder’s analysis interface makes it easier than ever to perform data transformation, such as filtering, like never before. Filtering a dataset by column value can be done in just a few simple steps directly from CARTO Builder’s layer list or by selecting “Analysis” from the layer view once a layer is selected.
In the “Add a new analysis” screen, you will notice a variety of methods for manipulating and analyzing data. By selecting “Transform” and then “Filter by column value,” we have added our first analysis node to the layer’s workflow. Filtering by column value works directly with the data to only render parameters specified by the user.
Understand how to improve your business achievement and make better, and faster decisions with CARTO Builder
Watch it now!If you are working with numerical or date values, it is possible to select a range from the data and filter out the results within the range, or not, meeting the criteria in the query. For string data types, or columns containing letters, numbers, and/or symbols, the filter by column value analysis allows you to search isolate, and/or remove specific cell values.
To learn more about analysis in CARTO Builder, be sure to check out our Analyzing your data section of our documentation.
Happy Data Mapping!
The ever-growing threat of climate change on the built environment cannot be ignored. Intensifying wildfires, storms, floods and sea level rise not only impact the health a...
NewsHundreds of data scientists, developers, business leaders and academics from around the world attended the 2022 Spatial Data Science Conference in London this past May! Wit...
NewsAt CARTO, we’re thrilled to announce that we’ll be sponsoring, attending and presenting at the 2022 Databricks’ Data + AI Summit taking place virtually and in-person June 2...
NewsPlease fill out the below form and we'll be in touch real soon.