I am looking for some help. I have let's say certain types of cars that will be built as soon as the offer is 'approved'. From that approved moment on, a lot of work will be put in building the car.
I am interested in to do an overlay of multiple cars and project simply that they were approved so I can see the amount of work. As the cars are built in different years, I can't do the overlay. Therefore I need to be able to recalculate my datefield that is simply the 'normalized approved date' attribute. Let me try to explain visually:
When I plot the approval date towards the total cost of building during the timing of building I get for 2 different cars with each a different approval date, following graph:
when I normalize the approval date (I simply marked the quarter of the approval date as Q and then for the total cost went Q-1 and Q+1 when going back in time or into the future) I can do an overlay and see if total costs are alike:
Anyone an idea on how to solve this?
Hi @Yuri Fal ,
thanks for this! I think it's almost right. The only thing which is not aligned is to make sure that the approval dates are normalized. The first approval date is on 2/9/2024 and the 2nd is 2/27/2023. I added some trendlines to your viz. The goal is to get them both on 1 line, this will shift the X1 to the left so it overlays on the orange as well.
