Follow
Grouping: Projects by Entry Date

In this custom project grouping, you can display projects grouped by their Entry Date values.

Each grouping shows projects with an Entry Date within:

  • the last 30 days
  • 30-60 days
  • 60 days or older

To apply this grouping:

  1. Navigate to an existing Project report, or create a new Project report.
    For more information about creating a report, see "Creating a 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
    group.0.name=Project 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"))
    group.0.valueformat=atDateAsMonthString
    textmode=true
  6. Click Save + Close.
This article last updated on 2018-03-07 19:56:12 UTC