Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The expression though shows an error, gives the output like this
Perhaps this?
Count({<Score = {">=5 <=10"}>} Name)
OR
Count({<Score = {">=5 <=10"}, [Test Date] = {'Date1','Date2','Date3'}>} Name)
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
I apologies, expected result?
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 |
You can try Expression as
aggr(if(Count({<Score = {">=5 <=10"}>} Name)>=5,'Yes','No'),Name)
--Surendra
Thank you
Check the attached.
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.
Its working..You can Apply Order by while pulling the data!!