Weekly wise Report Formula?

Question

Hi all, What is the formula for Week on week progress report in opportunity? e.g Table should be like Week1-26 Week2-30 created Opportunity.

Mohammed Rizwan · Answer

Report > New Report > Select Object > Create

Drag & Drop fields in the "Preview" pane that you would want in the the report.

Instead of "Tabular" select "Summary Format".

You would see a label -> "Drop a field here to create a grouping"

Drag CreatedDate field on that label.

A arrow would appear on the grouping field (eg CreatedDate)

Click on It.

Select "Group Date by" -> Calendar Week. Done.

For each week, you can see record count.

You can also add charts to your report.

If you want to add some conditions to your report, you can do that as well.

Mark this as Best Answer, if this helps solve your problem.

Formulas