reapit / foundations

Foundations platform mono repo
56 stars 21 forks source link

Adding Lettings Commission Changes to Analytics Schema #10574

Open ktanalyst opened 5 months ago

ktanalyst commented 5 months ago

Is your feature request related to a problem? Please describe.

Describe the solution you'd like

It would be very useful if there was a view available to access detail changes involving lettings property commission changes in the Analytics Schema.

We have access to sales price changes and lettings rent changes, so a view similar to these would be ideal. In the lettings world it is common for a property card to span several years and multiple tenancy terms; being able to report on these changes would have a very positive impact on the ability of a lettings business to track growth (and also identify opportunities for commission review).

I'd suggest the following columns would be appropriate (most are copied from PROPERTY_LETTINGS_RENT_CHANGES):

ID CHANGED_DATE LETTING_FEE_CHANGED_FROM new LETTING_FEE_CHANGED_TO new MANAGEMENT_FEE_CHANGED_FROM new MANAGEMENT_FEE_CHANGED_TO new NEGOTIATOR_ID PROPERTY_ID CUSTOMER_ID

See example below where there was a rent change and commission change recorded on the same day:

image

Describe alternatives you've considered No alternative available (as far as I'm aware)

Additional context Add any other context or screenshots about the feature request here.

github-actions[bot] commented 5 months ago

Thank you for raising a feature request. Feature requests will be prioritised in accordance with our roadmap, customer and developer priorities. This request will be reviewed in our weekly refinement sessions and assigned to a specific project board or column, depending on the nature of the request and the development work required. For more information on our processes, please click here

plittlewood-rpt commented 5 months ago

No real objections to this item. To add to the analytics tranch of work.