Skip to main content

How to find how many days it took to create the first 1000 records in a table?

  • April 22, 2020
  • 1 reply
  • 15 views
H
Forum|alt.badge.img+6

We have a table that contains cases that our company handles - each record in that table is a separate case (we’ve handled over 4000 cases so far). To demonstrate our growth, we’ve been asked to show:

How many days did it take for us to get 1000 cases?
How many days did it take for su to go from 1000 - 2000 cases?
From 2000 - 3000?
From 3000 - 4000?
…and possibly our current rate of cases per day…

Anyone have an idea about how I could configure that in a block or rollup?

    1 reply

    A
    Forum|alt.badge.img+19
    • andywingrave
    • Inspiring
    • April 22, 2020

    Hey there - If you’ve been adding cases daily you can add a field that tells you the date created (It’s called “Date Created”

    Then you can use the Chart block to create a line graph of this data

    It should be that simple - But let me know how you get on.

    Hope that helps!

    Terms & ConditionsAccessibility statement