SELECT 
CONCAT("<font color=orange size=1>",repeat('█', COUNT(*)/10),"</font>") as "Grafico/Graph",
DATE(fecha_edicion) as "Fecha",COUNT(*) as "Interacciones", FORMAT(AVG(lineas),0) as "Prom_Lineas", IF(AVG(caracteres)>1024000, CONCAT(FORMAT(AVG(caracteres)/1024000,0)," Mb"), IF(AVG(caracteres)>1024,CONCAT(FORMAT(AVG(caracteres)/1024,0)," Kb"),CONCAT(FORMAT(AVG(caracteres),0)," bytes"))) as "Prom_Tamano/Size"
FROM core_pcoder_historial
GROUP BY (DATE(fecha_edicion)) ORDER BY DATE(fecha_edicion) DESC LIMIT 0,30
