Count of data in a particular quarter

[#1]

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!

[v_iyyappan · Accepted solution]

Hi,

     Use like this

          count(if(Month([Date])>=1and Month([Date])<=4,Glucose))

Regards,

Iyyappan