Hi all. I’m in the process of creating a BAQ to show on time delivery so I can add it to a dashboard with our quarterly vendor spend for supplier grading purposes.
Right now, I’ve got an inner subquery that shows our vendor name, calculated on time (if due date > rcv date then on time, else late, end), quarter, year, due date, receipt date.
My top level query is pivoted to count the on time and group it by quarter, but when I test it, it’s not truly grouping my values together. What am I missing?
