Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have table and completion_date and Id and newdate fields is there.
[Completion Date],ID
10-jun-2017, 10
11-July-2017, 20
20-Aug.-2018, 30
9-dec-2018, 40
My requirement is
When I select date from newdate field and completion_date equal to 100% than calculate the 25,50,75,100% what are the id and completion_date available under 25,50,75,100% display in table .
EX: required Output
Completion_date value
25% 10-jun-2017 1
50% 11-july-2017 2
75% 20-aug-2018 3
100% 09-dec-2018 4
the above output value field is position of the date and above table I have taken only 4 records .if in case 1500 records is there and 1500 records dates equal to 100% and calculate 25,50,75 100 % .
in that 1500 records find the 25% and which id and completiondate available at 25% and same way 50 ,75,100.
Please help on this if have any idea.
thanks.
Hi,
you can use fractile() function :
in your case :
fractile(Completion_date, 0.25) and so and
for value : count(total completion_date) * 0.25 for first value
regards