Help

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

Topic Labels: Extensions
645 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Hal_Atkins
5 - Automation Enthusiast
5 - Automation Enthusiast

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 1

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!