Getting Last Month's Status of a Repair. Is it the same over the new month

[gosoccer]

Hi, :)

I have attached a mockup for this request. I have a need to see what repairs to the same car we continued from Jan - Feb or any previous month to the next month. So, the repair was still active as the car's repair was in process from Jan - Feb or any other Previous Month and Existing Month. Unfortunately, the field that has the Status of the Repair that would show us the repairs Status at different times is overwritten for everytime there is a change to the Status. So, there is no way to tell what was the previous Status.

Let me know what you think overall.

Thanks so much for your time. ;D ;D

[sdf]

first question can you still change the status of the car in a previous month?
initial thought is to have per month status other than the current status in your data source.

[gosoccer]

I like your idea about per month Status. Yes, I findout that we do have a Repair Status changed date that I can use.
Could you please let me know how I can accomplish this as a code within the Framework Model or Report Studio that
it would give me the COUNT for these types of repairs? For example,

How can I check to see if the Repair Status of the existing month is different than the Repair Status of the Previous Month for
the same repair?

This way I can count 1 when the above condition fails.

I'll continue my research and thanks so much for your time.  :) :)

[gosoccer]

I'm using a Relational Model.