topic Is it possible to do an arithmetic progression by year ? in App Development

Is it possible to do an arithmetic progression by year ?

fjdriouich — Thu, 27 Oct 2022 15:34:49 GMT

Hello community,

Can you please help me to have this result

Evolution type	Nb Student N-1	Nb Student N/N+1	Nb Student N+1/N+2
D=> C	2	1
B (constant)	1	1
A (constant)	1	1
C=>D	1	1
A=>C	1	0
C (constant)	0	2

If I have this data initially ?

	Evaluation year N-1	Evaluation year N	Evaluation year N+1	Evaluation year N+2
Student 1	D	C	C
Student 2	C	D	C
Student 3	B	B	B
Student 4	A	A	A
Student 5	A	C	D
Student 6	D	C	C

Thank you in advance,

Best regards

Re: Is it possible to do an arithmetic progression by year ?

vinieme12 — Fri, 28 Oct 2022 06:34:04 GMT

as below

Main: Load * ,[EvaluationyearN-1]&[EvaluationyearN] as [NbStudentN-1] ,[EvaluationyearN]&[EvaluationyearN+1] as [NbStudentN/N+1] ,[EvaluationyearN+1]&[EvaluationyearN+2] as [NbStudentN+1/N+2] ; load * inline [ Student,EvaluationyearN-1,EvaluationyearN,EvaluationyearN+1,EvaluationyearN+2 Student 1,D,C,C, Student 2,C,D,C, Student 3,B,B,B, Student 4,A,A,A, Student 5,A,C,D, Student 6,D,C,C ]; CrossTable(Compare,Values,1) Dim: Load Student ,[NbStudentN-1] ,[NbStudentN/N+1] ,[NbStudentN+1/N+2] Resident Main; left Join(Dim) Labels: Load * inline [ Values,Label DC,D=>C BB,B(Constant) AA,A(Constant) CD,C=>D AC,A=>C CC,C(Constant) ]; exit Script;

Dimension:

Label

Measures

=Count({<Compare={'NbStudentN-1'}>}Distinct Student)

Count({<Compare={'NbStudentN/N+1'}>}Distinct Student)

Count({<Compare={'NbStudentN+1/N+2'}>}Distinct Student)

Re: Is it possible to do an arithmetic progression by year ?

fjdriouich — Thu, 03 Nov 2022 10:01:11 GMT

Hello,

Thank you very much for your response

Actually what I would like to have is an arithmetic propgression with a result like this :

And I have all the datats concerning the marks of the student. I would like to have a resultat depending on the number of year i choose

Best regards