Hi, For dashboards I recommend to create a single row for the latest record only in a separate table/view in your data module and rename the month name to 'current'. Afterwards you can combine the table/view with the original by a union operation. You can use the result as the source in your dashboard and save the filter on 'current'. Technically this will lead to a duplication of the latest record.
------------------------------
Philipp Hornung
Product Owner & BI Manager
Techniker Krankenkasse
Hamburg Germany
#IBMChampion
------------------------------
Original Message:
Sent: Wed April 16, 2025 04:12 PM
From: Gautam Borkar
Subject: How to Filter Latest Records Based on Conditions in Cognos Dashboard?
I have a data module with the following structure:
| TBL-1-ID | TBL-2-ID | SEVERITY | VIEWS | MONTH |
|---|
| 123 | 1234 | CRITICAL | HIGH | JAN |
| 124 | 1234 | NULL | LOW | FEB |
| 125 | 1234 | HIGH | VERY HIGH | MAR |
| 126 | 1234 | LOW | LOW | APR |
Use Cases for My Dashboard:
- If no month is selected in the tab filter, the dashboard should display the VIEWS of the latest record (i.e., max(TBL-1-ID)) for the count.
- If a month is selected in the tab filter, the dashboard should display the VIEWS of the latest record in that month for the count.
Question: How can I achieve this functionality in my Cognos dashboard?
------------------------------
Gautam Borkar
------------------------------