{"size":{"Width":893,"Height":680},"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(flipStandardCharts)\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 formTable\n} else {\n ParseEnteredData(formEnteredData)\n}\n</pre>\n<pre class='debug-source'>&gt; \n</pre>\n<pre class='debug-source'>&gt;transpose &lt;- ifelse(formType != &quot;Donut&quot;, formTranspose, FALSE)\n</pre>\n<pre class='debug-source'>&gt;outer.palette &lt;- if (formType == &quot;Pie&quot; &amp;&amp; formPaletteOuter != &quot;Group colors&quot;) formPaletteOuter else NULL\n</pre>\n<pre class='debug-source'>&gt;bubble.title &lt;- ifelse(formType == &quot;Labeled Bubbleplot&quot;, formZTitle, &quot;&quot;)\n</pre>\n<pre class='debug-source'>&gt;radius &lt;- if (formType == &quot;Pie&quot; || formType == &quot;Donut&quot;) formRadius else NULL\n</pre>\n<pre class='debug-source'>&gt;group.indices &lt;- if (formType == &quot;Labeled Scatterplot&quot; || formType == &quot;Labeled Bubbleplot&quot;) formGroupIndices else NULL\n</pre>\n<pre class='debug-source'>&gt;group.labels &lt;- if (formType == &quot;Labeled Scatterplot&quot; || formType == &quot;Labeled Bubbleplot&quot;) formGroupLabels else NULL\n</pre>\n<pre class='debug-source'>&gt;x.grid.width &lt;- if ((formType %in% c(&quot;Bar&quot;, &quot;Stacked Bar&quot;, &quot;100% Stacked Bar&quot;, &quot;Labeled Scatterplot&quot;,\n &quot;Labeled Bubbleplot&quot;)) &amp;&amp; formShowGrid) 1 else 0\n</pre>\n<pre class='debug-source'>&gt;y.grid.width &lt;- if ((formType %in% c(&quot;Area&quot;, &quot;Stacked Area&quot;, &quot;100% Stacked Area&quot;, &quot;Line&quot;, &quot;Column&quot;,\n &quot;Stacked Column&quot;, &quot;100% Stacked Column&quot;, &quot;Labeled Scatterplot&quot;,\n &quot;Labeled Bubbleplot&quot;)) &amp;&amp; formShowGrid) 1 else 0\n</pre>\n<pre class='debug-source'>&gt;series.line.width &lt;- if (formType %in% c(&quot;Area&quot;, &quot;Stacked Area&quot;, &quot;100% Stacked Area&quot;)) 0 else 3\n</pre>\n<pre class='debug-source'>&gt;data.label.show &lt;- formType %in% c(&quot;Pie&quot;, &quot;Donut&quot;, &quot;Labeled Scatterplot&quot;, &quot;Labeled Bubbleplot&quot;) || formShowDataLabels\n</pre>\n<pre class='debug-source'>&gt;data.label.decimals &lt;- if (data.label.show &amp;&amp; !(formType %in% c(&quot;Labeled Scatterplot&quot;, &quot;Labeled Bubbleplot&quot;))) formDataLabelDecimals else 2\n</pre>\n<pre class='debug-source'>&gt;series.marker.show &lt;- if (formType %in% c(&quot;Labeled Scatterplot&quot;, &quot;Labeled Bubbleplot&quot;)) &quot;automatic&quot; else &quot;none&quot;\n</pre>\n<pre class='debug-source'>&gt;x.tick.prefix &lt;- &quot;&quot;\n</pre>\n<pre class='debug-source'>&gt;y.tick.prefix &lt;- &quot;&quot;\n</pre>\n<pre class='debug-source'>&gt;data.label.prefix &lt;- &quot;&quot;\n</pre>\n<pre class='debug-source'>&gt;x.tick.suffix &lt;- &quot;&quot;\n</pre>\n<pre class='debug-source'>&gt;y.tick.suffix &lt;- &quot;&quot;\n</pre>\n<pre class='debug-source'>&gt;data.label.suffix &lt;- &quot;&quot;\n</pre>\n<pre class='debug-source'>&gt;pie.show.percentages &lt;- formType %in% c(&quot;Pie&quot;, &quot;Donut&quot;) &amp;&amp; formPiePercentages\n</pre>\n<pre class='debug-source'>&gt;if (!(formType %in% c(&quot;100% Stacked Area&quot;, &quot;100% Stacked Bar&quot;, &quot;100% Stacked Column&quot;)) &amp;&amp; !pie.show.percentages)\n{\n if (formType == &quot;Bar&quot; || formType == &quot;Labeled Scatterplot&quot; || formType == &quot;Labeled Bubbleplot&quot;)\n {\n x.tick.prefix &lt;- formPrefix\n x.tick.suffix &lt;- formSuffix\n }\n if (formType != &quot;Bar&quot;)\n {\n y.tick.prefix &lt;- formPrefix\n y.tick.suffix &lt;- formSuffix\n }\n data.label.prefix = formPrefix\n data.label.suffix = formSuffix\n if (formSuffix == &quot;%&quot; &amp;&amp; formMultiplyBy100)\n dat &lt;- 100 * dat\n} else if (pie.show.percentages)\n data.label.suffix &lt;- &quot;%&quot;\n</pre>\n<pre class='debug-source'>&gt;x.title &lt;- if (!(formType %in% c(&quot;Pie&quot;, &quot;Donut&quot;))) formXTitle else &quot;&quot;\n</pre>\n<pre class='debug-source'>&gt;y.title &lt;- if (!(formType %in% c(&quot;Pie&quot;, &quot;Donut&quot;))) formYTitle else &quot;&quot;\n</pre>\n<pre class='debug-source'>&gt;us.date.format &lt;- if (!(formType %in% c(&quot;Labeled Scatterplot&quot;, &quot;Labeled Bubbleplot&quot;, &quot;Pie&quot;, &quot;Donut&quot;)))\n{\n if (formDateFormat == &quot;Default&quot;)\n NULL\n else if (formDateFormat == &quot;US (mm/dd/yyyy)&quot;)\n TRUE\n else if (formDateFormat == &quot;International (dd/mm/yyyy)&quot;)\n FALSE\n else\n stop(paste(&quot;Date format not recognized:&quot;, formDateFormat))\n}\n</pre>\n<pre class='debug-source'>&gt; \n</pre>\n<pre class='debug-source'>&gt;Donut &lt;- Chart(y = dat,\n type = formType,\n transpose = transpose,\n title = formTitle,\n title.font.family = NULL,\n title.font.color = NULL,\n title.font.size = 16,\n colors = formPalette,\n colors.reverse = FALSE,\n opacity = NULL,\n background.fill.color = rgb(255, 255, 255, maxColorValue = 255),\n background.fill.opacity = 1,\n charting.area.fill.color = rgb(255, 255, 255, maxColorValue = 255),\n charting.area.fill.opacity = 1,\n legend.show = TRUE,\n legend.fill = rgb(255, 255, 255, maxColorValue = 255),\n legend.border.color = rgb(44, 44, 44, maxColorValue = 255),\n legend.border.line.width = 0,\n legend.font.color = NULL,\n legend.font.family = NULL,\n legend.font.size = 10,\n legend.position = &quot;right&quot;,\n legend.ascending = TRUE,\n margin.top = NULL,\n margin.bottom = NULL,\n margin.left = NULL,\n margin.right = NULL,\n margin.inner.pad = NULL,\n y.title = y.title,\n y.title.font.color = NULL,\n y.title.font.family = NULL,\n y.title.font.size = 12,\n y.line.width = 0,\n y.line.color = rgb(0, 0, 0, maxColorValue = 255),\n y.tick.marks = &quot;&quot;,\n y.tick.mark.length = 5,\n y.bounds.minimum = NULL,\n y.bounds.maximum = NULL,\n y.tick.distance = NULL,\n y.zero.line.width = 0,\n y.zero.line.color = rgb(44, 44, 44, maxColorValue = 255),\n y.position = &quot;left&quot;,\n y.data.reversed = FALSE,\n y.grid.width = y.grid.width,\n y.grid.color = rgb(225, 225, 225, maxColorValue = 255),\n y.tick.show = TRUE,\n y.tick.suffix = y.tick.suffix,\n y.tick.prefix = y.tick.prefix,\n y.tick.decimals = NULL,\n y.tick.format.manual = &quot;&quot;,\n y.hovertext.decimals = NULL,\n y.hovertext.format.manual = &quot;&quot;,\n y.tick.angle = NULL,\n y.tick.font.color = NULL,\n y.tick.font.family = NULL,\n y.tick.font.size = 10,\n x.title = x.title,\n x.title.font.color = NULL,\n x.title.font.family = NULL,\n x.title.font.size = 12,\n x.line.width = 0,\n x.line.color = rgb(0, 0, 0, maxColorValue = 255),\n x.tick.marks = &quot;&quot;,\n x.tick.mark.length = 5,\n x.bounds.minimum = NULL,\n x.bounds.maximum = NULL,\n x.tick.distance = NULL,\n x.zero.line.width = 0,\n x.zero.line.color = rgb(44, 44, 44, maxColorValue = 255),\n x.position = &quot;bottom&quot;,\n x.data.reversed = FALSE,\n x.grid.width = x.grid.width,\n x.grid.color = rgb(225, 225, 225, maxColorValue = 255),\n x.tick.show = TRUE,\n x.tick.suffix = x.tick.suffix,\n x.tick.prefix = x.tick.prefix,\n x.tick.decimals = NULL,\n x.tick.format.manual = &quot;&quot;,\n x.hovertext.decimals = NULL,\n x.hovertext.format.manual = &quot;&quot;,\n x.tick.angle = NULL,\n x.tick.font.color = NULL,\n x.tick.font.family = NULL,\n x.tick.font.size = 10,\n x.tick.label.autoformat = TRUE,\n series.marker.show = series.marker.show,\n series.marker.colors = NULL,\n series.marker.colors.reverse = FALSE,\n series.marker.opacity = 1,\n series.marker.size = 6,\n series.marker.border.width = 1,\n series.marker.border.colors = NULL,\n series.marker.border.colors.reverse = FALSE,\n series.marker.border.opacity = 1,\n series.line.width = series.line.width,\n series.line.colors = NULL,\n series.line.colors.reverse = FALSE,\n series.line.opacity = 1,\n tooltip.show = TRUE,\n modebar.show = FALSE,\n global.font.family = &quot;Arial&quot;,\n global.font.color = rgb(44, 44, 44, maxColorValue=255),\n rows.to.ignore = formIgnoreRows,\n cols.to.ignore = formIgnoreColumns,\n bar.gap = 0.15,\n data.label.show = data.label.show,\n data.label.font.family = NULL,\n data.label.font.size = 10,\n data.label.font.color = NULL,\n data.label.decimals = data.label.decimals,\n data.label.prefix = data.label.prefix,\n data.label.suffix = data.label.suffix,\n data.label.threshold = NULL,\n data.label.position = &quot;top middle&quot;,\n pie.order = &quot;initial&quot;,\n pie.groups.order = &quot;initial&quot;,\n pie.subslice.colors = outer.palette,\n pie.subslice.colors.reverse = FALSE,\n pie.subslice.colors.repeat = TRUE,\n pie.border.color = rgb(255, 255, 255, maxColorValue = 255),\n pie.inner.radius = radius,\n pie.show.percentages = pie.show.percentages,\n z.title = bubble.title,\n scatter.group.indices = group.indices,\n scatter.group.labels = group.labels,\n us.date.format = us.date.format)\n</pre>\n<pre class='debug-source'>&gt; \n</pre>\n<pre class='debug-source'>&gt;Donut\n</pre>\r\n<div class=\"debug-summarystatistics\">\r\n<table>\r\n<tr><th>Total time:</th><td>2.57s</td></tr>\r\n<tr><th>Time on R server:</th><td title=\"rApacheServe 2.55s (pre 0.00s, post 0.00s) httpget_code() setup for eval 0.00s session$eval 2.51s (pre 0.00s, post 0.05s) unexplained 0.05s apparmor forking (pre 0.00s, post 0.00s)\">2.55s</td></tr>\r\n<tr><th>Time evaluating code:</th><td>2.42s</td></tr>\r\n<tr><th>Bytes sent:</th><td>11,305</td></tr>\r\n<tr><th>Bytes received:</th><td>24,997</td></tr>\r\n</table>\r\n</div>","htmlwidgets":"<div id=\"htmlwidget_container\">\n <div id=\"htmlwidget-1661c7bdcfa08a622f78\" style=\"width:960px;height:500px;\" class=\"rhtmlDonut html-widget\"></div>\n</div>\n<script type=\"application/json\" data-for=\"htmlwidget-1661c7bdcfa08a622f78\">{\"x\":{\"values\":[10.3867700417288,7.55697678485989,7.42524707033842,5.73712805261876,5.62806161235406,5.55509118895857,5.34518688609597,4.64598161148274,3.99948786796544,3.81542010617386,3.72628184574608,3.5268303271547,2.74917747366124,2.64904045188973,2.63040548861808,2.2519968202083,2.18217811240956,2.153179389187,2.01479896392064,1.9798615407631,1.87151215553823,1.78179135651408,1.7715940477885,1.54503302317399,1.39247365913545,1.07969307761345,1.00360267324304,0.701484453742371,0.694327217262107,0.685432158144338,0.605804030712213,0.418070902295817,0.253098331239176,0.236981277462318],\"labels\":[\"Reliable\",\"Fun\",\"Confident\",\"Honest\",\"Intelligent\",\"Upper-class\",\"Down-to-earth\",\"Sexy\",\"Up-to-date\",\"Traditional\",\"Charming\",\"Beautiful\",\"Humorous\",\"Imaginative\",\"Unconventional\",\"Masculine\",\"Outdoorsy\",\"Wholesome\",\"Sleepy\",\"Hip\",\"Open to new experiences\",\"Urban\",\"Carefree\",\"Tough\",\"Youthful\",\"Trying to be cool\",\"Health-conscious\",\"Older\",\"Weight-conscious\",\"Individualistic\",\"Feminine\",\"Rebellious\",\"Innocent\",\"Reckless\"],\"settings\":{\"valuesFont\":\"Arial\",\"valuesSize\":10,\"valuesColor\":[\"#5C9AD3\",\"#ED7D31\",\"#A5A5A5\",\"#FFC000\",\"#4473C5\",\"#70AD46\",\"#255F91\",\"#9E480D\",\"#636365\",\"#987300\",\"#26408B\",\"#42682B\",\"#5C9AD3\",\"#ED7D31\",\"#A5A5A5\",\"#FFC000\",\"#4473C5\",\"#70AD46\",\"#255F91\",\"#9E480D\",\"#636365\",\"#987300\",\"#26408B\",\"#42682B\",\"#5C9AD3\",\"#ED7D31\",\"#A5A5A5\",\"#FFC000\",\"#4473C5\",\"#70AD46\",\"#255F91\",\"#9E480D\",\"#636365\",\"#987300\"],\"valuesDisplay\":\"original\",\"valuesOrder\":\"initial\",\"valuesDec\":1,\"labelsFont\":\"Arial\",\"labelsSize\":10,\"labelsColor\":\"#2C2C2C\",\"labelsInner\":false,\"labelsBold\":false,\"labelsMinFontSize\":10,\"groups\":null,\"groupsFont\":\"Arial\",\"groupsFontColor\":\"#2C2C2C\",\"groupsSize\":10,\"groupsBold\":false,\"groupsColor\":null,\"groupsNames\":null,\"groupsSums\":null,\"groupsCounts\":null,\"groupLabelsMinFontSize\":10,\"footer\":\"\",\"footerFontFamily\":\"Arial\",\"footerFontSize\":8,\"footerFontColor\":\"#2C2C2C\",\"title\":\"\",\"titleFontFamily\":\"Arial\",\"titleFontSize\":16,\"titleFontColor\":\"#2C2C2C\",\"titleTopPadding\":0,\"subtitle\":\"\",\"subtitleFontFamily\":\"Arial\",\"subtitleFontSize\":12,\"subtitleFontColor\":\"#2C2C2C\",\"prefix\":\"\",\"suffix\":\"%\",\"orderControl\":false,\"gradient\":false,\"innerRadius\":\"60%\",\"minAngle\":0.003,\"borderColor\":\"#FFFFFF\"}},\"evals\":[],\"jsHooks\":[]}</script>\n<script type=\"application/htmlwidget-sizing\" data-for=\"htmlwidget-1661c7bdcfa08a622f78\">{\"viewer\":{\"width\":450,\"height\":350,\"padding\":0,\"fill\":true},\"browser\":{\"width\":960,\"height\":500,\"padding\":0,\"fill\":true}}</script>","htmlwidget-head":"{\"stylesheets\":[],\"javascript\":[\"https://rserverhtmlwidgetasset.azureedge.net/htmlwidgets-cd5c5716917807e1b69e2493221698b2.js\",\"https://rserverhtmlwidgetasset.azureedge.net/rhtmlDonut-07d83459e91c1cdc57696d3828593280.js\"],\"attachments\":[],\"widget-cannot-re-render\":false}","message":"","warning":""},"secondsTaken":2.5746484,"updated":"2018-03-22T05:06:48.1057779Z","lastUpdatedMessage":null,"executedCode":"library(flipTransformations)\nlibrary(flipStandardCharts)\n \ndat <- if (!exists(\"formDataType\") || formDataType == \"Use an existing table\") {\n formTable\n} else {\n ParseEnteredData(formEnteredData)\n}\n \ntranspose <- ifelse(formType != \"Donut\", formTranspose, FALSE)\nouter.palette <- if (formType == \"Pie\" && formPaletteOuter != \"Group colors\") formPaletteOuter else NULL\nbubble.title <- ifelse(formType == \"Labeled Bubbleplot\", formZTitle, \"\")\nradius <- if (formType == \"Pie\" || formType == \"Donut\") formRadius else NULL\ngroup.indices <- if (formType == \"Labeled Scatterplot\" || formType == \"Labeled Bubbleplot\") formGroupIndices else NULL\ngroup.labels <- if (formType == \"Labeled Scatterplot\" || formType == \"Labeled Bubbleplot\") formGroupLabels else NULL\nx.grid.width <- if ((formType %in% c(\"Bar\", \"Stacked Bar\", \"100% Stacked Bar\", \"Labeled Scatterplot\",\n \"Labeled Bubbleplot\")) && formShowGrid) 1 else 0\ny.grid.width <- if ((formType %in% c(\"Area\", \"Stacked Area\", \"100% Stacked Area\", \"Line\", \"Column\",\n \"Stacked Column\", \"100% Stacked Column\", \"Labeled Scatterplot\",\n \"Labeled Bubbleplot\")) && formShowGrid) 1 else 0\nseries.line.width <- if (formType %in% c(\"Area\", \"Stacked Area\", \"100% Stacked Area\")) 0 else 3\ndata.label.show <- formType %in% c(\"Pie\", \"Donut\", \"Labeled Scatterplot\", \"Labeled Bubbleplot\") || formShowDataLabels\ndata.label.decimals <- if (data.label.show && !(formType %in% c(\"Labeled Scatterplot\", \"Labeled Bubbleplot\"))) formDataLabelDecimals else 2\nseries.marker.show <- if (formType %in% c(\"Labeled Scatterplot\", \"Labeled Bubbleplot\")) \"automatic\" else \"none\"\nx.tick.prefix <- \"\"\ny.tick.prefix <- \"\"\ndata.label.prefix <- \"\"\nx.tick.suffix <- \"\"\ny.tick.suffix <- \"\"\ndata.label.suffix <- \"\"\npie.show.percentages <- formType %in% c(\"Pie\", \"Donut\") && formPiePercentages\nif (!(formType %in% c(\"100% Stacked Area\", \"100% Stacked Bar\", \"100% Stacked Column\")) && !pie.show.percentages)\n{\n if (formType == \"Bar\" || formType == \"Labeled Scatterplot\" || formType == \"Labeled Bubbleplot\")\n {\n x.tick.prefix <- formPrefix\n x.tick.suffix <- formSuffix\n }\n if (formType != \"Bar\")\n {\n y.tick.prefix <- formPrefix\n y.tick.suffix <- formSuffix\n }\n data.label.prefix = formPrefix\n data.label.suffix = formSuffix\n if (formSuffix == \"%\" && formMultiplyBy100)\n dat <- 100 * dat\n} else if (pie.show.percentages)\n data.label.suffix <- \"%\"\nx.title <- if (!(formType %in% c(\"Pie\", \"Donut\"))) formXTitle else \"\"\ny.title <- if (!(formType %in% c(\"Pie\", \"Donut\"))) formYTitle else \"\"\nus.date.format <- if (!(formType %in% c(\"Labeled Scatterplot\", \"Labeled Bubbleplot\", \"Pie\", \"Donut\")))\n{\n if (formDateFormat == \"Default\")\n NULL\n else if (formDateFormat == \"US (mm/dd/yyyy)\")\n TRUE\n else if (formDateFormat == \"International (dd/mm/yyyy)\")\n FALSE\n else\n stop(paste(\"Date format not recognized:\", formDateFormat))\n}\n \nDonut <- Chart(y = dat,\n type = formType,\n transpose = transpose,\n title = formTitle,\n title.font.family = NULL,\n title.font.color = NULL,\n title.font.size = 16,\n colors = formPalette,\n colors.reverse = FALSE,\n opacity = NULL,\n background.fill.color = rgb(255, 255, 255, maxColorValue = 255),\n background.fill.opacity = 1,\n charting.area.fill.color = rgb(255, 255, 255, maxColorValue = 255),\n charting.area.fill.opacity = 1,\n legend.show = TRUE,\n legend.fill = rgb(255, 255, 255, maxColorValue = 255),\n legend.border.color = rgb(44, 44, 44, maxColorValue = 255),\n legend.border.line.width = 0,\n legend.font.color = NULL,\n legend.font.family = NULL,\n legend.font.size = 10,\n legend.position = \"right\",\n legend.ascending = TRUE,\n margin.top = NULL,\n margin.bottom = NULL,\n margin.left = NULL,\n margin.right = NULL,\n margin.inner.pad = NULL,\n y.title = y.title,\n y.title.font.color = NULL,\n y.title.font.family = NULL,\n y.title.font.size = 12,\n y.line.width = 0,\n y.line.color = rgb(0, 0, 0, maxColorValue = 255),\n y.tick.marks = \"\",\n y.tick.mark.length = 5,\n y.bounds.minimum = NULL,\n y.bounds.maximum = NULL,\n y.tick.distance = NULL,\n y.zero.line.width = 0,\n y.zero.line.color = rgb(44, 44, 44, maxColorValue = 255),\n y.position = \"left\",\n y.data.reversed = FALSE,\n y.grid.width = y.grid.width,\n y.grid.color = rgb(225, 225, 225, maxColorValue = 255),\n y.tick.show = TRUE,\n y.tick.suffix = y.tick.suffix,\n y.tick.prefix = y.tick.prefix,\n y.tick.decimals = NULL,\n y.tick.format.manual = \"\",\n y.hovertext.decimals = NULL,\n y.hovertext.format.manual = \"\",\n y.tick.angle = NULL,\n y.tick.font.color = NULL,\n y.tick.font.family = NULL,\n y.tick.font.size = 10,\n x.title = x.title,\n x.title.font.color = NULL,\n x.title.font.family = NULL,\n x.title.font.size = 12,\n x.line.width = 0,\n x.line.color = rgb(0, 0, 0, maxColorValue = 255),\n x.tick.marks = \"\",\n x.tick.mark.length = 5,\n x.bounds.minimum = NULL,\n x.bounds.maximum = NULL,\n x.tick.distance = NULL,\n x.zero.line.width = 0,\n x.zero.line.color = rgb(44, 44, 44, maxColorValue = 255),\n x.position = \"bottom\",\n x.data.reversed = FALSE,\n x.grid.width = x.grid.width,\n x.grid.color = rgb(225, 225, 225, maxColorValue = 255),\n x.tick.show = TRUE,\n x.tick.suffix = x.tick.suffix,\n x.tick.prefix = x.tick.prefix,\n x.tick.decimals = NULL,\n x.tick.format.manual = \"\",\n x.hovertext.decimals = NULL,\n x.hovertext.format.manual = \"\",\n x.tick.angle = NULL,\n x.tick.font.color = NULL,\n x.tick.font.family = NULL,\n x.tick.font.size = 10,\n x.tick.label.autoformat = TRUE,\n series.marker.show = series.marker.show,\n series.marker.colors = NULL,\n series.marker.colors.reverse = FALSE,\n series.marker.opacity = 1,\n series.marker.size = 6,\n series.marker.border.width = 1,\n series.marker.border.colors = NULL,\n series.marker.border.colors.reverse = FALSE,\n series.marker.border.opacity = 1,\n series.line.width = series.line.width,\n series.line.colors = NULL,\n series.line.colors.reverse = FALSE,\n series.line.opacity = 1,\n tooltip.show = TRUE,\n modebar.show = FALSE,\n global.font.family = \"Arial\",\n global.font.color = rgb(44, 44, 44, maxColorValue=255),\n rows.to.ignore = formIgnoreRows,\n cols.to.ignore = formIgnoreColumns,\n bar.gap = 0.15,\n data.label.show = data.label.show,\n data.label.font.family = NULL,\n data.label.font.size = 10,\n data.label.font.color = NULL,\n data.label.decimals = data.label.decimals,\n data.label.prefix = data.label.prefix,\n data.label.suffix = data.label.suffix,\n data.label.threshold = NULL,\n data.label.position = \"top middle\",\n pie.order = \"initial\",\n pie.groups.order = \"initial\",\n pie.subslice.colors = outer.palette,\n pie.subslice.colors.reverse = FALSE,\n pie.subslice.colors.repeat = TRUE,\n pie.border.color = rgb(255, 255, 255, maxColorValue = 255),\n pie.inner.radius = radius,\n pie.show.percentages = pie.show.percentages,\n z.title = bubble.title,\n scatter.group.indices = group.indices,\n scatter.group.labels = group.labels,\n us.date.format = us.date.format)\n \nDonut","lastSavedCode":"library(flipTransformations)\nlibrary(flipStandardCharts)\n \ndat <- if (!exists(\"formDataType\") || formDataType == \"Use an existing table\") {\n formTable\n} else {\n ParseEnteredData(formEnteredData)\n}\n \ntranspose <- ifelse(formType != \"Donut\", formTranspose, FALSE)\nouter.palette <- if (formType == \"Pie\" && formPaletteOuter != \"Group colors\") formPaletteOuter else NULL\nbubble.title <- ifelse(formType == \"Labeled Bubbleplot\", formZTitle, \"\")\nradius <- if (formType == \"Pie\" || formType == \"Donut\") formRadius else NULL\ngroup.indices <- if (formType == \"Labeled Scatterplot\" || formType == \"Labeled Bubbleplot\") formGroupIndices else NULL\ngroup.labels <- if (formType == \"Labeled Scatterplot\" || formType == \"Labeled Bubbleplot\") formGroupLabels else NULL\nx.grid.width <- if ((formType %in% c(\"Bar\", \"Stacked Bar\", \"100% Stacked Bar\", \"Labeled Scatterplot\",\n \"Labeled Bubbleplot\")) && formShowGrid) 1 else 0\ny.grid.width <- if ((formType %in% c(\"Area\", \"Stacked Area\", \"100% Stacked Area\", \"Line\", \"Column\",\n \"Stacked Column\", \"100% Stacked Column\", \"Labeled Scatterplot\",\n \"Labeled Bubbleplot\")) && formShowGrid) 1 else 0\nseries.line.width <- if (formType %in% c(\"Area\", \"Stacked Area\", \"100% Stacked Area\")) 0 else 3\ndata.label.show <- formType %in% c(\"Pie\", \"Donut\", \"Labeled Scatterplot\", \"Labeled Bubbleplot\") || formShowDataLabels\ndata.label.decimals <- if (data.label.show && !(formType %in% c(\"Labeled Scatterplot\", \"Labeled Bubbleplot\"))) formDataLabelDecimals else 2\nseries.marker.show <- if (formType %in% c(\"Labeled Scatterplot\", \"Labeled Bubbleplot\")) \"automatic\" else \"none\"\nx.tick.prefix <- \"\"\ny.tick.prefix <- \"\"\ndata.label.prefix <- \"\"\nx.tick.suffix <- \"\"\ny.tick.suffix <- \"\"\ndata.label.suffix <- \"\"\npie.show.percentages <- formType %in% c(\"Pie\", \"Donut\") && formPiePercentages\nif (!(formType %in% c(\"100% Stacked Area\", \"100% Stacked Bar\", \"100% Stacked Column\")) && !pie.show.percentages)\n{\n if (formType == \"Bar\" || formType == \"Labeled Scatterplot\" || formType == \"Labeled Bubbleplot\")\n {\n x.tick.prefix <- formPrefix\n x.tick.suffix <- formSuffix\n }\n if (formType != \"Bar\")\n {\n y.tick.prefix <- formPrefix\n y.tick.suffix <- formSuffix\n }\n data.label.prefix = formPrefix\n data.label.suffix = formSuffix\n if (formSuffix == \"%\" && formMultiplyBy100)\n dat <- 100 * dat\n} else if (pie.show.percentages)\n data.label.suffix <- \"%\"\nx.title <- if (!(formType %in% c(\"Pie\", \"Donut\"))) formXTitle else \"\"\ny.title <- if (!(formType %in% c(\"Pie\", \"Donut\"))) formYTitle else \"\"\nus.date.format <- if (!(formType %in% c(\"Labeled Scatterplot\", \"Labeled Bubbleplot\", \"Pie\", \"Donut\")))\n{\n if (formDateFormat == \"Default\")\n NULL\n else if (formDateFormat == \"US (mm/dd/yyyy)\")\n TRUE\n else if (formDateFormat == \"International (dd/mm/yyyy)\")\n FALSE\n else\n stop(paste(\"Date format not recognized:\", formDateFormat))\n}\n \nDonut <- Chart(y = dat,\n type = formType,\n transpose = transpose,\n title = formTitle,\n title.font.family = NULL,\n title.font.color = NULL,\n title.font.size = 16,\n colors = formPalette,\n colors.reverse = FALSE,\n opacity = NULL,\n background.fill.color = rgb(255, 255, 255, maxColorValue = 255),\n background.fill.opacity = 1,\n charting.area.fill.color = rgb(255, 255, 255, maxColorValue = 255),\n charting.area.fill.opacity = 1,\n legend.show = TRUE,\n legend.fill = rgb(255, 255, 255, maxColorValue = 255),\n legend.border.color = rgb(44, 44, 44, maxColorValue = 255),\n legend.border.line.width = 0,\n legend.font.color = NULL,\n legend.font.family = NULL,\n legend.font.size = 10,\n legend.position = \"right\",\n legend.ascending = TRUE,\n margin.top = NULL,\n margin.bottom = NULL,\n margin.left = NULL,\n margin.right = NULL,\n margin.inner.pad = NULL,\n y.title = y.title,\n y.title.font.color = NULL,\n y.title.font.family = NULL,\n y.title.font.size = 12,\n y.line.width = 0,\n y.line.color = rgb(0, 0, 0, maxColorValue = 255),\n y.tick.marks = \"\",\n y.tick.mark.length = 5,\n y.bounds.minimum = NULL,\n y.bounds.maximum = NULL,\n y.tick.distance = NULL,\n y.zero.line.width = 0,\n y.zero.line.color = rgb(44, 44, 44, maxColorValue = 255),\n y.position = \"left\",\n y.data.reversed = FALSE,\n y.grid.width = y.grid.width,\n y.grid.color = rgb(225, 225, 225, maxColorValue = 255),\n y.tick.show = TRUE,\n y.tick.suffix = y.tick.suffix,\n y.tick.prefix = y.tick.prefix,\n y.tick.decimals = NULL,\n y.tick.format.manual = \"\",\n y.hovertext.decimals = NULL,\n y.hovertext.format.manual = \"\",\n y.tick.angle = NULL,\n y.tick.font.color = NULL,\n y.tick.font.family = NULL,\n y.tick.font.size = 10,\n x.title = x.title,\n x.title.font.color = NULL,\n x.title.font.family = NULL,\n x.title.font.size = 12,\n x.line.width = 0,\n x.line.color = rgb(0, 0, 0, maxColorValue = 255),\n x.tick.marks = \"\",\n x.tick.mark.length = 5,\n x.bounds.minimum = NULL,\n x.bounds.maximum = NULL,\n x.tick.distance = NULL,\n x.zero.line.width = 0,\n x.zero.line.color = rgb(44, 44, 44, maxColorValue = 255),\n x.position = \"bottom\",\n x.data.reversed = FALSE,\n x.grid.width = x.grid.width,\n x.grid.color = rgb(225, 225, 225, maxColorValue = 255),\n x.tick.show = TRUE,\n x.tick.suffix = x.tick.suffix,\n x.tick.prefix = x.tick.prefix,\n x.tick.decimals = NULL,\n x.tick.format.manual = \"\",\n x.hovertext.decimals = NULL,\n x.hovertext.format.manual = \"\",\n x.tick.angle = NULL,\n x.tick.font.color = NULL,\n x.tick.font.family = NULL,\n x.tick.font.size = 10,\n x.tick.label.autoformat = TRUE,\n series.marker.show = series.marker.show,\n series.marker.colors = NULL,\n series.marker.colors.reverse = FALSE,\n series.marker.opacity = 1,\n series.marker.size = 6,\n series.marker.border.width = 1,\n series.marker.border.colors = NULL,\n series.marker.border.colors.reverse = FALSE,\n series.marker.border.opacity = 1,\n series.line.width = series.line.width,\n series.line.colors = NULL,\n series.line.colors.reverse = FALSE,\n series.line.opacity = 1,\n tooltip.show = TRUE,\n modebar.show = FALSE,\n global.font.family = \"Arial\",\n global.font.color = rgb(44, 44, 44, maxColorValue=255),\n rows.to.ignore = formIgnoreRows,\n cols.to.ignore = formIgnoreColumns,\n bar.gap = 0.15,\n data.label.show = data.label.show,\n data.label.font.family = NULL,\n data.label.font.size = 10,\n data.label.font.color = NULL,\n data.label.decimals = data.label.decimals,\n data.label.prefix = data.label.prefix,\n data.label.suffix = data.label.suffix,\n data.label.threshold = NULL,\n data.label.position = \"top middle\",\n pie.order = \"initial\",\n pie.groups.order = \"initial\",\n pie.subslice.colors = outer.palette,\n pie.subslice.colors.reverse = FALSE,\n pie.subslice.colors.repeat = TRUE,\n pie.border.color = rgb(255, 255, 255, maxColorValue = 255),\n pie.inner.radius = radius,\n pie.show.percentages = pie.show.percentages,\n z.title = bubble.title,\n scatter.group.indices = group.indices,\n scatter.group.labels = group.labels,\n us.date.format = us.date.format)\n \nDonut","highlightedCodeSpans":[{"start":97,"length":12,"index":4},{"start":144,"length":9,"index":4},{"start":225,"length":8,"index":4},{"start":289,"length":8,"index":4},{"start":396,"length":8,"index":4},{"start":460,"length":8,"index":4},{"start":481,"length":8,"index":4},{"start":502,"length":10,"index":4},{"start":544,"length":8,"index":4},{"start":581,"length":8,"index":4},{"start":662,"length":8,"index":4},{"start":699,"length":8,"index":4},{"start":780,"length":8,"index":4},{"start":968,"length":8,"index":4},{"start":1259,"length":8,"index":4},{"start":1349,"length":8,"index":4},{"start":1496,"length":8,"index":4},{"start":1559,"length":21,"index":4},{"start":1614,"length":8,"index":4},{"start":1852,"length":8,"index":4},{"start":1887,"length":18,"index":4},{"start":1912,"length":8,"index":4},{"start":2029,"length":8,"index":4},{"start":2050,"length":8,"index":4},{"start":2087,"length":8,"index":4},{"start":2152,"length":10,"index":4},{"start":2188,"length":10,"index":4},{"start":2213,"length":8,"index":4},{"start":2263,"length":10,"index":4},{"start":2299,"length":10,"index":4},{"start":2340,"length":10,"index":4},{"start":2375,"length":10,"index":4},{"start":2394,"length":10,"index":4},{"start":2415,"length":17,"index":4},{"start":2538,"length":8,"index":4},{"start":2608,"length":8,"index":4},{"start":2685,"length":8,"index":4},{"start":3085,"length":8,"index":4},{"start":3166,"length":9,"index":4},{"start":3339,"length":11,"index":4},{"start":8071,"length":14,"index":4},{"start":8124,"length":17,"index":4}],"tableTransformations":"<TabularTransformer>\r\n <TabularTransform type=\"Truncation\" truncationHeaderType=\"Column\" />\r\n <TabularTransform />\r\n</TabularTransformer>","tabularFilteringOptions":null,"hasGuiControls":true,"guiControls":{"Code":"if (!form.dataEntry)\n form.dropBox({name: \"formTable\", label: \"Table\", 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: \"formTable\", label: \"Table\", 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 t = form.comboBox({name: \"formType\", label: \"Chart type\", alternatives: [\"Area\", \"Stacked Area\", \"100% Stacked Area\", \"Bar\", \"Stacked Bar\", \"100% Stacked Bar\",\n \"Column\", \"Stacked Column\", \"100% Stacked Column\", \"Line\", \"Donut\", \"Pie\", \"Labeled Scatterplot\", \"Labeled Bubbleplot\"], default_value: \"Donut\", required: true}).getValue();\nif (t == \"Labeled Scatterplot\" || t == \"Labeled Bubbleplot\")\n form.setHeading(t);\nelse\n form.setHeading(t + \" Chart\");\nvar show_pie_percentages = false;\nif (t == \"Pie\" || t == \"Donut\")\n show_pie_percentages = form.checkBox({name: \"formPiePercentages\", label: \"Show as percentages\"}).getValue();\nif (t != \"Donut\")\n form.checkBox({name: \"formTranspose\", label: \"Swap rows and columns\"});\nif (t == \"Labeled Scatterplot\" || t == \"Labeled Bubbleplot\")\n{\n form.textBox({name: \"formGroupIndices\", label: \"Group indices\", required: false, prompt: \"For example: 1,1,2,1,3,2\"});\n form.textBox({name: \"formGroupLabels\", label: \"Group labels\", required: false, prompt: \"For example: Group 1, Group 2, Group 3\"});\n}\nform.comboBox({name: \"formPalette\", label: \"Color palette\", alternatives: [\"Default colors\", \"Primary colors\", \"Rainbow\", \"Light pastels\", \"Strong colors\",\n \"Reds, dark to light\", \"Reds, light to dark\", \"Greens, dark to light\", \"Greens, light to dark\", \"Blues, dark to light\", \"Blues, light to dark\", \"Greys, dark to light\", \"Greys, light to dark\",\n \"Heat colors (red, yellow, white)\", \"Terrain colors (green, beige, grey)\"], default_value: \"Default colors\", required: true});\nif (t == \"Pie\")\n form.comboBox({name: \"formPaletteOuter\", label: \"Outer ring color palette\", alternatives: [\"Group colors\", \"Default colors\", \"Primary colors\", \"Rainbow\", \"Light pastels\", \"Strong colors\",\n \"Reds, dark to light\", \"Reds, light to dark\", \"Greens, dark to light\", \"Greens, light to dark\", \"Blues, dark to light\", \"Blues, light to dark\", \"Greys, dark to light\", \n \"Greys, light to dark\", \"Heat colors (red, yellow, white)\", \"Terrain colors (green, beige, grey)\"], default_value: \"Group colors\", required: true});\nform.textBox({name: \"formTitle\", label: \"Title\", required: false});\nif (t != \"Pie\" && t != \"Donut\")\n{\n form.textBox({name: \"formXTitle\", label: \"X-axis title\", required: false});\n form.textBox({name: \"formYTitle\", label: \"Y-axis title\", required: false});\n}\nif (t == \"Labeled Bubbleplot\")\n form.textBox({name: \"formZTitle\", label: \"Bubble title\", required: false});\nif (t != \"100% Stacked Area\" && t != \"100% Stacked Bar\" && t != \"100% Stacked Column\" && !show_pie_percentages)\n{\n form.textBox({name: \"formPrefix\", label: \"Data value prefix\", required: false});\n var suffix = form.textBox({name: \"formSuffix\", label: \"Data value suffix\", required: false});\n if (suffix.getValue() == \"%\")\n form.checkBox({name: \"formMultiplyBy100\", label: \"Multiply data by 100\", default_value: false});\n}\nvar show_decimals_control = t == \"Pie\" || t == \"Donut\" || (t != \"Labeled Scatterplot\" && t != \"Labeled Bubbleplot\" &&\n form.checkBox({name: \"formShowDataLabels\", label: \"Show data labels\", default_value: false}).getValue());\nif (show_decimals_control)\n form.numericUpDown({name: \"formDataLabelDecimals\", label: \"Data label decimal places\", default_value: 2, increment: 1, minimum: 0, maximum: 12});\nif (t != \"Pie\" && t != \"Donut\")\n form.checkBox({name: \"formShowGrid\", label: \"Show grid\", default_value: true});\nform.textBox({label: \"Rows to ignore\", type: \"text\", default_value: \"NET, Total, SUM\", name: \"formIgnoreRows\", required: false});\nform.textBox({label: \"Columns to ignore\", type: \"text\", default_value: \"NET, Total, SUM\", name: \"formIgnoreColumns\", required: false});\nif (t == \"Donut\")\n form.numericUpDown({name: \"formRadius\", label: \"Donut hole radius %\", default_value: 60, increment: 1, minimum: 1, maximum: 100});\nelse if (t == \"Pie\")\n form.numericUpDown({name: \"formRadius\", label: \"Radius of pie groupings % (multi-column tables only)\", default_value: 60, increment: 1, minimum: 1, maximum: 100});\nif (t != \"Labeled Scatterplot\" && t != \"Labeled Bubbleplot\" && t != \"Pie\" && t != \"Donut\")\n form.comboBox({name: \"formDateFormat\", label: \"Date format\", alternatives: [\"Default\", \"US (mm/dd/yyyy)\", \"International (dd/mm/yyyy)\"], default_value: \"Default\", required: true});","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":"Donut 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":"Use an existing table","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":"formTable","Page":null,"Group":null,"Type":"DropBox","Label":"Table","LabelEmphasised":false,"Value":"0c220641-9eb7-4973-bd50-1cb501371fd9","Allowed":null,"Multi":false,"Prompt":"Select an input which is of type Table or Ritem (Integer, Numeric, Matrix, Array, Data.Frame or Table).","ErrorMessage":"Table: Table accepts only one input which is of type Table or Ritem (Integer, Numeric, Matrix, Array, Data.Frame or Table).","Invalid":null,"Required":true,"AllowedTypes":["Table","RItem:integer,numeric,matrix,array,data.frame,table"],"OwnerRItemGuid":"35a7ca17-df59-4d59-99de-b47d59c1c233","MinInputs":1,"MaxInputs":1,"Height":1,"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":"formType","Page":null,"Group":null,"Type":"ComboBox","Label":"Chart type","LabelEmphasised":false,"Value":"Donut","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":["Area","Stacked Area","100% Stacked Area","Bar","Stacked Bar","100% Stacked Bar","Column","Stacked Column","100% Stacked Column","Line","Donut","Pie","Labeled Scatterplot","Labeled Bubbleplot"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formPiePercentages","Page":null,"Group":null,"Type":"CheckBox","Label":"Show as percentages","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":"formPalette","Page":null,"Group":null,"Type":"ComboBox","Label":"Color palette","LabelEmphasised":false,"Value":"Default colors","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","Rainbow","Light pastels","Strong colors","Reds, dark to light","Reds, light to dark","Greens, dark to light","Greens, light to dark","Blues, dark to light","Blues, light to dark","Greys, dark to light","Greys, light to dark","Heat colors (red, yellow, white)","Terrain colors (green, beige, grey)"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formTitle","Page":null,"Group":null,"Type":"TextBox","Label":"Title","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":"formPrefix","Page":null,"Group":null,"Type":"TextBox","Label":"Data value 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":"formSuffix","Page":null,"Group":null,"Type":"TextBox","Label":"Data value 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":"formMultiplyBy100","Page":null,"Group":null,"Type":"CheckBox","Label":"Multiply data by 100","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":"formDataLabelDecimals","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Data label decimal places","LabelEmphasised":false,"Value":1.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Data label decimal places: ","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":12.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formIgnoreRows","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":"formIgnoreColumns","Page":null,"Group":null,"Type":"TextBox","Label":"Columns 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":"formRadius","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Donut hole radius %","LabelEmphasised":false,"Value":60.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Donut hole radius %: ","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":1.0,"Max":100.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":"Automatic","warnSlow":true,"Options":{"debugconsole":false,"codeposition":"OutputOnly","splitH":0.45,"splitV":0.25,"update warnings":true,"updating":"Automatic","warn slow":true}}