Setting the Aggregation Function at the Card Level in Data Lens
One of the key benefits of create visualizations with Data Lens is the way publishers can quickly and easily summarize data using one of the supported aggregation functions to see trends and patterns. We just added more flexibility to Data Lens by enabling publishers to choose the aggregation function at the card level, rather than at the page level. Using this new feature, publishers can create more useful visualizations to highlight additional trends and comparisons. We’ve also enabled the SUM function for datasets that have more than 15 numerical columns so that publishers can use this feature for more of their datasets. To learn more about how to take advantage of this new functionality along with examples visit the Using the Aggregation Function in Data Lens support article on the Socrata Knowledge Base.
Grouping Multiple Resources with the Same File Type in an External Dataset
Many Socrata customers have valuable datasets and resources hosted off the Socrata platform in addition to those hosted on Socrata. We just added more flexibility for publishers to better organize external resources on Socrata so that they can be more easily discovered by data consumers. Now publishers can group together a set of related external resources, e.g. a CSV file of the data and another CSV of reference codes, so that they can be discovered by users as a single, logical unit. Previously, each external dataset could have multiple resources but each resource within the same dataset had to have a unique file type, e.g. CSV, PDF, etc. Removing that restriction reduces the number of related but similar datasets the publisher has to manage. In addition, now Socrata can easily ingest a data.json output to instantiate a catalog of datasets whereas previously we would not allow datasets with duplicate file types. This greatly improves Socrata’s interoperability with data.json.