
Not applicable
2013-02-11
11:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Split the Year in Quartiles
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.
- Tags:
- date_quartile
820 Views
3 Replies


Partner - Creator II
2013-02-11
11:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ceil(Month(Date)/3) as Quarter
572 Views

Not applicable
2013-02-11
11:34 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
572 Views


Partner - Creator II
2013-02-11
11:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
