Sources

\n\n

All the indicators in the time series section of this dashboard are published by the Puerto Rico Planning Board in this site: Indicadores Económicos

\nFor the top portion (icon storm) of this dasrboard the sources are as follows:\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n




	Datum	Source
	Producto Nacional Bruto (PNB)	Junta de Planificación de Puerto Rico, Apéndice Estadístico
	Población	American Community Survey, 5 years, 2019
	Migración	Negociado del Censo de Estados Unidos (2020). Puerto Rico Commonwealth Population Totals and Components of Change: 2010-2019
	Tasa de desempleo	Bureau of Labor Statistics
	Reclamaciones al desempleo	Bureau of Labor Statistics
	Venta de vivienda nueva	Junta de Planificación de Puerto Rico, Indicadores Mensuales
	Viviendas Reposeídas	Junta de Planificación de Puerto Rico, Indicadores Mensuales
	Venta al detal	Junta de Planificación de Puerto Rico, Indicadores Mensuales
	Venta de cemento	Banco de Desarrollo de PR, https://www.bde.pr.gov/BDESite/PRED.html
	Quiebras radicadas	Junta de Planifiación de Puerto Rico, Indicadores Mensuales
	Venta de autos nuevos	Banco de Desarrollo de PR, https://www.bde.pr.gov/BDESite/PRED.html
	Turismo - Visitantes
	Casos COVID	Monitoreo de Covid en Puerto Rico, https://rconnect.dfci.harvard.edu/covidpr/
	Muertes por COVID	Monitoreo de Covid en Puerto Rico, https://rconnect.dfci.harvard.edu/covidpr/
	Hospitalizaciones COVID	Monitoreo de Covid en Puerto Rico, https://rconnect.dfci.harvard.edu/covidpr/

\n
\n

Disclaimer

\n\n

For the last twenty-eight years, Estudios Técnicos, Inc. (ETI) has been the leading firm in Puerto Rico that provides support and research to private companies, public entities and non-profit organizations with social-economic data, market studies, business planning, and strategy and feasibility studies, all supported by concise and succinct research and data.

\n
\n

ETI provides a robust Data Platform that contains research and data regarding a broad variety of social-economic indicators in Puerto Rico. The Data Platform is accessible to users free of charge.

\n
\n

Access to, and all use of the ETI Data Platform, is governed by the following terms of use and legal disclaimers. To access and use the Data Platform you must agree to these terms and legal disclaimers by checking the “I agree” box at the bottom of this page. Then you will have access to the contents of the ETI Data Platform.

No Liability

\n\n

ETI endeavors to provide current and accurate information that it obtains from a variety of public and official sources (the “Information”). Neither ETI, nor any of its principals, employees or staff, make any warranties, express or implied, as to the accuracy, adequacy or completeness of any of the Information contained within the Data Platform. All such Information is provided by ETI on an “as is” basis, without any warranties as to merchantability or fitness for a particular purpose or use, including with respect to the results that may be obtained from the use of such information.

\n
\n

Neither ETI, nor any of its principals, employees or staff, shall bear any responsibility or liability for any errors or omissions in the Information, nor shall they be liable for any damages, whether direct or indirect, special or consequential, even if they are advised of the possibility of such damages.

\n
\n

In no event shall ETI, its principals, employees or staff, be liable pursuant to any cause of action, whether in contract, strict liability, tort or otherwise, arising from use by any person or entity of the Information. Users of the Information do so at their own risk and assume the risk that the Information may be inaccurate or not current.

\n
\n

ETI attributes the sources of the information within the Data Platform. The Information is subject to change and is not warranted as to its completeness, accuracy, merchantability or fitness for a particular purpose. Because such sources may change or correct the original information without notice, ETI encourages all users of the Information to confirm the accuracy of the Information with the original sources.

Intellectual Property\n

\n\n

The original public and official sources of the Information retain all copyright and other intellectual property rights in the Information. Neither ETI, nor any of its principals, employees or staff, claim any ownership of, or in, the Information. Any users of the Information agree that by virtue of accessing and using the Information, they will not enjoy any ownership of, or in, the Information. ETI expressly disclaims all warranties of any kind, including but not limited to, non-infringement of any proprietary rights.

