I need to create a report that basically has these columns:
- Rep name
- Number of requests younger than 2 days total time
- Number of requests older than 2 days but younger than 4 days
- Number of requests older than 4 days
Something to that extent. I can do further customisations if I understand the basics, I have basic SQL knowledge.
Also, I need the number of requests but would like to be able to expand / pivot / drill down on each number to see the related requests.
Is this possible?