{"id":7003,"date":"2024-08-13T15:59:54","date_gmt":"2024-08-13T12:59:54","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=7003"},"modified":"2024-08-13T15:59:54","modified_gmt":"2024-08-13T12:59:54","slug":"pravylo-pidsvitky-gradiyentna-zalyvka","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/stvorennya-interaktyvnogo-deshborda\/pidsvitka\/pravylo-pidsvitky-gradiyentna-zalyvka\/","title":{"rendered":"Format Rule: Gradient Ranges"},"content":{"rendered":"<p>\u201cGradient Ranges\u201d allow you to use predefined color gradients to apply conditional formatting to different ranges of values. You can also use specific colors to generate custom gradients.:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_1-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7012\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_1-2.png\" alt=\"\" width=\"379\" height=\"411\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_1-2.png 379w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_1-2-277x300.png 277w\" sizes=\"auto, (max-width: 379px) 100vw, 379px\" \/><\/a><\/p>\n<p>The form of the gradient highlight looks the following:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_2-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7011\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_2-2.png\" alt=\"\" width=\"284\" height=\"646\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_2-2.png 284w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_2-2-198x450.png 198w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_2-2-132x300.png 132w\" sizes=\"auto, (max-width: 284px) 100vw, 284px\" \/><\/a><\/p>\n<p>The following options will be available in the appeared window:<\/p>\n<ul>\n<li>Number of ranges \u2013 \u201cNumber of ranges\u201d allows you to specify the number of ranges used to classify values. Click the \u201cGenerate Ranges\u201d button to generate a new gradient scale according to the specified number of ranges;<\/li>\n<li>Use % ranges \u2013 the \u201cUse % ranges\u201d check box specifies whether the percent or absolute scale is used to generate ranges;<\/li>\n<\/ul>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_3-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7010\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/08\/9_21_7_3-2.png\" alt=\"\" width=\"233\" height=\"239\" \/><\/a><\/p>\n<ul>\n<li>Range field with specified ranges:<\/li>\n<li>Intersection mode \u2013 the level at which the highlight will be The levels can be as follows:\n<ul>\n<li>Auto \u2013 identifies the default For the Pivot dashboard item, Auto identifies the \u201cFirst Level\u201d;<\/li>\n<li>First level \u2013 first level values are used to apply conditional formatting;<\/li>\n<li>Last level \u2013 the last level values are used to apply conditional formatting;<\/li>\n<li>All levels \u2013 all pivot data cells are used to apply conditional formatting;<\/li>\n<li>Specific level \u2013 values from the specific level are used to apply conditional<\/li>\n<\/ul>\n<\/li>\n<li>Row\/Column dimension &#8211; if you specified the Intersection mode as \u201cSpecific Level\u201d, use the \u201cRow dimension\u201d and \u201cColumn dimension\u201d combo boxes to set the specific level;<\/li>\n<li>Apply to \u2013 to which element (measure, hierarchy) of the Pivot table the conditional formatting should be applied;<\/li>\n<\/ul>\n<p>Apply to row\/column \u2013 apply to the entire row \/ to the entire column.<\/p>","protected":false},"featured_media":0,"parent":6908,"menu_order":525,"template":"","manuals":[18],"class_list":["post-7003","manual","type-manual","status-publish","hentry","manuals-bat-desktop"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/7003","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\/6908"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=7003"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=7003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}