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:

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:

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:

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:

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:

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:

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:

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