Top 15 Donors by Year All Time
{ "Report": { "72": { "id": "72",
"name": "Total given by top 5 donors over the past 3 years - New",
"order": "49",
"show_in_crm": false,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:45" } },
"ReportColumn": { "1479": { "id": "1479",
"report_id": "72",
"report_dataset_id": "206",
"report_dataset_model_id": "713",
"is_internal": true,
"name": "Donor Person Id",
"alias": "donor_person_id",
"order": "28",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "",
"identifier": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"is_filter": true },
"1480": { "id": "1480",
"report_id": "72",
"report_dataset_id": "205",
"report_dataset_model_id": "710",
"is_internal": false,
"name": "Donor Person Id",
"alias": "donor_person_id",
"order": "30",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "",
"identifier": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"is_filter": true },
"1481": { "id": "1481",
"report_id": "72",
"report_dataset_id": "205",
"report_dataset_model_id": "710",
"is_internal": false,
"name": "Year",
"alias": "received",
"order": "31",
"column_type": "simple",
"simple_expression": "year( {column} )",
"smart_expression": "year( `Model710`.`received` )",
"identifier": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"is_filter": true },
"1482": { "id": "1482",
"report_id": "72",
"report_dataset_id": "205",
"report_dataset_model_id": "711",
"is_internal": false,
"name": "Fullname",
"alias": "fullname",
"order": "32",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "",
"identifier": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"is_filter": true },
"1483": { "id": "1483",
"report_id": "72",
"report_dataset_id": "205",
"report_dataset_model_id": "710",
"is_internal": false,
"name": "Gift Count",
"alias": "id",
"order": "33",
"column_type": "simple",
"simple_expression": "count(distinct {column})",
"smart_expression": "",
"identifier": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"is_filter": true },
"1484": { "id": "1484",
"report_id": "72",
"report_dataset_id": "205",
"report_dataset_model_id": "710",
"is_internal": false,
"name": "Average",
"alias": "amount",
"order": "34",
"column_type": "simple",
"simple_expression": "avg({column})",
"smart_expression": "",
"identifier": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"is_filter": true },
"1485": { "id": "1485",
"report_id": "72",
"report_dataset_id": "205",
"report_dataset_model_id": "710",
"is_internal": false,
"name": "Total",
"alias": "amount",
"order": "35",
"column_type": "simple",
"simple_expression": "sum({column})",
"smart_expression": "",
"identifier": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"is_filter": true },
"1486": { "id": "1486",
"report_id": "72",
"report_dataset_id": "205",
"report_dataset_model_id": "711",
"is_internal": false,
"name": "Created",
"alias": "created",
"order": "36",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "",
"identifier": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"is_filter": true } },
"ReportDataset": { "205": { "id": "205",
"report_id": "72",
"name": "Total given by top donors by year",
"description": "",
"is_base": true,
"is_aggregate": false,
"order": "0",
"group_by": "year(`Model710`.`received`) DESC, `Model710`.`donor_person_id`",
"having": "",
"order_by": "",
"limit": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34" },
"206": { "id": "206",
"report_id": "72",
"name": "Top 5 donors by gift count",
"description": "",
"is_base": false,
"is_aggregate": true,
"order": "1",
"group_by": "`Model713`.`donor_person_id`",
"having": "",
"order_by": "count(`Model713`.`id`) desc",
"limit": "15",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:34:32" } },
"ReportDatasetModel": { "710": { "id": "710",
"report_dataset_id": "205",
"alias": "HistoricGift",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": null,
"join_alias": "",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"union": "" },
"711": { "id": "711",
"report_dataset_id": "205",
"alias": "Person",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": "710",
"join_alias": "HistoricGiftDonorPerson",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"union": "" },
"712": { "id": "712",
"report_dataset_id": "205",
"alias": "",
"associated_report_dataset_id": "206",
"join_report_dataset_model_id": "710",
"join_alias": "",
"join_type": "inner",
"join_on_clause": "`Model710`.`donor_person_id` = `Model712`.`c_1479`",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"union": "" },
"713": { "id": "713",
"report_dataset_id": "206",
"alias": "HistoricGift",
"associated_report_dataset_id": null,
"join_report_dataset_model_id": null,
"join_alias": "",
"join_type": "left",
"join_on_clause": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"union": "" } },
"ReportDatasetCondition": { "208": { "id": "208",
"is_logical_operator": false,
"parent_id": null,
"condition_type": "smart",
"report_dataset_id": "205",
"report_dataset_model_id": null,
"column_alias": null,
"negate": false,
"type": "",
"value": null,
"compare": "value",
"compare_report_dataset_id": null,
"compare_report_dataset_model_id": null,
"compare_column_alias": null,
"smart_expression": "YEAR(`Model710`.`received`) > YEAR(CURDATE()) - 99",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:35:59" },
"209": { "id": "209",
"is_logical_operator": false,
"parent_id": null,
"condition_type": "simple",
"report_dataset_id": "206",
"report_dataset_model_id": "713",
"column_alias": "donor_person_id",
"negate": true,
"type": "null",
"value": "",
"compare": "value",
"compare_report_dataset_id": null,
"compare_report_dataset_model_id": null,
"compare_column_alias": null,
"smart_expression": "",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34" },
"210": { "id": "210",
"is_logical_operator": false,
"parent_id": null,
"condition_type": "smart",
"report_dataset_id": "206",
"report_dataset_model_id": "713",
"column_alias": "received",
"negate": false,
"type": ">=",
"value": "2016-01-01",
"compare": "value",
"compare_report_dataset_id": null,
"compare_report_dataset_model_id": null,
"compare_column_alias": null,
"smart_expression": "YEAR(`Model713`.`received`) > YEAR(CURDATE()) - 99",
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:35:51" } },
"ReportView": { "115": { "id": "115",
"report_id": "72",
"name": "Top 5 Donors over the past 3 years",
"order": "0",
"conditions": "",
"group_by": "",
"having": "",
"order_by": "vc_1331 DESC",
"limit": null,
"render_as": "table",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"rows_to_columns": false } },
"ReportViewColumn": { "1331": { "id": "1331",
"report_view_id": "115",
"name": "Year",
"alias": "c_1481",
"order": "0",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "1",
"type": "auto",
"number_style": "decimal",
"decimals": "0",
"currency": "",
"datetime_format": "",
"sprintf_format": "",
"segment": "c_1481",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Year" },
"1332": { "id": "1332",
"report_view_id": "115",
"name": "Donor",
"alias": "c_1482",
"order": "1",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "",
"type": "auto",
"number_style": "decimal",
"decimals": "0",
"currency": "",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Donor" },
"1333": { "id": "1333",
"report_view_id": "115",
"name": "Donor - Year Segment",
"alias": "c_1481",
"order": "2",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "",
"type": "auto",
"number_style": "decimal",
"decimals": "0",
"currency": "",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": true,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Donor - Year Segment" },
"1334": { "id": "1334",
"report_view_id": "115",
"name": "Gift Count",
"alias": "c_1483",
"order": "3",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "",
"type": "number",
"number_style": "decimal",
"decimals": "0",
"currency": "",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Gift Count" },
"1335": { "id": "1335",
"report_view_id": "115",
"name": "Gift Count - Year Segment",
"alias": "",
"order": "4",
"column_type": "smart",
"simple_expression": "sum(c_24) over(partition by c_26)",
"smart_expression": "sum(c_1483) over(partition by c_1481)",
"type": "number",
"number_style": "decimal",
"decimals": "0",
"currency": "",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Gift Count - Year Segment" },
"1336": { "id": "1336",
"report_view_id": "115",
"name": "Gift Count - Total",
"alias": "",
"order": "5",
"column_type": "smart",
"simple_expression": "sum(c_24) over()",
"smart_expression": "sum(c_1483) over()",
"type": "number",
"number_style": "decimal",
"decimals": "0",
"currency": "",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Gift Count - Total" },
"1337": { "id": "1337",
"report_view_id": "115",
"name": "Average",
"alias": "c_1484",
"order": "6",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "",
"type": "number",
"number_style": "currency",
"decimals": "0",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Average" },
"1338": { "id": "1338",
"report_view_id": "115",
"name": "Average - Year Segment",
"alias": "",
"order": "7",
"column_type": "smart",
"simple_expression": "",
"smart_expression": "avg(c_1484) over(partition by c_1481)",
"type": "number",
"number_style": "currency",
"decimals": "0",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Average - Year Segment" },
"1339": { "id": "1339",
"report_view_id": "115",
"name": "Average - Total",
"alias": "c_1484",
"order": "8",
"column_type": "simple",
"simple_expression": "avg( {column} ) over()",
"smart_expression": "",
"type": "number",
"number_style": "currency",
"decimals": "0",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Average - Total" },
"1340": { "id": "1340",
"report_view_id": "115",
"name": "Total Given",
"alias": "c_1485",
"order": "9",
"column_type": "simple",
"simple_expression": "",
"smart_expression": "",
"type": "number",
"number_style": "currency",
"decimals": "0",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Total Given" },
"1341": { "id": "1341",
"report_view_id": "115",
"name": "Total Given - Year Segment",
"alias": "",
"order": "10",
"column_type": "smart",
"simple_expression": "sum(c_25) over(partition by c_26)",
"smart_expression": "sum(c_1485) over(partition by c_1481)",
"type": "number",
"number_style": "currency",
"decimals": "0",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Total Given - Year Segment" },
"1342": { "id": "1342",
"report_view_id": "115",
"name": "Total Given - Total",
"alias": "",
"order": "11",
"column_type": "smart",
"simple_expression": "sum(c_25) over()",
"smart_expression": "sum(c_1485) over()",
"type": "number",
"number_style": "currency",
"decimals": "0",
"currency": "USD",
"datetime_format": "",
"sprintf_format": "",
"segment": "",
"is_hidden": false,
"render_as": "bar",
"chart_options": null,
"created": "2023-12-15 19:27:34",
"modified": "2023-12-15 19:27:34",
"dynamic_name": "",
"name_formatted": "Total Given - Total" } } }
Source: Ratio Christi
Updated on: 13/04/2026
Thank you!