Straight table to show latest comment log from similar dates

[userid128223]

Hi Everyone

I have straight table like below.

Company name

Case #

issue opened date

last comment date

last comment log

I am trying to summarize the log and show only the latest log from last comment date. I am able to get to the latest date, however the last comment log from that date is not showing up.

Dimension

Company name

Cast#

Issue opened date

Expression

=max(last comment date)

last comment log.

The above is not showing latest log.

Note: there could be multiple log entry for same date based on different timings.

[whiteline]

Hi.

You could try a firstsortedvalue() function.