Pausing a "Days Open" column based on status

[PMP90]

Hi everyone, 
I have data for job postings and unfortunatley don't have anything that records status changes. This is a problem when measuring how long a job has been open for, as the client would like the "Days Open" column to pause it's count whenever a job is placed On-Hold.

In the example data below, lets say job 3 was placed On Hold on 05-Nov, I would then like the Days Open column to show 2 for this job, and then if it becomes Open again, for the count to continue on from 2. Is this possible? Thanks!

Job	Created Date	Filled Date	Status	Days Open
1	01-Nov-23		Open	5
2	02-Nov-23		Open	5
3	03-Nov-23		On-Hold	5
4	04-Nov-23	06-Nov-23	Filled	2

[Syndicate_Admin]

Hello, could you let me see the size you are using for opening days?

[PMP90]

To get the data for Days Open it is just a DATDIFF between the Created Date and Today

[audreygerred]

If you add a column for date put on hold and a column for date re-opened you will be able to make this work.

[PMP90]

Yeah it 100% would but that's just the thing, how can I get it to record any time there is a change in status?

[audreygerred]

You'll need those added in and populated at the source.

[PMP90]

Not possible I'm afraid, the API used to collect this data is extremely limited and does not support timestamps on status changes.