\nFor additional information send a email to dataanalytics@estudiostecnicos.com\n","components":[{"mixin":"label","role":"data","data":[[]],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"de76815c-2","type":"html_data","dstContext":{"kid":"4c504873e02fd42aea62268c60ff7c6f","id":"dstde76815c2"}}],"displayName":"HTML Template","id":"48d588fe-1","type":"html_tpl2","dstContext":{"id":"dst48d588fe1"}}],"isForked":false,"id":"0db5242eff54705dc8040d8edfdcc4cb","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"disclaimer","usesSampleData":false,"master":"4c504873e02fd42aea62268c60ff7c6f"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Empleo"]],"displayName":"Label","formulas":[{"txt":"\"Empleo\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"77cdb596790f1534e86db7a38a81cc08","id":"dst2fd8cad3"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"2fd8cad3","wrap":true},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"77cdb596790f1534e86db7a38a81cc08","id":"dstf5b628da"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"f5b628da","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"d27d5122-9","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"dc8f4f01","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"41295f5f","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"d8aed991","type":"input","dstContext":{"kid":"77cdb596790f1534e86db7a38a81cc08","id":"dstd8aed991"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["egt.ajust.emp.tot","ee.no.agric","ee.ajust.manufactura","ee.ajust.com.pm","ee.ajust.com.d","ee.ajust.inf","ee.ajust.fina.seg","ee.ajust.b.raices","ee.ajust.sprof","ee.ajust.edu","ee.ajust.edu.salud","ee.ajust.rec","ee.ajust.hosp.rest","ee.ajust.otro.s","ee.ajust.gob"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"EMPLEO\")","ver":2.0}],"autoFmt":false,"id":"bbcc3c0c","type":"proxy"},{"role":"labels","data":[["Empleo Total (Miles de Personas Ajustado Estacionalmente)","Empleo No Agrícola: Todas las Industrias (Miles de Personas)","Empleo No Agrícola: Manufactura (Miles de Personas Ajustado Estacionalmente)","Empleo en Comercio al Por Mayor (Miles de Personas)","Empleo en Comercio al Detalle (Miles de Personas)","Empleo en Información (Miles de Personas)","Empleo en Finanzas y Seguros (Miles de Personas)","Empleo en Bienes Raíces, Alquiler y Arrendamiento (Miles de Personas)","Empleo en Servicios Profesionales y Comerciales (Miles de Personas)","Empleo en Servicios Educativos (Miles de Personas)","Empleo en Servicios Educativos y de Salud (Miles de Personas)","Empleo en Recreación y Alojamiento (Miles de Personas)","Empleo en Hospederías y Restaurantes (Miles de Personas)","Empleo en Otros Servicios (Miles de Personas)","Empleo en Gobierno (Miles de Personas Ajustado Estacionalmente)"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"LOOKUP(&'bbcc3c0c',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"9eab84ba","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"e1fb8580","type":"input","dstContext":{"ops":[{"groupBy":"bbcc3c0c","type":"group"},{"p":{"args":[{"args":[{"dim":"bbcc3c0c"},{"args":[{"value":"\"Label\""},{"value":"\"var_code\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"bbcc3c0c","variation":"member"}],"kid":"77cdb596790f1534e86db7a38a81cc08","id":"dste1fb8580","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"07658863"},{"role":"data","data":[["1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023","1-Oct-2023","1-Nov-2023","1-Dec-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\"lastDate\", MAX(\n\t\t\t\t\tDATE(!'5b661ab4', \"dd-MMM-yyyy\")\n\t\t\t\t), \nIF(\n\t$tend = 1,\n\tSELECT(\n\t\t!'5b661ab4',\n\t\tBETWEEN(\n\t\t\tDATE(!'5b661ab4', \"dd-MMM-yyyy\"),\n\t\t\tDATE_ADD(\n\t\t\t\t$lastDate,\n\t\t\t\t\"1\",\n\t\t\t\t-1\n\t\t\t),\n\t\t\t$lastDate\n\t\t)\n\t),\n\tIF(\n\t\t$tend = 2,\n\t\tSELECT(\n\t\t\t!'5b661ab4',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'5b661ab4', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD(\n\t\t\t\t\t$lastDate,\n\t\t\t\t\t\"1\",\n\t\t\t\t\t-5\n\t\t\t\t),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 3,\n\t\t\tSELECT(\n\t\t\t\t!'5b661ab4',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'5b661ab4', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD(\n\t\t\t\t\t\t$lastDate,\n\t\t\t\t\t\t\"1\",\n\t\t\t\t\t\t-10\n\t\t\t\t\t),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\t!'5b661ab4'\n\t\t)\n\t)\n)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"d4be8b69","type":"data_slot","fmt":"txt","dstContext":{"kid":"77cdb596790f1534e86db7a38a81cc08","id":"dstd4be8b69"}},{"role":"data","data":[["01/07/1999","01/08/1999","01/09/1999","01/10/1999","01/11/1999","01/12/1999","01/01/2000","01/02/2000","01/03/2000","01/04/2000","01/05/2000","01/06/2000","01/07/2000","01/08/2000","01/09/2000","01/10/2000","01/11/2000","01/12/2000","01/01/2001","01/02/2001","01/03/2001","01/04/2001","01/05/2001","01/06/2001","01/07/2001","01/08/2001","01/09/2001","01/10/2001","01/11/2001","01/12/2001","01/01/2002","01/02/2002","01/03/2002","01/04/2002","01/05/2002","01/06/2002","01/07/2002","01/08/2002","01/09/2002","01/10/2002","01/11/2002","01/12/2002","01/01/2003","01/02/2003","01/03/2003","01/04/2003","01/05/2003","01/06/2003","01/07/2003","01/08/2003","01/09/2003","01/10/2003","01/11/2003","01/12/2003","01/01/2004","01/02/2004","01/03/2004","01/04/2004","01/05/2004","01/06/2004","01/07/2004","01/08/2004","01/09/2004","01/10/2004","01/11/2004","01/12/2004","01/01/2005","01/02/2005","01/03/2005","01/04/2005","01/05/2005","01/06/2005","01/07/2005","01/08/2005","01/09/2005","01/10/2005","01/11/2005","01/12/2005","01/01/2006","01/02/2006","01/03/2006","01/04/2006","01/05/2006","01/06/2006","01/07/2006","01/08/2006","01/09/2006","01/10/2006","01/11/2006","01/12/2006","01/01/2007","01/02/2007","01/03/2007","01/04/2007","01/05/2007","01/06/2007","01/07/2007","01/08/2007","01/09/2007","01/10/2007"]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"dd/MM/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormat":"dd/MM/yyyy","dateFormatCustom":"dd/MM/yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"dd/MM/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":true,"name":"fecha data","isDstRoot":true,"id":"5b661ab4","type":"data_slot","fmt":"dat2","dstContext":{"kid":"77cdb596790f1534e86db7a38a81cc08","id":"dst5b661ab4"}}],"displayName":"Table","id":"a04ad0bd","type":"table","dstContext":{"ops":[{"groupBy":"07658863","type":"group"},{"sortBy":[{"dim":"07658863","dir":1.0}],"type":"sort"}],"kid":"77cdb596790f1534e86db7a38a81cc08","id":"dsta04ad0bd","aggs":{"5b661ab4":"auto","252f4d0a10":"auto","55ba747b38":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","id":"6e56f596","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Miles de Personas – Ajustado Estacionalmente"]],"displayName":"Label 3","formulas":[{"txt":"FIRST(LOOKUP($label1,6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;,6028c5aa106e6ff08a76aa6437175f62#72c005a10c851637b41cb8aa9e2e34f8;))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"77cdb596790f1534e86db7a38a81cc08","id":"dst340ab7709"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"340ab770-9","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"series","data":[[1140.0,1134.0,1129.0,1128.0,1132.0,1139.0,1148.0,1157.0,1164.0,1169.0,1171.0,1169.0,1167.0]],"color":"#E45565","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"2632c05e","chartStyle":"points_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"1"},"id":"b2caf174"},{"role":"axis_x","data":[["12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23","10/23","11/23","12/23"]],"displayName":"Untitled","formulas":[{"txt":"!'d4be8b69'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"cdd92793","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{},"id":"2632c05e","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"5e405f91","type":"chart_series","dstContext":{"ops":[{"groupBy":"cdd92793","type":"group"},{"p":{"args":[{"args":[{"dim":"cdd92793"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"cdd92793","variation":"member"},{"sortBy":[{"dim":"cdd92793","dir":1.0}],"type":"sort"}],"kid":"77cdb596790f1534e86db7a38a81cc08","id":"dst5e405f91","aggs":{"b2caf174":"auto","4bb9f57341":"auto"}},"height":"3"}],"displayName":"Layout Grid","id":"08867919","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"af914901","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"51d89686a0c20aaf1dff31789f24156f","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"77cdb596790f1534e86db7a38a81cc08"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Comercio Exterior"]],"displayName":"Label","formulas":[{"txt":"\"Comercio Exterior\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"0ceff9be7d07f6d7e11b425e26aa2e77","id":"dst1819c24b"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"1819c24b","wrap":true},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"0ceff9be7d07f6d7e11b425e26aa2e77","id":"dstdcc68dc2"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"dcc68dc2","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"c885511d","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"3472456a","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"68a498fd","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"85ba1801","type":"input","dstContext":{"kid":"0ceff9be7d07f6d7e11b425e26aa2e77","id":"dst85ba1801"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["tot.exp"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"OTROS INDICES ECONOMICOS\")","ver":2.0}],"autoFmt":false,"id":"fa9a2c8c","type":"proxy"},{"role":"labels","data":[["Total de Exportaciones (Miles de Dólares)"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"LOOKUP(&'fa9a2c8c',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"a85ddff5","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"860a0b13","type":"input","dstContext":{"ops":[{"groupBy":"fa9a2c8c","type":"group"},{"p":{"args":[{"dim":"a85ddff5"},{"args":[{"value":"\"Total de Exportaciones (Miles de Dólares)\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"a85ddff5","variation":"member"}],"kid":"0ceff9be7d07f6d7e11b425e26aa2e77","id":"dst860a0b13","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"5c95efc3"},{"role":"data","data":[["1-Nov-2022","1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023","1-Oct-2023","1-Nov-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\n\t\"lastDate\",\n\tMAX(\n\t\tDATE(!'c06ce7d9', \"dd-MMM-yyyy\")\n\t),\n\tIF(\n\t\t$tend = 1,\n\t\tSELECT(\n\t\t\t!'c06ce7d9',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'c06ce7d9', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD($lastDate, \"1\", -1),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 2,\n\t\t\tSELECT(\n\t\t\t\t!'c06ce7d9',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'c06ce7d9', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD($lastDate, \"1\", -5),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\tIF(\n\t\t\t\t$tend = 3,\n\t\t\t\tSELECT(\n\t\t\t\t\t!'c06ce7d9',\n\t\t\t\t\tBETWEEN(\n\t\t\t\t\t\tDATE(!'c06ce7d9', \"dd-MMM-yyyy\"),\n\t\t\t\t\t\tDATE_ADD($lastDate, \"1\", -10),\n\t\t\t\t\t\t$lastDate\n\t\t\t\t\t)\n\t\t\t\t),\n\t\t\t\t!'c06ce7d9'\n\t\t\t)\n\t\t)\n\t)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"8825f263","type":"data_slot","fmt":"txt","dstContext":{"kid":"0ceff9be7d07f6d7e11b425e26aa2e77","id":"dst8825f263"}},{"role":"data","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":false,"name":"fecha data","isDstRoot":true,"id":"c06ce7d9","type":"data_slot","fmt":"dat2","dstContext":{"kid":"0ceff9be7d07f6d7e11b425e26aa2e77","id":"dstc06ce7d9"}}],"displayName":"Table","id":"9d973b3d","type":"table","dstContext":{"ops":[{"groupBy":"5c95efc3","type":"group"},{"sortBy":[{"dim":"5c95efc3","dir":1.0}],"type":"sort"}],"kid":"0ceff9be7d07f6d7e11b425e26aa2e77","id":"dst9d973b3d","aggs":{"c06ce7d9":"auto","252f4d0a10":"auto","55ba747b38":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","id":"662c6fd7","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Miles de Dólares"]],"displayName":"Label 3 Copy","formulas":[{"txt":"LOOKUP($label1,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,E:E;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"0ceff9be7d07f6d7e11b425e26aa2e77","id":"dst44a5438d"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"44a5438d","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"renderer":"line","role":"series","data":[[4013060.698,4837608.303,4685478.758,4909108.588,4817861.938,4548417.798,3990695.089,3953096.9,4254840.146,4657906.647,5306702.387,5200475.429,4722033.243]],"color":"cx-theme_888","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"2623ae78","chartStyle":"points_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"id":"62a14b60"},{"role":"axis_x","data":[["11/22","12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23","10/23","11/23"]],"displayName":"Untitled","formulas":[{"txt":"!'8825f263'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"850e0e35","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{},"id":"2623ae78","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"fe8320ef","type":"chart_series","dstContext":{"ops":[{"groupBy":"850e0e35","type":"group"},{"p":{"args":[{"args":[{"dim":"850e0e35"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"850e0e35","variation":"member"},{"sortBy":[{"dim":"850e0e35","dir":1.0}],"type":"sort"}],"kid":"0ceff9be7d07f6d7e11b425e26aa2e77","id":"dstfe8320ef","aggs":{"4bb9f57341":"auto","62a14b60":"sum"}},"height":"3"}],"displayName":"Layout Grid","id":"edf4530b","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"2c72b4e0","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"69886966216c6506167e26623c22d01d","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"0ceff9be7d07f6d7e11b425e26aa2e77"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Ingresos fiscales"]],"displayName":"Label","formulas":[{"txt":"\"Ingresos fiscales\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"59859986df2c247defe3aec00b44dc83","id":"dst0aabe978"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"0aabe978","wrap":"active"},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"59859986df2c247defe3aec00b44dc83","id":"dste641b31c"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"e641b31c","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"538ed963","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"86a052fc","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"4cb89dc1","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"9662a7f3","type":"input","dstContext":{"kid":"59859986df2c247defe3aec00b44dc83","id":"dst9662a7f3"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["ingr.fg","in.rec.ivu"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"OTROS INDICES ECONOMICOS\")","ver":2.0}],"autoFmt":false,"id":"7a186722","type":"proxy"},{"role":"labels","data":[["Ingresos Netos al Fondo General (Miles de Dólares)","Recaudos por concepto del Impuesto sobre Ventas y Usos (IVU) Tasa del 11.5%"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"LOOKUP(&'7a186722',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"2d564053","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"f6afc1ad","type":"input","dstContext":{"ops":[{"groupBy":"7a186722","type":"group"},{"p":{"args":[{"dim":"2d564053"},{"args":[{"value":"\"Ingresos Netos al Fondo General (Miles de Dólares)\""},{"value":"\"Recaudos por concepto del Impuesto sobre Ventas y Usos (IVU) Tasa del 11.5%\""},{"value":"\"Precios Promedios Mensuales de Gasolina al detal en Puerto Rico\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"2d564053","variation":"member"}],"kid":"59859986df2c247defe3aec00b44dc83","id":"dstf6afc1ad","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"60547a1c"},{"role":"data","data":[["1-Nov-2022","1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023","1-Oct-2023","1-Nov-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\n\t\"lastDate\",\n\tMAX(\n\t\tDATE(!'52154390', \"dd-MMM-yyyy\")\n\t),\n\tIF(\n\t\t$tend = 1,\n\t\tSELECT(\n\t\t\t!'52154390',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'52154390', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD($lastDate, \"1\", -1),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 2,\n\t\t\tSELECT(\n\t\t\t\t!'52154390',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'52154390', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD($lastDate, \"1\", -5),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\tIF(\n\t\t\t\t$tend = 3,\n\t\t\t\tSELECT(\n\t\t\t\t\t!'52154390',\n\t\t\t\t\tBETWEEN(\n\t\t\t\t\t\tDATE(!'52154390', \"dd-MMM-yyyy\"),\n\t\t\t\t\t\tDATE_ADD($lastDate, \"1\", -10),\n\t\t\t\t\t\t$lastDate\n\t\t\t\t\t)\n\t\t\t\t),\n\t\t\t\t!'52154390'\n\t\t\t)\n\t\t)\n\t)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"310d70aa","type":"data_slot","fmt":"txt","dstContext":{"kid":"59859986df2c247defe3aec00b44dc83","id":"dst310d70aa"}},{"role":"data","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"dd/MM/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":false,"name":"fecha data","isDstRoot":true,"id":"52154390","type":"data_slot","fmt":"dat2","dstContext":{"kid":"59859986df2c247defe3aec00b44dc83","id":"dst52154390"}}],"displayName":"Table","id":"75281a0c","type":"table","dstContext":{"ops":[{"groupBy":"60547a1c","type":"group"},{"sortBy":[{"dim":"60547a1c","dir":1.0}],"type":"sort"}],"kid":"59859986df2c247defe3aec00b44dc83","id":"dst75281a0c","aggs":{"52154390":"auto","252f4d0a10":"auto","55ba747b38":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","id":"eac2f039","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Miles de Dólares"]],"displayName":"Label 3 Copy","formulas":[{"txt":"LOOKUP($label1,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,E:E;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"59859986df2c247defe3aec00b44dc83","id":"dst5d901156"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"5d901156","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"renderer":"line","role":"series","data":[[434544.0,467024.0,564390.0,437717.0,458015.0,859982.0,553959.0,403218.0,547914.0,868793.0,651228.0,696829.0,394944.0]],"color":"cx-theme_red_3","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"7ba4ccf9","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"4"},"id":"6a5b4082"},{"role":"axis_x","data":[["11/22","12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23","10/23","11/23"]],"displayName":"Untitled","formulas":[{"txt":"!'310d70aa'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"9a83db8d","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{},"id":"7ba4ccf9","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"21315551","type":"chart_series","dstContext":{"ops":[{"groupBy":"9a83db8d","type":"group"},{"p":{"args":[{"args":[{"dim":"9a83db8d"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"9a83db8d","variation":"member"},{"sortBy":[{"dim":"9a83db8d","dir":1.0}],"type":"sort"}],"kid":"59859986df2c247defe3aec00b44dc83","id":"dst21315551","aggs":{"6a5b4082":"auto","4bb9f57341":"auto"}},"height":"3"}],"displayName":"Layout Grid","id":"adbf7695","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"532fb3f7","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"a06152e5457c2e4a54ae0fa9223bc7f6","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"59859986df2c247defe3aec00b44dc83"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Índice de Actividad Económica Mensual"]],"displayName":"Label","formulas":[{"txt":"\"Índice de Actividad Económica Mensual\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"5a94b9bf4ee2f902484e57dc917aa3e7","id":"dst0bd93813"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"0bd93813","wrap":true},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"5a94b9bf4ee2f902484e57dc917aa3e7","id":"dst47d6c699"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"47d6c699","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"29be86be","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"08ad2642","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"47786673","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"234be414","type":"input","dstContext":{"kid":"5a94b9bf4ee2f902484e57dc917aa3e7","id":"dst234be414"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["indice.bde"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"OTROS INDICES ECONOMICOS\")","ver":2.0}],"autoFmt":false,"id":"58caf923","type":"proxy"},{"role":"labels","data":[["Índice de Actividad Económica del Banco de Desarrollo Económico (Ene-1980 = 100)"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"LOOKUP(&'58caf923',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"602ae058","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"64415216","type":"input","dstContext":{"ops":[{"groupBy":"58caf923","type":"group"},{"p":{"args":[{"dim":"602ae058"},{"args":[{"value":"\"Índice de Actividad Económica del Banco de Desarrollo Económico (Ene-1980 = 100)\""},{"value":"\"PNB\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"602ae058","variation":"member"}],"kid":"5a94b9bf4ee2f902484e57dc917aa3e7","id":"dst64415216","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"91712af5"},{"role":"data","data":[["1-Nov-2022","1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023","1-Oct-2023","1-Nov-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\n\t\"lastDate\",\n\tMAX(\n\t\tDATE(!'3effb88f', \"dd-MMM-yyyy\")\n\t),\n\tIF(\n\t\t$tend = 1,\n\t\tSELECT(\n\t\t\t!'3effb88f',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'3effb88f', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD($lastDate, \"1\", -1),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 2,\n\t\t\tSELECT(\n\t\t\t\t!'3effb88f',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'3effb88f', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD($lastDate, \"1\", -5),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\tIF(\n\t\t\t\t$tend = 3,\n\t\t\t\tSELECT(\n\t\t\t\t\t!'3effb88f',\n\t\t\t\t\tBETWEEN(\n\t\t\t\t\t\tDATE(!'3effb88f', \"dd-MMM-yyyy\"),\n\t\t\t\t\t\tDATE_ADD($lastDate, \"1\", -10),\n\t\t\t\t\t\t$lastDate\n\t\t\t\t\t)\n\t\t\t\t),\n\t\t\t\t!'3effb88f'\n\t\t\t)\n\t\t)\n\t)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"d3eb3f2f","type":"data_slot","fmt":"txt","dstContext":{"kid":"5a94b9bf4ee2f902484e57dc917aa3e7","id":"dstd3eb3f2f"}},{"role":"data","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"dd/MM/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":false,"name":"fecha data","isDstRoot":true,"id":"3effb88f","type":"data_slot","fmt":"dat2","dstContext":{"kid":"5a94b9bf4ee2f902484e57dc917aa3e7","id":"dst3effb88f"}}],"displayName":"Table","id":"4379eb8b","type":"table","dstContext":{"ops":[{"groupBy":"91712af5","type":"group"},{"sortBy":[{"dim":"91712af5","dir":1.0}],"type":"sort"}],"kid":"5a94b9bf4ee2f902484e57dc917aa3e7","id":"dst4379eb8b","aggs":{"252f4d0a10":"auto","3effb88f":"auto","55ba747b38":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","widths":[{"w":"50%","x":1.0}],"id":"21bcb8e1","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":1.0,"y":0.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Índice"]],"displayName":"Label 3 Copy","formulas":[{"txt":"LOOKUP($label1,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,E:E;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"5a94b9bf4ee2f902484e57dc917aa3e7","id":"dst75c29392"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"75c29392","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"renderer":"line","role":"series","data":[[151.3,151.5,150.9,150.3,149.5,148.7,149.1,149.8,149.7,149.3,148.9,150.3,151.8]],"color":"cx-theme_red_3","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"8cd26702","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"1"},"id":"32b86730"},{"role":"axis_x","data":[["11/22","12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23","10/23","11/23"]],"displayName":"Untitled","formulas":[{"txt":"!'d3eb3f2f'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"aabb312b","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{},"id":"8cd26702","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"1d062617","type":"chart_series","dstContext":{"ops":[{"groupBy":"aabb312b","type":"group"},{"p":{"args":[{"args":[{"dim":"aabb312b"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"aabb312b","variation":"member"},{"sortBy":[{"dim":"aabb312b","dir":1.0}],"type":"sort"}],"kid":"5a94b9bf4ee2f902484e57dc917aa3e7","id":"dst1d062617","aggs":{"4bb9f57341":"auto","32b86730":"auto"}},"height":"3"}],"displayName":"Layout Grid","id":"547703d4","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"293b980d","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"3cdcaf6e326eba996e203765f0913f8d","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"5a94b9bf4ee2f902484e57dc917aa3e7"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Turismo"]],"displayName":"Label","formulas":[{"txt":"\"Turismo\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"d0f1af7a5c26861a0489700ebaaedb8f","id":"dst7bea863f"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"7bea863f","wrap":true},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"d0f1af7a5c26861a0489700ebaaedb8f","id":"dstf30ee931"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"f30ee931","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"46a27b32","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"b2c144f6","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"691d9f8f","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"015cdfc3","type":"input","dstContext":{"kid":"d0f1af7a5c26861a0489700ebaaedb8f","id":"dst015cdfc3"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["tur.hot.par","ocup.hot"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"TURISMO\")","ver":2.0}],"autoFmt":false,"id":"4c2462cd","type":"proxy"},{"role":"labels","data":[["Total de Registros en Hoteles y Paradores (Número de Registros)","Tasa de Ocupación en Hoteles (%)"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"LOOKUP(&'4c2462cd',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"ee744350","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"9ea1bb41","type":"input","dstContext":{"ops":[{"groupBy":"4c2462cd","type":"group"},{"p":{"args":[{"args":[{"dim":"4c2462cd"},{"args":[{"value":"\"Label\""},{"value":"\"var_code\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"4c2462cd","variation":"member"}],"kid":"d0f1af7a5c26861a0489700ebaaedb8f","id":"dst9ea1bb41","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"8afeb13f"},{"role":"data","data":[["1-Nov-2022","1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023","1-Oct-2023","1-Nov-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\n\t\"lastDate\",\n\tMAX(\n\t\tDATE(!'d1bc107a', \"dd-MMM-yyyy\")\n\t),\n\tIF(\n\t\t$tend = 1,\n\t\tSELECT(\n\t\t\t!'d1bc107a',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'d1bc107a', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD($lastDate, \"1\", -1),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 2,\n\t\t\tSELECT(\n\t\t\t\t!'d1bc107a',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'d1bc107a', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD($lastDate, \"1\", -5),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\tIF(\n\t\t\t\t$tend = 3,\n\t\t\t\tSELECT(\n\t\t\t\t\t!'d1bc107a',\n\t\t\t\t\tBETWEEN(\n\t\t\t\t\t\tDATE(!'d1bc107a', \"dd-MMM-yyyy\"),\n\t\t\t\t\t\tDATE_ADD($lastDate, \"1\", -10),\n\t\t\t\t\t\t$lastDate\n\t\t\t\t\t)\n\t\t\t\t),\n\t\t\t\t!'d1bc107a'\n\t\t\t)\n\t\t)\n\t)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"09a995fa","type":"data_slot","fmt":"txt","dstContext":{"kid":"d0f1af7a5c26861a0489700ebaaedb8f","id":"dst09a995fa"}},{"role":"data","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"dd/MM/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":false,"name":"fecha data","isDstRoot":true,"id":"d1bc107a","type":"data_slot","fmt":"dat2","dstContext":{"kid":"d0f1af7a5c26861a0489700ebaaedb8f","id":"dstd1bc107a"}}],"displayName":"Table","id":"dde57209","type":"table","dstContext":{"ops":[{"groupBy":"8afeb13f","type":"group"},{"sortBy":[{"dim":"8afeb13f","dir":1.0}],"type":"sort"}],"kid":"d0f1af7a5c26861a0489700ebaaedb8f","id":"dstdde57209","aggs":{"252f4d0a10":"auto","55ba747b38":"auto","d1bc107a":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","id":"79ec92d5","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Registros"]],"displayName":"Label 3 Copy","formulas":[{"txt":"LOOKUP($label1,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,E:E;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"d0f1af7a5c26861a0489700ebaaedb8f","id":"dst4650de8b"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"4650de8b","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"series","data":[[176434.0,136344.0,104617.0,116172.0,125838.0,123021.0,136881.0,147009.0,154722.0,157345.0,143398.0,152311.0,179368.0]],"color":"cx-theme_888","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"6bdc0059","chartStyle":"points_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"id":"7846046f"},{"role":"axis_x","data":[["11/22","12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23","10/23","11/23"]],"displayName":"Untitled","formulas":[{"txt":"!'09a995fa'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"01f89890","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{},"id":"6bdc0059","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"6f68116d","type":"chart_series","dstContext":{"ops":[{"groupBy":"01f89890","type":"group"},{"p":{"args":[{"args":[{"dim":"01f89890"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"01f89890","variation":"member"},{"sortBy":[{"dim":"01f89890","dir":1.0}],"type":"sort"}],"kid":"d0f1af7a5c26861a0489700ebaaedb8f","id":"dst6f68116d","aggs":{"4bb9f57341":"auto","7846046f":"auto"}},"height":"3"}],"displayName":"Layout Grid","id":"acd2b4d6","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"412abfd6","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"130cb7bbf63576e87322a01abea20297","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"d0f1af7a5c26861a0489700ebaaedb8f"},{"showToolbar":false,"workspace":{"datasources":["6311a5cea2e0bb21ebc34c07bf8d17b1","0243d4c2d0ee0252a60196b523ae55a4"],"dimensions":{"w":904.0}},"components":[{"components":[{"data":[["https://tudashboard.com/wp-content/uploads/2020/09/Logo-estudios-tecnicos.png"]],"horizAlign":1.0,"displayName":"Image Copy","formulas":[{"txt":"\"https://tudashboard.com/wp-content/uploads/2020/09/Logo-estudios-tecnicos.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"61f866c863b66538eec29a6f3962b14b","id":"dst3aee782a"},"layoutConfig":{"x":0.0,"y":0.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"3aee782a","customHeightVal":"120","height":"cust"},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"data":[["Menu"]],"displayName":"Label","formulas":[{"txt":"\"Menu\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"txt","dstContext":{"kid":"61f866c863b66538eec29a6f3962b14b","id":"dstd8ad09d118"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"d8ad09d1-18","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["Empleo | #51d89686a0c20aaf1dff31789f24156f","Ventas al detal | #a0b42ec56e3fe65bd42877f0e753b9e8","Turismo | #130cb7bbf63576e87322a01abea20297","Transportacion | #6946481a3c3739d460201e968f15d2cd","Otros | #2f855852d48a2481075276c1ceaa7d52","Quiebras | #eb25d6f4ffe66ce572793fab520e48b1",""]],"displayName":"Menu","formulas":[{"txt":"ARRAY(\"Empleo | #51d89686a0c20aaf1dff31789f24156f\",\"Ventas al detal | #a0b42ec56e3fe65bd42877f0e753b9e8\",\"Turismo | #130cb7bbf63576e87322a01abea20297\",\"Transportacion | #6946481a3c3739d460201e968f15d2cd\",\"Otros | #2f855852d48a2481075276c1ceaa7d52\",\"Quiebras | #eb25d6f4ffe66ce572793fab520e48b1\")","ver":2.0}],"autoFmt":false,"index":0.0,"type":"table_col","fmt":"hyp","align":"c","borderLeft":"1","size":"xx-small","namerenamed":true,"borderRight":"0","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"name":"Menu","id":"c1d5f702-2","conditions":[{"predicates":[{"left":{"self":1.0}}],"reactions":[{"type":"color","value":"cx-theme_green_3"}]}]},{"components":[],"customHeader":false,"role":"tcol","data":[["Inflación | #434ccaa55b9d083e177be48d09255e2c","Vivienda | #bd01cd2dae495088af0f73dfd47eaa22","Producción Energía Eléctrica | #5cea82319a0eddcda8eb7b3eba2d1968","Comercio Exterior | #69886966216c6506167e26623c22d01d","Ingresos Fiscales | #a06152e5457c2e4a54ae0fa9223bc7f6","Índice de crecimiento económico | #3cdcaf6e326eba996e203765f0913f8d","Crecimiento PNB | #af384878de955611132ea0521e6e74ad"]],"displayName":"New Column","formulas":[{"txt":"ARRAY(\"Inflación | #434ccaa55b9d083e177be48d09255e2c\",\"Vivienda | #bd01cd2dae495088af0f73dfd47eaa22\",\"Producción Energía Eléctrica | #5cea82319a0eddcda8eb7b3eba2d1968\",\"Comercio Exterior | #69886966216c6506167e26623c22d01d\",\"Ingresos Fiscales | #a06152e5457c2e4a54ae0fa9223bc7f6\",\"Índice de crecimiento económico | #3cdcaf6e326eba996e203765f0913f8d\",\"Crecimiento PNB | #af384878de955611132ea0521e6e74ad\")","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"hyp","align":"c","borderLeft":"1","size":"xx-small","borderRight":"0","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"name":"New Column","id":"eb6e1919-14","wrap":"active"}],"maxRows":100000.0,"displayName":"Table","tableRowsType":"all","showHeader":false,"id":"65b5dd35-1","type":"table","dstContext":{"kid":"61f866c863b66538eec29a6f3962b14b","id":"dst65b5dd351"},"showBorder":false}],"displayName":"Layout Grid 3","id":"0887eab9-17","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 2","widths":[{"w":"35%","x":2.0}],"id":"fd3d62b9","cellData":[{"x":1.0,"y":0.0,"cellPadding":[25.0,0.0,0.0,0.0]},{"x":0.0,"y":0.0,"alignment":1.0},{"x":2.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":3.0},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"tpl":"

Descripción

\n\n

Este visualizador presenta los indicadores mensuales más importantes que publica la Junta de Planificación de Puerto Rico. El mismo está compuesto en una primera sección por unos iconos que presentan un resumen gráfico de varios indicadores importantes sobre la economía de Puerto Rico. Las flechas verdes (hacia arriba) o rojas (hacia abajo) indican si el último movimiento del indicador aumentó o disminuyó. Al lado de las unidades del indicador (\"dólares\" o \"sacos\") se indica con una \"Y\", \"Q\" o \"M\" si el indicador es anual, trimestral o mensual.\n\n

En la sección de las gráficas, podrá seleccionar varios indicadores relacionados al tema oprimiendo la caja a la derecha de la palabra \"Indicador\". En \"Tendencia\" al lado izquierdo de cada gráfica podrá ver los datos para 1, 5, 10 años o toda la historia del mismo. También, si oprime alguna serie en particular podrá hacer \"zoom\" y observar en más detalle ese periodo. Cada gráfica cuenta con su valor, solo debe colocar el cursor sobre este para que pueda aparecer.

\n","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"dbab9ea0","type":"html_data","dstContext":{"id":"dstdbab9ea0"}}],"displayName":"HTML Template 2 Copy","id":"12108f6f","type":"html_tpl2","dstContext":{"id":"dst12108f6f"}}],"displayName":"Layout Grid","id":"ac6c0191","cellData":[{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":3.0}],"isForked":false,"titleSize":"new-small","id":"cdd3d184c60b75433724f783a0834f3f","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"titulo y filtros","usesSampleData":false,"master":"61f866c863b66538eec29a6f3962b14b"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Transportación"]],"displayName":"Label","formulas":[{"txt":"\"Transportación\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"8173254d448d907ba4a38371dde67d83","id":"dst69e0071d"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"69e0071d","wrap":true},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"8173254d448d907ba4a38371dde67d83","id":"dst3ee4c213"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"3ee4c213","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"d3299ebd","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"03671f86","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"b7100002","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"997824f4","type":"input","dstContext":{"kid":"8173254d448d907ba4a38371dde67d83","id":"dst997824f4"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["mov.pasa.almm","mov.pasa.bc","mov.carga.sj","p.gas.pg"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"TRANSPORTACIÓN\")","ver":2.0}],"autoFmt":false,"id":"e7b0fff2","type":"proxy"},{"role":"labels","data":[["Movimiento de pasajeros en el aeropuerto Luis Muñoz Marín (SJU)","Movimiento de pasajeros en barcos cruceros (Puerto de San Juan)","Movimiento de carga: Puerto de San Juan (Toneladas)","Precios Promedios Mensuales de Gasolina al detal en Puerto Rico"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"LOOKUP(&'e7b0fff2',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"1eda0bfa","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"c3105c16","type":"input","dstContext":{"ops":[{"groupBy":"e7b0fff2","type":"group"},{"p":{"args":[{"args":[{"dim":"e7b0fff2"},{"args":[{"value":"\"Label\""},{"value":"\"var_code\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"e7b0fff2","variation":"member"}],"kid":"8173254d448d907ba4a38371dde67d83","id":"dstc3105c16","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"e2da1de0"},{"role":"data","data":[["1-Sep-2022","1-Oct-2022","1-Nov-2022","1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\n\t\"lastDate\",\n\tMAX(\n\t\tDATE(!'89737069', \"dd-MMM-yyyy\")\n\t),\n\tIF(\n\t\t$tend = 1,\n\t\tSELECT(\n\t\t\t!'89737069',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'89737069', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD($lastDate, \"1\", -1),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 2,\n\t\t\tSELECT(\n\t\t\t\t!'89737069',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'89737069', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD($lastDate, \"1\", -5),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\tIF(\n\t\t\t\t$tend = 3,\n\t\t\t\tSELECT(\n\t\t\t\t\t!'89737069',\n\t\t\t\t\tBETWEEN(\n\t\t\t\t\t\tDATE(!'89737069', \"dd-MMM-yyyy\"),\n\t\t\t\t\t\tDATE_ADD($lastDate, \"1\", -10),\n\t\t\t\t\t\t$lastDate\n\t\t\t\t\t)\n\t\t\t\t),\n\t\t\t\t!'89737069'\n\t\t\t)\n\t\t)\n\t)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"ed2b749d","type":"data_slot","fmt":"txt","dstContext":{"kid":"8173254d448d907ba4a38371dde67d83","id":"dsted2b749d"}},{"role":"data","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"dd/MM/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":false,"name":"fecha data","isDstRoot":true,"id":"89737069","type":"data_slot","fmt":"dat2","dstContext":{"kid":"8173254d448d907ba4a38371dde67d83","id":"dst89737069"}}],"displayName":"Table","id":"6b8fd227","type":"table","dstContext":{"ops":[{"groupBy":"e2da1de0","type":"group"},{"sortBy":[{"dim":"e2da1de0","dir":1.0}],"type":"sort"}],"kid":"8173254d448d907ba4a38371dde67d83","id":"dst6b8fd227","aggs":{"252f4d0a10":"auto","55ba747b38":"auto","89737069":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","id":"c82462db","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Pasajeros"]],"displayName":"Label 3 Copy","formulas":[{"txt":"LOOKUP($label1,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,E:E;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"8173254d448d907ba4a38371dde67d83","id":"dstbc20b3b8"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"bc20b3b8","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"series","data":[[871540.0,737195.0,498856.0,562111.0,633379.0,764618.0,733203.0,632610.0,801127.0,726002.0,694933.0,831141.0,916865.0]],"color":"#E45565","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"b372908d","chartStyle":"points_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"id":"e2f8f58a"},{"role":"axis_x","data":[["9/22","10/22","11/22","12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23"]],"displayName":"Untitled","formulas":[{"txt":"!'ed2b749d'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"9c0f644a","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{},"id":"b372908d","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"403a2007","type":"chart_series","dstContext":{"ops":[{"groupBy":"9c0f644a","type":"group"},{"p":{"args":[{"args":[{"dim":"9c0f644a"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"9c0f644a","variation":"member"},{"sortBy":[{"dim":"9c0f644a","dir":1.0}],"type":"sort"}],"kid":"8173254d448d907ba4a38371dde67d83","id":"dst403a2007","aggs":{"e2f8f58a":"auto","4bb9f57341":"auto"}},"height":"3"}],"displayName":"Layout Grid","id":"e5b3b6b2","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"f1065f97","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"6946481a3c3739d460201e968f15d2cd","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"8173254d448d907ba4a38371dde67d83"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Vivienda"]],"displayName":"Label","formulas":[{"txt":"\"Vivienda\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"e48f1decca7fa3809f85959ce5fb2a85","id":"dst45083f6d"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"45083f6d","wrap":true},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"e48f1decca7fa3809f85959ce5fb2a85","id":"dst9659f78b"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"9659f78b","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"f44c7c2f","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"d37fdf77","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"6a5e9c5c","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"6723456b","type":"input","dstContext":{"kid":"e48f1decca7fa3809f85959ce5fb2a85","id":"dst6723456b"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["const.tot.units","const.repos"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"OTROS INDICES ECONOMICOS\")","ver":2.0}],"autoFmt":false,"id":"83825383","type":"proxy"},{"role":"labels","data":[["Unidades de Vivienda Vendidas en Puerto Rico (Número)","Unidades Residenciales Reposeídas (Número)"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"LOOKUP(&'83825383',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"ff823bab","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"0a3e3bf7","type":"input","dstContext":{"ops":[{"groupBy":"83825383","type":"group"},{"p":{"args":[{"dim":"ff823bab"},{"args":[{"value":"\"Unidades de Vivienda Vendidas en Puerto Rico (Número)\""},{"value":"\"Unidades Residenciales Reposeídas (Número)\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"ff823bab","variation":"member"}],"kid":"e48f1decca7fa3809f85959ce5fb2a85","id":"dst0a3e3bf7","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"399bc4d1"},{"role":"data","data":[["1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023","1-Oct-2023","1-Nov-2023","1-Dec-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\n\t\"lastDate\",\n\tMAX(\n\t\tDATE(!'79af492b', \"dd-MMM-yyyy\")\n\t),\n\tIF(\n\t\t$tend = 1,\n\t\tSELECT(\n\t\t\t!'79af492b',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'79af492b', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD($lastDate, \"1\", -1),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 2,\n\t\t\tSELECT(\n\t\t\t\t!'79af492b',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'79af492b', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD($lastDate, \"1\", -5),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\tIF(\n\t\t\t\t$tend = 3,\n\t\t\t\tSELECT(\n\t\t\t\t\t!'79af492b',\n\t\t\t\t\tBETWEEN(\n\t\t\t\t\t\tDATE(!'79af492b', \"dd-MMM-yyyy\"),\n\t\t\t\t\t\tDATE_ADD($lastDate, \"1\", -10),\n\t\t\t\t\t\t$lastDate\n\t\t\t\t\t)\n\t\t\t\t),\n\t\t\t\t!'79af492b'\n\t\t\t)\n\t\t)\n\t)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"79821598","type":"data_slot","fmt":"txt","dstContext":{"kid":"e48f1decca7fa3809f85959ce5fb2a85","id":"dst79821598"}},{"role":"data","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"dd/MM/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":false,"name":"fecha data","isDstRoot":true,"id":"79af492b","type":"data_slot","fmt":"dat2","dstContext":{"kid":"e48f1decca7fa3809f85959ce5fb2a85","id":"dst79af492b"}}],"displayName":"Table","id":"4f5b85cc","type":"table","dstContext":{"ops":[{"groupBy":"399bc4d1","type":"group"},{"sortBy":[{"dim":"399bc4d1","dir":1.0}],"type":"sort"}],"kid":"e48f1decca7fa3809f85959ce5fb2a85","id":"dst4f5b85cc","aggs":{"79af492b":"auto","252f4d0a10":"auto","55ba747b38":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","id":"a1c06ece","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Unidades"]],"displayName":"Label 3 Copy","formulas":[{"txt":"LOOKUP($label1,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,E:E;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"e48f1decca7fa3809f85959ce5fb2a85","id":"dst7e1763a1"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"7e1763a1","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"series","data":[[846.0,1448.0,1074.0,1248.0,1022.0,1098.0,1395.0,1578.0,1563.0,1747.0,1529.0,1165.0,1275.0]],"color":"cx-theme_888","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"3466a05b","chartStyle":"points_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"id":"44e6204c"},{"role":"axis_x","data":[["12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23","10/23","11/23","12/23"]],"displayName":"Untitled","formulas":[{"txt":"!'79821598'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"b6b5aa23","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{},"id":"3466a05b","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"670efe81","type":"chart_series","dstContext":{"ops":[{"groupBy":"b6b5aa23","type":"group"},{"p":{"args":[{"args":[{"dim":"b6b5aa23"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"b6b5aa23","variation":"member"},{"sortBy":[{"dim":"b6b5aa23","dir":1.0}],"type":"sort"}],"kid":"e48f1decca7fa3809f85959ce5fb2a85","id":"dst670efe81","aggs":{"44e6204c":"auto","4bb9f57341":"auto"}},"height":"3"}],"displayName":"Layout Grid","id":"6168f430","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"0245daf5","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"bd01cd2dae495088af0f73dfd47eaa22","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"e48f1decca7fa3809f85959ce5fb2a85"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Otros Indicadores Económicos"]],"displayName":"Label","formulas":[{"txt":"\"Otros Indicadores Económicos\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"bf9d21d26bfc1c51def9a6128c3c0566","id":"dst5989dfb9"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"5989dfb9","wrap":"active"},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"bf9d21d26bfc1c51def9a6128c3c0566","id":"dstf68425fb"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"f68425fb","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"c0066708","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"0a96fd3c","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"b8b77239","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"15da9278","type":"input","dstContext":{"kid":"bf9d21d26bfc1c51def9a6128c3c0566","id":"dst15da9278"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["Auto.Total","cement.1"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"OTROS INDICES ECONOMICOS\")","ver":2.0}],"autoFmt":false,"id":"429d7402","type":"proxy"},{"role":"labels","data":[["Autos","Cemento"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"LOOKUP(&'429d7402',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"a06c1f2f","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"d7301b50","type":"input","dstContext":{"ops":[{"groupBy":"429d7402","type":"group"},{"p":{"args":[{"args":[{"dim":"a06c1f2f"},{"args":[{"value":"\"Inflación respecto al mismo mes del año anterior\""},{"value":"\"Ingresos Netos al Fondo General (Miles de Dólares)\""},{"value":"\"PNB\""},{"value":"\"Producción de Energía Eléctrica (Millones de Kilovatios / Hora)\""},{"value":"\"Recaudos por concepto del Impuesto sobre Ventas y Usos (IVU) Tasa del 11.5%\""},{"value":"\"Total de Exportaciones (Miles de Dólares)\""},{"value":"\"Total de Quiebras en Puerto Rico (Número)\""},{"value":"\"Unidades de Vivienda Vendidas en Puerto Rico (Número)\""},{"value":"\"Unidades Residenciales Reposeídas (Número)\""},{"value":"\"Índice de Actividad Económica del Banco de Desarrollo Económico (Ene-1980 = 100)\""},{"value":"\"Índice de Precios al Consumidor (Todos los Grupos)\""},{"value":"\"Producto Nacional Bruto\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"a06c1f2f","variation":"member"}],"kid":"bf9d21d26bfc1c51def9a6128c3c0566","id":"dstd7301b50","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"9491d8b7"},{"role":"data","data":[["1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023","1-Oct-2023","1-Nov-2023","1-Dec-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\n\t\"lastDate\",\n\tMAX(\n\t\tDATE(!'ddfe9450', \"dd-MMM-yyyy\")\n\t),\n\tIF(\n\t\t$tend = 1,\n\t\tSELECT(\n\t\t\t!'ddfe9450',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'ddfe9450', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD($lastDate, \"1\", -1),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 2,\n\t\t\tSELECT(\n\t\t\t\t!'ddfe9450',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'ddfe9450', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD($lastDate, \"1\", -5),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\tIF(\n\t\t\t\t$tend = 3,\n\t\t\t\tSELECT(\n\t\t\t\t\t!'ddfe9450',\n\t\t\t\t\tBETWEEN(\n\t\t\t\t\t\tDATE(!'ddfe9450', \"dd-MMM-yyyy\"),\n\t\t\t\t\t\tDATE_ADD($lastDate, \"1\", -10),\n\t\t\t\t\t\t$lastDate\n\t\t\t\t\t)\n\t\t\t\t),\n\t\t\t\t!'ddfe9450'\n\t\t\t)\n\t\t)\n\t)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"2fa023cb","type":"data_slot","fmt":"txt","dstContext":{"kid":"bf9d21d26bfc1c51def9a6128c3c0566","id":"dst2fa023cb"}},{"role":"data","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"MM/dd/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":false,"name":"fecha data","isDstRoot":true,"id":"ddfe9450","type":"data_slot","fmt":"dat2","dstContext":{"kid":"bf9d21d26bfc1c51def9a6128c3c0566","id":"dstddfe9450"}}],"displayName":"Table","id":"b841061e","type":"table","dstContext":{"ops":[{"groupBy":"9491d8b7","type":"group"},{"sortBy":[{"dim":"9491d8b7","dir":1.0}],"type":"sort"}],"kid":"bf9d21d26bfc1c51def9a6128c3c0566","id":"dstb841061e","aggs":{"ddfe9450":"auto","252f4d0a10":"auto","55ba747b38":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","id":"7e71bbac","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Autos"]],"displayName":"Label 3 Copy","formulas":[{"txt":"LOOKUP($label1,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,E:E;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"bf9d21d26bfc1c51def9a6128c3c0566","id":"dstc7f2df05"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"c7f2df05","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"renderer":"line","role":"series","data":[[6328.0,7027.0,6672.0,6499.0,7381.0,9533.0,6354.0,6430.0,7079.0,5616.0,6546.0,7685.0,5661.0]],"color":"cx-theme_red_3","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"80ced84c","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"1"},"id":"1df15ae1"},{"role":"axis_x","data":[["12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23","10/23","11/23","12/23"]],"displayName":"Untitled","formulas":[{"txt":"!'2fa023cb'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"affa6a6f","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{},"id":"80ced84c","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"086fd31d","type":"chart_series","dstContext":{"ops":[{"groupBy":"affa6a6f","type":"group"},{"p":{"args":[{"args":[{"dim":"affa6a6f"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"affa6a6f","variation":"member"},{"sortBy":[{"dim":"affa6a6f","dir":1.0}],"type":"sort"}],"kid":"bf9d21d26bfc1c51def9a6128c3c0566","id":"dst086fd31d","aggs":{"1df15ae1":"auto","4bb9f57341":"auto"}},"height":"3"}],"displayName":"Layout Grid","id":"b20f1deb","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"06330ffb","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"2f855852d48a2481075276c1ceaa7d52","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"bf9d21d26bfc1c51def9a6128c3c0566"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Quiebras"]],"displayName":"Label","formulas":[{"txt":"\"Quiebras\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"305e8693add7b7a264c6d3cf0c4876d1","id":"dstef3d38d8"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"ef3d38d8","wrap":true},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"305e8693add7b7a264c6d3cf0c4876d1","id":"dst8836eee6"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"8836eee6","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"2287cb20","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"eb76d049","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"317ae4ef","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"51d66c65","type":"input","dstContext":{"kid":"305e8693add7b7a264c6d3cf0c4876d1","id":"dst51d66c65"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["tot.quiebra"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"OTROS INDICES ECONOMICOS\")","ver":2.0}],"autoFmt":false,"id":"c3b9656e","type":"proxy"},{"role":"labels","data":[["Total de Quiebras en Puerto Rico (Número)"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"LOOKUP(&'c3b9656e',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"dc28cecd","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"fe2bd089","type":"input","dstContext":{"ops":[{"groupBy":"c3b9656e","type":"group"},{"p":{"args":[{"dim":"c3b9656e"},{"args":[{"value":"\"tot.quiebra\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"c3b9656e","variation":"member"}],"kid":"305e8693add7b7a264c6d3cf0c4876d1","id":"dstfe2bd089","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"c12de293"},{"role":"data","data":[["1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023","1-Oct-2023","1-Nov-2023","1-Dec-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\n\t\"lastDate\",\n\tMAX(\n\t\tDATE(!'97aae846', \"dd-MMM-yyyy\")\n\t),\n\tIF(\n\t\t$tend = 1,\n\t\tSELECT(\n\t\t\t!'97aae846',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'97aae846', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD($lastDate, \"1\", -1),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 2,\n\t\t\tSELECT(\n\t\t\t\t!'97aae846',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'97aae846', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD($lastDate, \"1\", -5),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\tIF(\n\t\t\t\t$tend = 3,\n\t\t\t\tSELECT(\n\t\t\t\t\t!'97aae846',\n\t\t\t\t\tBETWEEN(\n\t\t\t\t\t\tDATE(!'97aae846', \"dd-MMM-yyyy\"),\n\t\t\t\t\t\tDATE_ADD($lastDate, \"1\", -10),\n\t\t\t\t\t\t$lastDate\n\t\t\t\t\t)\n\t\t\t\t),\n\t\t\t\t!'97aae846'\n\t\t\t)\n\t\t)\n\t)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"dadfd851","type":"data_slot","fmt":"txt","dstContext":{"kid":"305e8693add7b7a264c6d3cf0c4876d1","id":"dstdadfd851"}},{"role":"data","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"dd/MM/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":false,"name":"fecha data","isDstRoot":true,"id":"97aae846","type":"data_slot","fmt":"dat2","dstContext":{"kid":"305e8693add7b7a264c6d3cf0c4876d1","id":"dst97aae846"}}],"displayName":"Table","id":"498d21a3","type":"table","dstContext":{"ops":[{"groupBy":"c12de293","type":"group"},{"sortBy":[{"dim":"c12de293","dir":1.0}],"type":"sort"}],"kid":"305e8693add7b7a264c6d3cf0c4876d1","id":"dst498d21a3","aggs":{"97aae846":"auto","252f4d0a10":"auto","55ba747b38":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","id":"ee4e4619","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Quiebras"]],"displayName":"Label 3 Copy","formulas":[{"txt":"LOOKUP($label1,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,E:E;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"305e8693add7b7a264c6d3cf0c4876d1","id":"dsta434259a"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"a434259a","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"series","data":[[1089.0,1169.0,1140.0,1314.0,976.0,1096.0,839.0,1212.0,1272.0,1075.0,1307.0,1243.0,1258.0]],"color":"cx-theme_red_3","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"0bae90f4","chartStyle":"points_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"id":"2de2679b"},{"role":"axis_x","data":[["12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23","10/23","11/23","12/23"]],"displayName":"Untitled","formulas":[{"txt":"!'dadfd851'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"6c33b8ce","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{},"id":"0bae90f4","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"0c0e61b3","type":"chart_series","dstContext":{"ops":[{"groupBy":"6c33b8ce","type":"group"},{"p":{"args":[{"args":[{"dim":"6c33b8ce"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"6c33b8ce","variation":"member"},{"sortBy":[{"dim":"6c33b8ce","dir":1.0}],"type":"sort"}],"kid":"305e8693add7b7a264c6d3cf0c4876d1","id":"dst0c0e61b3","aggs":{"2de2679b":"auto","4bb9f57341":"auto"}},"height":"3"}],"displayName":"Layout Grid","id":"acfd4053","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"6bec0cdf","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"eb25d6f4ffe66ce572793fab520e48b1","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"305e8693add7b7a264c6d3cf0c4876d1"},{"showToolbar":false,"workspace":{"datasources":["0243d4c2d0ee0252a60196b523ae55a4","0a4226922b41c76251c43004511e6774","9ddcfa4cbadd5672be7499ed89b209bd"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1240.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[["Inflación"]],"displayName":"Label","formulas":[{"txt":"\"Inflación\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#C62537","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"23ce74a63d47d1d4bb788cf72366b93f","id":"dstff97ddba"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"ff97ddba","wrap":true},{"data":[["Menu principal | #cdd3d184c60b75433724f783a0834f3f"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Menu principal | #cdd3d184c60b75433724f783a0834f3f\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"hyp","dstContext":{"kid":"23ce74a63d47d1d4bb788cf72366b93f","id":"dstd6ef3416"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"hypSameTab":"active"},"id":"d6ef3416","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"cx-border_888","displayName":"Separator","id":"9b0527e9","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"values","data":[["1","2","3","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"ARRAY(1,2,3,4)","ver":2.0}],"autoFmt":false,"id":"e88af2a0","type":"proxy"},{"role":"labels","data":[["1 año"," 5 años"," 10 años"," Todos los años"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"1 año, 5 años, 10 años, Todos los años\")","ver":2.0}],"autoFmt":false,"id":"e095607c","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Tendencia","inputType":1.0,"id":"d76712c9","type":"input","dstContext":{"kid":"23ce74a63d47d1d4bb788cf72366b93f","id":"dstd76712c9"},"propName":"tend"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"values","data":[["ipc.p.cons","inf.mes.ant"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SELECT(9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,D:D;=\"OTROS INDICES ECONOMICOS\")","ver":2.0}],"autoFmt":false,"id":"de727552","type":"proxy"},{"role":"labels","data":[["Índice de Precios al Consumidor (Todos los Grupos)","Inflación respecto al mismo mes del año anterior"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"LOOKUP(&'de727552',9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,B:B;)","ver":2.0}],"autoFmt":false,"id":"c523875b","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Indicador","inputType":1.0,"id":"31349f93","type":"input","dstContext":{"ops":[{"groupBy":"de727552","type":"group"},{"p":{"args":[{"dim":"c523875b"},{"args":[{"value":"\"Índice de Precios al Consumidor (Todos los Grupos)\""},{"value":"\"Inflación respecto al mismo mes del año anterior\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"c523875b","variation":"member"}],"kid":"23ce74a63d47d1d4bb788cf72366b93f","id":"dst31349f93","aggs":{}},"propName":"label1"},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Unnamed 1","formulas":[],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Unnamed 1","id":"286c10cc"},{"role":"data","data":[["1-Dec-2022","1-Jan-2023","1-Feb-2023","1-Mar-2023","1-Apr-2023","1-May-2023","1-Jun-2023","1-Jul-2023","1-Aug-2023","1-Sep-2023","1-Oct-2023","1-Nov-2023","1-Dec-2023"]],"displayName":"Fecha","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}}},"formulas":[{"txt":"SET(\n\t\"lastDate\",\n\tMAX(\n\t\tDATE(!'5371b561', \"dd-MMM-yyyy\")\n\t),\n\tIF(\n\t\t$tend = 1,\n\t\tSELECT(\n\t\t\t!'5371b561',\n\t\t\tBETWEEN(\n\t\t\t\tDATE(!'5371b561', \"dd-MMM-yyyy\"),\n\t\t\t\tDATE_ADD($lastDate, \"1\", -1),\n\t\t\t\t$lastDate\n\t\t\t)\n\t\t),\n\t\tIF(\n\t\t\t$tend = 2,\n\t\t\tSELECT(\n\t\t\t\t!'5371b561',\n\t\t\t\tBETWEEN(\n\t\t\t\t\tDATE(!'5371b561', \"dd-MMM-yyyy\"),\n\t\t\t\t\tDATE_ADD($lastDate, \"1\", -5),\n\t\t\t\t\t$lastDate\n\t\t\t\t)\n\t\t\t),\n\t\t\tIF(\n\t\t\t\t$tend = 3,\n\t\t\t\tSELECT(\n\t\t\t\t\t!'5371b561',\n\t\t\t\t\tBETWEEN(\n\t\t\t\t\t\tDATE(!'5371b561', \"dd-MMM-yyyy\"),\n\t\t\t\t\t\tDATE_ADD($lastDate, \"1\", -10),\n\t\t\t\t\t\t$lastDate\n\t\t\t\t\t)\n\t\t\t\t),\n\t\t\t\t!'5371b561'\n\t\t\t)\n\t\t)\n\t)\n)","ver":2.0}],"autoFmt":false,"name":"Fecha","isDstRoot":true,"id":"2e1d5711","type":"data_slot","fmt":"txt","dstContext":{"kid":"23ce74a63d47d1d4bb788cf72366b93f","id":"dst2e1d5711"}},{"role":"data","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"fecha data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"d-MMM-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"dd/MM/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, AND(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3; > 0, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137; = $label1, 6028c5aa106e6ff08a76aa6437175f62#a4f7c01f9c86459f6dbec33c87ca6d03; = 72))","ver":2.0}],"autoFmt":false,"name":"fecha data","isDstRoot":true,"id":"5371b561","type":"data_slot","fmt":"dat2","dstContext":{"kid":"23ce74a63d47d1d4bb788cf72366b93f","id":"dst5371b561"}}],"displayName":"Table","id":"fb7ccfb0","type":"table","dstContext":{"ops":[{"groupBy":"286c10cc","type":"group"},{"sortBy":[{"dim":"286c10cc","dir":1.0}],"type":"sort"}],"kid":"23ce74a63d47d1d4bb788cf72366b93f","id":"dstfb7ccfb0","aggs":{"5371b561":"auto","252f4d0a10":"auto","55ba747b38":"auto","6c3c35599":"auto"}}}],"displayName":"Layout Grid 2","id":"f7c22cfd","cellData":[{"x":0.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":2.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":2.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[["Índice"]],"displayName":"Label 3 Copy","formulas":[{"txt":"LOOKUP($label1,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,A:A;,9ddcfa4cbadd5672be7499ed89b209bd@Hoja 1,E:E;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"txt","dstContext":{"kid":"23ce74a63d47d1d4bb788cf72366b93f","id":"dstf21f6b9c"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"Medida: "},"id":"f21f6b9c","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"renderer":"line","role":"series","data":[[81.81,82.091,82.282,82.428,82.11,82.476,82.715,82.99,83.584,83.764,83.603,84.429,85.045]],"color":"cx-theme_red_3","displayName":"Value","seriesName":"Value","formulas":[{"txt":"SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;, $label1=6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"9948ec47","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"3"},"id":"d99ec9ae"},{"role":"axis_x","data":[["12/22","1/23","2/23","3/23","4/23","5/23","6/23","7/23","8/23","9/23","10/23","11/23","12/23"]],"displayName":"Untitled","formulas":[{"txt":"!'2e1d5711'","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"dat2","labelStagger":"0","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"M/yy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"M/yy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"labelAngle":"auto","id":"fb2c3b16","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"50","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{"precision":"2"},"id":"9948ec47","customInterval":false,"labelDrop":0.0}],"displayName":"Bar/Line Chart","showLegend":false,"zoom":"x","id":"bc4200b9","type":"chart_series","dstContext":{"ops":[{"groupBy":"fb2c3b16","type":"group"},{"p":{"args":[{"args":[{"dim":"fb2c3b16"},{"args":[{"f":"blank","type":"f"},{"value":"\"\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"}],"f":"not","type":"f"},"type":"filter","filterBy":"fb2c3b16","variation":"member"},{"sortBy":[{"dim":"fb2c3b16","dir":1.0}],"type":"sort"}],"kid":"23ce74a63d47d1d4bb788cf72366b93f","id":"dstbc4200b9","aggs":{"d99ec9ae":"sum","4bb9f57341":"auto"}},"height":"3"}],"displayName":"Layout Grid","id":"925f6eb6","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 3","id":"9c0d46df","cellData":[{"w":3.0,"x":0.0,"y":1.0},{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"434ccaa55b9d083e177be48d09255e2c","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"hsitoricos dash2","usesSampleData":false,"master":"23ce74a63d47d1d4bb788cf72366b93f"},{"showToolbar":false,"workspace":{"datasources":["0a4226922b41c76251c43004511e6774","af5da5a133e2d409df95277e8c364a48"],"dataSets":[{"id":"6028c5aa106e6ff08a76aa6437175f62"}],"dimensions":{"w":1089.0}},"components":[{"components":[{"data":[["Resumen de indicadores Económicos de Puerto Rico"]],"displayName":"Label","formulas":[{"txt":"\"Resumen de indicadores Económicos de Puerto Rico\" ","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst68c8b540"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"68c8b540","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"enableClick":false,"data":[["https://tudashboard.com/wp-content/uploads/2020/12/retail.png"]],"horizAlign":1.0,"displayName":"Image","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,F9;","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstd3a8e1c19"},"layoutConfig":{"x":0.0,"y":0.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"d3a8e1c1-9","resizeHeight":"50"},{"data":[["Venta al detal"]],"displayName":"Label 6","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,A9;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst7a326fb68"},"align":"c","layoutConfig":{"x":0.0,"y":1.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"7a326fb6-8","wrap":true},{"data":[["Miles de Dólares (M)"]],"displayName":"Label 4 Copy 2","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,E9;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst9dac4d98"},"align":"c","layoutConfig":{"x":0.0,"y":2.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"9dac4d98","wrap":true},{"data":[[2.026876147319911]],"displayName":"Label 3 Copy 7","formulas":[{"txt":"SET(\"var\", \"tot.v.det\", SELECT(6028c5aa106e6ff08a76aa6437175f62#47dec15eb3f65e87f49df305213378d0;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_fff","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst2b8886cb"},"align":"c","layoutConfig":{"x":0.0,"y":3.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"id":"2b8886cb","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lteq"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}],"wrap":true},{"data":[[3397970.38325897]],"displayName":"Label 2","formulas":[{"txt":"SET(\"var\", \"tot.v.det\", SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var))/1000)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst578a6fc14"},"align":"c","layoutConfig":{"x":0.0,"y":4.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"precision":"2"},"id":"578a6fc1-4"},{"data":[["November 2023"]],"displayName":"Label 5","formulas":[{"txt":"SET(\"var\", \"tot.v.det\", LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"dat2","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst4720d04e7"},"align":"c","layoutConfig":{"x":0.0,"y":5.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"MMMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"id":"4720d04e-7","wrap":true}],"displayName":"Layout Grid 2 Copy 7","id":"de16bb30","cellData":[{"x":0.0,"y":0.0},{"x":0.0,"y":4.0,"cellPadding":[5.0,5.0,0.0,5.0]},{"x":0.0,"y":5.0,"cellPadding":[0.0,5.0,5.0,5.0]}],"type":"panel_grid","rows":6.0,"cols":1.0},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"enableClick":false,"data":[["https://tudashboard.com/wp-content/uploads/2020/12/Cemento.png"]],"horizAlign":1.0,"displayName":"Image Copy","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,F10;","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst2a38bbdb"},"layoutConfig":{"x":0.0,"y":0.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"2a38bbdb","resizeHeight":"50"},{"data":[["Venta de cemento"]],"displayName":"Label 6 Copy","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,A10;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst74193b13"},"align":"c","layoutConfig":{"x":0.0,"y":1.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"74193b13","wrap":true},{"data":[["Bolsas de 94 libras (M)"]],"displayName":"Label 4 Copy 4","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,E10;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstdbee1079"},"align":"c","layoutConfig":{"x":0.0,"y":2.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"dbee1079","wrap":true},{"data":[[-0.6701387734001722]],"displayName":"Label 3 Copy","formulas":[{"txt":"SET(\"var\", \"cement.1\", SELECT(6028c5aa106e6ff08a76aa6437175f62#47dec15eb3f65e87f49df305213378d0;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_fff","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dste94ddd16"},"align":"c","layoutConfig":{"x":0.0,"y":3.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"id":"e94ddd16","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lteq"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}],"wrap":true},{"data":[[643.4]],"displayName":"Label 2 Copy","formulas":[{"txt":"SET(\"var\", \"cement.1\", SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstd47453d8"},"align":"c","layoutConfig":{"x":0.0,"y":4.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"precision":"0"},"id":"d47453d8"},{"data":[["January 2024"]],"displayName":"Label 5 Copy","formulas":[{"txt":"SET(\"var\", \"cement.1\", LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"dat2","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstf428e8bd"},"align":"c","layoutConfig":{"x":0.0,"y":5.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"MMMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"id":"f428e8bd","wrap":true}],"displayName":"Layout Grid 2 Copy","id":"14709b95","cellData":[{"x":0.0,"y":0.0},{"x":0.0,"y":4.0,"cellPadding":[5.0,5.0,0.0,5.0]},{"x":0.0,"y":5.0,"cellPadding":[0.0,5.0,5.0,5.0]}],"type":"panel_grid","rows":6.0,"cols":1.0},{"layoutConfig":{"x":4.0,"y":0.0},"components":[{"enableClick":false,"data":[["https://tudashboard.com/wp-content/uploads/2020/12/Reposeida.png"]],"horizAlign":1.0,"displayName":"Image Copy 2","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,F15;","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstd7fe82e6"},"layoutConfig":{"x":0.0,"y":0.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"d7fe82e6","resizeHeight":"50"},{"data":[["Viviendas Reposeídas"]],"displayName":"Label 6 Copy 2","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,A15;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst03c75806"},"align":"c","layoutConfig":{"x":0.0,"y":1.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"03c75806","wrap":true},{"data":[["Hipotecas (M)"]],"displayName":"Label 4 Copy 3","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,E15;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstce76c40b"},"align":"c","layoutConfig":{"x":0.0,"y":2.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"ce76c40b","wrap":true},{"data":[[-0.9988115171826747]],"displayName":"Label 3 Copy 2","formulas":[{"txt":"SET(\"var\", \"const.repos\", SELECT(6028c5aa106e6ff08a76aa6437175f62#47dec15eb3f65e87f49df305213378d0;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_fff","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst6e698886"},"align":"c","layoutConfig":{"x":0.0,"y":3.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"id":"6e698886","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lteq"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}],"wrap":true},{"data":[[174.0]],"displayName":"Label 2 Copy 2","formulas":[{"txt":"SET(\"var\", \"const.repos\", SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst939b48b3"},"align":"c","layoutConfig":{"x":0.0,"y":4.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"precision":"0"},"id":"939b48b3"},{"data":[["June 2023"]],"displayName":"Label 5 Copy 2","formulas":[{"txt":"SET(\"var\", \"const.repos\", LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"dat2","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst5473a8f8"},"align":"c","layoutConfig":{"x":0.0,"y":5.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"MMMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"id":"5473a8f8","wrap":true}],"displayName":"Layout Grid 2 Copy 2","id":"3dbbfb15","cellData":[{"x":0.0,"y":0.0},{"x":0.0,"y":4.0,"cellPadding":[5.0,5.0,0.0,5.0]},{"x":0.0,"y":5.0,"cellPadding":[0.0,5.0,5.0,5.0]}],"type":"panel_grid","rows":6.0,"cols":1.0},{"layoutConfig":{"x":6.0,"y":0.0},"components":[{"enableClick":false,"data":[["https://tudashboard.com/wp-content/uploads/2020/12/Quiebra.png"]],"horizAlign":1.0,"displayName":"Image Copy 3","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,F8;","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dste71c9d86"},"layoutConfig":{"x":0.0,"y":0.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"e71c9d86","resizeHeight":"50"},{"data":[["Quiebras radicadas"]],"displayName":"Label 6 Copy 3","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,A8;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst989f0b87"},"align":"c","layoutConfig":{"x":0.0,"y":1.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"989f0b87","wrap":true},{"data":[["Quiebras (M)"]],"displayName":"Label 4 Copy 5","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,E8;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstadca07ad"},"align":"c","layoutConfig":{"x":0.0,"y":2.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"adca07ad","wrap":true},{"data":[[2.4556056747954655]],"displayName":"Label 3 Copy 3","formulas":[{"txt":"SET(\"var\", \"tot.quiebra\", SELECT(6028c5aa106e6ff08a76aa6437175f62#47dec15eb3f65e87f49df305213378d0;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_fff","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstb87cc6ad"},"align":"c","layoutConfig":{"x":0.0,"y":3.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"id":"b87cc6ad","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lteq"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}],"wrap":true},{"data":[[438.0]],"displayName":"Label 2 Copy 3","formulas":[{"txt":"SET(\"var\", \"tot.quiebra\", SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst63456302"},"align":"c","layoutConfig":{"x":0.0,"y":4.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"precision":"0"},"id":"63456302"},{"data":[["December 2023"]],"displayName":"Label 5 Copy 3","formulas":[{"txt":"SET(\"var\", \"tot.quiebra\", LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"dat2","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst0c02f4a1"},"align":"c","layoutConfig":{"x":0.0,"y":5.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"MMMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"id":"0c02f4a1","wrap":true}],"displayName":"Layout Grid 2 Copy 3","id":"8c22a14e","cellData":[{"x":0.0,"y":0.0},{"x":0.0,"y":4.0,"cellPadding":[5.0,5.0,0.0,5.0]},{"x":0.0,"y":5.0,"cellPadding":[0.0,5.0,5.0,5.0]}],"type":"panel_grid","rows":6.0,"cols":1.0}],"displayName":"Layout Grid 3","widths":[{"w":"2%","x":5.0},{"w":"2%","x":3.0},{"w":"2%","x":1.0}],"id":"92e1e4a6","cellData":[{"x":5.0,"y":0.0},{"x":3.0,"y":0.0},{"x":1.0,"y":0.0},{"x":0.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":7.0},{"layoutConfig":{"x":0.0,"y":2.0},"line_colour":"cx-border_red_4","displayName":"Separator Copy","id":"a79e54e6","type":"separator","line_style":"ShortDot"},{"layoutConfig":{"x":1.0,"y":3.0},"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","size":"medium","data":[["https://tudashboard.com/wp-content/uploads/2020/12/Auto.png"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"imgFixWidth":"50","scale":"fd"},"formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,F12;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"1a310b30","type":"label","fmt":"img","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst1a310b30"},"align":"c"},{"role":"secondary","data":[["Venta de autos nuevos"]],"displayName":"Secondary Value","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,A12;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst4934b033"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"4934b033","wrap":"active"}],"displayName":"Value Pair Copy 10","id":"e382db96","type":"simple_value","dstContext":{"id":"dste382db96"}},{"data":[["Autos (M)"]],"displayName":"Label 4 Copy 10","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,E12;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dste82139c6"},"align":"c","layoutConfig":{"x":0.0,"y":1.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"e82139c6","wrap":true},{"data":[[0.5503674906255498]],"displayName":"Label 3 Copy 10","formulas":[{"txt":"SET(\"var\", \"Auto.Total\", SELECT(6028c5aa106e6ff08a76aa6437175f62#47dec15eb3f65e87f49df305213378d0;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_fff","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst35b73dcc"},"align":"c","layoutConfig":{"x":0.0,"y":2.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"id":"35b73dcc","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lteq"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}],"wrap":"active"},{"layoutConfig":{"x":0.0,"y":3.0},"components":[{"role":"primary","data":[[11538.0]],"displayName":"Primary Value","formulas":[{"txt":"SET(\"var\", \"Auto.Total\", SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_red_4","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst6dbeed5c"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"dateInputFormatCustom":"MMddyy","dateFormat":"custom","dateFormatCustom":"MMddyy","dateInputFormat":"custom"},"id":"6dbeed5c"},{"role":"secondary","data":[["December 2023"]],"displayName":"Secondary Value","formulas":[{"txt":"SET(\"var\", \"Auto.Total\", LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"dat2","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst7160fcb4"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"MMMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"id":"7160fcb4","conditions":[{"predicates":[{"left":{"self":1.0}}],"reactions":[{"type":"color","value":"cx-theme_green_3"}]}]}],"displayName":"Value Pair 2 Copy 10","id":"314764fc","type":"simple_value","dstContext":{"id":"dst314764fc"}}],"displayName":"Layout Grid 2 Copy 10","id":"15a1a043","cellData":[{"x":0.0,"y":2.0}],"type":"panel_grid","rows":4.0,"cols":1.0},{"layoutConfig":{"x":3.0,"y":3.0},"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","size":"medium","data":[["https://tudashboard.com/wp-content/uploads/2020/12/Turismo.png"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"imgFixWidth":"40","scale":"fd"},"formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,F13;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"0c2a3cd1","type":"label","fmt":"img","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst0c2a3cd1"},"align":"c"},{"role":"secondary","data":[["Turismo"]],"displayName":"Secondary Value","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,A13;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstf60b5850"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"f60b5850","wrap":"active"}],"displayName":"Value Pair Copy 11","id":"985610e2","type":"simple_value","dstContext":{"id":"dst985610e2"}},{"data":[["Pasajeros (M)"]],"displayName":"Label 4 Copy 11","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,E13;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst68567489"},"align":"c","layoutConfig":{"x":0.0,"y":1.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"68567489","wrap":true},{"data":[[779645.0]],"displayName":"Label 3 Copy 11","formulas":[{"txt":"SET(\"var\", \"mov.pasa.almm\", SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_fff","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst77140b1b"},"align":"c","layoutConfig":{"x":0.0,"y":2.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"77140b1b","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lteq"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}],"wrap":true},{"layoutConfig":{"x":0.0,"y":3.0},"components":[{"role":"primary","data":[[779645.0]],"displayName":"Primary Value","formulas":[{"txt":"SET(\"var\", \"mov.pasa.almm\", SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst47089500"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"47089500"},{"role":"secondary","data":[["September 2023"]],"displayName":"Secondary Value","formulas":[{"txt":"SET(\"var\", \"mov.pasa.almm\", LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"dat2","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstb187dbe2"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"MMMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"id":"b187dbe2","conditions":[{"predicates":[{"left":{"self":1.0}}],"reactions":[{"type":"color","value":"cx-theme_green_3"}]}]}],"displayName":"Value Pair 2 Copy 11","id":"67ba25b7","type":"simple_value","dstContext":{"id":"dst67ba25b7"}}],"displayName":"Layout Grid 2 Copy 11","id":"ce3de1b3","type":"panel_grid","rows":4.0,"cols":1.0},{"layoutConfig":{"x":5.0,"y":3.0},"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","size":"medium","data":[["https://tudashboard.com/wp-content/uploads/2020/12/venta.png"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"imgFixWidth":"40","scale":"fd"},"formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,F14;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"03c62eef","type":"label","fmt":"img","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst03c62eef"},"align":"c"},{"role":"secondary","data":[["Venta de vivienda nueva"]],"displayName":"Secondary Value","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,A14;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstd13df6fc"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"d13df6fc","wrap":"active"}],"displayName":"Value Pair Copy 12","id":"f128ec5b","type":"simple_value","dstContext":{"id":"dstf128ec5b"}},{"data":[["Viviendas (M)"]],"displayName":"Label 4 Copy 12","formulas":[{"txt":"0a4226922b41c76251c43004511e6774@Hoja 2,E14;","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst9d5020a5"},"align":"c","layoutConfig":{"x":0.0,"y":1.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"","autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"9d5020a5","wrap":true},{"data":[[73.0]],"displayName":"Label 3 Copy 12","formulas":[{"txt":"SET(\"var\", \"const.units.new\", SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_fff","type":"label","fmt":"num","dstContext":{"ops":[],"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst2eca2f00","aggs":{"2eca2f00":"auto"}},"align":"c","layoutConfig":{"x":0.0,"y":2.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"2eca2f00","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lteq"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"replace","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}],"wrap":"active"},{"layoutConfig":{"x":0.0,"y":3.0},"components":[{"role":"primary","data":[[73.0]],"displayName":"Primary Value","formulas":[{"txt":"SET(\"var\", \"const.units.new\", SELECT(6028c5aa106e6ff08a76aa6437175f62#484c77fdc54bd41689dc80aff27b80f3;,AND(LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)) = 6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"num","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dstccbe99bd"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"ccbe99bd"},{"role":"secondary","data":[["December 2023"]],"displayName":"Secondary Value","formulas":[{"txt":"SET(\"var\", \"const.units.new\", LAST(SELECT(6028c5aa106e6ff08a76aa6437175f62#da50b05c3eae2e8b3d39a8f75d41c4d3;, 6028c5aa106e6ff08a76aa6437175f62#bae38f6e4c3ec8d20a71a61ab851c137;=$var)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_red_4","type":"label","fmt":"dat2","dstContext":{"kid":"232f1a953764b94b8da1bf65eea23b4c","id":"dst240c7b33"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"MMMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d-MMM-yyyy","dateFormat":"custom","dateFormatCustom":"MMMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"id":"240c7b33","conditions":[{"predicates":[{"left":{"self":1.0}}],"reactions":[{"type":"color","value":"cx-theme_green_3"}]}]}],"displayName":"Value Pair 2 Copy 12","id":"b314a1c1","type":"simple_value","dstContext":{"id":"dstb314a1c1"}}],"displayName":"Layout Grid 2 Copy 12","id":"6c849593","type":"panel_grid","rows":4.0,"cols":1.0}],"displayName":"Layout Grid","widths":[{"w":"2%","x":2.0},{"w":"2%","x":4.0},{"w":"2%","x":6.0},{"w":"2%","x":0.0}],"id":"3264757d","cellData":[{"x":2.0,"y":1.0},{"x":1.0,"y":1.0,"alignment":1.0},{"x":3.0,"y":1.0,"alignment":1.0},{"x":5.0,"y":1.0,"alignment":1.0},{"x":1.0,"y":3.0},{"x":3.0,"y":3.0,"alignment":1.0},{"x":5.0,"y":3.0,"alignment":1.0},{"w":7.0,"x":0.0,"y":0.0,"alignment":1.0},{"w":7.0,"x":0.0,"y":2.0},{"x":3.0,"y":0.0},{"w":7.0,"x":0.0,"y":1.0},{"x":0.0,"y":3.0}],"type":"panel_grid","rows":4.0,"cols":7.0}],"isForked":false,"id":"160c235eeeac50e063789efea3d3b1f1","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"principales","usesSampleData":false,"master":"232f1a953764b94b8da1bf65eea23b4c"}]}]