Max date of report

[#1]

I want to make a bar chart that is displaying the most recent modify date of my list of reports.

How would I go about doing this?

Right now I have lastmodifydate as my dimension with my expression of a count of reports. but what I want to see is a count of the most recent modify date of each report because I have mutiple records for each time a report is modified.

Thanks

[Gysbert_Wassenaar]

Assuming your dimensions are reportname and lastmodifydate, try:

=aggr(max(lastmodifydate),reportname)

[#3]

that did not work as an expression

[#4]

any other ideas?

I just want to restrict the data in the bar chart to count only a single record of the report that has the highest date value.

[#5]

Hi,

just add as Dimension the Report and as Expression: max(LastModifyDate)