set analysis on non-consecutive dates

[Anonymous]

LOAD * INLINE [
Test Date, Name, Score
01/01/2017, S1, 9
01/01/2017, S2, 5
01/01/2017, S3, 6
17/03/2017, S1, 9
17/03/2017, S2, 7
17/03/2017, S3, 7
03/05/2017, S1, 4
03/05/2017, S2, 10
03/05/2017, S3, 2
30/05/2017, S1, 8
30/05/2017, S2, 5
30/05/2017, S3, 8
31/05/2017, S1, 5
31/05/2017, S2, 5
31/05/2017, S3, 10
01/10/2017, S1, 5
01/10/2017, S2, 9
01/10/2017, S3, 9
];

I am trying to figure out how many students manage to keep a consecutive score  between 5 and 10 for 3 consecutive test date, to show that in both a text object , and also in a straight table.

Any idea?

Thank you

[Anil_Babu_Samineni]

Perhaps this?

Count({<Score = {">=5 <=10"}>} Name)

OR

Count({<Score = {">=5 <=10"}, [Test Date] = {'Date1','Date2','Date3'}>} Name)

[Anonymous]

That is not taking into account the non consecutive dates business - or will need me to put all the dates manually into it - so no good, but thank you for trying

[Anil_Babu_Samineni]

I apologies, expected result?

[Anonymous]

new dataset:

LOAD * INLINE [
Test Date, Name, Score
01/01/2017, S1, 9
01/01/2017, S2, 10
01/01/2017, S3, 6
17/03/2017, S1, 9
17/03/2017, S2, 7
17/03/2017, S3, 7
03/05/2017, S1, 4
03/05/2017, S2, 1
03/05/2017, S3, 2
30/05/2017, S1, 8
30/05/2017, S2, 1
30/05/2017, S3, 8
31/05/2017, S1, 5
31/05/2017, S2, 1
31/05/2017, S3, 10
01/10/2017, S1, 5
01/10/2017, S2, 10
01/10/2017, S3, 9
];

expected answer:

text object :2

straight table:

S1	yes
S2	no
S3	yes

[surendraj]

You can try Expression as

aggr(if(Count({<Score = {">=5 <=10"}>} Name)>=5,'Yes','No'),Name)

--Surendra

[Anonymous]

Thank you

[techvarun]

Check the attached.

[Anonymous]

actually that does not give correct answer - does not take care of the consecutive dates, it is a count on all date... but thank you for trying

I am trying to figure out how many students manage to keep a consecutive score between 5 and 10 for 3 consecutive test date, to show that in both a text object , and also in a straight table.

[surendraj]

Its working..You can Apply Order by while pulling the data!!