{"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-02T10:37:21","modified_gmt":"2026-10-02T08:37:21","password":"","slug":"how-do-i-use-an-ad-hoc-report","status":"publish","type":"docs","link":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/adhoc-reports-en\/how-do-i-use-an-ad-hoc-report\/","title":{"rendered":"How do I use an ad hoc 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<p class=\"wp-block-paragraph\"><span style=\"font-weight: bold\">Statistics<\/span><\/p>\n\n<p class=\"wp-block-paragraph\">Ad Hoc reports are statistical data. This means that a basic understanding of how to interpret statistics is necessary to understand the reports. <\/p>\n\n<h2 class=\"wp-block-heading\">Run an Ad Hoc Report<\/h2>\n\n<p class=\"wp-block-paragraph\">Under Ad Hoc 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<p class=\"wp-block-paragraph\">Once you&#8217;ve selected everything, click &#8220;Run Query&#8221; (4) to start, and you&#8217;ll see the result.  <\/p>\n\n<figure class=\"wp-block-image\"><img fetchpriority=\"high\" decoding=\"async\" width=\"867\" height=\"205\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image.jpeg\" alt=\"\" class=\"wp-image-11891\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image.jpeg 867w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image-300x71.jpeg 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image-768x182.jpeg 768w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image-360x85.jpeg 360w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><\/figure>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<h2 class=\"wp-block-heading\">Statistics Settings<\/h2>\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 ad hoc report is used (see [[How do I create a new ad hoc report?]]).   <\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"940\" height=\"549\" src=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image-1.jpeg\" alt=\"\" class=\"wp-image-11893\" srcset=\"https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image-1.jpeg 940w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image-1-300x175.jpeg 300w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image-1-768x449.jpeg 768w, https:\/\/churchtools.academy\/wp-content\/uploads\/2022\/01\/image-1-360x210.jpeg 360w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/figure>\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<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>Hinweis<\/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<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<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<p class=\"wp-block-paragraph\"><span style=\"font-weight: bold\">Order of the Fields<\/span><\/p>\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<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<h4 class=\"wp-block-heading has-medium-font-size\">Read more<\/h4>\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 ad hoc 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 Ad Hoc reports are statistical data. This means that a basic understanding of how to interpret statistics is necessary to [&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-10","word_count":285,"total_views":"1","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":2,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/97357\/revisions"}],"predecessor-version":[{"id":97363,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/97357\/revisions\/97363"}],"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}]}}