需要有关一周结束报告的正确代码的帮助 [英] Need help with proper code for a week ending report

问题描述

所以我一起工作，为我们的客户制作报告。该报告通过招聘流程跟踪候选人及其行动。我有一份我已经建立的每周报告，跟踪我们每周（从星期一到星期日）有多少申请人，
，但我想扩展它并且无法计算我需要的嵌套代码。我在字段标题"Sources"下跟踪每个候选人的应用位置（确实，Craigslist等）。这导致我得到了我需要的代码：
目标是按周结束跟踪每个来源应用的候选人数 。我有一个查询设置，可以跟踪每个来源有多少
总计，但是无法在周末之前对其进行过滤。非常感谢任何帮助！

So I work with, and develop a report for a client of ours. The report tracks candidates and their movement through the hiring process. I have a weekly report that I have set up, that tracks how many applicants we've had through each week(from Monday to Sunday), but I would like to expand on it and haven't been able to figure out the nested code I would need. I track where each of the candidates applied from(Indeed, Craigslist, etc.) under the field title, "Sources". Which leads me to the code I need: The goal is to track by week end how many candidates applied from each individual source. I've got a query set up that tracks how many total from each source, but have been unable to filter that by week end. Any help is much appreciated!

推荐答案

您好，您是否尝试过按日期分组（）表达式拉动申请日期的周数？只是一个想法......

Hi, Have you tried grouping by on a DatePart() expression pulling the week number of the application date? Just a thought...

这篇关于需要有关一周结束报告的正确代码的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！