{"size":{"Width":508,"Height":255},"appearance":{"background":null,"padding":14,"font":{"family":"Courier New","size":10.0,"bold":false,"italic":false,"underline":false,"strikeout":false,"color":"rgb(0,72,168)"},"border":{"on":true,"size":0.0,"style":"solid","color":"#666"},"text":{"wrap":false,"hAlign":"left","vAlign":"top"}},"outputType":"WIDGET","widgetState":null,"outputs":{"console":"<pre class='debug-source'>&gt;library(flipTransformations)\n</pre>\n<pre class='debug-source'>&gt;library(flipPictographs)\n</pre>\n<pre class='debug-source'>&gt;is.custom.url &lt;- icon == &quot;(Custom icon)&quot;\n</pre>\n<pre class='debug-source'>&gt;icon.image &lt;- if (is.custom.url) customurl else icon\n</pre>\n<pre class='debug-source'>&gt;fill.palette &lt;- if (is.custom.url) &quot;Strong colors&quot; else fillPalette\n</pre>\n<pre class='debug-source'>&gt;fill.color &lt;- if (is.custom.url || fillPalette != &quot;User-specified&quot;) &quot;black&quot; else fillColor\n</pre>\n<pre class='debug-source'>&gt;hide.base &lt;- if (is.custom.url) FALSE else hideBase\n</pre>\n<pre class='debug-source'>&gt;base.color &lt;- if (is.custom.url || hideBase) &quot;&quot; else baseColor\n</pre>\n<pre class='debug-source'>&gt;label.col.as.icon &lt;- if (is.custom.url) FALSE else labelColAsIcon\n</pre>\n<pre class='debug-source'>&gt;\n</pre>\n<pre class='debug-source'>&gt;dat &lt;- if (!exists(&quot;formDataType&quot;) || formDataType == &quot;Use an existing table&quot;) {\n x\n} else {\n ParseEnteredData(formEnteredData)\n}\n</pre>\n<pre class='debug-source'>&gt;dat[is.na(dat)] &lt;- NaN\n</pre>\n<pre class='debug-source'>&gt;\n</pre>\n<pre class='debug-source'>&gt;pictoBarChart.2 &lt;- PictographChart(dat, mode=&quot;bar&quot;, image = icon.image, icon.ncol=as.numeric(numCols),\n base.image = custombaseurl, fix.icon.nrow=ifelse(numCols==&quot;&quot; | !hide.base, TRUE, fixNRows),\n total.icons = as.numeric(totalIcons), scale = as.numeric(scale), is.custom.url = is.custom.url, \n\t icon.palette = fill.palette, icon.colors = fill.color, fill.direction = direction,\n hide.base.image = hide.base, base.icon.color = base.color, \n hide.label.top=TRUE, hide.label.right=(!rowLabelShow || direction != &quot;From right&quot;),\n hide.label.left=(!rowLabelShow || direction != &quot;From left&quot;),\n label.color.asIcon = label.col.as.icon, label.font.family = labelFont,\n label.left.font.color = labelColor, label.right.font.color = labelColor,\n label.left.font.size = labelRowSize, label.right.font.size = labelRowSize,\n label.left.align.horizontal = labelRowHAlign, label.right.align.horizontal = labelRowHAlign,\n show.label.data = dLabPos != &quot;No&quot;, label.data.position = dLabPos,\n customize.label.data = (dLabPos != &quot;No&quot; &amp;&amp; dLabCustom),\n label.data.align.horizontal = ifelse(dLabCustom &amp;&amp; dLabPos %in% c(&quot;Above icons&quot;, &quot;Below icons&quot;), dLabAlign, &quot;Default&quot;), \n #label.data.align.horizontal = &quot;Default&quot;,\n label.data.font.size = dLabSize, row.names.to.remove = rowsToIgnore,\n label.data.prefix=dLabPrefix, label.data.suffix=dLabSuffix, \n label.data.100prc=(grepl(&quot;%&quot;, dLabSuffix) &amp;&amp; dLab100Prc), label.data.digits=dLabDigits,\n pad.row = padRow, pad.icon.row = 0, pad.icon.col = 0, label.pad = 5,\n background.color = &quot;transparent&quot;, show.legend=FALSE,\n graphic.width.inch=QOutputSizeWidth, graphic.height.inch=QOutputSizeHeight) # picked up from Displayr environment\n</pre>\n<pre class='debug-source'>&gt;pictoBarChart.2\n</pre>\r\n<div class=\"debug-summarystatistics\"><table>\r\n<tr><th>Started:</th><td class=utc-time>2018-09-19T06:47:57.485Z</td></tr>\r\n<tr><th>Finished:</th><td class=utc-time>2018-09-19T06:47:57.485Z</td></tr>\r\n<tr><th>Total time:</th><td>0.64s</td></tr>\r\n<tr><th>Time executing code:</th><td title=\"0.03s\">0.61s</td></tr>\r\n<tr><th>Other overhead on R server:</th><td>0.40s</td></tr>\r\n<tr><th>Time spent transferring data:</th><td>0.03s</td></tr>\r\n<tr><th>Data sent to R server:</th><td>4KB</td></tr>\r\n<tr><th>Data received from R server:</th><td>13.6KB</td></tr>\r\n</table></div>","htmlwidgets":"<div id=\"htmlwidget_container\">\n <div id=\"htmlwidget-fc72dab7ce6224d2012d\" style=\"width:960px;height:500px;\" class=\"rhtmlPictographs html-widget\"></div>\n</div>\n<script type=\"application/json\" data-for=\"htmlwidget-fc72dab7ce6224d2012d\">{\"x\":\"{\\\"width\\\":507.99996, \\\"height\\\":294.999984,\\\"background-color\\\":\\\"transparent\\\",\\\"table\\\":{\\\"rowHeights\\\":[\\\"proportion:0.2\\\",\\\"proportion:0.2\\\",\\\"proportion:0.2\\\",\\\"proportion:0.2\\\",\\\"proportion:0.2\\\"],\\\"rowGutterLength\\\":2,\\\"columnGutterLength\\\":2,\\\"colWidths\\\":[\\\"flexible:label\\\",\\\"flexible:graphic\\\"],\\\"rows\\\":[[{\\\"type\\\":\\\"label\\\", \\\"value\\\":{\\\"padding-right\\\":5.000000,\\n \\\"padding-top\\\":1.000000, \\\"padding-bottom\\\":0.000000, \\\"vertical-align\\\":\\\"center\\\", \\\"labels\\\": [{\\\"text\\\":\\\"Facebook\\\", \\\"font-size\\\": \\\"11.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#3B5699\\\"},{\\\"text\\\": \\\"99%\\\", \\\"font-size\\\": \\\"12.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#3B5699\\\"}]}},{\\\"type\\\":\\\"graphic\\\", \\\"value\\\":{\\\"proportion\\\":0.990000,\\\"numImages\\\":10,\\n \\\"variableImage\\\":\\\"url:#3B5699:fromleft:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"baseImage\\\":\\\"url:#CCCCCC:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"numRows\\\": 1, \\n \\\"columnGutter\\\":0.000000, \\\"rowGutter\\\":0.000000, \\\"padding\\\":\\\"1.000000 0.000000 0.000000 0.000000\\\"}}],[{\\\"type\\\":\\\"label\\\", \\\"value\\\":{\\\"padding-right\\\":5.000000,\\n \\\"padding-top\\\":0.000000, \\\"padding-bottom\\\":0.000000, \\\"vertical-align\\\":\\\"center\\\", \\\"labels\\\": [{\\\"text\\\":\\\"Twitter\\\", \\\"font-size\\\": \\\"11.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#1AB8E8\\\"},{\\\"text\\\": \\\"90%\\\", \\\"font-size\\\": \\\"12.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#1AB8E8\\\"}]}},{\\\"type\\\":\\\"graphic\\\", \\\"value\\\":{\\\"proportion\\\":0.900000,\\\"numImages\\\":10,\\n \\\"variableImage\\\":\\\"url:#1AB8E8:fromleft:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"baseImage\\\":\\\"url:#CCCCCC:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"numRows\\\": 1, \\n \\\"columnGutter\\\":0.000000, \\\"rowGutter\\\":0.000000, \\\"padding\\\":\\\"0.000000 0.000000 0.000000 0.000000\\\"}}],[{\\\"type\\\":\\\"label\\\", \\\"value\\\":{\\\"padding-right\\\":5.000000,\\n \\\"padding-top\\\":0.000000, \\\"padding-bottom\\\":0.000000, \\\"vertical-align\\\":\\\"center\\\", \\\"labels\\\": [{\\\"text\\\":\\\"LinkedIn\\\", \\\"font-size\\\": \\\"11.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#3592BE\\\"},{\\\"text\\\": \\\"68%\\\", \\\"font-size\\\": \\\"12.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#3592BE\\\"}]}},{\\\"type\\\":\\\"graphic\\\", \\\"value\\\":{\\\"proportion\\\":0.680000,\\\"numImages\\\":10,\\n \\\"variableImage\\\":\\\"url:#3592BE:fromleft:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"baseImage\\\":\\\"url:#CCCCCC:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"numRows\\\": 1, \\n \\\"columnGutter\\\":0.000000, \\\"rowGutter\\\":0.000000, \\\"padding\\\":\\\"0.000000 0.000000 0.000000 0.000000\\\"}}],[{\\\"type\\\":\\\"label\\\", \\\"value\\\":{\\\"padding-right\\\":5.000000,\\n \\\"padding-top\\\":0.000000, \\\"padding-bottom\\\":0.000000, \\\"vertical-align\\\":\\\"center\\\", \\\"labels\\\": [{\\\"text\\\":\\\"Pinterest\\\", \\\"font-size\\\": \\\"11.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#EF2731\\\"},{\\\"text\\\": \\\"46%\\\", \\\"font-size\\\": \\\"12.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#EF2731\\\"}]}},{\\\"type\\\":\\\"graphic\\\", \\\"value\\\":{\\\"proportion\\\":0.460000,\\\"numImages\\\":10,\\n \\\"variableImage\\\":\\\"url:#EF2731:fromleft:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"baseImage\\\":\\\"url:#CCCCCC:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"numRows\\\": 1, \\n \\\"columnGutter\\\":0.000000, \\\"rowGutter\\\":0.000000, \\\"padding\\\":\\\"0.000000 0.000000 0.000000 0.000000\\\"}}],[{\\\"type\\\":\\\"label\\\", \\\"value\\\":{\\\"padding-right\\\":5.000000,\\n \\\"padding-top\\\":0.000000, \\\"padding-bottom\\\":1.000000, \\\"vertical-align\\\":\\\"center\\\", \\\"labels\\\": [{\\\"text\\\":\\\"Google+\\\", \\\"font-size\\\": \\\"11.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#E44D38\\\"},{\\\"text\\\": \\\"42%\\\", \\\"font-size\\\": \\\"12.000000px\\\", \\\"font-weight\\\":\\\"normal\\\", \\\"horizontal-align\\\":\\\"right\\\", \\\"font-family\\\":\\\"Arial\\\",\\\"font-color\\\":\\\"#E44D38\\\"}]}},{\\\"type\\\":\\\"graphic\\\", \\\"value\\\":{\\\"proportion\\\":0.420000,\\\"numImages\\\":10,\\n \\\"variableImage\\\":\\\"url:#E44D38:fromleft:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"baseImage\\\":\\\"url:#CCCCCC:https://displayrcors.azureedge.net/images/user_grey.svg\\\", \\\"numRows\\\": 1, \\n \\\"columnGutter\\\":0.000000, \\\"rowGutter\\\":0.000000, \\\"padding\\\":\\\"0.000000 0.000000 1.000000 0.000000\\\"}}]]}}\",\"evals\":[],\"jsHooks\":[]}</script>\n<script type=\"application/htmlwidget-sizing\" data-for=\"htmlwidget-fc72dab7ce6224d2012d\">{\"viewer\":{\"width\":450,\"height\":350,\"padding\":0,\"fill\":true},\"browser\":{\"width\":960,\"height\":500,\"padding\":0,\"fill\":true}}</script>","htmlwidget-head":"{\"stylesheets\":[\"https://rserverhtmlwidgetasset.azureedge.net/main-1c2ecf90c95d7abb5b3f8b8a31dc8484.css\"],\"javascript\":[\"https://rserverhtmlwidgetasset.azureedge.net/htmlwidgets-917a66c6e5036eb1bfd1fb672a82635a.js\",\"https://rserverhtmlwidgetasset.azureedge.net/rhtmlPictographs-2f218a3b5a5839a026b28d993f671af8.js\"],\"attachments\":[],\"widget-cannot-re-render\":false}","message":"","warning":""},"secondsTaken":0.6368278,"updated":"2018-09-19T06:47:57.4854509Z","lastUpdatedMessage":null,"executedCode":"library(flipTransformations)\nlibrary(flipPictographs)\nis.custom.url <- icon == \"(Custom icon)\"\nicon.image <- if (is.custom.url) customurl else icon\nfill.palette <- if (is.custom.url) \"Strong colors\" else fillPalette\nfill.color <- if (is.custom.url || fillPalette != \"User-specified\") \"black\" else fillColor\nhide.base <- if (is.custom.url) FALSE else hideBase\nbase.color <- if (is.custom.url || hideBase) \"\" else baseColor\nlabel.col.as.icon <- if (is.custom.url) FALSE else labelColAsIcon\n\ndat <- if (!exists(\"formDataType\") || formDataType == \"Use an existing table\") {\n x\n} else {\n ParseEnteredData(formEnteredData)\n}\ndat[is.na(dat)] <- NaN\n\npictoBarChart.2 <- PictographChart(dat, mode=\"bar\", image = icon.image, icon.ncol=as.numeric(numCols),\n base.image = custombaseurl, fix.icon.nrow=ifelse(numCols==\"\" | !hide.base, TRUE, fixNRows),\n total.icons = as.numeric(totalIcons), scale = as.numeric(scale), is.custom.url = is.custom.url, \n\t icon.palette = fill.palette, icon.colors = fill.color, fill.direction = direction,\n hide.base.image = hide.base, base.icon.color = base.color, \n hide.label.top=TRUE, hide.label.right=(!rowLabelShow || direction != \"From right\"),\n hide.label.left=(!rowLabelShow || direction != \"From left\"),\n label.color.asIcon = label.col.as.icon, label.font.family = labelFont,\n label.left.font.color = labelColor, label.right.font.color = labelColor,\n label.left.font.size = labelRowSize, label.right.font.size = labelRowSize,\n label.left.align.horizontal = labelRowHAlign, label.right.align.horizontal = labelRowHAlign,\n show.label.data = dLabPos != \"No\", label.data.position = dLabPos,\n customize.label.data = (dLabPos != \"No\" && dLabCustom),\n label.data.align.horizontal = ifelse(dLabCustom && dLabPos %in% c(\"Above icons\", \"Below icons\"), dLabAlign, \"Default\"), \n #label.data.align.horizontal = \"Default\",\n label.data.font.size = dLabSize, row.names.to.remove = rowsToIgnore,\n label.data.prefix=dLabPrefix, label.data.suffix=dLabSuffix, \n label.data.100prc=(grepl(\"%\", dLabSuffix) && dLab100Prc), label.data.digits=dLabDigits,\n pad.row = padRow, pad.icon.row = 0, pad.icon.col = 0, label.pad = 5,\n background.color = \"transparent\", show.legend=FALSE,\n graphic.width.inch=QOutputSizeWidth, graphic.height.inch=QOutputSizeHeight) # picked up from Displayr environment\npictoBarChart.2","lastSavedCode":"library(flipTransformations)\nlibrary(flipPictographs)\nis.custom.url <- icon == \"(Custom icon)\"\nicon.image <- if (is.custom.url) customurl else icon\nfill.palette <- if (is.custom.url) \"Strong colors\" else fillPalette\nfill.color <- if (is.custom.url || fillPalette != \"User-specified\") \"black\" else fillColor\nhide.base <- if (is.custom.url) FALSE else hideBase\nbase.color <- if (is.custom.url || hideBase) \"\" else baseColor\nlabel.col.as.icon <- if (is.custom.url) FALSE else labelColAsIcon\n\ndat <- if (!exists(\"formDataType\") || formDataType == \"Use an existing table\") {\n x\n} else {\n ParseEnteredData(formEnteredData)\n}\ndat[is.na(dat)] <- NaN\n\npictoBarChart.2 <- PictographChart(dat, mode=\"bar\", image = icon.image, icon.ncol=as.numeric(numCols),\n base.image = custombaseurl, fix.icon.nrow=ifelse(numCols==\"\" | !hide.base, TRUE, fixNRows),\n total.icons = as.numeric(totalIcons), scale = as.numeric(scale), is.custom.url = is.custom.url, \n\t icon.palette = fill.palette, icon.colors = fill.color, fill.direction = direction,\n hide.base.image = hide.base, base.icon.color = base.color, \n hide.label.top=TRUE, hide.label.right=(!rowLabelShow || direction != \"From right\"),\n hide.label.left=(!rowLabelShow || direction != \"From left\"),\n label.color.asIcon = label.col.as.icon, label.font.family = labelFont,\n label.left.font.color = labelColor, label.right.font.color = labelColor,\n label.left.font.size = labelRowSize, label.right.font.size = labelRowSize,\n label.left.align.horizontal = labelRowHAlign, label.right.align.horizontal = labelRowHAlign,\n show.label.data = dLabPos != \"No\", label.data.position = dLabPos,\n customize.label.data = (dLabPos != \"No\" && dLabCustom),\n label.data.align.horizontal = ifelse(dLabCustom && dLabPos %in% c(\"Above icons\", \"Below icons\"), dLabAlign, \"Default\"), \n #label.data.align.horizontal = \"Default\",\n label.data.font.size = dLabSize, row.names.to.remove = rowsToIgnore,\n label.data.prefix=dLabPrefix, label.data.suffix=dLabSuffix, \n label.data.100prc=(grepl(\"%\", dLabSuffix) && dLab100Prc), label.data.digits=dLabDigits,\n pad.row = padRow, pad.icon.row = 0, pad.icon.col = 0, label.pad = 5,\n background.color = \"transparent\", show.legend=FALSE,\n graphic.width.inch=QOutputSizeWidth, graphic.height.inch=QOutputSizeHeight) # picked up from Displayr environment\npictoBarChart.2","highlightedCodeSpans":[{"start":71,"length":4,"index":4},{"start":143,"length":4,"index":4},{"start":204,"length":11,"index":4},{"start":251,"length":11,"index":4},{"start":297,"length":9,"index":4},{"start":350,"length":8,"index":4},{"start":394,"length":8,"index":4},{"start":412,"length":9,"index":4},{"start":473,"length":14,"index":4},{"start":527,"length":12,"index":4},{"start":742,"length":7,"index":4},{"start":816,"length":7,"index":4},{"start":899,"length":10,"index":4},{"start":931,"length":5,"index":4},{"start":1055,"length":9,"index":4},{"start":1196,"length":12,"index":4},{"start":1212,"length":9,"index":4},{"start":1273,"length":12,"index":4},{"start":1289,"length":9,"index":4},{"start":1391,"length":9,"index":4},{"start":1528,"length":12,"index":4},{"start":1566,"length":12,"index":4},{"start":1625,"length":14,"index":4},{"start":1672,"length":14,"index":4},{"start":1721,"length":7,"index":4},{"start":1760,"length":7,"index":4},{"start":1808,"length":7,"index":4},{"start":1827,"length":10,"index":4},{"start":1892,"length":10,"index":4},{"start":1906,"length":7,"index":4},{"start":2080,"length":8,"index":4},{"start":2112,"length":12,"index":4},{"start":2159,"length":10,"index":4},{"start":2189,"length":10,"index":4},{"start":2247,"length":10,"index":4},{"start":2262,"length":10,"index":4},{"start":2293,"length":10,"index":4},{"start":2330,"length":6,"index":4}],"tableTransformations":"<TabularTransformer>\r\n <TabularTransform type=\"Truncation\" truncationHeaderType=\"Column\" />\r\n <TabularTransform />\r\n</TabularTransformer>","tabularFilteringOptions":null,"hasGuiControls":true,"guiControls":{"Code":"form.setHeading(\"Pictograph bar chart\")\nif (!form.dataEntry)\n form.dropBox({name: \"x\", label: \"Input data\", types: [\"Table\", \"RItem:integer,numeric,matrix,array,data.frame,table\"], required: true});\nelse\n{\n var dt = form.comboBox({name: \"formDataType\", label: \"Data source\", alternatives: [\"Use an existing table\", \"Type or paste data\"], default_value: \"Use an existing table\"});\n if (dt.getValue() == \"Use an existing table\")\n form.dropBox({name: \"x\", label: \"Input data\", types: [\"Table\", \"RItem:integer,numeric,matrix,array,data.frame,table\"], required: true});\n else\n form.dataEntry({name: \"formEnteredData\", prompt: \"Opens a spreadsheet into which you can paste data.\"})\n}\nvar custom_label = \"(Custom icon)\";\nvar icon = form.comboBox({name: \"icon\", label: \"Icon\", alternatives: [\n custom_label, \"Apple\", \"Banana\", \"Baby\", \"Beer\", \"Book\", \"Bread\", \"Building\", \"Cake\", \"Car\", \"Cash\", \"Circle\", \"Chicken\", \"Church\", \"Computer\", \"Cow\", \"Cross\", \"Cup\", \"Cutlery\",\n \"Elephant\", \"Glass\", \"Globe\", \"Gun\", \"Heart\", \"House\", \"Idea\", \"Law\", \"Medicine\", \"Money\", \"Rocket\", \"Soldier\", \"Soup\", \"Sport\", \"Square\", \"Star\", \"Sick person\", \"Stick man\", \"Stick woman\", \"Test tube\",\n \"Thumbs up\", \"Thumbs down\", \"Tick\", \"Tools\", \"Tomato\", \"Traffic light\", \"Train\", \"Tree\", \"Truck\", \"TV\", \"User\", \"Water drop\", \"Weight\", \"Wine\"], default_value: \"Stick man\"});\nif (icon.getValue() == custom_label)\n{\n form.textBox({name: \"customurl\", label: \"Icon URL\", type: \"text\", required: true});\n var customBase = form.textBox({name: \"custombaseurl\", label: \"Base icon URL\", type: \"text\", required: false, prompt: \"Leave blank to hide unfilled icons\"});\n}\nform.textBox({name: \"scale\", label: \"Units per icon (scale)\", type: \"number\", required: false, prompt: \"Leave blank to determine based on range of Input data\"});\nform.textBox({name: \"totalIcons\", label: \"Total icons\", type: \"number\", required: false, prompt: \"Leave blank to determine from Input data\"});\nvar ncolOpt = form.textBox({name:\"numCols\", label: \"Maximum icons per row\", type: \"number\", prompt: \"Leave blank for all icons to be placed in a single row\", required: false});\nform.comboBox({name:\"direction\", label: \"Direction of fill\", alternatives: [\"From left\", \"From right\"], default_value: \"From left\"});\n \nif (icon.getValue() != custom_label)\n{\n paletteOpt = form.comboBox({name: \"fillPalette\", label: \"Icon color palette\", alternatives: [\n \"Default colors\", \"Primary colors\", \"Strong colors\", \"Light pastels\", \"Rainbow\", \"Reds\", \"Blues\", \"Greens\", \"Greys\", \"User-specified\"], default_value: \"Default colors\"});\n if (paletteOpt.getValue() == \"User-specified\")\n form.textBox({name: \"fillColor\", label: \"Icon fill color\", default_value: \"#FFA500\", prompt: \"Enter color as a string. Multiple values should be separated by commas.\"});\n var baseOpt = form.checkBox({name: \"hideBase\", label: \"Hide base image\", default_value: true});\n if (!baseOpt.getValue())\n form.colorPicker({name: \"baseColor\", label: \"Icon base color\",default_value: \"#CCCCCC\"});\n var labColOpt = form.checkBox({name: \"labelColAsIcon\", label: \"Labels colored as icons\"});\n}\n\nform.comboBox({name:\"labelFont\", label: \"Label font\", alternatives: [\"Arial\", \"Arial Black\", \"Century Gothic\", \"Georgia\", \"Impact\", \"Times New Roman\", \"Trebuchet MS\", \"Verdana\"], default_value: \"Arial\"});\nvar rowLabOpt = form.checkBox({name:\"rowLabelShow\", label: \"Show row label\", default_value: true});\nif (rowLabOpt.getValue())\n{\n form.numericUpDown({name:\"labelRowSize\", label: \"Row label size\", minimum: 5, maximum: 50, default_value: 12});\n if (icon.getValue() == custom_label || !labColOpt.getValue())\n form.colorPicker({name: \"labelColor\", label: \"Label color\", default_value: \"#2C2C2C\"});\n form.comboBox({name:\"labelRowHAlign\", label: \"Row label horizontal alignment\", alternatives: [\"Default\", \"Left\", \"Center\", \"Right\"], default_value: \"Default\"});\n}\n \nvar dLabOpt = form.comboBox({name:\"dLabPos\", label: \"Show data label\", alternatives: [\"No\", \"Next to bar\", \"Below row label\", \"Above row label\", \"Below icons\", \"Above icons\"], default_value: \"Next to bar\"});\nif (dLabOpt.getValue() != \"No\")\n{\n var dLabCOpt = form.checkBox({name:\"dLabCustom\", label:\"Customize data label\", default_value: false});\n if (dLabCOpt.getValue())\n { \n form.textBox({name:\"dLabPrefix\", label:\"Data label prefix\", type:\"text\", required:false});\n var dLabSxOpt = form.textBox({name:\"dLabSuffix\", label:\"Data label suffix\", type:\"text\", required:false});\n if (dLabSxOpt.getValue().match(\"%\"))\n form.checkBox({name:\"dLab100Prc\", label:\"Multiply by 100\"});\n form.numericUpDown({name:\"dLabDigits\", label: \"Decimals shown\", minimum: 0, maximum: 6, default_value: 0});\n form.numericUpDown({name:\"dLabSize\", label: \"Data label font size\", minimum: 5, maximum: 50, default_value: 12});\n if (dLabOpt.getValue() == \"Below icons\" || dLabOpt.getValue() == \"Above icons\")\n form.comboBox({name:\"dLabAlign\", label:\" Data label horizontal alignment\", alternatives: [\"Default\", \"Left\", \"Center\", \"Right\"], default_value: \"Default\"});\n }\n}\nif (ncolOpt.getValue() != \"\" && (icon.getValue() == custom_label && !customBase.getValue())||(icon.getValue() != custom_label && baseOpt.getValue()))\n form.checkBox({name:\"fixNRows\", label:\"Fixed number of rows per bar\", default_value: true});\nform.numericUpDown({name:\"padRow\", label: \"Space between bars\", minimum: 0, default_value: 2, increment:1});\nform.textBox({name:\"rowsToIgnore\", label: \"Rows to ignore\", type: \"text\", default_value: \"NET, Total, SUM\", required: false});","JSError":null,"JSErrorDetails":null,"ControlDefinitionErrors":null,"InputValidationErrors":null,"Controls":[{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":null,"Page":null,"Group":null,"Type":"Heading","Label":null,"LabelEmphasised":false,"Value":null,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":"Pictograph bar chart","Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formDataType","Page":null,"Group":null,"Type":"ComboBox","Label":"Data source","LabelEmphasised":false,"Value":"Type or paste data","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Use an existing table","Type or paste data"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formEnteredData","Page":null,"Group":null,"Type":"DataEntry","Label":"Edit Data...","LabelEmphasised":false,"Value":"[[\"\",\"\"],[\"Facebook\",\"0.99\"],[\"Twitter\",\"0.9\"],[\"LinkedIn\",\"0.68\"],[\"Pinterest\",\"0.46\"],[\"Google+\",\"0.42\"]]","Allowed":null,"Multi":false,"Prompt":"Opens a spreadsheet into which you can paste data.","ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"icon","Page":null,"Group":null,"Type":"ComboBox","Label":"Icon","LabelEmphasised":false,"Value":"User","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["(Custom icon)","Apple","Banana","Baby","Beer","Book","Bread","Building","Cake","Car","Cash","Circle","Chicken","Church","Computer","Cow","Cross","Cup","Cutlery","Elephant","Glass","Globe","Gun","Heart","House","Idea","Law","Medicine","Money","Rocket","Soldier","Soup","Sport","Square","Star","Sick person","Stick man","Stick woman","Test tube","Thumbs up","Thumbs down","Tick","Tools","Tomato","Traffic light","Train","Tree","Truck","TV","User","Water drop","Weight","Wine"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"scale","Page":null,"Group":null,"Type":"TextBox","Label":"Units per icon (scale)","LabelEmphasised":false,"Value":"0.1","Allowed":null,"Multi":false,"Prompt":"Leave blank to determine based on range of Input data","ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"totalIcons","Page":null,"Group":null,"Type":"TextBox","Label":"Total icons","LabelEmphasised":false,"Value":"10","Allowed":null,"Multi":false,"Prompt":"Leave blank to determine from Input data","ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"numCols","Page":null,"Group":null,"Type":"TextBox","Label":"Maximum icons per row","LabelEmphasised":false,"Value":"","Allowed":null,"Multi":false,"Prompt":"Leave blank for all icons to be placed in a single row","ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"direction","Page":null,"Group":null,"Type":"ComboBox","Label":"Direction of fill","LabelEmphasised":false,"Value":"From left","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["From left","From right"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"fillPalette","Page":null,"Group":null,"Type":"ComboBox","Label":"Icon color palette","LabelEmphasised":false,"Value":"User-specified","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Default colors","Primary colors","Strong colors","Light pastels","Rainbow","Reds","Blues","Greens","Greys","User-specified"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"fillColor","Page":null,"Group":null,"Type":"TextBox","Label":"Icon fill color","LabelEmphasised":false,"Value":"#3B5699,#1AB8E8,#3592BE,#EF2731,#E44D38","Allowed":null,"Multi":false,"Prompt":"Enter color as a string. Multiple values should be separated by commas.","ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"hideBase","Page":null,"Group":null,"Type":"CheckBox","Label":"Hide base image","LabelEmphasised":false,"Value":false,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":"left","Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"baseColor","Page":null,"Group":null,"Type":"ColorPicker","Label":"Icon base color","LabelEmphasised":false,"Value":"rgb(204, 204, 204)","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Icon base color: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"labelColAsIcon","Page":null,"Group":null,"Type":"CheckBox","Label":"Labels colored as icons","LabelEmphasised":false,"Value":true,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":"left","Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"labelFont","Page":null,"Group":null,"Type":"ComboBox","Label":"Label font","LabelEmphasised":false,"Value":"Arial","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Arial","Arial Black","Century Gothic","Georgia","Impact","Times New Roman","Trebuchet MS","Verdana"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"rowLabelShow","Page":null,"Group":null,"Type":"CheckBox","Label":"Show row label","LabelEmphasised":false,"Value":true,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":"left","Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"labelRowSize","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Row label size","LabelEmphasised":false,"Value":11.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Row label size: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":1.0,"Min":5.0,"Max":50.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"labelRowHAlign","Page":null,"Group":null,"Type":"ComboBox","Label":"Row label horizontal alignment","LabelEmphasised":false,"Value":"Default","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Default","Left","Center","Right"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"dLabPos","Page":null,"Group":null,"Type":"ComboBox","Label":"Show data label","LabelEmphasised":false,"Value":"Below row label","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["No","Next to bar","Below row label","Above row label","Below icons","Above icons"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"dLabCustom","Page":null,"Group":null,"Type":"CheckBox","Label":"Customize data label","LabelEmphasised":false,"Value":true,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":"left","Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"dLabPrefix","Page":null,"Group":null,"Type":"TextBox","Label":"Data label prefix","LabelEmphasised":false,"Value":"","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"dLabSuffix","Page":null,"Group":null,"Type":"TextBox","Label":"Data label suffix","LabelEmphasised":false,"Value":"%","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"dLab100Prc","Page":null,"Group":null,"Type":"CheckBox","Label":"Multiply by 100","LabelEmphasised":false,"Value":true,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":"left","Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"dLabDigits","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Decimals shown","LabelEmphasised":false,"Value":0.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Decimals shown: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":1.0,"Min":0.0,"Max":6.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"dLabSize","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Data label font size","LabelEmphasised":false,"Value":12.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Data label font size: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":1.0,"Min":5.0,"Max":50.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"padRow","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Space between bars","LabelEmphasised":false,"Value":2.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Space between bars: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":1.0,"Min":0.0,"Max":100.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"rowsToIgnore","Page":null,"Group":null,"Type":"TextBox","Label":"Rows to ignore","LabelEmphasised":false,"Value":"NET, Total, SUM","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":null,"Page":null,"Group":null,"Type":null,"Label":null,"LabelEmphasised":false,"Value":null,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":true}]},"calculating":"Idle","showDebug":false,"layout":"OutputOnly","vSplit":0.25,"hSplit":0.45,"updateWarnings":true,"updateMode":"Manual","warnSlow":false,"Options":{"debugconsole":false,"codeposition":"OutputOnly","splitH":0.45,"splitV":0.25,"update warnings":true,"updating":"Manual","warn slow":false}}