{"queries":[{"id":"tipos","compiledQueryString":"select distinct tipo\nfrom maestras.telefonos_final\nwhere tipo is not null\norder by tipo","inputQueryString":"select distinct tipo\nfrom maestras.telefonos_final\nwhere tipo is not null\norder by tipo","compiled":false,"inline":true},{"id":"marcas","compiledQueryString":"select distinct principales_marcas as marca\nfrom maestras.telefonos_final\nwhere principales_marcas is not null\norder by principales_marcas","inputQueryString":"select distinct principales_marcas as marca\nfrom maestras.telefonos_final\nwhere principales_marcas is not null\norder by principales_marcas","compiled":false,"inline":true},{"id":"segmentos","compiledQueryString":"select distinct segmento\nfrom maestras.telefonos_final\nwhere segmento is not null\norder by segmento","inputQueryString":"select distinct segmento\nfrom maestras.telefonos_final\nwhere segmento is not null\norder by segmento","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":"segmento_mes","compiledQueryString":"with base as (\n select\n segmento,\n case\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer) then 'actual'\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer) then 'anterior'\n end as periodo,\n ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} as metrica,\n pre_unit\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and cast(anio as integer) in (cast('${inputs.anio.value}' as integer), cast('${inputs.anio.value}' as integer) - 1)\n),\nagg as (\n select\n segmento,\n sum(case when periodo = 'actual' then metrica else 0 end) as unidades,\n sum(case when periodo = 'anterior' then metrica else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * metrica else 0 end)\n / nullif(sum(case when periodo = 'actual' then metrica else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by segmento\n),\ntot as (\n select sum(unidades) as total_unidades, sum(unidades_anterior) as total_anterior, max(unidades) as max_unidades from agg\n)\nselect\n segmento,\n unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota,\n unidades_anterior,\n (unidades - unidades_anterior) * 1.0 / nullif(unidades_anterior, 0) as variacion_pct,\n fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg\ncross join tot\nwhere unidades > 0\norder by segmento","inputQueryString":"with base as (\n select\n segmento,\n case\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer) then 'actual'\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer) then 'anterior'\n end as periodo,\n ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} as metrica,\n pre_unit\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and cast(anio as integer) in (cast('${inputs.anio.value}' as integer), cast('${inputs.anio.value}' as integer) - 1)\n),\nagg as (\n select\n segmento,\n sum(case when periodo = 'actual' then metrica else 0 end) as unidades,\n sum(case when periodo = 'anterior' then metrica else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * metrica else 0 end)\n / nullif(sum(case when periodo = 'actual' then metrica else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by segmento\n),\ntot as (\n select sum(unidades) as total_unidades, sum(unidades_anterior) as total_anterior, max(unidades) as max_unidades from agg\n)\nselect\n segmento,\n unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota,\n unidades_anterior,\n (unidades - unidades_anterior) * 1.0 / nullif(unidades_anterior, 0) as variacion_pct,\n fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg\ncross join tot\nwhere unidades > 0\norder by segmento","compiled":false,"inline":true},{"id":"segmento_acumulado","compiledQueryString":"with base as (\n select\n segmento,\n case\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer) then 'actual'\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer) then 'anterior'\n end as periodo,\n ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} as metrica,\n pre_unit\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n and cast(anio as integer) in (cast('${inputs.anio.value}' as integer), cast('${inputs.anio.value}' as integer) - 1)\n),\nagg as (\n select\n segmento,\n sum(case when periodo = 'actual' then metrica else 0 end) as unidades,\n sum(case when periodo = 'anterior' then metrica else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * metrica else 0 end)\n / nullif(sum(case when periodo = 'actual' then metrica else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by segmento\n),\ntot as (\n select sum(unidades) as total_unidades, sum(unidades_anterior) as total_anterior, max(unidades) as max_unidades from agg\n)\nselect\n segmento,\n unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota,\n unidades_anterior,\n (unidades - unidades_anterior) * 1.0 / nullif(unidades_anterior, 0) as variacion_pct,\n fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg\ncross join tot\nwhere unidades > 0\norder by segmento","inputQueryString":"with base as (\n select\n segmento,\n case\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer) then 'actual'\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer) then 'anterior'\n end as periodo,\n ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} as metrica,\n pre_unit\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n and cast(anio as integer) in (cast('${inputs.anio.value}' as integer), cast('${inputs.anio.value}' as integer) - 1)\n),\nagg as (\n select\n segmento,\n sum(case when periodo = 'actual' then metrica else 0 end) as unidades,\n sum(case when periodo = 'anterior' then metrica else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * metrica else 0 end)\n / nullif(sum(case when periodo = 'actual' then metrica else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by segmento\n),\ntot as (\n select sum(unidades) as total_unidades, sum(unidades_anterior) as total_anterior, max(unidades) as max_unidades from agg\n)\nselect\n segmento,\n unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota,\n unidades_anterior,\n (unidades - unidades_anterior) * 1.0 / nullif(unidades_anterior, 0) as variacion_pct,\n fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg\ncross join tot\nwhere unidades > 0\norder by segmento","compiled":false,"inline":true},{"id":"totales","compiledQueryString":"select\n sum(unidades) as unidades_mes,\n sum(unidades_anterior) as unidades_mes_anterior,\n sum(unidades) * 1.0 / nullif(sum(unidades), 0) as cuota_mes,\n (sum(unidades) - sum(unidades_anterior)) * 1.0 / nullif(sum(unidades_anterior), 0) as var_mes,\n sum(fob_prom * unidades) / nullif(sum(unidades), 0) as fob_mes\nfrom (with base as (\n select\n segmento,\n case\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer) then 'actual'\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer) then 'anterior'\n end as periodo,\n ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} as metrica,\n pre_unit\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n and cast(anio as integer) in (cast('${inputs.anio.value}' as integer), cast('${inputs.anio.value}' as integer) - 1)\n),\nagg as (\n select\n segmento,\n sum(case when periodo = 'actual' then metrica else 0 end) as unidades,\n sum(case when periodo = 'anterior' then metrica else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * metrica else 0 end)\n / nullif(sum(case when periodo = 'actual' then metrica else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by segmento\n),\ntot as (\n select sum(unidades) as total_unidades, sum(unidades_anterior) as total_anterior, max(unidades) as max_unidades from agg\n)\nselect\n segmento,\n unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota,\n unidades_anterior,\n (unidades - unidades_anterior) * 1.0 / nullif(unidades_anterior, 0) as variacion_pct,\n fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg\ncross join tot\nwhere unidades > 0\norder by segmento)","inputQueryString":"select\n sum(unidades) as unidades_mes,\n sum(unidades_anterior) as unidades_mes_anterior,\n sum(unidades) * 1.0 / nullif(sum(unidades), 0) as cuota_mes,\n (sum(unidades) - sum(unidades_anterior)) * 1.0 / nullif(sum(unidades_anterior), 0) as var_mes,\n sum(fob_prom * unidades) / nullif(sum(unidades), 0) as fob_mes\nfrom ${segmento_mes}","compiled":true,"inline":true},{"id":"totales_acum","compiledQueryString":"select\n sum(unidades) as unidades,\n sum(unidades_anterior) as unidades_anterior,\n (sum(unidades) - sum(unidades_anterior)) * 1.0 / nullif(sum(unidades_anterior), 0) as var_pct,\n sum(fob_prom * unidades) / nullif(sum(unidades), 0) as fob_prom\nfrom (with base as (\n select\n segmento,\n case\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer) then 'actual'\n when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer) then 'anterior'\n end as periodo,\n ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} as metrica,\n pre_unit\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n and cast(anio as integer) in (cast('${inputs.anio.value}' as integer), cast('${inputs.anio.value}' as integer) - 1)\n),\nagg as (\n select\n segmento,\n sum(case when periodo = 'actual' then metrica else 0 end) as unidades,\n sum(case when periodo = 'anterior' then metrica else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * metrica else 0 end)\n / nullif(sum(case when periodo = 'actual' then metrica else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by segmento\n),\ntot as (\n select sum(unidades) as total_unidades, sum(unidades_anterior) as total_anterior, max(unidades) as max_unidades from agg\n)\nselect\n segmento,\n unidades,\n unidades * 1.0 / nullif(total_unidades, 0) as cuota,\n unidades_anterior,\n (unidades - unidades_anterior) * 1.0 / nullif(unidades_anterior, 0) as variacion_pct,\n fob_prom,\n unidades * 100.0 / nullif(max_unidades, 0) as bar_pct\nfrom agg\ncross join tot\nwhere unidades > 0\norder by segmento)","inputQueryString":"select\n sum(unidades) as unidades,\n sum(unidades_anterior) as unidades_anterior,\n (sum(unidades) - sum(unidades_anterior)) * 1.0 / nullif(sum(unidades_anterior), 0) as var_pct,\n sum(fob_prom * unidades) / nullif(sum(unidades), 0) as fob_prom\nfrom ${segmento_acumulado}","compiled":true,"inline":true},{"id":"segmento_anual","compiledQueryString":"with agg as (\n select\n cast(anio as integer) as anio,\n segmento,\n sum(${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'}) as unidades\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n and cast(anio as integer) between cast('${inputs.anio.value}' as integer) - 3 and cast('${inputs.anio.value}' as integer)\n group by cast(anio as integer), segmento\n),\ntot as (\n select anio, sum(unidades) as total_unidades\n from agg\n group by anio\n)\nselect\n agg.anio,\n agg.segmento,\n agg.unidades,\n agg.unidades * 1.0 / nullif(tot.total_unidades, 0) as cuota\nfrom agg\njoin tot using (anio)\norder by agg.anio, agg.segmento","inputQueryString":"with agg as (\n select\n cast(anio as integer) as anio,\n segmento,\n sum(${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'}) as unidades\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n and cast(anio as integer) between cast('${inputs.anio.value}' as integer) - 3 and cast('${inputs.anio.value}' as integer)\n group by cast(anio as integer), segmento\n),\ntot as (\n select anio, sum(unidades) as total_unidades\n from agg\n group by anio\n)\nselect\n agg.anio,\n agg.segmento,\n agg.unidades,\n agg.unidades * 1.0 / nullif(tot.total_unidades, 0) as cuota\nfrom agg\njoin tot using (anio)\norder by agg.anio, agg.segmento","compiled":false,"inline":true},{"id":"marca_segmento_mes","compiledQueryString":"with agg as (\n select\n segmento,\n principales_marcas as marca,\n sum(${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'}) as unidades\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n group by segmento, principales_marcas\n),\ntot as (\n select segmento, sum(unidades) as total_unidades\n from agg\n group by segmento\n)\nselect agg.segmento, agg.marca, agg.unidades, agg.unidades * 1.0 / nullif(tot.total_unidades, 0) as cuota\nfrom agg\njoin tot using (segmento)\nwhere agg.unidades > 0\norder by agg.segmento, agg.unidades desc","inputQueryString":"with agg as (\n select\n segmento,\n principales_marcas as marca,\n sum(${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'}) as unidades\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n group by segmento, principales_marcas\n),\ntot as (\n select segmento, sum(unidades) as total_unidades\n from agg\n group by segmento\n)\nselect agg.segmento, agg.marca, agg.unidades, agg.unidades * 1.0 / nullif(tot.total_unidades, 0) as cuota\nfrom agg\njoin tot using (segmento)\nwhere agg.unidades > 0\norder by agg.segmento, agg.unidades desc","compiled":false,"inline":true},{"id":"marca_segmento_acumulado","compiledQueryString":"with agg as (\n select\n segmento,\n principales_marcas as marca,\n sum(${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'}) as unidades\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n group by segmento, principales_marcas\n),\ntot as (\n select segmento, sum(unidades) as total_unidades\n from agg\n group by segmento\n)\nselect agg.segmento, agg.marca, agg.unidades, agg.unidades * 1.0 / nullif(tot.total_unidades, 0) as cuota\nfrom agg\njoin tot using (segmento)\nwhere agg.unidades > 0\norder by agg.segmento, agg.unidades desc","inputQueryString":"with agg as (\n select\n segmento,\n principales_marcas as marca,\n sum(${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'}) as unidades\n from maestras.telefonos_final\n where operation = '${inputs.operacion.value}'\n and tipo like '${inputs.tipo.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 cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n group by segmento, principales_marcas\n),\ntot as (\n select segmento, sum(unidades) as total_unidades\n from agg\n group by segmento\n)\nselect agg.segmento, agg.marca, agg.unidades, agg.unidades * 1.0 / nullif(tot.total_unidades, 0) as cuota\nfrom agg\njoin tot using (segmento)\nwhere agg.unidades > 0\norder by agg.segmento, agg.unidades desc","compiled":false,"inline":true}]}

Import-Export por segmento