{"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":"kpis","compiledQueryString":"with filtered as (\n select *\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),\nmonthly as (\n select\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_mes,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_mes_anterior,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_acumuladas,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_acumuladas_anterior,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n then pre_unit * ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end)\n / nullif(sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end), 0) as fob_prom_mes,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n then pre_unit * ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end)\n / nullif(sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end), 0) as fob_prom_acumulado\n from filtered\n)\nselect\n unidades_mes,\n unidades_mes_anterior,\n unidades_mes - unidades_mes_anterior as variacion_mes,\n (unidades_mes - unidades_mes_anterior) / nullif(unidades_mes_anterior, 0) as variacion_mes_pct,\n unidades_acumuladas,\n unidades_acumuladas_anterior,\n unidades_acumuladas - unidades_acumuladas_anterior as variacion_acumulada,\n (unidades_acumuladas - unidades_acumuladas_anterior) / nullif(unidades_acumuladas_anterior, 0) as variacion_acumulada_pct,\n fob_prom_mes,\n fob_prom_acumulado\nfrom monthly","inputQueryString":"with filtered as (\n select *\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),\nmonthly as (\n select\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_mes,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_mes_anterior,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_acumuladas,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer) - 1\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_acumuladas_anterior,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n then pre_unit * ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end)\n / nullif(sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) = cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end), 0) as fob_prom_mes,\n sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n then pre_unit * ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end)\n / nullif(sum(case when cast(anio as integer) = cast('${inputs.anio.value}' as integer)\n and cast(mes as integer) <= cast('${inputs.mes.value}' as integer)\n then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end), 0) as fob_prom_acumulado\n from filtered\n)\nselect\n unidades_mes,\n unidades_mes_anterior,\n unidades_mes - unidades_mes_anterior as variacion_mes,\n (unidades_mes - unidades_mes_anterior) / nullif(unidades_mes_anterior, 0) as variacion_mes_pct,\n unidades_acumuladas,\n unidades_acumuladas_anterior,\n unidades_acumuladas - unidades_acumuladas_anterior as variacion_acumulada,\n (unidades_acumuladas - unidades_acumuladas_anterior) / nullif(unidades_acumuladas_anterior, 0) as variacion_acumulada_pct,\n fob_prom_mes,\n fob_prom_acumulado\nfrom monthly","compiled":false,"inline":true},{"id":"marca_mes","compiledQueryString":"with base as (\n select\n principales_marcas as marca,\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'},\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 marca,\n sum(case when periodo = 'actual' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades,\n sum(case when periodo = 'anterior' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end)\n / nullif(sum(case when periodo = 'actual' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by marca\n),\ntot as (\n select sum(unidades) as total_unidades, max(unidades) as max_unidades from agg\n)\nselect\n marca,\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 unidades desc","inputQueryString":"with base as (\n select\n principales_marcas as marca,\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'},\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 marca,\n sum(case when periodo = 'actual' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades,\n sum(case when periodo = 'anterior' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end)\n / nullif(sum(case when periodo = 'actual' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by marca\n),\ntot as (\n select sum(unidades) as total_unidades, max(unidades) as max_unidades from agg\n)\nselect\n marca,\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 unidades desc","compiled":false,"inline":true},{"id":"marca_acumulado","compiledQueryString":"with base as (\n select\n principales_marcas as marca,\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'},\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 marca,\n sum(case when periodo = 'actual' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades,\n sum(case when periodo = 'anterior' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end)\n / nullif(sum(case when periodo = 'actual' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by marca\n),\ntot as (\n select sum(unidades) as total_unidades, max(unidades) as max_unidades from agg\n)\nselect\n marca,\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 unidades desc","inputQueryString":"with base as (\n select\n principales_marcas as marca,\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'},\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 marca,\n sum(case when periodo = 'actual' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades,\n sum(case when periodo = 'anterior' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end) as unidades_anterior,\n sum(case when periodo = 'actual' then pre_unit * ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end)\n / nullif(sum(case when periodo = 'actual' then ${inputs.medida.value === 'valor' ? 'cif_item' : 'unidades_importadas'} else 0 end), 0) as fob_prom\n from base\n where periodo is not null\n group by marca\n),\ntot as (\n select sum(unidades) as total_unidades, max(unidades) as max_unidades from agg\n)\nselect\n marca,\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 unidades desc","compiled":false,"inline":true},{"id":"serie_anual","compiledQueryString":"select\n mes,\n anio,\n 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(${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) 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,\n anio,\n 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(${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) 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}]}

Import-Export por marca