{"id":2291,"date":"2021-12-13T10:28:43","date_gmt":"2021-12-13T01:28:43","guid":{"rendered":"https:\/\/kintools.com\/?post_type=docs&#038;p=2291"},"modified":"2021-12-13T10:28:43","modified_gmt":"2021-12-13T01:28:43","password":"","slug":"conditions-3","status":"publish","type":"docs","link":"https:\/\/kintools.com\/en\/docs\/conditions-3\/","title":{"rendered":"conditions"},"content":{"rendered":"<p class=\"wp-block-paragraph\">If you need to set the color of the values in your chart, you can specify a condition. To set conditional formatting, use the Conditions property of the series editor. Use this property to invoke the condition editor. The figure below shows the main elements of the condition editor.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/embim1240.png\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/embim1241.png\" width=\"13\" height=\"13\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 13px; --smush-placeholder-aspect-ratio: 13\/13;\"><strong>&nbsp;the field is<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is used to select the type of condition.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" width=\"13\" height=\"13\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/embim1242.png\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 13px; --smush-placeholder-aspect-ratio: 13\/13;\"><strong>\u00a0<strong>data type<\/strong><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This field specifies the type of data on which the condition works. There are five types of data: strings, numbers, datetimes, booleans, and expressions. The data type affects how reporting tools process conditions. For example, if the data type is a string, the method for working with strings is used. Also, depending on the data type, the list of available operations for conditions will change. For example, for String data types, only the Containing operation is available. The Expression data type allows you to specify an expression in place of the second value. In this case, the reporting tool does not check compatibility between the first and second values of the condition. So the user should take care of the correctness of the expression.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" width=\"13\" height=\"13\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/embim1243.png\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 13px; --smush-placeholder-aspect-ratio: 13\/13;\"><strong>conditions<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The type of operation used to calculate the value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" width=\"13\" height=\"13\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/embim1244.png\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 13px; --smush-placeholder-aspect-ratio: 13\/13;\"><strong>\u00a0<\/strong>value<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">is the first value in the condition<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" width=\"13\" height=\"13\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/embim1245.png\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 13px; --smush-placeholder-aspect-ratio: 13\/13;\"><strong>\u00a0<\/strong>colour<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select a color to mark the value corresponding to the condition.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u30c1\u30e3\u30fc\u30c8\u5185\u306e\u5024\u306e\u8272\u3092\u8a2d\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408\u3001\u6761\u4ef6\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b\u306b\u306f\u3001\u30b7\u30ea\u30fc\u30ba [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","footnotes":""},"doc_category":[122],"doc_tag":[],"class_list":["post-2291","docs","type-docs","status-publish","hentry","doc_category-series","entry"],"year_month":"2026-05","word_count":3,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"yuko.imai","author_nicename":"yuko-imai","author_url":"https:\/\/kintools.com\/en\/author\/yuko-imai\/"},"doc_category_info":[{"term_name":"\u30b7\u30ea\u30fc\u30ba","term_url":"https:\/\/kintools.com\/en\/docs-category\/series\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/2291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/comments?post=2291"}],"version-history":[{"count":1,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/2291\/revisions"}],"predecessor-version":[{"id":2292,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/2291\/revisions\/2292"}],"wp:attachment":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/media?parent=2291"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_category?post=2291"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_tag?post=2291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}