Print Page - Show first date

Title: Show first date
Post by: et21 on 04 Oct 2023 05:11:00 PM

Hi all,

I have a question regardless of how to show only the first date that was enter in the report.

Eg: Project A: Updated on 12/05/2022
Project A: Updated on 25/06/2022

I only want to show the first update 12/05/2022. Can someone please help me with that. TIA

Title: Re: Show first date
Post by: MFGF on 05 Oct 2023 07:25:23 AM

Quote from: et21 on 04 Oct 2023 05:11:00 PM
Hi all,

I have a question regardless of how to show only the first date that was enter in the report.

Eg: Project A: Updated on 12/05/2022
Project A: Updated on 25/06/2022

I only want to show the first update 12/05/2022. Can someone please help me with that. TIA

Hi,

I assume this is the first date for each project?

Assuming you have a [Project] item and a [Date] item, you could add a detail filter to your report

[Date] = minimum([Date] for [Project])

Does this work for you?

Cheers!

MF.

Title: Re: Show first date
Post by: et21 on 05 Oct 2023 02:32:04 PM

Thank you MFGF, its working fine. I forgot that we can use minimum for that

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: et21 on 04 Oct 2023 05:11:00 PM