{"queries":[{"id":"categorias","compiledQueryString":"select distinct categoria\nfrom maestras.cat_list\norder by 1","inputQueryString":"select distinct categoria\nfrom maestras.cat_list\norder by 1","compiled":false,"inline":true},{"id":"catinfo","compiledQueryString":"select category from maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\nlimit 1","inputQueryString":"select category from maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\nlimit 1","compiled":false,"inline":true},{"id":"tipos","compiledQueryString":"select distinct tipo from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and tipo is not null and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by tipo","inputQueryString":"select distinct tipo from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and tipo is not null and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by tipo","compiled":false,"inline":true},{"id":"segmentos","compiledQueryString":"select distinct segmento from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and segmento is not null and segmento <> '' and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by segmento","inputQueryString":"select distinct segmento from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and segmento is not null and segmento <> '' and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by segmento","compiled":false,"inline":true},{"id":"marcas","compiledQueryString":"select distinct principales_marcas as marca from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and principales_marcas is not null and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by principales_marcas","inputQueryString":"select distinct principales_marcas as marca from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and principales_marcas is not null and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by principales_marcas","compiled":false,"inline":true},{"id":"rams","compiledQueryString":"select distinct ram from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and ram is not null and ram <> '' and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by ram","inputQueryString":"select distinct ram from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and ram is not null and ram <> '' and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by ram","compiled":false,"inline":true},{"id":"roms","compiledQueryString":"select distinct almacenamiento as rom from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and almacenamiento is not null and almacenamiento <> '' and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by almacenamiento","inputQueryString":"select distinct almacenamiento as rom from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and almacenamiento is not null and almacenamiento <> '' and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by almacenamiento","compiled":false,"inline":true},{"id":"redes","compiledQueryString":"select distinct red from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and red is not null and red <> '' and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by red","inputQueryString":"select distinct red from maestras.cat_${params.categoria} where lower(category) = '${params.categoria}' and red is not null and red <> '' and operation = '${inputs.operacion.value}' and cast(anio as integer) = cast('${inputs.anio.value}' as integer) and cast(mes as integer) = cast('${inputs.mes.value}' as integer) order by red","compiled":false,"inline":true},{"id":"meses","compiledQueryString":"select distinct cast(cast(mes as integer) as varchar) as mes\nfrom maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and mes is not null\norder by cast(mes as integer)","inputQueryString":"select distinct cast(cast(mes as integer) as varchar) as mes\nfrom maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and mes is not null\norder by cast(mes as integer)","compiled":false,"inline":true},{"id":"modelo_mes","compiledQueryString":"with base as (\n select\n principales_marcas as marca, modelo, ram, almacenamiento as rom, red, segmento,\n unidades_importadas as metrica, pre_unit\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n),\nagg as (\n select marca, modelo, ram, rom, red, max(segmento) as segmento,\n sum(metrica) as unidades,\n sum(pre_unit * metrica) / nullif(sum(metrica), 0) as fob_prom\n from base\n group by marca, modelo, ram, rom, red\n),\ntot as (select sum(unidades) as total_unidades, max(unidades) as max_unidades from agg)\nselect marca, modelo, ram, rom, red, segmento, unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota, fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg cross join tot\nwhere unidades > 0\norder by unidades desc\nlimit 100","inputQueryString":"with base as (\n select\n principales_marcas as marca, modelo, ram, almacenamiento as rom, red, segmento,\n unidades_importadas as metrica, pre_unit\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n),\nagg as (\n select marca, modelo, ram, rom, red, max(segmento) as segmento,\n sum(metrica) as unidades,\n sum(pre_unit * metrica) / nullif(sum(metrica), 0) as fob_prom\n from base\n group by marca, modelo, ram, rom, red\n),\ntot as (select sum(unidades) as total_unidades, max(unidades) as max_unidades from agg)\nselect marca, modelo, ram, rom, red, segmento, unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota, fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg cross join tot\nwhere unidades > 0\norder by unidades desc\nlimit 100","compiled":false,"inline":true},{"id":"modelo_mes_tot","compiledQueryString":"select sum(metrica) as unidades, sum(pre_unit * metrica) / nullif(sum(metrica), 0) as fob_prom\nfrom (\n select unidades_importadas as metrica, pre_unit\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\n)","inputQueryString":"select sum(metrica) as unidades, sum(pre_unit * metrica) / nullif(sum(metrica), 0) as fob_prom\nfrom (\n select unidades_importadas as metrica, pre_unit\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\n)","compiled":false,"inline":true},{"id":"modelo_acum","compiledQueryString":"with base as (\n select\n principales_marcas as marca, modelo, ram, almacenamiento as rom, red, segmento,\n unidades_importadas as metrica, pre_unit\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n),\nagg as (\n select marca, modelo, ram, rom, red, max(segmento) as segmento,\n sum(metrica) as unidades,\n sum(pre_unit * metrica) / nullif(sum(metrica), 0) as fob_prom\n from base\n group by marca, modelo, ram, rom, red\n),\ntot as (select sum(unidades) as total_unidades, max(unidades) as max_unidades from agg)\nselect marca, modelo, ram, rom, red, segmento, unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota, fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg cross join tot\nwhere unidades > 0\norder by unidades desc\nlimit 100","inputQueryString":"with base as (\n select\n principales_marcas as marca, modelo, ram, almacenamiento as rom, red, segmento,\n unidades_importadas as metrica, pre_unit\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n),\nagg as (\n select marca, modelo, ram, rom, red, max(segmento) as segmento,\n sum(metrica) as unidades,\n sum(pre_unit * metrica) / nullif(sum(metrica), 0) as fob_prom\n from base\n group by marca, modelo, ram, rom, red\n),\ntot as (select sum(unidades) as total_unidades, max(unidades) as max_unidades from agg)\nselect marca, modelo, ram, rom, red, segmento, unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota, fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg cross join tot\nwhere unidades > 0\norder by unidades desc\nlimit 100","compiled":false,"inline":true},{"id":"modelo_acum_tot","compiledQueryString":"select sum(metrica) as unidades, sum(pre_unit * metrica) / nullif(sum(metrica), 0) as fob_prom\nfrom (\n select unidades_importadas as metrica, pre_unit\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\n)","inputQueryString":"select sum(metrica) as unidades, sum(pre_unit * metrica) / nullif(sum(metrica), 0) as fob_prom\nfrom (\n select unidades_importadas as metrica, pre_unit\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\n)","compiled":false,"inline":true},{"id":"serie_modelo","compiledQueryString":"select\n mes, anio, unidades,\n sum(unidades) over (partition by anio order by mes) as unidades_acum\nfrom (\n select\n cast(mes as integer) as mes,\n cast(cast(anio as integer) as varchar) as anio,\n sum(unidades_importadas) as unidades\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\n and cast(anio as integer) in (cast('${inputs.anio.value}' as integer), cast('${inputs.anio.value}' as integer) - 1)\n group by cast(mes as integer), cast(cast(anio as integer) as varchar)\n)\norder by anio, mes","inputQueryString":"select\n mes, anio, unidades,\n sum(unidades) over (partition by anio order by mes) as unidades_acum\nfrom (\n select\n cast(mes as integer) as mes,\n cast(cast(anio as integer) as varchar) as anio,\n sum(unidades_importadas) as unidades\n from maestras.cat_${params.categoria}\n where lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\n and cast(anio as integer) in (cast('${inputs.anio.value}' as integer), cast('${inputs.anio.value}' as integer) - 1)\n group by cast(mes as integer), cast(cast(anio as integer) as varchar)\n)\norder by anio, mes","compiled":false,"inline":true},{"id":"dist_ram","compiledQueryString":"select coalesce(nullif(ram, ''), '(s/d)') as valor, sum(unidades_importadas) as unidades\nfrom maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\ngroup by 1\nhaving sum(unidades_importadas) > 0\norder by unidades desc","inputQueryString":"select coalesce(nullif(ram, ''), '(s/d)') as valor, sum(unidades_importadas) as unidades\nfrom maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\ngroup by 1\nhaving sum(unidades_importadas) > 0\norder by unidades desc","compiled":false,"inline":true},{"id":"dist_rom","compiledQueryString":"select coalesce(nullif(almacenamiento, ''), '(s/d)') as valor, sum(unidades_importadas) as unidades\nfrom maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\ngroup by 1\nhaving sum(unidades_importadas) > 0\norder by unidades desc","inputQueryString":"select coalesce(nullif(almacenamiento, ''), '(s/d)') as valor, sum(unidades_importadas) as unidades\nfrom maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.red.value && inputs.red.value.includes(\"'\") ? \"red in \" + inputs.red.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\ngroup by 1\nhaving sum(unidades_importadas) > 0\norder by unidades desc","compiled":false,"inline":true},{"id":"dist_red","compiledQueryString":"select coalesce(nullif(red, ''), '(s/d)') as valor, sum(unidades_importadas) as unidades\nfrom maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\ngroup by 1\nhaving sum(unidades_importadas) > 0\norder by unidades desc","inputQueryString":"select coalesce(nullif(red, ''), '(s/d)') as valor, sum(unidades_importadas) as unidades\nfrom maestras.cat_${params.categoria}\nwhere lower(category) = '${params.categoria}'\n and operation = '${inputs.operacion.value}'\n and ${inputs.tipo.value && inputs.tipo.value.includes(\"'\") ? \"tipo in \" + inputs.tipo.value : \"1=1\"}\n and ${inputs.ram.value && inputs.ram.value.includes(\"'\") ? \"ram in \" + inputs.ram.value : \"1=1\"}\n and ${inputs.rom.value && inputs.rom.value.includes(\"'\") ? \"almacenamiento in \" + inputs.rom.value : \"1=1\"}\n and ${inputs.segmento.value && inputs.segmento.value.includes(\"'\") ? \"segmento in \" + inputs.segmento.value : \"1=1\"}\n and ${inputs.marca.value && inputs.marca.value.includes(\"'\") ? \"principales_marcas in \" + inputs.marca.value : \"1=1\"}\n and modelo ilike '%${inputs.buscar}%'\n and cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and ${inputs.marcaCF && String(inputs.marcaCF) ? \"principales_marcas = \" + inputs.marcaCF.sql : \"1=1\"}\ngroup by 1\nhaving sum(unidades_importadas) > 0\norder by unidades desc","compiled":false,"inline":true}]}

Import-Export por modelo