CODEWITHSUNDEEP
cognoscognos-bi
Richard Wonner
Richard Wonner

Reputation: 35

Cognos calculation and aggregation

I want to do the following.

I have warranty Claim Dates - each Claim is a single instance with Dates attached. Now I want to see the time elapsed from failure date to repair date.

However this Report is huge. So I want to see the median of the elapsed time for each dealer.

I know it would be possible with SQL but is that also possible in Cognos?

BR Richard

Upvotes: 1

Views: 1018

Answers (1)

Johnsonium
Johnsonium

Reputation: 2005

Assumptions: You have data items called [Failure Date], [Repair Date], and [Dealer]. You want to measure the time in days.

Create a new data item with the following expresion:

average(_days_between([Repair Date],[Failure Date]) for [Dealer])

Set the Aggregate Function property for the new data item to 'Calculated'.

Upvotes: 1

Related Questions