Check for Previous Instances

[prees959]

Hi,

I have been asked to see if it is possible to track if users are using a new system booking system more than they used an old system.  Each day we receive data from two systems 'SystemA' and 'SystemB' linked on 'User' and when the application loads I would like to be able to say that from 'today' onwards, Users are taking more bookings from System B than they were taking from System A ?  I have a attached a sample document.

So , for example, in the attached document if we take today's date as 28/01/2017, we can see that User C has taken 5 bookings from System A but going forward User C has taken 7 bookings from System B.

Is there any suitable way to show this graphically as a number Users' per day going forward compared to the past (as a % or ratio)?

Thanks for any help or suggestions!

Phil

[prees959]

no one?

(sorry for the bump!)