{"id":97357,"date":"2022-01-03T16:25:52","date_gmt":"2022-01-03T14:25:52","guid":{"rendered":"https:\/\/churchtools.academy\/help\/non-knowledgebase\/uncategorized\/how-do-i-use-an-ad-hoc-report\/"},"modified":"2026-10-28T15:51:57","modified_gmt":"2026-10-28T13:51:57","password":"","slug":"how-to-use-an-adhoc-report","status":"publish","type":"docs","link":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/adhoc-reports-en\/how-to-use-an-adhoc-report\/","title":{"rendered":"How to use an adhoc report?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">ChurchTools comes standard with several typical ad hoc reports that provide answers to questions about congregational development and ChurchTools usage. The reports are always run immediately and therefore reflect the current state of affairs.   <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"font-weight: bold\">Statistics<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Adhoc reports are statistical data. This means that a basic understanding of how to interpret statistics is necessary to understand the reports. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Run an Adhoc report<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Under Adhoc Reports (1), select the desired query (2) and specify the desired report (3) if there are multiple options. If report filters exist for the selected query, they will be displayed on a second line. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you&#8217;ve selected everything, click &#8220;Execute request&#8221; (4) to start, and you&#8217;ll see the result. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-reports.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"279\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-reports-1024x279.png\" alt=\"Screenshot Report Adhoc reports\" class=\"wp-image-98222\" style=\"aspect-ratio:3.6702860963538306;width:687px;height:auto\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-reports-1024x279.png 1024w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-reports-300x82.png 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-reports-768x210.png 768w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-reports-360x98.png 360w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-reports.png 1070w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Statistics Settings<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The query results are displayed in the center. By default, the chart type specified in the master data for the adhoc report is used (see [[How do I create a new ad hoc report?]]).  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-report-details.png\"><img decoding=\"async\" width=\"1024\" height=\"599\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-report-details-1024x599.png\" alt=\"Screenshot Report Adhoc report details\" class=\"wp-image-98225\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-report-details-1024x599.png 1024w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-report-details-300x175.png 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-report-details-768x449.png 768w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-report-details-1536x898.png 1536w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-report-details-360x211.png 360w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/Report_Adhoc-report-details.png 1640w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">(1) You can change the chart type at any time.<br>(2) The same applies to the aggregation of the data.<\/p>\n\n\n\n<aside class=\"wp-block-group ct-box ct-box-blue has-background is-vertical is-layout-flex wp-container-core-group-is-layout-1ccdadb1 wp-block-group-is-layout-flex\" style=\"border-radius:8px;border-left-color:#3e70ce;border-left-width:0.5rem;background-color:#f3f5f7;margin-top:var(--wp--preset--spacing--60);margin-bottom:var(--wp--preset--spacing--60)\">\n<p class=\"wp-block-paragraph\" style=\"margin-top:0.5rem;margin-right:0.5rem;margin-bottom:0rem;margin-left:0.5rem\"><strong>Note<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"margin-top:0rem;margin-right:0.5rem;margin-bottom:0.5rem;margin-left:0.5rem\">Not every aggregation and chart type is appropriate for every situation. You&#8217;ll need to make the right choice here so that the data is displayed correctly and you can interpret it. <\/p>\n<\/aside>\n\n\n\n<p class=\"wp-block-paragraph\">(3) This section displays the fields from the query that are not yet being used in the current report. If you want to use them, simply drag and drop them into the column or row (4). <br>(4) Fields in the query that are used as columns or rows in this view.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Multiple fields can be used for the column or row display. This groups the values.<br>For example, this allows you to compare reports not only by year but also by year\/month.   <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"font-weight: bold\">Order of the fields<\/span><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Please note that the order of the fields in the column\/row is important. For example, the display for &#8220;Year\/Month&#8221; is different from that for &#8220;Month\/Year.&#8221; <\/p>\n\n\n\n<aside class=\"wp-block-group ct-artikel-zum-weiterlesen has-background is-layout-constrained wp-container-core-group-is-layout-79a8db7e wp-block-group-is-layout-constrained\" style=\"border-radius:8px;background-color:#f9fafb;margin-top:24px;margin-bottom:24px;padding-top:32px;padding-right:24px;padding-bottom:32px;padding-left:24px\">\n<h2 class=\"wp-block-heading has-medium-font-size\">Read more<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/adhoc-reports-en\/what-are-ad-hoc-reports\/\" id=\"7603\">What are adhoc reports?<\/a><\/li>\n<\/ul>\n<\/aside>\n","protected":false},"excerpt":{"rendered":"<p>ChurchTools comes standard with several typical ad hoc reports that provide answers to questions about congregational development and ChurchTools usage. The reports are always run immediately and therefore reflect the current state of affairs. Statistics Adhoc reports are statistical data. This means that a basic understanding of how to interpret statistics is necessary to understand [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[494],"doc_tag":[],"knowledge_base":[224],"class_list":["post-97357","docs","type-docs","status-publish","hentry","doc_category-adhoc-reports-en","knowledge_base-churchtools-modules"],"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","pp_force_visibility":null,"pp_subpost_visibility":null,"pp_inherited_force_visibility":null,"pp_inherited_subpost_visibility":null,"acf":[],"year_month":"2026-11","word_count":280,"total_views":"12","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Victoria Weidemann","author_nicename":"vweidemann","author_url":"https:\/\/churchtools.academy\/en\/author\/vweidemann\/"},"doc_category_info":[{"term_name":"AdHoc-Reports","term_url":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/adhoc-reports-en\/"}],"doc_tag_info":[],"knowledge_base_info":[{"term_name":"Modules","term_url":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/","term_slug":"churchtools-modules"}],"knowledge_base_slug":["churchtools-modules"],"_links":{"self":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/97357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/comments?post=97357"}],"version-history":[{"count":10,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/97357\/revisions"}],"predecessor-version":[{"id":98231,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/97357\/revisions\/98231"}],"wp:attachment":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/media?parent=97357"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/doc_category?post=97357"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/doc_tag?post=97357"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/knowledge_base?post=97357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}