Dati e Grafici 📊️

È bello, quando si hanno dati derivabili dalle proprie cose, poterli visualizzare con grafici intriganti… quindi, ecco qui.

Alcuni grafici sono generati grazie al plugin SQL Chart Builder, con una piccola modifica che rende visibile il codice sorgente SQL usato, che potete copiare!

Post al Giorno (Mensile)

SQL Code

SELECT * 
FROM (
  SELECT
    COUNT(*) AS postCount,
    SUBSTRING(`post_date_gmt`,1,10) AS postDate
  FROM avwp_posts
    WHERE post_type = "post"
    AND post_status = "publish"
  GROUP BY postDate
  ORDER BY postDate DESC
  LIMIT 31
) AS _
ORDER BY postDate ASC;

Parole al Giorno (Mensile, approssimato)

SQL Code

SELECT * 
FROM (
  SELECT
    -- https://stackoverflow.com/questions/41952250/sql-string-counting-words-inside-a-string
    SUM(LENGTH(REPLACE(REPLACE(REPLACE(post_content, " ", "><"), "<>", ""), "><", " ")) - LENGTH(REPLACE(REPLACE(REPLACE(REPLACE(post_content, " ", "><"), "<>", ""), "><", " "), " ", ""))) AS wordCount,
    SUBSTRING(`post_date_gmt`,1,10) AS postDate
  FROM avwp_posts
    WHERE post_type = "post"
    AND post_status = "publish"
  GROUP BY postDate
  ORDER BY postDate DESC
  LIMIT 31
) AS _
ORDER BY postDate ASC;

Post al Giorno (Annuale)

SQL Code

SELECT * 
FROM (
  SELECT
    COUNT(*) AS postCount,
    SUBSTRING(`post_date_gmt`,1,10) AS postDate
  FROM avwp_posts
    WHERE post_type = "post"
    AND post_status = "publish"
  GROUP BY postDate
  ORDER BY postDate DESC
  LIMIT 365
) AS _
ORDER BY postDate ASC;

Tag Cloud

Post al Giorno (Mensile)

Parole al Giorno (Mensile, approssimato)

Post al Giorno (Annuale)