hi there,
my requirement is my service no has to respond 48 times a day and some of them are responding more than 48, i want month percentage calculation . if month is January then 48*31=1488 , if month is February then 29*48=1392.
,i have multiple records per interval which is shown in sheet 4 i want only the Last record per interval ( i need to take only one record per interval) .
i need SQL query as well along with the month calculation.
1 respuesta
Hi Suresh,
I am not sure exactly what are you looking for ?
For first questions try this :
For Second question write calc :
Please mark as correct and helpful if this helps.
Thanks,
Shruten
