COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: Imre on 02 Jul 2019 09:45:29 AM

Title: Migration matrix
Post by: Imre on 02 Jul 2019 09:45:29 AM

Is it possible to create a migration matrix by using the same column for eg. Status T0 and Status T1?

An example maybe shows my needs better that words:

(https://cdn3.imggmi.com/uploads/2019/7/2/0a36f5293422530f01aca084c4a88032-full.jpg)

https://cdn3.imggmi.com/uploads/2019/7/2/0a36f5293422530f01aca084c4a88032-full.jpg (https://cdn3.imggmi.com/uploads/2019/7/2/0a36f5293422530f01aca084c4a88032-full.jpg)

The data behind the example would be a column "Date" with the values "April" and "May", a column "Status" with the values "Good", "Worse", "Worst" and one column with values. I would filter the values to my preferred Date.

I tried it with a crosstab but could not make it work.

Do you have any ideas?

Thanks.
Title: Re: Migration matrix
Post by: Imre on 08 Jul 2019 08:44:28 AM
I got the solution. I just need an other column with the T0 data.