I have table with name,id,date, startinterval and endinterval(halfhour wise) fields.My requirement is:
i need to calculate
if(each Endinterval count id's/ecah Startinterval count if id's)>=70% then take how many intervals getting more than 70% then take count of intervals. like wise for all intervals.
I need to show this value in chart datewise how many intervals getting more than 70%.