whaticket-community
whaticket-community copied to clipboard
Published
20 hours ago •
canove
canove
[Feature Suggestion] More Statistics
Can you add more statistics to the Dashboard ? Example:
Total Number of Contacts Charged
select count(*) as Cantidad_Contactos from Contacts;
Total number of messages received
select count(fromMe) Mensajes_Recibidos from Messages
where fromMe = 0;
Number of messages received per day
select count(fromMe) Mensajes_Recibidos from Messages
where fromMe = 0 and Messages.createdAt like '2020-12-02%';
Total Number of Messages Sent
select count(fromMe) Mensajes_Enviados from Messages
where fromMe = 1;
Total Number of Messages Sent by User
select count(T.id) as Mensajes_Enviados,
U.name as Operador
from Messages
inner join Tickets T on Messages.ticketId = T.id
inner join Users U on T.userId = U.id
where fromMe = 1 and Messages.createdAt like '2020-12-02%'
group by Operador;
Total Number of Messages Sent per User per Day
select count(T.id) as Mensajes_Enviados,
U.name as Operador
from Messages
inner join Tickets T on Messages.ticketId = T.id
inner join Users U on T.userId = U.id
where fromMe = 1 and Messages.createdAt like '2020-12-02%'
group by Operador;
Total number of messages sent per day
select count(*) as Total
from Messages
where createdAt LIKE '2020-12-03%';
Number of tickets open per User
select count(status),name from Tickets
inner join Users on Tickets.userId = Users.id
where status = 'open' group by name;
Number of Tickets Closed per User
select count(status),name from Tickets
inner join Users on Tickets.userId = Users.id
where status = 'closed' group by name;
Number of Tickets Earring per User
select count(status),name from Tickets
inner join Users on Tickets.userId = Users.id
where status = 'pending' group by name;
Number of Messages Sent with a whatsapp account
select count(ticketId) Cantidad, name Numero_Telefono from Tickets
inner join Messages M on Tickets.id = M.ticketId
inner join Whatsapps W on Tickets.whatsappId = W.id
where fromMe = '1' /* Mensajes Salientes */
group by name;
Number yield
select name Numero,status Estado,DATEDIFF(updatedAt,createdAt) as DiasActivo from Whatsapps;
