{"id":3345,"date":"2024-01-12T17:42:31","date_gmt":"2024-01-12T15:42:31","guid":{"rendered":"https:\/\/bitimpulse.com\/?post_type=manual&#038;p=3345"},"modified":"2024-09-26T11:20:24","modified_gmt":"2024-09-26T08:20:24","slug":"pidsvitka-danyh","status":"publish","type":"manual","link":"https:\/\/bitimpulse.com\/en\/manual\/rozshyreni-mozhlyvosti-oformlennya-zvitiv\/pidsvitka-danyh\/","title":{"rendered":"Data Highlighting"},"content":{"rendered":"<p>Highlighting helps you to better analyze data. Let\u2019s prepare the table of the next structure:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3346\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_3.png\" alt=\"\" width=\"704\" height=\"514\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_3.png 704w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_3-450x329.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_3-300x219.png 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/a><\/p>\n<p>On the rows \u2013 \u201cProduct Categories\u201d dimension with a whole \u201cProduct\u201d level selected under the \u201cTouring Bikes\u201d element:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3347\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_4.png\" alt=\"\" width=\"181\" height=\"166\" \/><\/a><\/p>\n<p>on columns \u2013 years 2017 and 2018. Inside the table \u2013 \u201cReseller Sales Amount\u201d measure.<\/p>\n<p>Say, we need to emphasize somehow the sales amount larger than 500,000. To do that, perform one of the following actions:<\/p>\n<ol>\n<li>Select \u201cTable \/ Highlight\u201d from main menu.<\/li>\n<li>Select the corresponding item from the context menu of the table:<\/li>\n<\/ol>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3348\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_5.png\" alt=\"\" width=\"789\" height=\"478\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_5.png 789w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_5-450x273.png 450w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_5-300x182.png 300w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_5-768x465.png 768w\" sizes=\"auto, (max-width: 789px) 100vw, 789px\" \/><\/a><\/p>\n<ol start=\"3\">\n<li>Press the Highlight button at the bottom of the editor:<\/li>\n<\/ol>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3349\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_6.png\" alt=\"\" width=\"234\" height=\"275\" \/><\/a><\/p>\n<p>The window will appear containing highlight rules (there are no rules at the moment):<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3350\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_7.png\" alt=\"\" width=\"520\" height=\"542\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_7.png 520w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_7-432x450.png 432w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_7-288x300.png 288w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<p>Press the Add button and a new tab with a highlight rule will appear.<\/p>\n<p>Let\u2019s name the rule \u201cMore than 500K\u201d and fill in all the fields as it is shown on the picture below:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3351\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_8.png\" alt=\"\" width=\"520\" height=\"542\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_8.png 520w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_8-432x450.png 432w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_8-288x300.png 288w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<p>According to the configured rule, the \u201cReseller Sales Amount\u201d measure will be analyzed. The type of analysis is Exception (exceptional situation), empty fields will be ignored and the values bigger than 500,000 will be colored green.<\/p>\n<p>After pressing \u00abOK\u00bb button you will see that all values bigger than 500,000 are highlighted with a green color:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3352\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_9.png\" alt=\"\" width=\"338\" height=\"369\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_9.png 338w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_9-275x300.png 275w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/a><\/p>\n<p>You can set multiple highlight rules.<\/p>\n<p>The highlight can also be of gradient type. Open the highlight rules window once again and change the highlight settings as it is shown on the picture:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3353\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_10.png\" alt=\"\" width=\"520\" height=\"542\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_10.png 520w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_10-432x450.png 432w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_10-288x300.png 288w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<p>After that the table will look like this:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3354\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_11.png\" alt=\"\" width=\"338\" height=\"369\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_11.png 338w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_11-275x300.png 275w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/a><\/p>\n<p>You can easily notice that the bigger is value in the cell, the more saturated is its color. If you press the \u201cSelect\u201d button in the highlight rule\u2019s settings window,<a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3355\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_12.png\" alt=\"\" width=\"520\" height=\"542\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_12.png 520w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_12-432x450.png 432w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_12-288x300.png 288w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<p>then the other window will appear where you can set the gradient settings:<\/p>\n<p><a href=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3356\" src=\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_13.png\" alt=\"\" width=\"440\" height=\"220\" srcset=\"https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_13.png 440w, https:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/01\/6_13-300x150.png 300w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>You can set one-color, two-color or rainbow highlight, set the number of steps, etc.<\/p>","protected":false},"featured_media":0,"parent":3335,"menu_order":121,"template":"","manuals":[17],"class_list":["post-3345","manual","type-manual","status-publish","hentry","manuals-bat-report"],"_links":{"self":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manual\/3345","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\/3335"}],"wp:attachment":[{"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/media?parent=3345"}],"wp:term":[{"taxonomy":"manuals","embeddable":true,"href":"https:\/\/bitimpulse.com\/en\/wp-json\/wp\/v2\/manuals?post=3345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}