Does anyone know how to dynamically filter time and date at the same time?
I have a DPU and FPY bar chart for our PDI area and I want to create a bookmark button that will automatically always show the results from Friday 9.30am to next Friday 9.29am, so realistically speaking if it’s Friday 9.28am there should be a full week of data and if it’s Friday 9.31am there should be usually nothing.
Do you have any ideas or videos on how this could be achieved?
DPU stands for Defects Per Unit and FPY is First Pass Yield, which are common quality metrics in Manufacturing industry.
I have three tables;
- Calendar Table
- Defects table - every time when defect is found, one row is created with the date, time and serial number of the vehicle (plus many other details but that’s not important here)
- Vehicles Audited table - every time when a vehicle is audited, one row is created (date, time and serial number)
I’ve merged these two tables (all matching from Vehicles, I didn’t lose any records), Serial Number was my key.
I want to base the one week filter (from Friday 9.30am to Friday 9.29am) on the time and date when the vehicle was audited.