{"queries":[{"id":"metricas","compiledQueryString":"select distinct metric from marketshare.fact_full order by 1","inputQueryString":"select distinct metric from marketshare.fact_full order by 1","compiled":false,"inline":true},{"id":"companias","compiledQueryString":"select distinct manufacturer from marketshare.fact_full\nwhere manufacturer is not null order by 1","inputQueryString":"select distinct manufacturer from marketshare.fact_full\nwhere manufacturer is not null order by 1","compiled":false,"inline":true},{"id":"vg_kpis","compiledQueryString":"with base as (\n select f.value, f.manufacturer,\n case\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx then 'cur'\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx - 1 then 'prev'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 3 and a.aidx then 'cur'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 7 and a.aidx - 4 then 'prev'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 11 and a.aidx then 'cur'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 23 and a.aidx - 12 then 'prev'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear and f.pidx <= a.aidx then 'cur'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear - 1 and f.pidx <= a.aidx - 12 then 'prev'\n end as bucket\n from marketshare.fact_full f\n cross join (\n select cast('${inputs.anio}' as integer) as ayear,\n cast('${inputs.anio}' as integer) * 12\n + cast('${inputs.mes}' as integer) as aidx\n ) a\n where f.metric = '${inputs.metrica.value}'\n and ('${inputs.pais}' = 'ALL' or f.country_code = '${inputs.pais}')\n),\nm as (\n select\n sum(value) filter (where bucket = 'cur') as mkt_cur,\n sum(value) filter (where bucket = 'prev') as mkt_prev,\n sum(value) filter (where bucket = 'cur' and manufacturer = '${inputs.compania.value}') as comp_cur,\n sum(value) filter (where bucket = 'prev' and manufacturer = '${inputs.compania.value}') as comp_prev\n from base\n where bucket is not null\n),\nr as (\n select\n coalesce(comp_cur, 0) as comp_cur,\n case when mkt_cur = 0 then null else comp_cur / mkt_cur end as ms_cur,\n case when mkt_prev = 0 then null else comp_prev / mkt_prev end as ms_prev,\n case when mkt_prev = 0 then null else mkt_cur / mkt_prev - 1 end as pct_var,\n case when mkt_cur is null or mkt_cur = 0 then null\n when mkt_prev is null or mkt_prev = 0 then 0\n else (comp_cur / mkt_cur - coalesce(comp_prev, 0) / mkt_prev) * 10000\n end as bps\n from m\n)\nselect\n comp_cur,\n -- es_escala: formato adaptativo europeo (mill./mil/unidades)\n case when abs(comp_cur) >= 1e6 then replace(printf('%.1f', comp_cur / 1e6), '.', ',') || ' mill.'\n when abs(comp_cur) >= 1e3 then replace(printf('%.1f', comp_cur / 1e3), '.', ',') || ' mil'\n else cast(cast(round(comp_cur) as bigint) as varchar)\n end as ventas_escala,\n ms_cur, ms_prev, pct_var, bps,\n replace(printf('%.1f', ms_cur * 100), '.', ',') || ' %' as ms_fmt,\n replace(printf('%.1f', pct_var * 100), '.', ',') || ' %' as pct_var_fmt,\n -- es_sig: ≥2 cifras significativas para que un BPS pequeño no salga \"0\"\n case when bps is null then null\n when bps = 0 then '0'\n when abs(bps) >= 10 then cast(cast(round(bps) as bigint) as varchar)\n when abs(bps) >= 1 then replace(printf('%.1f', bps), '.', ',')\n when abs(bps) >= 0.1 then replace(printf('%.2f', bps), '.', ',')\n else replace(printf('%.4f', bps), '.', ',')\n end as bps_sig\nfrom r","inputQueryString":"with base as (\n select f.value, f.manufacturer,\n case\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx then 'cur'\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx - 1 then 'prev'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 3 and a.aidx then 'cur'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 7 and a.aidx - 4 then 'prev'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 11 and a.aidx then 'cur'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 23 and a.aidx - 12 then 'prev'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear and f.pidx <= a.aidx then 'cur'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear - 1 and f.pidx <= a.aidx - 12 then 'prev'\n end as bucket\n from marketshare.fact_full f\n cross join (\n select cast('${inputs.anio}' as integer) as ayear,\n cast('${inputs.anio}' as integer) * 12\n + cast('${inputs.mes}' as integer) as aidx\n ) a\n where f.metric = '${inputs.metrica.value}'\n and ('${inputs.pais}' = 'ALL' or f.country_code = '${inputs.pais}')\n),\nm as (\n select\n sum(value) filter (where bucket = 'cur') as mkt_cur,\n sum(value) filter (where bucket = 'prev') as mkt_prev,\n sum(value) filter (where bucket = 'cur' and manufacturer = '${inputs.compania.value}') as comp_cur,\n sum(value) filter (where bucket = 'prev' and manufacturer = '${inputs.compania.value}') as comp_prev\n from base\n where bucket is not null\n),\nr as (\n select\n coalesce(comp_cur, 0) as comp_cur,\n case when mkt_cur = 0 then null else comp_cur / mkt_cur end as ms_cur,\n case when mkt_prev = 0 then null else comp_prev / mkt_prev end as ms_prev,\n case when mkt_prev = 0 then null else mkt_cur / mkt_prev - 1 end as pct_var,\n case when mkt_cur is null or mkt_cur = 0 then null\n when mkt_prev is null or mkt_prev = 0 then 0\n else (comp_cur / mkt_cur - coalesce(comp_prev, 0) / mkt_prev) * 10000\n end as bps\n from m\n)\nselect\n comp_cur,\n -- es_escala: formato adaptativo europeo (mill./mil/unidades)\n case when abs(comp_cur) >= 1e6 then replace(printf('%.1f', comp_cur / 1e6), '.', ',') || ' mill.'\n when abs(comp_cur) >= 1e3 then replace(printf('%.1f', comp_cur / 1e3), '.', ',') || ' mil'\n else cast(cast(round(comp_cur) as bigint) as varchar)\n end as ventas_escala,\n ms_cur, ms_prev, pct_var, bps,\n replace(printf('%.1f', ms_cur * 100), '.', ',') || ' %' as ms_fmt,\n replace(printf('%.1f', pct_var * 100), '.', ',') || ' %' as pct_var_fmt,\n -- es_sig: ≥2 cifras significativas para que un BPS pequeño no salga \"0\"\n case when bps is null then null\n when bps = 0 then '0'\n when abs(bps) >= 10 then cast(cast(round(bps) as bigint) as varchar)\n when abs(bps) >= 1 then replace(printf('%.1f', bps), '.', ',')\n when abs(bps) >= 0.1 then replace(printf('%.2f', bps), '.', ',')\n else replace(printf('%.4f', bps), '.', ',')\n end as bps_sig\nfrom r","compiled":false,"inline":true},{"id":"vg_evol","compiledQueryString":"-- Depende solo del año seleccionado (no del mes)\nwith mkt as (\n select month_number, month_long as mes,\n sum(value) filter (where year = cast('${inputs.anio}' as integer)) as mkt_cur,\n sum(value) filter (where year = cast('${inputs.anio}' as integer) - 1) as mkt_prev\n from marketshare.fact_full\n where metric = '${inputs.metrica.value}'\n and ('${inputs.pais}' = 'ALL' or country_code = '${inputs.pais}')\n group by 1, 2\n),\ncomp as (\n select month_number,\n sum(value) filter (where year = cast('${inputs.anio}' as integer)) as cur,\n sum(value) filter (where year = cast('${inputs.anio}' as integer) - 1) as prev\n from marketshare.fact_full\n where metric = '${inputs.metrica.value}'\n and manufacturer = '${inputs.compania.value}'\n and ('${inputs.pais}' = 'ALL' or country_code = '${inputs.pais}')\n group by 1\n)\nselect m.month_number, m.mes,\n coalesce(c.cur, 0) as \"Año actual\",\n coalesce(c.prev, 0) as \"Año anterior\",\n case when m.mkt_cur = 0 or m.mkt_cur is null then null\n else coalesce(c.cur, 0) / m.mkt_cur end as ms_cur,\n case when m.mkt_prev = 0 or m.mkt_prev is null then null\n else coalesce(c.prev, 0) / m.mkt_prev end as ms_prev,\n case when m.mkt_cur = 0 or m.mkt_prev is null or m.mkt_prev = 0 then 0\n else (coalesce(c.cur, 0) / m.mkt_cur - coalesce(c.prev, 0) / m.mkt_prev) * 10000\n end as bps\nfrom mkt m\nleft join comp c on m.month_number = c.month_number\norder by m.month_number","inputQueryString":"-- Depende solo del año seleccionado (no del mes)\nwith mkt as (\n select month_number, month_long as mes,\n sum(value) filter (where year = cast('${inputs.anio}' as integer)) as mkt_cur,\n sum(value) filter (where year = cast('${inputs.anio}' as integer) - 1) as mkt_prev\n from marketshare.fact_full\n where metric = '${inputs.metrica.value}'\n and ('${inputs.pais}' = 'ALL' or country_code = '${inputs.pais}')\n group by 1, 2\n),\ncomp as (\n select month_number,\n sum(value) filter (where year = cast('${inputs.anio}' as integer)) as cur,\n sum(value) filter (where year = cast('${inputs.anio}' as integer) - 1) as prev\n from marketshare.fact_full\n where metric = '${inputs.metrica.value}'\n and manufacturer = '${inputs.compania.value}'\n and ('${inputs.pais}' = 'ALL' or country_code = '${inputs.pais}')\n group by 1\n)\nselect m.month_number, m.mes,\n coalesce(c.cur, 0) as \"Año actual\",\n coalesce(c.prev, 0) as \"Año anterior\",\n case when m.mkt_cur = 0 or m.mkt_cur is null then null\n else coalesce(c.cur, 0) / m.mkt_cur end as ms_cur,\n case when m.mkt_prev = 0 or m.mkt_prev is null then null\n else coalesce(c.prev, 0) / m.mkt_prev end as ms_prev,\n case when m.mkt_cur = 0 or m.mkt_prev is null or m.mkt_prev = 0 then 0\n else (coalesce(c.cur, 0) / m.mkt_cur - coalesce(c.prev, 0) / m.mkt_prev) * 10000\n end as bps\nfrom mkt m\nleft join comp c on m.month_number = c.month_number\norder by m.month_number","compiled":false,"inline":true},{"id":"vg_rank","compiledQueryString":"with base as (\n select f.value, f.manufacturer,\n case\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx then 'cur'\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx - 1 then 'prev'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 3 and a.aidx then 'cur'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 7 and a.aidx - 4 then 'prev'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 11 and a.aidx then 'cur'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 23 and a.aidx - 12 then 'prev'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear and f.pidx <= a.aidx then 'cur'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear - 1 and f.pidx <= a.aidx - 12 then 'prev'\n end as bucket\n from marketshare.fact_full f\n cross join (\n select cast('${inputs.anio}' as integer) as ayear,\n cast('${inputs.anio}' as integer) * 12\n + cast('${inputs.mes}' as integer) as aidx\n ) a\n where f.metric = '${inputs.metrica.value}'\n and ('${inputs.pais}' = 'ALL' or f.country_code = '${inputs.pais}')\n),\ntot as (select sum(value) filter (where bucket = 'cur') as mkt_cur from base),\nagg as (\n select\n manufacturer as compania,\n sum(value) filter (where bucket = 'cur') as ventas,\n sum(value) filter (where bucket = 'cur') - sum(value) filter (where bucket = 'prev') as crecimiento,\n case when sum(value) filter (where bucket = 'prev') = 0 then null\n else sum(value) filter (where bucket = 'cur') / sum(value) filter (where bucket = 'prev') - 1 end as pct_crec,\n sum(value) filter (where bucket = 'cur') / (select mkt_cur from tot) as market_share\n from base\n where bucket is not null\n group by 1\n having sum(value) filter (where bucket = 'cur') > 0\n)\nselect\n compania, ventas, crecimiento, pct_crec, market_share,\n replace(printf('%,d', cast(round(ventas) as bigint)), ',', '.') as ventas_fmt,\n replace(printf('%.1f', market_share * 100), '.', ',') || ' %' as ms_fmt,\n case when crecimiento is null then '–'\n when crecimiento > 0 then '▲ ' || replace(printf('%,d', cast(round(crecimiento) as bigint)), ',', '.') || ''\n when crecimiento < 0 then '▼ ' || replace(printf('%,d', cast(round(abs(crecimiento)) as bigint)), ',', '.') || ''\n else '– 0'\n end as crec_html,\n case when pct_crec is null then '–'\n when pct_crec > 0 then '▲ ' || replace(printf('%.1f', pct_crec * 100), '.', ',') || ' %'\n when pct_crec < 0 then '▼ ' || replace(printf('%.1f', abs(pct_crec) * 100), '.', ',') || ' %'\n else '– 0,0 %'\n end as pct_crec_html\nfrom agg\norder by ventas desc","inputQueryString":"with base as (\n select f.value, f.manufacturer,\n case\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx then 'cur'\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx - 1 then 'prev'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 3 and a.aidx then 'cur'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 7 and a.aidx - 4 then 'prev'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 11 and a.aidx then 'cur'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 23 and a.aidx - 12 then 'prev'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear and f.pidx <= a.aidx then 'cur'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear - 1 and f.pidx <= a.aidx - 12 then 'prev'\n end as bucket\n from marketshare.fact_full f\n cross join (\n select cast('${inputs.anio}' as integer) as ayear,\n cast('${inputs.anio}' as integer) * 12\n + cast('${inputs.mes}' as integer) as aidx\n ) a\n where f.metric = '${inputs.metrica.value}'\n and ('${inputs.pais}' = 'ALL' or f.country_code = '${inputs.pais}')\n),\ntot as (select sum(value) filter (where bucket = 'cur') as mkt_cur from base),\nagg as (\n select\n manufacturer as compania,\n sum(value) filter (where bucket = 'cur') as ventas,\n sum(value) filter (where bucket = 'cur') - sum(value) filter (where bucket = 'prev') as crecimiento,\n case when sum(value) filter (where bucket = 'prev') = 0 then null\n else sum(value) filter (where bucket = 'cur') / sum(value) filter (where bucket = 'prev') - 1 end as pct_crec,\n sum(value) filter (where bucket = 'cur') / (select mkt_cur from tot) as market_share\n from base\n where bucket is not null\n group by 1\n having sum(value) filter (where bucket = 'cur') > 0\n)\nselect\n compania, ventas, crecimiento, pct_crec, market_share,\n replace(printf('%,d', cast(round(ventas) as bigint)), ',', '.') as ventas_fmt,\n replace(printf('%.1f', market_share * 100), '.', ',') || ' %' as ms_fmt,\n case when crecimiento is null then '–'\n when crecimiento > 0 then '▲ ' || replace(printf('%,d', cast(round(crecimiento) as bigint)), ',', '.') || ''\n when crecimiento < 0 then '▼ ' || replace(printf('%,d', cast(round(abs(crecimiento)) as bigint)), ',', '.') || ''\n else '– 0'\n end as crec_html,\n case when pct_crec is null then '–'\n when pct_crec > 0 then '▲ ' || replace(printf('%.1f', pct_crec * 100), '.', ',') || ' %'\n when pct_crec < 0 then '▼ ' || replace(printf('%.1f', abs(pct_crec) * 100), '.', ',') || ' %'\n else '– 0,0 %'\n end as pct_crec_html\nfrom agg\norder by ventas desc","compiled":false,"inline":true},{"id":"vg_top7","compiledQueryString":"with base as (\n select f.value, f.manufacturer,\n case\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx then 'cur'\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx - 1 then 'prev'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 3 and a.aidx then 'cur'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 7 and a.aidx - 4 then 'prev'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 11 and a.aidx then 'cur'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 23 and a.aidx - 12 then 'prev'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear and f.pidx <= a.aidx then 'cur'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear - 1 and f.pidx <= a.aidx - 12 then 'prev'\n end as bucket\n from marketshare.fact_full f\n cross join (\n select cast('${inputs.anio}' as integer) as ayear,\n cast('${inputs.anio}' as integer) * 12\n + cast('${inputs.mes}' as integer) as aidx\n ) a\n where f.metric = '${inputs.metrica.value}'\n and ('${inputs.pais}' = 'ALL' or f.country_code = '${inputs.pais}')\n),\nagg as (\n select\n manufacturer as compania,\n sum(value) filter (where bucket = 'cur') as ventas,\n sum(value) filter (where bucket = 'prev') as ventas_prev\n from base\n where bucket is not null\n group by 1\n having sum(value) filter (where bucket = 'cur') > 0\n)\nselect\n compania,\n ventas,\n ventas - coalesce(ventas_prev, 0) as crecimiento,\n case when ventas_prev is not null and ventas - ventas_prev > 0 then ventas end as \"Sube\",\n case when ventas_prev is not null and ventas - ventas_prev < 0 then ventas end as \"Baja\",\n case when ventas_prev is not null and ventas - ventas_prev = 0 then ventas end as \"Sin cambio\",\n case when ventas_prev is null then ventas end as \"Sin comparativa\"\nfrom agg\norder by ventas desc\nlimit 7","inputQueryString":"with base as (\n select f.value, f.manufacturer,\n case\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx then 'cur'\n when '${inputs.win}' = 'MES' and f.pidx = a.aidx - 1 then 'prev'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 3 and a.aidx then 'cur'\n when '${inputs.win}' = 'L4M' and f.pidx between a.aidx - 7 and a.aidx - 4 then 'prev'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 11 and a.aidx then 'cur'\n when '${inputs.win}' = 'TAM' and f.pidx between a.aidx - 23 and a.aidx - 12 then 'prev'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear and f.pidx <= a.aidx then 'cur'\n when '${inputs.win}' = 'YTD' and f.year = a.ayear - 1 and f.pidx <= a.aidx - 12 then 'prev'\n end as bucket\n from marketshare.fact_full f\n cross join (\n select cast('${inputs.anio}' as integer) as ayear,\n cast('${inputs.anio}' as integer) * 12\n + cast('${inputs.mes}' as integer) as aidx\n ) a\n where f.metric = '${inputs.metrica.value}'\n and ('${inputs.pais}' = 'ALL' or f.country_code = '${inputs.pais}')\n),\nagg as (\n select\n manufacturer as compania,\n sum(value) filter (where bucket = 'cur') as ventas,\n sum(value) filter (where bucket = 'prev') as ventas_prev\n from base\n where bucket is not null\n group by 1\n having sum(value) filter (where bucket = 'cur') > 0\n)\nselect\n compania,\n ventas,\n ventas - coalesce(ventas_prev, 0) as crecimiento,\n case when ventas_prev is not null and ventas - ventas_prev > 0 then ventas end as \"Sube\",\n case when ventas_prev is not null and ventas - ventas_prev < 0 then ventas end as \"Baja\",\n case when ventas_prev is not null and ventas - ventas_prev = 0 then ventas end as \"Sin cambio\",\n case when ventas_prev is null then ventas end as \"Sin comparativa\"\nfrom agg\norder by ventas desc\nlimit 7","compiled":false,"inline":true}]}

Vista General

KPIs — Compañía SN · L4M

Incremento vs período anterior — evolución mensual

Performance del mercado — Top 7