{"id":5631,"date":"2024-08-05T13:12:46","date_gmt":"2024-08-05T10:12:46","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=5631"},"modified":"2024-08-05T13:24:37","modified_gmt":"2024-08-05T10:24:37","slug":"stvorennya-obchyslyuvalnyh-poliv","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-interaktyvnogo-deshborda\/dzherelo-danyh-baza-danyh\/stvorennya-obchyslyuvalnyh-poliv\/","title":{"rendered":"Creating a Calculated Field"},"content":{"rendered":"<p>After you created the data source, you can add a new calculated field based on the existing data source fields.<\/p>\n<p>To create a calculated field, select the required data source in the Data Source list and click the \u00abAdd Calculated Field\u00bb button on the \u201cData Source\u201d tab:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5643\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_1-2.png\" alt=\"\" width=\"1026\" height=\"239\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_1-2.png 1026w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_1-2-450x105.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_1-2-300x70.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_1-2-768x179.png 768w\" sizes=\"auto, (max-width: 1026px) 100vw, 1026px\" \/><\/a><\/p>\n<p>In the \u201cExpression Editor\u201d window that appears, you can specify the calculated field:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_2-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5645\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_2-3.png\" alt=\"\" width=\"745\" height=\"578\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_2-3.png 745w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_2-3-450x349.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_2-3-300x233.png 300w\" sizes=\"auto, (max-width: 745px) 100vw, 745px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The following elements are available:<\/p>\n<ul>\n<li>Functions<\/li>\n<li>Operators<\/li>\n<li>Columns<\/li>\n<li>Constants<\/li>\n<\/ul>\n<p>Later-generated calculated field will be displayed in the data source structure:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_3-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5641\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_3-2.png\" alt=\"\" width=\"191\" height=\"328\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_3-2.png 191w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_3-2-175x300.png 175w\" sizes=\"auto, (max-width: 191px) 100vw, 191px\" \/><\/a><\/p>\n<p>The calculated field has its own context menu:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_4-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5640\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_1_4_4-2.png\" alt=\"\" width=\"300\" height=\"197\" \/><\/a><\/p>\n<ul>\n<li>Add Calculated Field \u2013 add calculated field;<\/li>\n<li>Edit Expression\u2026 \u2013 edit calculated field;<\/li>\n<li>Field Type \u2013 define calculated field type;<\/li>\n<li>Rename \u2013 changes the calculated field name;<\/li>\n<li>Delete \u2013 removes the calculated field from the data<\/li>\n<\/ul>\n<p><\/p>","protected":false},"featured_media":0,"parent":5535,"menu_order":428,"template":"","manuals":[18],"class_list":["post-5631","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/5631","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\/5535"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=5631"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=5631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}