Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to calculate the count of glucose values with dates in the Q1, then Q2,Q3,Q4.
The columns in the table to be used are:
Glucose Date
I think I might need something like.
count(if([Date]>=Jan and [Date]<=April,Glucose))
Please advise!
Thanks in Advance!
Hi,
Use like this
count(if(Month([Date])>=1and Month([Date])<=4,Glucose))
Regards,
Iyyappan
Hi,
Use like this
count(if(Month([Date])>=1and Month([Date])<=4,Glucose))
Regards,
Iyyappan