{"id":11663,"date":"2021-08-04T00:00:55","date_gmt":"2021-08-04T07:00:55","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=11663"},"modified":"2025-06-13T19:27:05","modified_gmt":"2025-06-14T02:27:05","slug":"amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","title":{"rendered":"Mejora tu an\u00e1lisis de datos con la nueva agregaci\u00f3n ROLLUP en Couchbase Analytics"},"content":{"rendered":"<p><strong>Me complace anunciar dos nuevas y potentes funciones de an\u00e1lisis de datos<\/strong> ahora disponible como parte de Couchbase Analytics: 1) <code>ROLLUP<\/code> agregaci\u00f3n, y 2) <code>CUBO<\/code> para ayudarle a agregar datos a trav\u00e9s de m\u00faltiples atributos de documentos.<\/p>\n<p>La adici\u00f3n del <code>ROLLUP<\/code> funcionalidad de agregaci\u00f3n a <a href=\"https:\/\/docs.couchbase.com\/server\/current\/analytics\/introduction.html?ref=blog\" target=\"_blank\" rel=\"noopener\">el servicio Couchbase Analytics<\/a> forma parte de <a href=\"https:\/\/www.couchbase.com\/blog\/es\/couchbase-server-7-0-release\/?ref=blog\" target=\"_blank\" rel=\"noopener\">la versi\u00f3n 7.0 de Couchbase Server<\/a>. (Cubriremos el <code>CUBO<\/code> funcionalidad en un art\u00edculo la semana que viene).<\/p>\n<h2>Ejemplo de agregaci\u00f3n ROLLUP: Datos de comercio electr\u00f3nico<\/h2>\n<p>En <code>ROLLUP<\/code> es una extensi\u00f3n de la funci\u00f3n <a href=\"https:\/\/docs.couchbase.com\/server\/current\/analytics\/primer-beer.html?ref=blog#Query_9\" target=\"_blank\" rel=\"noopener\">GRUPO POR<\/a> cl\u00e1usula.<\/p>\n<p>En <code>ROLLUP<\/code> le permite incluir filas adicionales - com\u00fanmente denominadas filas superagregadas - que representan subtotales en sus datos junto con la fila del total general.<\/p>\n<p>Por ejemplo, supongamos que tiene una colecci\u00f3n de an\u00e1lisis llamada Ventas que realiza un seguimiento de la informaci\u00f3n de comercio electr\u00f3nico de su empresa. Los datos clave que m\u00e1s le interesan son pa\u00eds, regi\u00f3n\/estado, producto, cantidad y precio. (Y supongamos que calcula Ventas como Ventas = cantidad * precio).<\/p>\n<p>A continuaci\u00f3n se muestra un subconjunto de nuestro ejemplo de recopilaci\u00f3n de datos de comercio electr\u00f3nico:<\/p>\n<pre>{\r\n    \"Country\": \"US\",\r\n    \"Region\": \"California\",\r\n    \"Product\": \"Rubber Keyboard\",\r\n    \"Qty\": 1,\r\n    \"Price\": 35.5\r\n  },\r\n  {\r\n    \"Country\": \"US\",\r\n    \"Region\": \"Colorado\",\r\n    \"Product\": \"Gloves\",\r\n    \"Qty\": 4,\r\n    \"Price\": 6.95\r\n  },\r\n {\r\n    \"Country\": \"US\",\r\n    \"Region\": \"Connecticut\",\r\n    \"Product\": \"Cotton Ties\",\r\n    \"Qty\": 2,\r\n    \"Price\": 12.75\r\n}\r\n\u2026\r\n<\/pre>\n<div class=\"wp-block-spacer\" style=\"height: 15px\" aria-hidden=\"true\"><\/div>\n<p>Ahora, supongamos que sus usuarios necesitan determinar la siguiente informaci\u00f3n utilizando los datos anteriores:<\/p>\n<p>1) Ventas totales de todos los pa\u00edses y regiones<br \/>\n2) Ventas totales de todas las regiones por pa\u00eds<br \/>\n3) Ventas totales de cada regi\u00f3n<\/p>\n<p>En <code>ROLLUP<\/code> es una opci\u00f3n excelente para responder a este tipo de preguntas de an\u00e1lisis de datos. Su ingeniero de datos o analista de datos simplemente utiliza la subcl\u00e1usula <a href=\"https:\/\/www.couchbase.com\/blog\/es\/products\/n1ql\/?ref=blog\" target=\"_blank\" rel=\"noopener\">Consulta N1QL<\/a> que se muestra a continuaci\u00f3n.<\/p>\n<pre class=\"\">SELECT   IFNULL(country,\"All Countries\") Country,\r\n                  IFNULL(region,\"All Regions\") Region,\r\n                  ROUND(SUM(o.qty * o.price),0) Sales\r\nFROM     orders o\r\nWHERE  region LIKE \u201cC%\u201d\r\nLET      country = o.country,  region = o.region\r\nGROUP BY ROLLUP(country, region)\r\nORDER BY country ASC, region ASC, Sales DESC;\r\n<\/pre>\n<div class=\"wp-block-spacer\" style=\"height: 15px\" aria-hidden=\"true\"><\/div>\n<p>En la consulta N1QL anterior, utilizamos el pa\u00eds y la regi\u00f3n como variables. La direcci\u00f3n <code>ROLLUP<\/code> asume una jerarqu\u00eda entre los atributos de datos especificados.<\/p>\n<p>Por ejemplo, si la columna de entrada es <code>(pa\u00eds, regi\u00f3n)<\/code>la jerarqu\u00eda <code>pa\u00eds<\/code> es mayor o igual que <code>regi\u00f3n<\/code>. Por eso tiene sentido utilizar <code>ROLLUP<\/code> para generar los subtotales y el total general con fines informativos.<\/p>\n<p>Seg\u00fan la consulta anterior, <code>ROLLUP(pa\u00eds, regi\u00f3n)<\/code> genera los siguientes resultados:<\/p>\n<pre>{ \"Country\": \"All Countries\",\r\n    \"Region\": \"All Regions\",\r\n    \"Sales\": 19921991 \r\n},\r\n{ \"Country\": \"US\",\r\n  \"Region\": \"All Regions\",\r\n   \"Sales\": 199219915 \r\n},\r\n{ \"Country\": \"US\",\r\n  \"Region\": \"California\",\r\n  \"Sales\": 6610804\r\n},\r\n{ \"Country\": \"US\",\r\n  \"Region\": \"Colorado\",\r\n  \"Sales\": 6569542 }\r\n {\r\n    \"Country\": \"US\",\r\n    \"Region\": \"Connecticut\",\r\n    \"Sales\": 6741644\r\n  }\r\n...\r\n<\/pre>\n<div class=\"wp-block-spacer\" style=\"height: 15px\" aria-hidden=\"true\"><\/div>\n<p>Observe que el resultado es exactamente el que buscaban los usuarios de su ejemplo:<\/p>\n<ol>\n<li>En la parte superior de los resultados, un campo JSON de resumen del total general muestra las ventas totales de todos los pa\u00edses y regiones. En estas filas, los valores NULL de los atributos de pa\u00eds y regi\u00f3n se transforman en \"Todos los pa\u00edses\" y \"Todas las regiones\", respectivamente, para que el resultado sea m\u00e1s legible.<\/li>\n<li>A continuaci\u00f3n, para cada pa\u00eds (en este caso, EE.UU.), aparece un elemento de datos JSON de resumen de subtotal adicional que muestra las ventas totales. En ellos, los valores del atributo regi\u00f3n se transforman de NULL a \"Todas las regiones\"<\/li>\n<li>Por \u00faltimo, el resultado muestra las ventas totales de cada regi\u00f3n del pa\u00eds. En este ejemplo, se muestran las ventas de California, Colorado y Connecticut dentro de Estados Unidos.<\/li>\n<\/ol>\n<h2>Conclusi\u00f3n<\/h2>\n<p>Esto ha sido s\u00f3lo un vistazo r\u00e1pido al nuevo <code>ROLLUP<\/code> en el servicio Couchbase Analytics. Para m\u00e1s informaci\u00f3n, <a href=\"https:\/\/docs.couchbase.com\/server\/current\/introduction\/whats-new.html?ref=blog#rollup-and-cube-extensions-to-group-by\" target=\"_blank\" rel=\"noopener\">consulte el <code>ROLLUP<\/code> documentaci\u00f3n<\/a>. Espero que esta nueva capacidad le resulte \u00fatil para futuros proyectos de an\u00e1lisis de datos en su empresa.<\/p>\n<p>Estoy deseando <a href=\"https:\/\/www.couchbase.com\/blog\/es\/forums\/?ref=blog\" target=\"_blank\" rel=\"noopener\">sus comentarios en los foros de Couchbase<\/a> - \u00a1H\u00e1ganos saber lo que piensa!<\/p>\n<div class=\"wp-block-spacer\" style=\"height: 30px\" aria-hidden=\"true\"><\/div>\n<div style=\"text-align: center\"><strong>No tiene por qu\u00e9 creerme: Prueba Couchbase Analytics hoy mismo<br \/><a href=\"https:\/\/www.couchbase.com\/blog\/es\/downloads\/?ref=blog\" target=\"_blank\" rel=\"noopener\">Pruebe Couchbase<\/a><\/strong><\/div>\n<div class=\"wp-block-spacer\" style=\"height: 15px\" aria-hidden=\"true\"><\/div>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>I&#8217;m excited to announce two new powerful data analysis capabilities now available as part of Couchbase Analytics: 1) ROLLUP aggregation, and 2) CUBE functionality, both to help you aggregate data across multiple document attributes. The addition of the ROLLUP aggregation [&hellip;]<\/p>","protected":false},"author":58630,"featured_media":11665,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1815,2294,1816,1812],"tags":[2014,2155,9354,1261,9353],"ppma_author":[8967],"class_list":["post-11663","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices-and-tutorials","category-analytics","category-couchbase-server","category-n1ql-query","tag-data-analysis","tag-ecommerce","tag-group-by","tag-json","tag-super-aggregate-rows"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.7.1 (Yoast SEO v25.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Analysis with ROLLUP Aggregation in Couchbase Analytics<\/title>\n<meta name=\"description\" content=\"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/es\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics\" \/>\n<meta property=\"og:description\" content=\"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/es\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-04T07:00:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T02:27:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service-social.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"418\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Idris Motiwala\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service-social.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Idris Motiwala\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/\"},\"author\":{\"name\":\"Idris Motiwala\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8\"},\"headline\":\"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics\",\"datePublished\":\"2021-08-04T07:00:55+00:00\",\"dateModified\":\"2025-06-14T02:27:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/\"},\"wordCount\":513,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg\",\"keywords\":[\"Data Analysis\",\"ecommerce\",\"GROUP BY\",\"JSON\",\"super-aggregate rows\"],\"articleSection\":[\"Best Practices and Tutorials\",\"Couchbase Analytics\",\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/\",\"name\":\"Data Analysis with ROLLUP Aggregation in Couchbase Analytics\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg\",\"datePublished\":\"2021-08-04T07:00:55+00:00\",\"dateModified\":\"2025-06-14T02:27:05+00:00\",\"description\":\"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg\",\"width\":1200,\"height\":628,\"caption\":\"Talend adds Couchbase Capella connector support\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8\",\"name\":\"Idris Motiwala\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/28d4b56674680cd3d7fe940321c3e98a\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g\",\"caption\":\"Idris Motiwala\"},\"description\":\"Idris is a Principal Product Manager, Analytics at Couchbase with 20+ years experience in design, development and execution of software products at both Fortune 500s and startups leading teams in digital transformation, cloud and analytics. Idris holds an MS in Technology Management and certifications in product management .\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/idrismotiwala\/\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/es\/author\/idris-motiwala\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Analysis with ROLLUP Aggregation in Couchbase Analytics","description":"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/es\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","og_locale":"es_MX","og_type":"article","og_title":"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics","og_description":"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.","og_url":"https:\/\/www.couchbase.com\/blog\/es\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","og_site_name":"The Couchbase Blog","article_published_time":"2021-08-04T07:00:55+00:00","article_modified_time":"2025-06-14T02:27:05+00:00","og_image":[{"width":800,"height":418,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service-social.jpg","type":"image\/jpeg"}],"author":"Idris Motiwala","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service-social.jpg","twitter_misc":{"Written by":"Idris Motiwala","Est. reading time":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/"},"author":{"name":"Idris Motiwala","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8"},"headline":"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics","datePublished":"2021-08-04T07:00:55+00:00","dateModified":"2025-06-14T02:27:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/"},"wordCount":513,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg","keywords":["Data Analysis","ecommerce","GROUP BY","JSON","super-aggregate rows"],"articleSection":["Best Practices and Tutorials","Couchbase Analytics","Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","url":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/","name":"Data Analysis with ROLLUP Aggregation in Couchbase Analytics","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg","datePublished":"2021-08-04T07:00:55+00:00","dateModified":"2025-06-14T02:27:05+00:00","description":"Walk through an example of the new ROLLUP sub-clause feature in Couchbase Analytics to help you aggregate data across multiple JSON document attributes.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2021\/08\/data-analysis-rollup-aggregation-function-couchbase-analytics-service.jpg","width":1200,"height":628,"caption":"Talend adds Couchbase Capella connector support"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/amp-up-your-data-analysis-with-the-new-rollup-aggregation-in-couchbase-analytics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"El blog de Couchbase","description":"Couchbase, la base de datos NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/2fc07a18d91ce2e4e0f1f7c5c9e620b8","name":"Idris Motiwala","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/28d4b56674680cd3d7fe940321c3e98a","url":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","caption":"Idris Motiwala"},"description":"Idris es Director Principal de Producto, Anal\u00edtica en Couchbase con m\u00e1s de 20 a\u00f1os de experiencia en dise\u00f1o, desarrollo y ejecuci\u00f3n de productos de software tanto en Fortune 500 como en startups liderando equipos en transformaci\u00f3n digital, nube y anal\u00edtica. Idris tiene una Maestr\u00eda en Gesti\u00f3n de Tecnolog\u00eda y certificaciones en gesti\u00f3n de productos .","sameAs":["https:\/\/www.linkedin.com\/in\/idrismotiwala\/"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/idris-motiwala\/"}]}},"authors":[{"term_id":8967,"user_id":58630,"is_guest":0,"slug":"idris-motiwala","display_name":"Idris Motiwala","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/41b4ee771dab1b1ff8152be7b5545a13ff3cca8ca7e9021e762e3d7af21763f0?s=96&d=mm&r=g","first_name":"Idris","last_name":"Motiwala","user_url":"","author_category":"","description":"Idris es Director Principal de Producto, Anal\u00edtica en Couchbase con m\u00e1s de 20 a\u00f1os de experiencia en dise\u00f1o, desarrollo y ejecuci\u00f3n de productos de software tanto en Fortune 500 como en startups liderando equipos en transformaci\u00f3n digital, nube y anal\u00edtica. Idris tiene una Maestr\u00eda en Gesti\u00f3n de Tecnolog\u00eda y certificaciones en gesti\u00f3n de productos ."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/11663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/58630"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=11663"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/11663\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/11665"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=11663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=11663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=11663"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=11663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}