View historical pipeline in an Interface

Topic Labels: Formulas
394 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi there,

We currently have a candidate pipeline interface that looks like this:


The numbers are based on a formula that outputs the stage based on the latest date set, so the 11 candidates in stage 2 all have the latest date added as 'Stage 2 start date'. As soon as we add a date to a candidate to 'Stage 3 start date', it will add take 1 of stage 2 in the interface and add 1 to stage 3. 

Here's the database view of that, where you can see the formula and the some example date fields: 


This works well, but: now we want to be able to add a filter where we select a date, displaying the pipeline from that date, so how many candidates on that day were in each stage.

Does anyone have a clue how to get this, let's say, historical snapshot view of the pipeline?

Thanks in advance!

0 Replies 0