Plotting posts on a graph

You can do that with a custom SQL query, something along the lines of:

global $wpdb;
$results = $wpdb->get_results( "SELECT DATE(post_date) AS d, COUNT(*) AS c FROM $wpdb->posts WHERE post_status="publish" GROUP BY d" );

You’ll get an array of objects where d is the date and c is the number of posts published on that date. You should also put LIMIT constraints if you plan to query large datasets.

Hope this helps.

Related Posts:

  1. How to get post creation date?
  2. Changing the post date and time with function
  3. WordPress removing tags?
  4. Add tag to post api wordpress
  5. Set tags for a post – without tag creation
  6. Is it possible to Schedule Attachments in WordPress?
  7. How to put last edited entry on top of the blog-post list?
  8. Plain-text tag list?
  9. Edit a post from frontend. post_tags get saved, but not separated
  10. Update existing post dates to random dates
  11. featuring old articles without messing up with the archive
  12. how to limit and display tag?
  13. Include related posts on a page
  14. Human Time Diff, change mins to minutes
  15. Display custom post types by date field
  16. How to add shortcode tags in single.php [closed]
  17. Remove post_tag from default post type, add custom taxonomy
  18. Fetch posts from current week (Sunday to Saturday)
  19. How to set post expiration date and time and move the page to archive after expiration [closed]
  20. How to display all posts assigned to some tag?
  21. How To Add One Tag to Multiple Posts?
  22. Add Post Tags to Body Class
  23. Get random posts between specific dates / of specific age
  24. WP Query – duplicated posts once including tags in search results
  25. XML-RPC and post_date
  26. wp_tag_cloud() and the_taxonomies() work but not the_tag()
  27. Automatically republish old posts
  28. Tags to Post-ID mysql query. Tag Search
  29. Replace ‘published on date’ with ‘modified on date’ on Posts
  30. Display post from current category and same tag?
  31. How can I show many posts an author has per week?
  32. Should I use posts or pages in this scenario?
  33. “more” tag doesn’t appear when browsing category achives or search
  34. Display tag image in post using Taxonomy Images plugin index.php
  35. Help with Taxonomies
  36. WordPress Sidebar menu for posts based on date – guidance needed
  37. How can I hide tags on a child-category page, if that tag has not been used?
  38. date issue with category post retrival
  39. How to get date of post when using wp_get_recent_posts()?
  40. How to get a post’s content? [closed]
  41. Conditionals if tags exist?
  42. How to remove specific tag from multiple posts?
  43. How to get posts published on the latest date?
  44. Extracting relevant tags associated with that particular single post only
  45. How to change the layout of posts when viewing all posts by tag [closed]
  46. How to get post with associated categories and tags names instead of ids with rest api?
  47. Tags on products vs tags on blog posts. An easy way to duplicate them
  48. Changing Post Tag Color Based On Post Count
  49. How to update all posts at once?
  50. Assigning Two Different Post Dates For Single Post
  51. Using system date format
  52. Removing all post tags except a given list
  53. Add “Posted on” to post date
  54. Auto update post title and slug when post status is changed
  55. How to check if there are posts with the same tag
  56. In what context should Categories and Tags be used
  57. wp_query if have posts show date but not in loop
  58. Retrieving posts by their date and category
  59. How to compare post tags?
  60. Getting an extra post’s meta data?
  61. Short link to read complete post
  62. Delete all Tag Links from Posts
  63. How to Rearrange WordPress Tags list on frontend using Shortcode with specific order?
  64. Post date automatically +100 years into the future
  65. Can I show category name in url for only one of my categories?
  66. how to add tags to post in the Loop?
  67. Is there a way to categorize a list posts all at once?
  68. Change Old WordPress Post Date Year
  69. Css and function issue on author archive page
  70. Tag for custom post type
  71. WordPress get tags in “publish_post” hook
  72. Need to display a Jan 1st post as the site’s front page on Jan 1st, and Jan 2nd post as front page on Jan 2nd etc
  73. Top tags with minimum number of posts
  74. Set a post expiration and delete a post when expirate
  75. How to count posts in tags within time limit
  76. Why do I have categories with duplicate slugs?
  77. Exclude posts in home slider from sections
  78. Display Updated Date Instead of Published Date
  79. Display all tags even if they are not assigned to a post
  80. How do you update post date (year only) in a separate custom field?
  81. getting custom post by tag
  82. Replace Tag Keyword With Link Within Post Content
  83. show only one category and filter by tag
  84. How to hide meta from search result only on pages?
  85. How do I display posts ordered by a date custom field?
  86. Compare date of user’s last posts
  87. Query post for today, if no post get the previous one
  88. Hide Certain Tags on Single Post Page
  89. Display only current page -> posts tags in page
  90. Add tags to post before it’s created
  91. Display metabox with date
  92. How can I count articles retrieved by tags
  93. Display the popular tags by default in the backend post edit page (without having to click on the link that displays them) [closed]
  94. How to display a certain template element only for posts published within certain time range?
  95. the_time() cannot be placed correctly
  96. How to remove a specific script from bulk wordpress posts and images description?
  97. WordPress More tag doesn’t work on Single post
  98. how show post date for specific post?
  99. Insert Tag in WordPress Post
  100. WordPress converting ‘ to ’ and – to –?