# Reporting number of entities created over time

**URL:** <https://community.fibery.io/t/reporting-number-of-entities-created-over-time/3762>\
**Category:** Get Help\
**Created:** [January 3, 2023, 10:36am UTC](https://community.fibery.io/t/reporting-number-of-entities-created-over-time/3762 "2023-01-03T10:36:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pmackay](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/pmackay/32/3856_2.png) [@pmackay](https://community.fibery.io/u/pmackay)\
**Post date:** [January 3, 2023, 10:36am UTC](https://community.fibery.io/t/reporting-number-of-entities-created-over-time/3762/1 "2023-01-03T10:36:01Z")

</div>

I’d like a report that shows the number of entities from a database created over time, e.g. X-axis shows number/week.

I tried doing the default Count of records but that looks to show the count of all records currently open at that time, which is not the same.

Any tips appreciated!

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [January 3, 2023, 1:13pm UTC](https://community.fibery.io/t/reporting-number-of-entities-created-over-time/3762/2 "2023-01-03T13:13:06Z")

</div>

Try setting the chart x-axis to `Creation Date`, grouped by week, and configured with periodic scale.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/a/adb8de54c00febaab0e800d30e0ba1b725125a3a.png)

Then set the y-axis to Count of Records: `COUNT([Public Id])`

Here’s how it looks for me (displayed as a histogram)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0103f4e7954d88dd75b0b4d7af53c36c0af1665b.png)

Is that close to what you needed?