{"id":4774,"date":"2024-02-12T09:55:32","date_gmt":"2024-02-12T07:55:32","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=4774"},"modified":"2024-10-22T14:00:15","modified_gmt":"2024-10-22T11:00:15","slug":"nalashtuvannya-avtomatychnoyi-rozsylky","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/rozsylka-zvitiv-poshtoyu-2\/nalashtuvannya-avtomatychnoyi-rozsylky\/","title":{"rendered":"Setting Up the Mail Broadcast"},"content":{"rendered":"<p>Switch to the \u201cList\u201d tab and select the report for which you would like to set up a mail broadcast. Now press the \u201cMail Broadcast\u201d button:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4777\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_2.png\" alt=\"\" width=\"926\" height=\"600\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_2.png 926w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_2-450x292.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_2-300x194.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_2-768x498.png 768w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/a><\/p>\n<p>After this field that appears to the left, click on the \u201c New Report Broadcast\u201d button:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4778\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_3.png\" alt=\"\" width=\"926\" height=\"600\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_3.png 926w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_3-450x292.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_3-300x194.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_3-768x498.png 768w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/a><\/p>\n<p>A form for mail broadcast settings will appear:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4779\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_4.png\" alt=\"\" width=\"805\" height=\"692\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_4.png 805w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_4-450x387.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_4-300x258.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_4-768x660.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>On the tab \u201cGeneral\u201d you can select the status of the mail broadcast (you can change it later if necessary), assign a name to this broadcast, choose the language of the cube or to use the report name instead, and to add the notes.<\/p>\n<p>On the tab \u201cPeriods\u201d use the section \u201cMode\u201d to select one of the scheduling modes:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4780\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_5.png\" alt=\"\" width=\"805\" height=\"692\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_5.png 805w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_5-450x387.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_5-300x258.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_5-768x660.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>In the section \u201cProperties\u201d set up the date and periods. In the lower left zone there is a possibility to set up the desired time, or to set up \u201csend every N hours\u201d. Also there is a possibility to set up the end date of the mail broadcast. In the right part of the window there is a description that tells about when the mail broadcast will be working and what is the first date and time when it will run.<\/p>\n<p>On the tab \u201cFormat\u201d you will have to select the file type that will be sent:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4781\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_6.png\" alt=\"\" width=\"284\" height=\"156\" \/><\/a><\/p>\n<p>The tab \u201cPages\u201d is used to select the set of pages that will be sent to the user:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4782\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_7.png\" alt=\"\" width=\"805\" height=\"692\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_7.png 805w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_7-450x387.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_7-300x258.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_7-768x660.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>There exist three types of pages: administrator pages, user pages and shared pages. It is possible to set up the desired type of page and to select the specific pages:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4783\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_8.png\" alt=\"\" width=\"805\" height=\"692\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_8.png 805w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_8-450x387.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_8-300x258.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_8-768x660.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>In the edit box \u201cSearch\u201d there is a way to quickly select the pages by name:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4784\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_9.png\" alt=\"\" width=\"282\" height=\"453\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_9.png 282w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_9-280x450.png 280w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_9-187x300.png 187w\" sizes=\"auto, (max-width: 282px) 100vw, 282px\" \/><\/a><\/p>\n<p>The tab \u201cCondition\u201d allows to set up optional condition that will be checked to decide if to send the mail or not to send:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4785\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_10.png\" alt=\"\" width=\"805\" height=\"692\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_10.png 805w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_10-450x387.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_10-300x258.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_10-768x660.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>By default there are no conditions. It means that the mail broadcast will work always.<\/p>\n<p>But you can change it here:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4786\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_11.png\" alt=\"\" width=\"287\" height=\"126\" \/><\/a><\/p>\n<ul>\n<li>Unconditional: the report will be sent always;<\/li>\n<li>Conditional: the report will be sent only if the condition is met.<\/li>\n<\/ul>\n<p>If you selected \u201cConditional\u201d, you have to set up the condition using one of the ways:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4787\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_12.png\" alt=\"\" width=\"419\" height=\"127\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_12.png 419w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_12-300x91.png 300w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><\/a><\/p>\n<ul>\n<li><strong>MDX: <\/strong>you can write an arbitrary MDX by pressing the button \u201cCreate\u201d<\/li>\n<\/ul>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4788\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_13.png\" alt=\"\" width=\"982\" height=\"749\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_13.png 982w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_13-450x343.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_13-300x229.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_13-768x586.png 768w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/a><\/p>\n<ul>\n<li>you can create a new page or to use an existing page. If you create a new page, the window for page type selection will appear:<\/li>\n<\/ul>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4789\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_14.png\" alt=\"\" width=\"590\" height=\"243\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_14.png 590w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_14-450x185.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_14-300x124.png 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/a><\/p>\n<p>In the case if you select an existing page, there will be another window:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4790\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_15.png\" alt=\"\" width=\"310\" height=\"432\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_15.png 310w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_15-215x300.png 215w\" sizes=\"auto, (max-width: 310px) 100vw, 310px\" \/><\/a><\/p>\n<p>In both cases a new designer form will be open.<\/p>\n<p>Then you have to define how the condition is checked. There are 4 ways:<\/p>\n<ul>\n<li>Query should return at least one cell;<\/li>\n<li>Query should not return any cells;<\/li>\n<li>Query should return at least one member on rows\/columns;<\/li>\n<li>Query should not return any members on rows\/columns.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>The report will be sent only in the case if the condition is met.<\/p>\n<p>Administrator also has a choice to select the user context under which the test will be performed:<\/p>\n<ul>\n<li><strong>Current user<\/strong>: the check will be made in the context of the user for whom the report is generated;<\/li>\n<li><strong>Administrator<\/strong>: the check is performed in context of administrator.<\/li>\n<\/ul>\n<p>Let us set up the schedule so that all users will get a report \u00ab<em>Report 1<\/em>\u00bb on the first and third Monday of May every 2 hours till 6pm in NRP format, including just pages \u00ab Map 1\u00bb.\u00a0 To achieve this goal, fill in the forms as shown:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_16.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4791\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_16.png\" alt=\"\" width=\"504\" height=\"278\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_16.png 504w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_16-450x248.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_16-300x165.png 300w\" sizes=\"auto, (max-width: 504px) 100vw, 504px\" \/><\/a><\/p>\n<p>The tab \u201cPeriods\u201d:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4792\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_17.png\" alt=\"\" width=\"805\" height=\"692\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_17.png 805w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_17-450x387.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_17-300x258.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_17-768x660.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>Select NRP on the tab \u201cFormat\u201d. Select the necessary pages on the \u201cPages\u201d tab:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4793\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_18.png\" alt=\"\" width=\"498\" height=\"348\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_18.png 498w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_18-450x314.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_18-300x210.png 300w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p>The tab \u201cCondition\u201d should be like this:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_19.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4794\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_19.png\" alt=\"\" width=\"805\" height=\"692\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_19.png 805w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_19-450x387.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_19-300x258.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_19-768x660.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>After pressing \u00abOK\u00bb you will get a new record in the list of mail broadcasts:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4795\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_20.png\" alt=\"\" width=\"1046\" height=\"600\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_20.png 1046w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_20-450x258.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_20-300x172.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_20-768x441.png 768w\" sizes=\"auto, (max-width: 1046px) 100vw, 1046px\" \/><\/a><\/p>\n<p>Let us assume we need to get the report \u201cSales Loss\u201d only in the case if the loss had place.<\/p>\n<p>We want to make so that this report comes by mail every first day of every month at 10:00am, but only in the case if the sales of \u00a0\u201cBikes\u201d decreased in France in comparison with the previous month. If the sales did not decrease, it is not necessary to send the report.<\/p>\n<p>To implement this task let us fill in the tab \u201cGeneral\u201d:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4796\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_21.png\" alt=\"\" width=\"498\" height=\"271\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_21.png 498w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_21-450x245.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_21-300x163.png 300w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p>On the tab \u201cPeriods\u201d set the following parameters:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_22.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4797\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_22.png\" alt=\"\" width=\"805\" height=\"692\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_22.png 805w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_22-450x387.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_22-300x258.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_22-768x660.png 768w\" sizes=\"auto, (max-width: 805px) 100vw, 805px\" \/><\/a><\/p>\n<p>Select NRP on the tab \u201cFormat\u201d<strong>. <\/strong>Select the necessary pages on the tab \u201cPages\u201d:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_23.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4798\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_23.png\" alt=\"\" width=\"498\" height=\"638\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_23.png 498w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_23-351x450.png 351w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_23-234x300.png 234w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Select \u201cConditional\u201d on the tab \u201cCondition\u201d:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_24.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4799\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_24.png\" alt=\"\" width=\"498\" height=\"246\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_24.png 498w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_24-450x222.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_24-300x148.png 300w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p>Now we have a goal \u2013 to set up the condition \u201cif the sales decreased in comparison with the previous month, then send the report, otherwise don\u2019t send\u201d.<\/p>\n<p>The condition will be implemented using a regular table (like in regular reports). This table will contain a filter which checks the loss of sales. If the table returns at least one row, it means that the condition is met and the report should be sent.<\/p>\n<p>Let us show how this should be set up:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4800\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_25.png\" alt=\"\" width=\"590\" height=\"243\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_25.png 590w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_25-450x185.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_25-300x124.png 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/a><\/p>\n<p>In the page designer let us select the following data:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_26.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4801\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_26.png\" alt=\"\" width=\"361\" height=\"252\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_26.png 361w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_26-300x209.png 300w\" sizes=\"auto, (max-width: 361px) 100vw, 361px\" \/><\/a><\/p>\n<p>To set up the date it is preferable to use the \u201cfloating period\u201d:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_27.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4802\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_27.png\" alt=\"\" width=\"462\" height=\"606\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_27.png 462w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_27-343x450.png 343w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_27-229x300.png 229w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>The rows contain the \u201cBikes\u201d category, the columns contain France. The date is in context.<\/p>\n<p>Let us set up the filter:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_28.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4803\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_28.png\" alt=\"\" width=\"629\" height=\"635\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_28.png 629w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_28-446x450.png 446w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_28-297x300.png 297w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_29.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4804\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_29.png\" alt=\"\" width=\"358\" height=\"190\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_29.png 358w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_29-300x159.png 300w\" sizes=\"auto, (max-width: 358px) 100vw, 358px\" \/><\/a><\/p>\n<p>This filter will return a row only in the case if the sales of bikes in the last month decreased in one of the countries in comparison to the previous month. Then let us save and close the page.<\/p>\n<p>In the schedule settings in \u201cWhat test to do\u201d we have to select \u201cQuery should return at least one cell\u201d (we know that the report will return data only in the case if there is a loss of sales):<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_30.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4805\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_30.png\" alt=\"\" width=\"498\" height=\"371\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_30.png 498w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_30-450x335.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_30-300x223.png 300w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p>After you press \u00abOK\u00bb the list of mail broadcasts will have a new record:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_31.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4806\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_31.png\" alt=\"\" width=\"1046\" height=\"600\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_31.png 1046w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_31-450x258.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_31-300x172.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/7_31-768x441.png 768w\" sizes=\"auto, (max-width: 1046px) 100vw, 1046px\" \/><\/a><\/p>","protected":false},"featured_media":0,"parent":4767,"menu_order":178,"template":"","manuals":[17],"class_list":["post-4774","manual","type-manual","status-publish","hentry","manuals-bat-report"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/4774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual"}],"about":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/types\/manual"}],"up":[{"embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/4767"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=4774"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=4774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}