chronological.json

{
    "copyright": "© Sutoiku, Inc. 2013",
    "stc_type": "stc_levels",
    "stc_summaries": "stc_numerical",
    "stc_id_expression": "MOMENTUTC(group, 'YYYY-MM-DD[T]HH:mm:ss+00:00')",
    "stc_add_expression": "MOMENTUTCADD(start, period, number)",
    "stc_diff_expression": "MOMENTUTCDIFF(start, end, period)",
    "stc_format_expression": "MOMENTUTC(group)",
    "stc_casting_expression": "MOMENT(value, 'X')",
    "stc_inverse_expression": "MOMENT(value * 1000, 'YYYY-MM-DD[T]HH:mm:ss+00:00')",
    "stc_levels": [
        {
            "stc_name": "By year",
            "stc_identifier": "stc_year",
            "stc_type": "stc_intervals",
            "stc_period_name": "years",
            "stc_color": "#bc5679",
            "stc_name_expression": "MOMENTUTC(group, '[Year] YYYY')",
            "stc_group_expression": "MOMENTUTC(value, 'YYYY-01-01T00:00:00+00:00')"
        },
        {
            "stc_name": "By semester",
            "stc_identifier": "stc_semester",
            "stc_type": "stc_intervals",
            "stc_period_name": "months",
            "stc_multiple": 6,
            "stc_color": "#6f85bf",
            "stc_name_expression": "CONCATENATE('Semester ', CEILING(MOMENTUTC(group, 'M') / 6), MOMENTUTC(group, ', YYYY'))",
            "stc_group_expression": "CONCATENATE(MOMENTUTC(value, 'YYYY-0'), FLOOR((MOMENTUTC(value, 'M') - 1) / 6) * 6 + 1, '-01T00:00:00+00:00')"
        },
        {
            "stc_name": "By quarter",
            "stc_identifier": "stc_quarter",
            "stc_type": "stc_intervals",
            "stc_period_name": "months",
            "stc_multiple": 3,
            "stc_color": "#f9b256",
            "stc_name_expression": "CONCATENATE('Quarter ', CEILING(MOMENTUTC(group, 'M') / 3), MOMENTUTC(group, ', YYYY'))",
            "stc_group_expression": "CONCATENATE(MOMENTUTC(value, 'YYYY-'), PAD(FLOOR((MOMENTUTC(value, 'M') - 1) / 3) * 3 + 1, 2), '-01T00:00:00+00:00')"
        },
        {
            "stc_name": "By month",
            "stc_identifier": "stc_month",
            "stc_type": "stc_intervals",
            "stc_period_name": "months",
            "stc_color": "#8cc474",
            "stc_name_expression": "MOMENTUTC(group, 'MMMM YYYY')",
            "stc_group_expression": "MOMENTUTC(value, 'YYYY-MM-01T00:00:00+00:00')"
        },
        {
            "stc_name": "By fortnight",
            "stc_identifier": "stc_fortnight",
            "stc_type": "stc_intervals",
            "stc_period_name": "days",
            "stc_multiple": 14,
            "stc_color": "#fbcb43",
            "stc_name_expression": "CONCATENATE('Fortnight ', CEILING(MOMENTUTC(group, 'w') / 2), MOMENTUTC(group, ', YYYY'))",
            "stc_group_expression": "CONCATENATE(MOMENTUTC(MOMENTUTCSUB(MOMENTUTC(value), 'days', MOMENTUTC(value, 'd') + (IF(ISEVEN(MOMENTUTC(value, 'w')), 7, 0))), 'YYYY-MM-DD'), 'T00:00:00+00:00')"
        },
        {
            "stc_name": "By week",
            "stc_identifier": "stc_week",
            "stc_type": "stc_intervals",
            "stc_period_name": "days",
            "stc_multiple": 7,
            "stc_color": "#76a7fa",
            "stc_name_expression": "MOMENTUTC(group, '[Week] w, YYYY')",
            "stc_group_expression": "CONCATENATE(MOMENTUTC(MOMENTUTCSUB(MOMENTUTC(value), 'days', MOMENTUTC(value, 'd')), 'YYYY-MM-DD'), 'T00:00:00+00:00')"
        },
        {
            "stc_name": "By day",
            "stc_identifier": "stc_day",
            "stc_type": "stc_intervals",
            "stc_period_name": "days",
            "stc_color": "#e46f61",
            "stc_name_expression": "MOMENTUTC(group, 'MMMM D, YYYY')",
            "stc_group_expression": "MOMENTUTC(value, 'YYYY-MM-DDT00:00:00+00:00')"
        },
        {
            "stc_name": "By hour",
            "stc_identifier": "stc_hour",
            "stc_type": "stc_intervals",
            "stc_period_name": "hours",
            "stc_color": "#bc5679",
            "stc_name_expression": "MOMENTUTC(group, 'H:00 A, MMMM D, YYYY')",
            "stc_group_expression": "MOMENTUTC(value, 'YYYY-MM-DDTHH:00:00+00:00')"
        },
        {
            "stc_name": "By minute",
            "stc_identifier": "stc_minute",
            "stc_type": "stc_intervals",
            "stc_period_name": "minutes",
            "stc_color": "#6f85bf",
            "stc_name_expression": "MOMENTUTC(group, 'H:mm A, MMMM D, YYYY')",
            "stc_group_expression": "MOMENTUTC(value, 'YYYY-MM-DDTHH:mm:00+00:00')"
        },
        {
            "stc_name": "By second",
            "stc_identifier": "stc_second",
            "stc_type": "stc_intervals",
            "stc_period_name": "seconds",
            "stc_color": "#f9b256",
            "stc_name_expression": "MOMENTUTC(group, 'H:mm:ss A, MMMM D, YYYY')",
            "stc_group_expression": "MOMENTUTC(value, 'YYYY-MM-DDTHH:mm:ss+00:00')"
        }
    ]
}