Hi,
I need to extract the month and year information from Date column in format of mm/dd/yyyy to mm/yyyy so I can find the mean of turnaround time by month. Month(:Date) extract month and Year(:Date) give year of the date. But I need it both in same formula (or same column). Tried Month(:Date) || Year(:Date) worked but resulting date type - 'expression' won't allow to plot the data.
The attached table "Turnaround Time" consist of Start Dates of analysis and turnaround time (or Net workdays needed to complete the analysis). I need to find the mean turnaround time for each month and plot it in 'Fit Y by X' format where X will month of each year and Y will be mean turnaround time for each month.
Man thanks in advance for your support!