{"queries":[{"id":"tipos","compiledQueryString":"select distinct tipo from maestras.telefonos_final where tipo is not null order by tipo","inputQueryString":"select distinct tipo from maestras.telefonos_final where tipo is not null order by tipo","compiled":false,"inline":true},{"id":"segmentos","compiledQueryString":"select distinct segmento from maestras.telefonos_final where segmento is not null and segmento <> '' order by segmento","inputQueryString":"select distinct segmento from maestras.telefonos_final where segmento is not null and segmento <> '' order by segmento","compiled":false,"inline":true},{"id":"marcas","compiledQueryString":"select distinct principales_marcas as marca from maestras.telefonos_final where principales_marcas is not null order by principales_marcas","inputQueryString":"select distinct principales_marcas as marca from maestras.telefonos_final where principales_marcas is not null order by principales_marcas","compiled":false,"inline":true},{"id":"rams","compiledQueryString":"select distinct ram from maestras.telefonos_final where ram is not null and ram <> '' order by ram","inputQueryString":"select distinct ram from maestras.telefonos_final where ram is not null and ram <> '' order by ram","compiled":false,"inline":true},{"id":"roms","compiledQueryString":"select distinct almacenamiento as rom from maestras.telefonos_final where almacenamiento is not null and almacenamiento <> '' order by almacenamiento","inputQueryString":"select distinct almacenamiento as rom from maestras.telefonos_final where almacenamiento is not null and almacenamiento <> '' order by almacenamiento","compiled":false,"inline":true},{"id":"redes","compiledQueryString":"select distinct red from maestras.telefonos_final where red is not null and red <> '' order by red","inputQueryString":"select distinct red from maestras.telefonos_final where red is not null and red <> '' order by red","compiled":false,"inline":true},{"id":"meses","compiledQueryString":"select distinct cast(cast(mes as integer) as varchar) as mes\nfrom maestras.telefonos_final\nwhere 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.telefonos_final\nwhere 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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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)","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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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)","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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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)","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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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)","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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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) 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.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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) 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.telefonos_final\nwhere operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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)\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.telefonos_final\nwhere operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and almacenamiento like '${inputs.rom.value}'\n and red like '${inputs.red.value}'\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)\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.telefonos_final\nwhere operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and red like '${inputs.red.value}'\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)\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.telefonos_final\nwhere operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and red like '${inputs.red.value}'\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)\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.telefonos_final\nwhere operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\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)\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.telefonos_final\nwhere operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.value}'\n and ram like '${inputs.ram.value}'\n and almacenamiento like '${inputs.rom.value}'\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)\ngroup by 1\nhaving sum(unidades_importadas) > 0\norder by unidades desc","compiled":false,"inline":true}]}

Import-Export por modelo