How drawing a Matrix showing number of changes between a current and previous Class

michele_stenico — Sat, 16 Nov 2024 17:45:58 GMT

Hi,

I start from this kind of Input Date

NDC,Data,Class
1,2020/01/01,A
1,2020/02/01,B
2,2020/01/01,A
2,2020/02/01,A
3,2020/01/01,C
3,2020/02/01,A
4,2020/01/01,B
4,2020/02/01,B
];

I would like to count the number of Class Changing of my Customer and show the results in a matrix like this.

		Current Class
		A	B	C
Previous Class	A	1	1	0
B	0	1	0
C	1	0	0

I could calculate the previous Class in the Load Script, using previous function, but I would like to be able to do it in the presentation, may be using additional dimension (e.g Class_Prev, Class_Cur).

Could you help me ?

Michele

Re: How drawing a Matrix showing number of changes between a current and previous Class

michele_stenico — Sat, 28 Nov 2020 17:56:13 GMT

Sorry, the example table was badly posted, that is

A B C

A 1 1 0

B 0 1 0

C 1 0 0

thanks

topic Re: How drawing a Matrix showing number of changes between a current and previous Class in App Development

How drawing a Matrix showing number of changes between a current and previous Class

Re: How drawing a Matrix showing number of changes between a current and previous Class