How to Group Projects by Entry Date

Grouping projects by entry date

In this custom project grouping, you can display projects grouped by their entry date values.
The breakdowns show entry date for the last 30 days, 30-60 days, and 60 days or older.

Steps to add grouping

To apply this grouping:

  1. Navigate to an existing Project report, or create a new Project report.
  2. From the Grouping tab, select New Grouping.
  3. Click Switch to Text Mode.
  4. Remove the text in the Group your Report area.
  5. Replace the text with the following code:
    group.0.linkedname=direct Entry
    group.0.valueexpression=IF(ABS(DATEDIFF({entryDate},$$TODAY))<=30,"Last 30 Days",IF(ABS(DATEDIFF({entryDate},$$TODAY))>30&&ABS(DATEDIFF({entryDate},$$TODAY))<=60,"30-60 Days","Older than 60 days"))

  6. Click Save + Close.
This article last updated on 2017-11-10 19:53:55 UTC