Para acessar a demonstração de gráficos, basta utilizar as seguintes credenciais no APP:
Chave APP: demo
Usuário: usuário demonstração
senha: 123
Caso você queira replicar toda a configuração da "Demo" vamos deixar o link para o download do DUMP do banco e as "Configs" do PlugBot, os links estão no fim do post, para iniciar a réplica você pode consultar essa outra documentação "Como replicar as configurações do PlugBot";
Obs: Para replicar as configurações da demonstração você deve utilizar o PlugBot Desktop.
Grupo Metas
Gráfico 1:
Meta de vendas do Mês e do Ano - Progresso
SQL:
Aba Ano - select 42 as atual, 100 as maximo
Aba Mês - select '100' as maximo, '75' as atual
Gráfico 2:
Vendas nos últimos 5 anos - Barra horizontal
SQL:
select '2016' as label, '107' as value union all
select '2017' as label, '97' as value union all
select '2018' as label, '103' as value union all
select '2019' as label, '121' as value union all
select '2020' as label, '73' as value
Gráfico 3:
Metas de Vendas Mensais - Barra vertical
SQL:
select 'Meta|color:rgba(0, 150, 148, 0.8)|type:line' as label, 300 as value, '01/2021' as bar union
select 'Meta|color:rgba(0, 150, 148, 0.8)|type:line' as label, 300 as value, '02/2021' as bar union
select 'Meta|color:rgba(0, 150, 148, 0.8)|type:line' as label, 300 as value, '03/2021' as bar union
select 'Meta|color:rgba(0, 150, 148, 0.8)|type:line' as label, 300 as value, '04/2021' as bar union
select 'Vendas|color:cyan' as label, 320 as value, '01/2021' as bar union
select 'Vendas|color:cyan' as label, 523 as value, '02/2021' as bar union
select 'Vendas|color:cyan' as label, 432 as value, '03/2021' as bar union
select 'Vendas|color:cyan' as label, 260 as value, '04/2021' as bar
Gráfico 4:
Top 4 Vendedores do Último Mês - Lista com avatar
SQL:
select 'João da Silva' as nome, 'Valor Vendido: R$ 4.234,00' as descricao, 'Meta Individual' as info, '%' as mascara, 'https://i.imgur.com/mMFiUou.png' as foto, '115' as valor union all
select 'Jefferson Rodrigues' as nome, 'Valor Vendido: R$ 3.224,00' as descricao, 'Meta Individual' as info, '%' as mascara, 'https://ca.slack-edge.com/T0HEXERJ6-U8FMA9K1P-b7eee03999bd-72' as foto, '87' as valor union all
select 'Fabio Rogerio' as nome, 'Valor Vendido: R$ 2.550,30' as descricao, 'Meta Individual' as info, '%' as mascara, 'https://ca.slack-edge.com/T0HEXERJ6-U3N8SPA3B-919a2236ffa7-48' as foto, '77' as valor union all
select 'Fernando Silva' as nome, 'Valor Vendido: R$ 1.753,87' as descricao, 'Meta Individual' as info, '%' as mascara, 'https://i.imgur.com/UP1kiPq.png' as foto, '62' as valor
Gráfico 5:
Vendedor em Destaque - Informativo
SQL:
select 'João da Silva' as value, 'https://i.imgur.com/EqVfFx9.png' as image, /*'ion-social-usd' as icon,*/ '115% da Meta Individual Atingida' as label
Grupo Industria
Gráfico 1:
Volume de Negócios - Barra vertical
SQL:
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '1' as bar, 11478 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '2' as bar, 11698 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '3' as bar, 12961 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '4' as bar, 12854 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '5' as bar, 13125 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '6' as bar, 13612 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '7' as bar, 13345 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '8' as bar, 13803 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '9' as bar, 13102 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '10' as bar, 12658 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '11' as bar, 12253 as value union
select 'Volume de Negócios|color:rgb(3, 173, 252)' as label, '12' as bar, 11159 as value
Gráfico 2:
Backorders e Backorders Atendidos - Linha
SQL:
select 'Backorders Atendidos' as label, 188 as value, '1' bar union
select 'Backorders Atendidos' as label, 224 as value, '2' bar union
select 'Backorders Atendidos' as label, 187 as value, '3' bar union
select 'Backorders Atendidos' as label, 156 as value, '4' bar union
select 'Backorders Atendidos' as label, 168 as value, '5' bar union
select 'Backorders Atendidos' as label, 219 as value, '6' bar union
select 'Backorders Atendidos' as label, 197 as value, '7' bar union
select 'Backorders Atendidos' as label, 155 as value, '8' bar union
select 'Backorders Atendidos' as label, 123 as value, '9' bar union
select 'Backorders Atendidos' as label, 238 as value, '10' bar union
select 'Backorders Atendidos' as label, 209 as value, '11' bar union
select 'Backorders Atendidos' as label, 241 as value, '12' bar union
select 'Backorders Atendidos' as label, 243 as value, '13' bar union
select 'Backorders Atendidos' as label, 197 as value, '14' bar union
select 'Backorders Atendidos' as label, 223 as value, '15' bar union
select 'Backorders Atendidos' as label, 179 as value, '16' bar union
select 'Backorders Atendidos' as label, 156 as value, '17' bar union
select 'Backorders Atendidos' as label, 188 as value, '18' bar union
select 'Backorders Atendidos' as label, 265 as value, '19' bar union
select 'Backorders Atendidos' as label, 168 as value, '20' bar union
select 'Backorders Atendidos' as label, 140 as value, '21' bar union
select 'Backorders Atendidos' as label, 161 as value, '22' bar union
select 'Backorders Atendidos' as label, 138 as value, '23' bar union
select 'Backorders Atendidos' as label, 264 as value, '24' bar union
select 'Backorders Atendidos' as label, 290 as value, '25' bar union
select 'Backorders Atendidos' as label, 198 as value, '26' bar union
select 'Backorders Atendidos' as label, 176 as value, '27' bar union
select 'Backorders Atendidos' as label, 294 as value, '28' bar union
select 'Backorders Atendidos' as label, 315 as value, '29' bar union
select 'Backorders Atendidos' as label, 220 as value, '30' bar union
select 'Backorders Atendidos' as label, 236 as value, '31' bar union
select 'Backorders' as label, 305 as value, '1' bar union
select 'Backorders' as label, 421 as value, '2' bar union
select 'Backorders' as label, 280 as value, '3' bar union
select 'Backorders' as label, 313 as value, '4' bar union
select 'Backorders' as label, 335 as value, '5' bar union
select 'Backorders' as label, 302 as value, '6' bar union
select 'Backorders' as label, 310 as value, '7' bar union
select 'Backorders' as label, 362 as value, '8' bar union
select 'Backorders' as label, 344 as value, '9' bar union
select 'Backorders' as label, 386 as value, '10' bar union
select 'Backorders' as label, 296 as value, '11' bar union
select 'Backorders' as label, 311 as value, '12' bar union
select 'Backorders' as label, 339 as value, '13' bar union
select 'Backorders' as label, 306 as value, '14' bar union
select 'Backorders' as label, 362 as value, '15' bar union
select 'Backorders' as label, 337 as value, '16' bar union
select 'Backorders' as label, 374 as value, '17' bar union
select 'Backorders' as label, 309 as value, '18' bar union
select 'Backorders' as label, 368 as value, '19' bar union
select 'Backorders' as label, 299 as value, '20' bar union
select 'Backorders' as label, 321 as value, '21' bar union
select 'Backorders' as label, 334 as value, '22' bar union
select 'Backorders' as label, 326 as value, '23' bar union
select 'Backorders' as label, 328 as value, '24' bar union
select 'Backorders' as label, 333 as value, '25' bar union
select 'Backorders' as label, 307 as value, '26' bar union
select 'Backorders' as label, 264 as value, '27' bar union
select 'Backorders' as label, 313 as value, '28' bar union
select 'Backorders' as label, 329 as value, '29' bar union
select 'Backorders' as label, 370 as value, '30' bar union
select 'Backorders' as label, 318 as value, '31' bar
Gráfico 3:
Inventário para Vendas - Lista
SQL:
select 'Spaghetti' as nome, 7660.90 valor, '1049BR1236' as descricao, '11786 UN' as info union
select 'Pappardelle' as nome, 11463.60 valor, '4589BR7896' as descricao, '9553 UN' as info union
select 'Talharim' as nome, 10289.36 valor, '7896BR2365' as descricao, '12548 UN' as info union
select 'Penne' as nome, 7706.61 valor, '5689BR7892' as descricao, '11169 UN' as info union
select 'Rigatoni' as nome, 10065.12 valor, '2315BR6547' as descricao, '6452 UN' as info union
select 'Fusilli' as nome, 14786.20 valor, '5897BR1236' as descricao, '7865 UN' as info union
select 'Elbow' as nome, 16198.60 valor, '4562BR4569' as descricao, '8756 UN' as info union
select 'Farfalle' as nome, 13395.68 valor, '5563BR6687' as descricao, '11548 UN' as info union
select 'Capellini' as nome, 11132.62 valor, '1324BR4875' as descricao, '8126 UN' as info union
select 'Fetuccine' as nome, 14612.16 valor, '2581BR1234' as descricao, '7856 UN' as info union
select 'Tagliatele' as nome, 11910.30 valor, '7895BR4213' as descricao, '6845 UN' as info union
select 'Linguine' as nome, 13138.71 valor, '8541BR2382' as descricao, '7423 UN' as info
Gráfico 4:
On Time, In Full - Barra vertical
SQL:
Aba "On Time"
select 'On Time|color:rgb(69, 237, 178)' as label, 'Jan' as bar, 88 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Fev' as bar, 91 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Mar' as bar, 89 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Abr' as bar, 92 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Mai' as bar, 93 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Jun' as bar, 94 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Jul' as bar, 93 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Ago' as bar, 95 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Set' as bar, 95 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Out' as bar, 95 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Nov' as bar, 95 as value union
select 'On Time|color:rgb(69, 237, 178)' as label, 'Dez' as bar, 89 as value
Aba "In Full"
select 'In Full|color:rgb(247, 109, 113)' as label, 'Jan' as bar, 95 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Fev' as bar, 96 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Mar' as bar, 95 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Abr' as bar, 95 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Mai' as bar, 94 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Jun' as bar, 95 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Jul' as bar, 94 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Ago' as bar, 95 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Set' as bar, 94 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Out' as bar, 95 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Nov' as bar, 98 as value union
select 'In Full|color:rgb(247, 109, 113)' as label, 'Dez' as bar, 95 as value
Aba "OTIF"
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Jan' as bar, 83.60 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Fev' as bar, 87.36 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Mar' as bar, 85.30 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Abr' as bar, 88.24 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Mai' as bar, 88.45 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Jun' as bar, 89.87 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Jul' as bar, 89.11 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Ago' as bar, 90.82 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Set' as bar, 90.16 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Out' as bar, 91.11 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Nov' as bar, 94.07 as value union
select 'OTIF|color:rgb(77, 151, 247)' as label, 'Dez' as bar, 85.49 as value
Gráfico 5:
Produção por Hora - Barra vertical
SQL:
select 'Produção|color:rgb(66, 133, 244)' as label, 00 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 01 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 02 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 03 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 04 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 05 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 06 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 07 as bar, 989 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 08 as bar, 1233 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 09 as bar, 1518 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 10 as bar, 1518 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 11 as bar, 1518 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 12 as bar, 1518 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 13 as bar, 1518 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 14 as bar, 1518 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 15 as bar, 1518 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 16 as bar, 1233 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 17 as bar, 1233 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 18 as bar, 989 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 19 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 20 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 21 as bar, 0 as value union
select 'Produção|color:rgb(66, 133, 244)' as label, 22 as bar, 0 as value
Gráfico 6:
Tempo Inatividade - Linha
SQL:
select 'Horas|color:rgb(54, 148, 235)' as label, '1' as bar, -0.17 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '2' as bar, -0.39 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '3' as bar, -0.34 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '4' as bar, 0.12 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '5' as bar, -0.38 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '8' as bar, -1.21 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '9' as bar, -0.15 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '10' as bar, -0.04 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '11' as bar, -0.4 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '12' as bar, 0.3 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '15' as bar, -0.19 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '16' as bar, 1.18 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '17' as bar, -0.44 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '18' as bar, -0.22 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '19' as bar, -0.31 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '22' as bar, 0.1 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '23' as bar, 0.12 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '24' as bar, 0.69 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '25' as bar, -0.14 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '26' as bar, -0.09 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '29' as bar, -0.02 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '30' as bar, 0.1 as value union
select 'Horas|color:rgb(54, 148, 235)' as label, '31' as bar, -0.34 as value
Gráfico 7:
Mean Time to Repair - Linha
SQL:
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Jan' as bar, 3.79 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Fev' as bar, 5.12 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Mar' as bar, 3.96 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Abr' as bar, 3.85 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Mai' as bar, 3.81 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Jun' as bar, 4.77 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Jul' as bar, 3.82 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Ago' as bar, 3.75 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Set' as bar, 4.78 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Out' as bar, 3.83 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Nov' as bar, 3.79 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Dez' as bar, 3.74 as value
Gráfico 8:
Nível de utilização da capacidade instalada - Linha
SQL:
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Janeiro' as bar, 55.53 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Fevereiro' as bar, 62.63 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Março' as bar, 76.01 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Abril' as bar, 84.52 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Maio' as bar, 91.22 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Junho' as bar, 89.56 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Julho' as bar, 88.23 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Agosto' as bar, 86.56 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Setembro' as bar, 88.12 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Outubro' as bar, 84.56 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Novembro' as bar, 79.23 as value union
select 'Nível de utilização (%)|color:rgba(104, 158, 247, 1)|type:line' as label, 'Dezembro' as bar, 68.23 as value
Gráfico 9:
Ticket Médio - Linha
SQL:
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Jan' as bar, 14768.45 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Fev' as bar, 14213.57 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Mar' as bar, 14998.76 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Abr' as bar, 15110.98 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Mai' as bar, 14987.67 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Jun' as bar, 15002.45 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Jul' as bar, 15225.43 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Ago' as bar, 15110.90 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Set' as bar, 15013.67 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Out' as bar, 15128.55 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Nov' as bar, 15230.77 as value union
select 'Mês|color:rgba(104, 158, 247, 1)|type:line' as label, 'Dez' as bar, 15222.45 as value
Gráfico 10:
Lote x Vencimento - Lista
SQL:
select 'Spaghetti' as nome, 'Vencimento' as valor, '1049BR1236' as descricao, '09/11/2021' as info union
select 'Pappardelle' as nome, 'Vencimento' as valor, '4589BR7896' as descricao, '03/12/2021' as info union
select 'Talharim' as nome, 'Vencimento' as valor, '7896BR2365' as descricao, '13/12/2021' as info union
select 'Penne' as nome, 'Vencimento' as valor, '5689BR7892' as descricao, '01/04/2022' as info union
select 'Rigatoni' as nome, 'Vencimento' as valor, '2315BR6547' as descricao, '06/04/2022' as info union
select 'Fusilli' as nome, 'Vencimento' as valor, '5897BR1236' as descricao, '18/06/2022' as info union
select 'Elbow' as nome, 'Vencimento' as valor, '4562BR4569' as descricao, '07/07/2022' as info union
select 'Farfalle' as nome, 'Vencimento' as valor, '5563BR6687' as descricao, '15/08/2022' as info union
select 'Capellini' as nome, 'Vencimento' as valor, '1324BR4875' as descricao, '18/09/2022' as info union
select 'Fetuccine' as nome, 'Vencimento' as valor, '2581BR1234' as descricao, '23/09/2022' as info union
select 'Tagliatele' as nome, 'Vencimento' as valor, '7895BR4213' as descricao, '07/10/2022' as info union
select 'Linguine' as nome, 'Vencimento' as valor, '8541BR2382' as descricao, '12/12/2022' as info
Grupo Varejo
Gráfico 1:
Tendência de Leads - Linha
SQL:
select 'Leads|color:rgb(54, 162, 235)' as label, '1' as bar, 3 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '3' as bar, 2 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '5' as bar, 8 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '7' as bar, 6 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '9' as bar, 5 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '11' as bar, 7 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '13' as bar, 5 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '15' as bar, 12 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '17' as bar, 4 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '19' as bar, 6 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '21' as bar, 8 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '23' as bar, 11 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '25' as bar, 8 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '27' as bar, 5 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '29' as bar, 4 as value union
select 'Leads|color:rgb(54, 162, 235)' as label, '31' as bar, 12 as value
Gráfico 2:
Base de clientes - Linha
SQL:
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Jan' as bar, 113 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Fev' as bar, 126 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Mar' as bar, 135 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Abr' as bar, 144 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Mai' as bar, 132 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Jun' as bar, 142 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Jul' as bar, 148 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Ago' as bar, 156 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Set' as bar, 164 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Out' as bar, 182 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Nov' as bar, 173 as value union
select 'Meta|color:rgba(104, 158, 247, 1)|type:line' as label, 'Dez' as bar, 200 as value
Gráfico 3:
Metas de Vendas - Progresso
SQL:
select '133057.72' as atual, '185000' as maximo
Gráfico 4:
Faturamento - Barra Horizontal
SQL:
Aba "Completas"
select 'Out' as label, 172097.88 as value union
select 'Nov' as label, 181435.65 as value union
select 'Dez' as label, 181123.89 as value
Aba "Reembolsadas"
select 'Out' as label, 19767.12 as value union
select 'Nov' as label, 18759.87 as value union
select 'Dez' as label, 15112.33 as value
Aba "Canceladas"
select 'Out' as label, 12856.22 as value union
select 'Nov' as label, 9876.99 as value union
select 'Dez' as label, 9996.24 as value
Gráfico 5:
Ticket Médio - Linha
SQL:
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Jan' as bar, 4768.45 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Fev' as bar, 4213.57 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Mar' as bar, 4998.76 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Abr' as bar, 5110.98 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Mai' as bar, 4987.67 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Jun' as bar, 5002.45 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Jul' as bar, 5225.43 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Ago' as bar, 5225.43 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Set' as bar, 5013.67 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Out' as bar, 5128.55 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Nov' as bar, 5230.77 as value union
select 'Ticket|color:rgb(54, 148, 235)' as label, 'Dez' as bar, 5222.45 as value
Gráfico 6:
ROI - Linha
SQL:
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Jan' as bar, 1.88 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Fev' as bar, 1.64 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Mar' as bar, 1.67 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Abr' as bar, 1.43 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Mai' as bar, 1.81 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Jun' as bar, 1.89 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Jul' as bar, 1.91 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Ago' as bar, 1.72 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Set' as bar, 1.69 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Out' as bar, 2.3 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Nov' as bar, 1.96 as value union
select 'Ticket|color:rgb(67, 227, 232)' as label, 'Dez' as bar, 1.6 as value
Gráfico 7:
Conversão em Oportunidades - Rosquinha
SQL:
select 'Oportunidades' as label, 118 as value union
select 'Leads' as label, 131 as value
Gráfico 8:
Taxa de Perda - Pizza
SQL:
select 'Perdas' as label, 3465 as value union
select 'Total' as label, 12000 as value
Gráfico 9:
Satisfação dos Clientes - Barra vertical
SQL:
select 'Satisfeitos|color:rgb(46, 243, 171)' as label, 'Dezembro' as bar, 156 as value union
select 'Total de atendimentos|color:rgb(54, 162, 235)' as label, 'Dezembro' as bar, 254 as value union
select 'Insatisfeitos|color:rgb(255, 99, 132)' as label, 'Dezembro' as bar, 98 as value
Gráfico 10:
Receitas - Barra Vertical
SQL:
Aba "Receitas"
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Jan' as bar, 140987.64 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Fev' as bar, 138580.91 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Mar' as bar, 138745.22 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Abr' as bar, 141675.76 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Mai' as bar, 138765.89 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Jun' as bar, 152458.32 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Jul' as bar, 149456.45 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Ago' as bar, 140998.70 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Set' as bar, 141969.16 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Out' as bar, 139474.54 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Nov' as bar, 152798.79 as value union
select 'Receitas|color:rgb(54, 235, 114)' as label, 'Dez' as bar, 156015.32 as value
Aba "Despesas"
select 'Despesas' as label, 'Jan' as bar, 52347.89 as value union
select 'Despesas' as label, 'Fev' as bar, 58444.56 as value union
select 'Despesas' as label, 'Mar' as bar, 56784.43 as value union
select 'Despesas' as label, 'Abr' as bar, 54673.87 as value union
select 'Despesas' as label, 'Mai' as bar, 55664.35 as value union
select 'Despesas' as label, 'Jun' as bar, 53478.65 as value union
select 'Despesas' as label, 'Jul' as bar, 55668.97 as value union
select 'Despesas' as label, 'Ago' as bar, 56346.23 as value union
select 'Despesas' as label, 'Set' as bar, 52998.76 as value union
select 'Despesas' as label, 'Out' as bar, 54634.55 as value union
select 'Despesas' as label, 'Nov' as bar, 52347.89 as value union
select 'Despesas' as label, 'Dez' as bar, 58532.88 as value
Gráfico 11:
<Nome grafico> - <Tipo grafico>
SQL:
query grafico
Gráfico 12:
Estoque por Produto - Barra vertical
SQL:
select 'Estoque mínimo' as label, 'Produto A' as bar, 300 as value union
select 'Estoque mínimo' as label, 'Produto B' as bar, 400 as value union
select 'Estoque mínimo' as label, 'Produto C' as bar, 300 as value union
select 'Estoque mínimo' as label, 'Produto D' as bar, 350 as value union
select 'Estoque mínimo' as label, 'Produto E' as bar, 500 as value union
select 'Qtde' as label, 'Produto A' as bar, 346 as value union
select 'Qtde' as label, 'Produto B' as bar, 584 as value union
select 'Qtde' as label, 'Produto C' as bar, 312 as value union
select 'Qtde' as label, 'Produto D' as bar, 415 as value union
select 'Qtde' as label, 'Produto E' as bar, 348 as value
Gráfico 13:
Capacidade de Armazenamento - Progresso
SQL:
select 2005 as atual, 4000 as maximo
Gráfico 14:
NPS - Informativo
SQL:
select '6,14' as value, 'NPS' as label
Gráfico 15:
Tempo Médio de Atendimento Diário - Linha
SQL:
select 'Minutos|color:rgb(54, 148, 235)' as label, '1' as bar, 12 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '3' as bar, 9 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '5' as bar, 10 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '7' as bar, 10 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '9' as bar, 7 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '11' as bar, 10 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '13' as bar, 18 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '15' as bar, 11 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '17' as bar, 9 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '19' as bar, 11 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '21' as bar, 10 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '23' as bar, 10 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '25' as bar, 8 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '27' as bar, 9 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '29' as bar, 10 as value union
select 'Minutos|color:rgb(54, 148, 235)' as label, '31' as bar, 11 as value
Gráfico 16:
Vendas por produto - Lista
SQL:
select 'Produto A' as nome, 36815.82 valor, 'Produto' as descricao, '647 UN' as info union
select 'Produto B' as nome, 29719.47 valor, 'Produto' as descricao, '398 UN' as info union
select 'Produto C' as nome, 24435.56 valor, 'Produto' as descricao, '428 UN' as info union
select 'Produto D' as nome, 21067.43 valor, 'Produto' as descricao, '291 UN' as info union
select 'Produto E' as nome, 21019.44 valor, 'Produto' as descricao, '357 UN' as info
Grupo Financeiro:
Gráfico 1:
Metas de Vendas - Progresso
SQL:
select 45000 as maximo, 33077.80 as atual
Gráfico 2:
Formas de Pagamento - Pizza
SQL:
select 584 as value, 'Cartão de Crédito' as label union
select 452 as value, 'Dinheiro' as label union
select 553 as value, 'Cartão de Débito' as label union
select 374 as value, 'PIX' as label union
select 103 as value, 'Boleto Bancário' as label
Gráfico 3:
Faturamento - Rosquinha
SQL:
select 9328.92 as value, 'Cartão de Crédito' as label union
select 6773.75 as value, 'Dinheiro' as label union
select 8612.25 as value, 'Cartão de Débito' as label union
select 5257.56 as value, 'PIX' as label union
select 3105.32 as value, 'Boleto Bancário' as label
Grupo Comercial:
Gráfico 1:
As 3 categorias mais vendidas - Barra vertical
SQL:
Aba "Mês"
select 'Moda e Acessórios|color:rgba(255,255,255,0.6)' as label, 'Vendas' as bar, 56677 as value union all
select 'Eletrodomésticos|color:rgba(255,255,255,0.6)' as label, 'Vendas' as bar, 72677 as value union all
select 'Informática|color:rgba(255,255,255,0.6)' as label, 'Vendas' as bar, 26677 as value
Aba "Semana"
select 'Moda e Acessórios|color:rgba(255,255,255,0.6)' as label, 'Vendas' as bar, 6677 as value union all
select 'Eletrodomésticos|color:rgba(255,255,255,0.6)' as label, 'Vendas' as bar, 2677 as value union all
select 'Informática|color:rgba(255,255,255,0.6)' as label, 'Vendas' as bar, 6677 as value
Aba "Dia"
select 'Moda e Acessórios|color:rgba(255,255,255,0.6)' as label, 'Vendas' as bar, 233 as value union all
select 'Eletrodomésticos|color:rgba(255,255,255,0.6)' as label, 'Vendas' as bar, 123 as value union all
select 'Informática|color:rgba(255,255,255,0.6)' as label, 'Vendas' as bar, 212 as value
Gráfico 2:
Total de Vendas - Linhas
SQL:
Aba "Dia"
select 'Acessórios masculinos|color:#fff' as label, '8H' as bar, 123 as value union all
select 'Acessórios masculinos|color:#fff' as label, '9H' as bar, 221 as value union all
select 'Acessórios masculinos|color:#fff' as label, '10H' as bar, 212 as value union all
select 'Acessórios masculinos|color:#fff' as label, '11H' as bar, 23 as value union all
select 'Acessórios masculinos|color:#fff' as label, '12H' as bar, 32 as value union all
select 'Acessórios masculinos|color:#fff' as label, '13H' as bar, 43 as value union all
select 'Acessórios masculinos|color:#fff' as label, '14H' as bar, 12 as value union all
select 'Acessórios masculinos|color:#fff' as label, '15H' as bar, 22 as value union all
select 'Acessórios femininos|color:#fff' as label, '8H' as bar, 123 as value union all
select 'Acessórios femininos|color:#fff' as label, '9H' as bar, 221 as value union all
select 'Acessórios femininos|color:#fff' as label, '10H' as bar, 212 as value union all
select 'Acessórios femininos|color:#fff' as label, '11H' as bar, 23 as value union all
select 'Acessórios femininos|color:#fff' as label, '12H' as bar, 32 as value union all
select 'Acessórios femininos|color:#fff' as label, '13H' as bar, 43 as value union all
select 'Acessórios femininos|color:#fff' as label, '14H' as bar, 12 as value union all
select 'Acessórios femininos|color:#fff' as label, '15H' as bar, 22 as value
Aba "Semana"
select 'Acessórios masculinos|color:#fff' as label, 'QUA' as bar, 287 as value union all
select 'Acessórios masculinos|color:#fff' as label, 'QUI' as bar, 7212 as value union all
select 'Acessórios masculinos|color:#fff' as label, 'SEX' as bar, 6212 as value union all
select 'Acessórios masculinos|color:#fff' as label, 'SAB' as bar, 2123 as value union all
select 'Acessórios masculinos|color:#fff' as label, 'DOM' as bar, 0 as value union all
select 'Acessórios masculinos|color:#fff' as label, 'SEG' as bar, 8123 as value union all
select 'Acessórios masculinos|color:#fff' as label, 'TER' as bar, 5342 as value union all
select 'Acessórios femininos|color:#fff' as label, 'QUA' as bar, 287 as value union all
select 'Acessórios femininos|color:#fff' as label, 'QUI' as bar, 7212 as value union all
select 'Acessórios femininos|color:#fff' as label, 'SEX' as bar, 6212 as value union all
select 'Acessórios femininos|color:#fff' as label, 'SAB' as bar, 2123 as value union all
select 'Acessórios femininos|color:#fff' as label, 'DOM' as bar, 0 as value union all
select 'Acessórios femininos|color:#fff' as label, 'SEG' as bar, 8213 as value
Aba "Mês"
select 'Acessórios femininos|color:#fff' as label, '08/17' as bar, 217667 as value union all
select 'Acessórios femininos|color:#fff' as label, '09/17' as bar, 207667 as value union all
select 'Acessórios femininos|color:#fff' as label, '10/17' as bar, 187667 as value union all
select 'Acessórios femininos|color:#fff' as label, '11/17' as bar, 127667 as value union all
select 'Acessórios femininos|color:#fff' as label, '12/17' as bar, 187667 as value union all
select 'Acessórios femininos|color:#fff' as label, '01/18' as bar, 117667 as value union all
select 'Acessórios femininos|color:#fff' as label, '02/18' as bar, 127667 as value union all
select 'Acessórios femininos|color:#fff' as label, '03/18' as bar, 137667 as value union all
select 'Acessórios femininos|color:#fff' as label, '04/18' as bar, 7667 as value union all
select 'Acessórios masculinos|color:#fff' as label,'08/17' as bar, 217667 as value union all
select 'Acessórios masculinos|color:#fff' as label,'09/17' as bar, 207667 as value union all
select 'Acessórios masculinos|color:#fff' as label,'10/17' as bar, 187667 as value union all
select 'Acessórios masculinos|color:#fff' as label,'11/17' as bar, 127667 as value union all
select 'Acessórios masculinos|color:#fff' as label,'12/17' as bar, 187667 as value union all
select 'Acessórios masculinos|color:#fff' as label,'01/18' as bar, 117667 as value union all
select 'Acessórios masculinos|color:#fff' as label,'02/18' as bar, 127667 as value union all
select 'Acessórios masculinos|color:#fff' as label,'03/18' as bar, 137667 as value union all
select 'Acessórios masculinos|color:#fff' as label,'04/18' as bar, 7667 as value
Gráfico 3:
Total de vendas diária por categoria - Linha
SQL:
select 'Categoria A' as label, 'QUA' as bar, 187 as value union all
select 'Categoria A' as label, 'QUI' as bar, 5212 as value union all
select 'Categoria A' as label, 'SEX' as bar, 8212 as value union all
select 'Categoria A' as label, 'SAB' as bar, 1123 as value union all
select 'Categoria A' as label, 'DOM' as bar, 0 as value union all
select 'Categoria A' as label, 'SEG' as bar, 4123 as value union all
select 'Categoria A' as label, 'TER' as bar, 1342 as value union all
select 'Categoria B' as label,'QUA'as bar, 287 as value union all
select 'Categoria B' as label,'QUI'as bar, 7212 as value union all
select 'Categoria B' as label,'SEX'as bar, 6212 as value union all
select 'Categoria B' as label,'SAB'as bar, 2123 as value union all
select 'Categoria B' as label,'DOM'as bar, 0 as value union all
select 'Categoria B' as label,'SEG'as bar, 8123 as value union all
select 'Categoria B' as label,'TER'as bar, 5342 as value
Gráfico 4:
Top 5 Produtos mais vendidos - Lista
SQL:
select 'Notebook Lenovo Ideapad 320 Intel Core i7-7500u 8GB' as nome, 'Notebook' as descricao, '564 UN' as info, 23045 as valor union all
select 'Notebook Acer A515-51G-58VH Intel Cori i5 8GB' as nome, 'Notebook' as descricao, '376 UN' as info, 21245 as valor union all
select 'MacBook Air MQD32BZ/A com Intel Core i5 Dual Core 8GB' as nome, 'Notebook' as descricao, '126 UN' as info, 20245 as valor union all
select 'Smartphone Samsung Galaxy J7 Metal' as nome, 'Celulares e Smartphones' as descricao, '234 UN' as info, 12876 as valor union all
select 'iPhone 8 Cinza Espacial 64 GB' as nome, 'Celulares e Smartphones' as descricao, '24 UN' as info, 1276 as valor
Grupo Estoque:
Gráfico 1:
Lista de Produtos no Estoque - Lista
SQL:
select 'ZTE KIS C341 Preto' as nome, 'Celulares e Smartphones' as descricao, 'R$ 279,00' as info, 18 valor union all
select 'Samsung Galaxy S7 Dourado' as nome, 'Celulares e Smartphones' as descricao, 'R$ 1.153,39' as info, 178 valor union all
select 'TV LG 32JF88473 32”' as nome, 'Televisores e SmartTV' as descricao, 'R$ 1.399,99' as info, 237 valor union all
select 'SmartTV Samsung UN344H292 40”' as nome, 'Televisores e SmartTV' as descricao, 'R$ 1.699,99' as info, 80 valor union all
select 'MacBook Air 13" Prateado' as nome, 'Notebooks e Computadores' as descricao, 'R$ 6.300,00' as info, 105 valor union all
select 'Xiaomi Redmi 9A Azul' as nome, 'Celulares e Smartphones' as descricao, 'R$ 809,10' as info, 320 valor union all
select 'iPhone XR Apple Branco 6,1” 12MP' as nome, 'Celulares e Smartphones' as descricao, 'R$ 3.648,99' as info, 152 valor union all
select 'Motorola Moto Z2 Play Tela 5.5" Platinum' as nome, 'Celulares e Smartphones' as descricao, 'R$ 1.499,00' as info, 291 valor union all
select 'LG G4 Single H815P' as nome, 'Celulares e Smartphones' as descricao, 'R$ 811,00' as info, 356 valor union all
select 'Asus Live G500 Preto' as nome, 'Celulares e Smartphones' as descricao, 'R$ 799,00' as info, 412 valor union all
select 'iPhone 6S 64GB Cinza Espacial' as nome, 'Celulares e Smartphones' as descricao, 'R$ 2.299,90' as info, 122 valor
order by valor desc
Gráfico 2:
Os 4 produtos com mais estoque - Pizza
SQL:
select 'Asus Live G500 Preto' as label, 412 as value union all
select 'LG G4 Single H815P' as label, 356 as value union all
select 'Xiaomi Redmi 9A Azul' as label, 320 as value union all
select 'Motorola Moto Z2 Play Tela 5.5" Platinum' as label, 291 as value
Gráfico 1:
Produtos com estoque abaixo do mínimo - Barra Vertical
SQL:
select 'Estoque atual|color:rgba(255,255,255,0.8)' as label, 'iPhone 6S 64GB Cinza Espacial' as bar, 122 as value union all
select 'Estoque atual|color:rgba(255,255,255,0.8)' as label, 'iPhone XR Apple Branco 6,1” 12MP' as bar, 152 as value union all
select 'Estoque atual|color:rgba(255,255,255,0.8)' as label, 'ZTE KIS C341 Preto' as bar, 18 as value union all
select 'Estoque atual|color:rgba(255,255,255,0.8)' as label, 'SmartTV Samsung UN344H292 40' as bar, 80 as value union all
select 'Estoque mínimo|color:rgba(0,0,0,0.8)' as label, 'iPhone 6S 64GB Cinza Espacial' as bar, 150 as value union all
select 'Estoque mínimo|color:rgba(0,0,0,0.8)' as label, 'iPhone XR Apple Branco 6,1” 12MP' as bar, 200 as value union all
select 'Estoque mínimo|color:rgba(0,0,0,0.8)' as label, 'ZTE KIS C341 Preto' as bar, 20 as value union all
select 'Estoque mínimo|color:rgba(0,0,0,0.8)' as label, 'SmartTV Samsung UN344H292 40' as bar, 100 as value
Box 1
Info: Estoque atual
select 372 as value
Box 2
Info: Estoque mínimo
select 470 as value
Grupo Suporte:
Gráfico 1:
Total de Atendimentos - Rosquinha
SQL:
Aba Ontem:
select 37 as value, 'Chat' as label union
select 19 as value, 'Ticket' as label union
select 9 as value, 'Telefone' as label union
select 6 as value, 'Comunidade' as label
Aba Semana Passada:
select 180 as value, 'Chat' as label union
select 75 as value, 'Ticket' as label union
select 37 as value, 'Telefone' as label union
select 15 as value, 'Comunidade' as label
Gráfico 2:
Satisfação dos Clientes - Barra vertical
SQL:
select 'Clientes Satisfeitos|color:rgba(66,255,167,0.8)' as label, 'JAN' as bar, 736 as value union all
select 'Clientes Satisfeitos|color:rgba(66,255,167,0.8)' as label, 'FEV' as bar, 508 as value union all
select 'Clientes Satisfeitos|color:rgba(66,255,167,0.8)' as label, 'MAR' as bar, 812 as value union all
select 'Total de Atendimentos|color:rgba(66,154,255,0.8)' as label, 'JAN' as bar, 948 as value union all
select 'Total de Atendimentos|color:rgba(66,154,255,0.8)' as label, 'FEV' as bar, 612 as value union all
select 'Total de Atendimentos|color:rgba(66,154,255,0.8)' as label, 'MAR' as bar, 1076 as value union all
select 'Clientes Insatisfeitos|color:rgba(255,105,105,0.8)' as label, 'JAN' as bar, 212 as value union all
select 'Clientes Insatisfeitos|color:rgba(255,105,105,0.8)' as label, 'FEV' as bar, 104 as value union all
select 'Clientes Insatisfeitos|color:rgba(255,105,105,0.8)' as label, 'MAR' as bar, 264 as value
Gráfico 3:
Total de Atendimentos - Lista com avatar
SQL:
select 'João Silva' as nome,'Consultor Técnico' as descricao, '-' as info, ' Atendimentos' as mascara,'https://image.freepik.com/vetores-gratis/perfil-de-avatar-de-homem-no-icone-redondo_24640-14044.jpg' as foto, 334 valor union
select 'Marcos Paulo' as nome,'Vendedor' as descricao, '-' as info, ' Atendimentos' as mascara,'https://image.freepik.com/vetores-gratis/perfil-de-avatar-de-homem-no-icone-redondo_24640-14044.jpg' as foto, 378 valor union
select 'Pedro Lucas' as nome,'Consultor Técnico' as descricao, '-' as info, ' Atendimentos' as mascara,'https://image.freepik.com/vetores-gratis/perfil-de-avatar-de-homem-no-icone-redondo_24640-14044.jpg' as foto, 364 valor
order by valor desc
Grupo Restaurante:
Gráfico 1:
Custo fixo mensal - Barra vertical
SQL:
select 'Aluguel' label, 3000 as value, '07/2020'bar union
select 'Cozinheiro' label, 1450 as value, '07/2020'bar union
select 'Internet' label, 150 as value, '07/2020'bar union
select 'Gás' label, 500 as value, '07/2020' bar union
select 'Entregador' label, 1600 as value, '07/2020' bar
Gráfico 2:
Formas de Pagamentos por Mês - Pizza
SQL:
select 'Cartão de Crédito' label, 102 value union
select 'Cartão de Débito' label, 67 value union
select 'Dinheiro' label, 137 value union
select 'Ticket Alimentação/ Refeição' label, 146 value
Gráfico 3:
Os 4 Pratos Mais Pedidos - Indicador
SQL:
select 'Prato Tradicional' as label, 312 as value, 'https://i.imgur.com/3XaZyGs.png' as image union
select 'Porção de Batata' as label, 264 as value, 'https://i.imgur.com/wuGWXV2.png' as image union
select 'Porção de Tilápia' as label, 202 as value, 'https://i.imgur.com/gUe5A8B.png' as image union
select 'Feijoada' as label, 197 as value, 'https://i.imgur.com/UEej2Uo.png' as image
Gráfico 4:
Total de pedidos semanais - Barra Vertical
SQL:
Select 'Pedidos |color:orange' as label, 20 as value, 'Segunda' as bar union
Select 'Pedidos |color:orange' as label, 16 as value, 'Terça' as bar union
Select 'Pedidos |color:orange' as label, 22 as value, 'Quarta' as bar union
Select 'Pedidos |color:orange' as label, 13 as value, 'Quinta' as bar union
Select 'Pedidos |color:orange' as label, 18 as value, 'Sexta' as bar union
Select 'Pedidos |color:orange' as label, 35 as value, 'Sabado' as bar
Gráfico 5:
Pedidos Delivery - Linha
SQL:
select 'iFood' as label, 56 as value, '02/2020' bar union
select 'iFood' as label, 42 as value, '03/2020' bar union
select 'iFood' as label, 78 as value, '04/2020' bar union
select 'iFood' as label, 128 as value, '05/2020' bar union
select 'iFood' as label, 102 as value, '06/2020' bar union
select 'Uber Eats' as label, 80 as value, '02/2020' bar union
select 'Uber Eats' as label, 68 as value, '03/2020' bar union
select 'Uber Eats' as label, 85 as value, '04/2020' bar union
select 'Uber Eats' as label, 70 as value, '05/2020' bar union
select 'Uber Eats' as label, 78 as value, '06/2020' bar
Link para download do arquivo de configuração do PlugBot com a Demonstração e o DUMP do banco de dados:
https://drive.google.com/drive/folders/1BOWu09qbtTpkDS5BTvhGEcaEIHbWsvCn
Como replicar as configurações do PlugBot:
https://atendimento.tecnospeed.com.br/hc/pt-br/articles/4799150811415-Como-Replicar-as-Configura%C3%A7%C3%B5es-PlugBot
Comentários
0 comentário
Por favor, entre para comentar.