Scatter Plot of time between two date fields per primary key of table
Hello,
I am attempting to make a scatter plot for a dashboard I am creating. Basically, I have a table called REQUISITIONS that contains a primary key (ACC_ID) and two date fields (Received_date, Printed_date). What I want to display in the scatter plot is over a period of received_dates scatter the interval between the received_date and Print_date per accession. For example on received_date = 9/30/2021 I want to see a dot per ACC_ID with the value being the difference between the received_date and Printed_date of that acc_id. I am very amateur and need help with this. thank you!
