{"id":7692,"date":"2014-07-07T14:44:37","date_gmt":"2014-07-07T19:44:37","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/legacy\/?page_id=7692"},"modified":"2023-11-16T13:56:59","modified_gmt":"2023-11-16T19:56:59","slug":"color-coding-via-m-painter","status":"publish","type":"page","link":"https:\/\/www.mrc-productivity.com\/legacy\/m-painter-app-prop\/color-coding-via-m-painter","title":{"rendered":"Color Coding via m-Painter"},"content":{"rendered":"<h1>Color Coding via m-Painter<\/h1>\n<p>Click <a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/color-coding-via-m-painter\">here<\/a> to view documentation for the current version of this feature.<br \/>\nTo help highlight data patterns, developers often employ the use of conditional styles to color code their data. For example, when a percentage is greater than 80%, you may wish to make that data cell green, whereas otherwise you would want to continue to leave it as a white background with black text.<\/p>\n<h2>Color Coding Demonstration<\/h2>\n<p><iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"\/\/www.youtube.com\/embed\/l6jqfeSwufw\" frameborder=\"0\" allowfullscreen=\"\"><\/iframe><\/p>\n<p>m-Painter allows you to add color coding to your data set in the following methods:<\/p>\n<p><a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/color-coding-via-m-painter\" here<=\"\" a=\"\"><\/a><a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/color-coding-via-m-painter\" here<=\"\" a=\"\"><\/a><a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/color-coding-via-m-painter\" here<=\"\" a=\"\"><\/a><a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/color-coding-via-m-painter\" here<=\"\" a=\"\"><\/a><a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/color-coding-via-m-painter\" here<=\"\" a=\"\"><\/a><\/p>\n<div class=\"leftMargin\" <ul=\"\"><a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/color-coding-via-m-painter\" here<=\"\" a=\"\"><br \/>\n<\/a><\/p>\n<li><a href=\"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/color-coding-via-m-painter\" here<=\"\" a=\"\"><\/a><a href=\"#cell\">By color coding the individual cell\/row across all templates<\/a><\/li>\n<li><a href=\"#column\">By color coding the entire column (Reports only)<\/a><\/li>\n<h2 id=\"cell\">Color Coding the Cell\/Row<\/h2>\n<p>To begin, right click the cell you wish to color code, then place your cursor over the &quot;Cell&quot; context option, and select &quot;Color Code Cell&quot;.<br \/>\n<img decoding=\"async\" src=\"\/legacy\/images\/color1.png\" class=\"alignnone\"><br \/>\nYou will be brought to a screen that looks like this:<br \/>\n<img decoding=\"async\" src=\"\/legacy\/images\/color2.png\" class=\"alignnone\"><\/p>\n<p>Utilize the condition area to specify the rules for your condition. In the &quot;Value Field\/Text&quot; input box you can either specify a hard-coded value (via the &quot;Text&quot; option) or compare two fields to one another (via the &quot;Field Value&quot; option). By clicking the &quot;Add Another Case&quot; button, you can add additional conditions to this rule.<\/p>\n<p>The next step, is to specify either a CSS Class or a CSS Style. If you have a pre-made CSS class you wish to use, please enter it in the &quot;CSS Class Name.&quot; If not, toggle to the &quot;Set CSS Styles&quot; tab and enter in the rules you wish your condition to use.<\/p>\n<p>When finished, be sure to click &quot;Save Condition&quot; button. If you wish to have multiple color condition rules on one cell, feel free to add additional conditions within this same wizard. When completed, be sure to press OK to close the wizard.<br \/>\nIn the below example, I have created 3 rules depending on the value of my &quot;Runs&quot; field value.<br \/>\n<img decoding=\"async\" src=\"\/legacy\/images\/color3.png\" class=\"alignnone\"><\/p>\n<p>In m-Painter, I can see this individual cell has color coding on it, as a thicker border is now drawn.<br \/>\n<img decoding=\"async\" src=\"\/legacy\/images\/color4.png\" class=\"alignnone\"><br \/>\n<strong>Note: <\/strong> This border is only visible in m-Painter and will not be seen by the end-user.<\/p>\n<p>At run-time my application looks something like this:<br \/>\n<img decoding=\"async\" src=\"\/legacy\/images\/color5.png\" class=\"alignnone\"><\/p>\n<p><strong>Note: <\/strong>While not explicitly stated above, the same process could be employed by row so that your conditional logic is applied to all cells within a row by right clicking on a cell, hovering over Row, then choosing the &quot;Color Code Row&quot; option.<\/p>\n<h2 id=\"column\">Color Coding the Entire Column with a Report<\/h2>\n<p>Report templates are unique in that they display multiple levels of output depending on selected subtotal and grand total levels. If you were interested in creating a conditional rule that applied to all rows for a given column, first right click one of the cells within the column you wish to color code, then place your cursor over the &quot;Column&quot; context option, and select &quot;Color Code Column&quot;.<\/p>\n<p>You&#39;ll notice that you now have the ability to select the &quot;From&quot; location of your selected field. The purpose of this option is to allow you &quot;from&quot; where you would like the data accessed for your conditional logic. Specifically, since you are working across multiple levels, be sure to select either &quot;Subtotal&quot; or &quot;Last Row of Detail&quot;, depending on how you want your totaling levels to be computed &#8212; when the color conditioning is processed for the detail level, it will automatically utilize the data from the row level.<\/p>\n<p>As an example, see how I have configured my column to print a yellow background when the value from field &quot;Issues- this period&quot; is greater than the value from field &quot;Receipts- this period&quot;. Be sure to press &quot;Save Condition&quot; prior to pressing &quot;Ok.&quot;<br \/>\n<img decoding=\"async\" src=\"\/legacy\/images\/color6.png\" class=\"alignnone\"><\/p>\n<p>In my output below, you can see how my color logic was applied to all levels.<br \/>\n<img decoding=\"async\" src=\"\/legacy\/images\/color7.png\" class=\"alignnone\"><\/p>\n<h2>Color Coding with the OLAP Pivot Table Report Template<\/h2>\n<p>The OLAP Pivot Table template supports color coding as of the January 2015 release of m-Power.<\/p>\n<p>Click the Color Code icon in the Insert tool menu to add a new color condition.<\/p>\n<p><a href=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/ColorCodeButton-1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/ColorCodeButton-1.png\" alt=\"\" width=\"76\" height=\"66\" class=\"aligncenter size-full wp-image-8773\"><\/a><\/p>\n<p>m-Painter will display a list of saved conditions at the bottom of the page. To edit a saved condition, place your cursor over the desired condition and right-click. Select Insert\/Edit Color Condition.<\/p>\n<p><a href=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/ColorConditionList1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/ColorConditionList1.png\" alt=\"\" width=\"454\" height=\"142\" class=\"aligncenter size-full wp-image-8776\" srcset=\"https:\/\/www.mrc-productivity.com\/legacy\/images\/ColorConditionList1.png 454w, https:\/\/www.mrc-productivity.com\/legacy\/images\/ColorConditionList1-150x47.png 150w, https:\/\/www.mrc-productivity.com\/legacy\/images\/ColorConditionList1-300x94.png 300w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><\/a><\/p>\n<p><strong>Note:<\/strong> Color coding dimension fields is not supported in the OLAP Pivot Table template. You may only set conditional coloring for value fields.<\/p>\n<p>Other Important Details&#8230;.<\/p>\n<div class=\"leftMargin\" <ul=\"\">\n<li>To delete an individual condition, click the &quot;Remove&quot; link. However, if you wish to delete the entire entry, click the &quot;Remove Existing Color Code Condition&quot; checkbox at the top of the dialog window, then press &quot;Ok.&quot;<\/li>\n<li>The color conditional logic is not designed to have multiple rules applied to the same cell. For instance, do not attempt to apply one rule to an individual cell, then a separate rule applied to the entire row.<\/li>\n<li>This feature is not supported in applications where the run time property &quot;Column Reorder&quot; has been enabled.<\/li>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Color Coding via m-Painter Click here to view documentation for the current version of this feature. To help highlight data patterns, developers often employ the use of conditional styles to color code their data. For example, when a percentage is greater than 80%, you may wish to make that data cell green, whereas otherwise you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1410,"menu_order":50,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-7692","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/7692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=7692"}],"version-history":[{"count":21,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/7692\/revisions"}],"predecessor-version":[{"id":9578,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/7692\/revisions\/9578"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1410"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=7692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}