Forum Discussion
Row Context in Calculated Column
staff members move around over time (and we have no clean data on this in the model) Maybe you want to fix that? Read about SCD2.
Thanks lbendlin
I've looked into slowly changing data previously (we don't use it in our model). Our working practices (we're a small community hub) are such that staff overlap between projects - for example our front desk does most (but not all) of the registrations and is assigned to a particuarly project - but staff from other projects will cover this role, say for the lunch break.
Therefore there isn't really a clean way of acheive what we need (I don't think) other than some sort of fomula to determine the first project a contact engaged with?
Thanks,
Adam
Just for further clarity about our model, it isn't huge, which may help in terms of a solution.
We have:
Staff Members: 371 - including staff who have left - there's about 80 at any one time.
Contacts (people registered with us): 16,000
Projects: 127
Total Interactions: 198,598 - anything from an appointment, group session attendance, a referal, various kinds of outcome, and we also log enrollment start and finsh dates.
Most clients will only have a small number of interactions say 1-10, a small number will have maybe a few hundred. So a vitual table of the activity filtered by Client ID, wouldn't be very large for each client, but will need to be calulated 16,000 times.
So we're not talking millions of rows.
Thanks,
Adam