How do I limit the number of Project Status Reports to the latest per project in PMO Dashboard

[s_renjarnbo]

In the PMO Dashboard we have below 2 reports that shows the total number of Project Status Reports generated "this month" and "last month"

If a project generates more than one Status Report in a month the counter in above reports will increasing correspondingly.

I have a requirement to only show the latest Status Report per project (if any is available) both in the report donut and in the list view. So basically one Status Report per project

[pavani_paluri]

Hi @s_renjarnbo ,

Create a Database View that joins:

Project table

Status Report table

Create a report on your new Database View.

Group by → Project (so you only get one line per project).

Aggregation → MAX(Created On) (so it picks the latest report for each project).

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[pavani_paluri]

Could you Please accept the solution if that solves your problem.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[s_renjarnbo]

Thanks for the initial help Pavani but I am not used to work with database views.

I have created below database view (test):

It does return a "concatenated" list of status reports and related project

BUT

when I created the report it is not possible to aggregate max on created on. The field is not there (and neither is the status report date):

What could be wrong ?

Regards

Søren