I did look at implementing this some times ago, and this is sadly a way bigger change than I anticipated. The frontend part could be a reasonable amount of work, however the named periods are deeply used in backend, with even database columns named after the periods. This is due to the fact that this is an heavy computation.
While I would agree this would be a nice feature, I think this is too much work ATM.
Concerning a workaround for your case @ShanuM you can use:
/admin/reports/topicswhich will let you know how many topics were created on a specific period of time, which I understand is not exactly your query- the data explorer plugin (GitHub - discourse/discourse-data-explorer: SQL Queries for admins in Discourse · GitHub) if available to you
I will think of solution tomorrow, which could be a custom report, or maybe some custom code in TopTopic to allow this. Will update by the end of the day tomorrow.