Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have loads of dates and I need to split each year into quartiles.
How would I do that? As after I will have to display a set of data for each quartile.
Ceil(Month(Date)/3) as Quarter
How would I use this?
I need to have 4 quartiles, e.g. dec, jan, feb for each year. Then I have to create a table to display the highest values for each quartile.
In your script.
You have a date.
Let's create a new field with your date field.
Ceil(Month(Date)/3) as Quarter
This formula will give you 1 for January, 1 for February, 1 for march and 2 for April.