{"size":{"Width":780,"Height":395},"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":"TABLE","widgetState":null,"outputs":{"text":" Lead Score Lead Origin1 Do Not Email1 Do Not Call1\n1 105 API No No\n2 120 API No No\n3 150 Landing Page Submission No No\n4 60 Landing Page Submission No No\n5 80 Landing Page Submission No No\n6 0 API No No\n7 80 Landing Page Submission No No\n8 0 API No No\n9 80 Landing Page Submission No No\n10 145 API No No\n11 150 Landing Page Submission No No\n12 140 Landing Page Submission No No\n13 170 API No No\n14 300 Landing Page Submission No No\n15 60 Landing Page Submission Yes No\n16 140 API No No\n17 0 API No No\n18 135 API No No\n19 165 Landing Page Submission No No\n20 115 API No No\n21 60 Landing Page Submission No No\n22 90 API No No\n23 70 Landing Page Submission No No\n24 160 Landing Page Submission No No\n25 205 API No No\n26 75 Landing Page Submission No No\n27 140 Landing Page Submission No No\n28 125 Landing Page Submission No No\n29 215 Landing Page Submission No No\n30 80 API No No\n31 210 Landing Page Submission No No\n32 80 API No No\n33 90 API No No\n34 115 API No No\n35 100 Landing Page Submission No No\n36 90 API No No\n37 165 Landing Page Submission No No\n38 115 Landing Page Submission No No\n39 95 API No No\n40 85 Landing Page Submission No No\n41 90 API No No\n42 87 Landing Page Submission Yes No\n43 155 API No No\n44 190 Landing Page Submission No No\n45 200 Landing Page Submission No No\n46 175 Landing Page Submission No No\n47 140 Landing Page Submission No No\n48 0 API No No\n49 110 API No No\n50 0 API No No\n51 10 API No No\n52 95 Landing Page Submission No No\n53 150 Landing Page Submission No No\n54 100 API No No\n55 150 API No No\n56 60 API No No\n57 200 Landing Page Submission No No\n58 130 API No No\n59 230 Landing Page Submission No No\n60 170 Landing Page Submission No No\n61 85 API No No\n62 50 API No No\n Profile Score1 a free copy of Mastering The Interview1\n1 BLANK No\n2 BLANK No\n3 BLANK Yes\n4 BLANK No\n5 BLANK No\n6 BLANK No\n7 BLANK No\n8 BLANK No\n9 BLANK Yes\n10 BLANK No\n11 BLANK Yes\n12 BLANK Yes\n13 BLANK No\n14 BLANK Yes\n15 BLANK No\n16 BLANK No\n17 BLANK No\n18 BLANK No\n19 BLANK No\n20 BLANK No\n21 BLANK No\n22 BLANK No\n23 BLANK No\n24 BLANK No\n25 BLANK Yes\n26 BLANK No\n27 BLANK Yes\n28 BLANK No\n29 BLANK No\n30 BLANK No\n31 BLANK Yes\n32 BLANK No\n33 BLANK No\n34 BLANK No\n35 BLANK Yes\n36 BLANK No\n37 BLANK No\n38 BLANK No\n39 BLANK No\n40 BLANK No\n41 BLANK No\n42 BLANK Yes\n43 BLANK No\n44 BLANK No\n45 BLANK Yes\n46 BLANK No\n47 BLANK Yes\n48 BLANK No\n49 BLANK No\n50 BLANK No\n51 BLANK No\n52 BLANK No\n53 BLANK Yes\n54 BLANK No\n55 BLANK No\n56 BLANK No\n57 BLANK No\n58 BLANK No\n59 BLANK Yes\n60 BLANK Yes\n61 BLANK No\n62 BLANK No\n you to consider SomeSchool1 Last Visit Date1 Engagement Score\n1 Select 25/07/2016-31/07/2016 0\n2 Select 08/08/2016-14/08/2016 0\n3 Select 01/08/2016-07/08/2016 80\n4 Select 01/08/2016-07/08/2016 0\n5 Select 01/08/2016-07/08/2016 10\n6 Not selected 25/07/2016-31/07/2016 0\n7 Select 01/08/2016-07/08/2016 10\n8 Not selected 25/07/2016-31/07/2016 0\n9 Not selected 01/08/2016-07/08/2016 0\n10 Not selected 08/08/2016-14/08/2016 0\n11 Select 01/08/2016-07/08/2016 80\n12 Select 01/08/2016-07/08/2016 0\n13 Select 01/08/2016-07/08/2016 120\n14 Select 08/08/2016-14/08/2016 0\n15 Select 01/08/2016-07/08/2016 0\n16 Select 08/08/2016-14/08/2016 90\n17 Not selected 25/07/2016-31/07/2016 0\n18 Select 25/07/2016-31/07/2016 0\n19 Select 01/08/2016-07/08/2016 60\n20 Select 25/07/2016-31/07/2016 0\n21 Select 01/08/2016-07/08/2016 0\n22 Select 01/08/2016-07/08/2016 0\n23 Select 25/07/2016-31/07/2016 0\n24 Select 01/08/2016-07/08/2016 0\n25 Select 08/08/2016-14/08/2016 110\n26 Select 25/07/2016-31/07/2016 10\n27 Select 08/08/2016-14/08/2016 70\n28 Select 01/08/2016-07/08/2016 60\n29 Select 08/08/2016-14/08/2016 0\n30 Select 01/08/2016-07/08/2016 30\n31 Select 08/08/2016-14/08/2016 120\n32 Select 01/08/2016-07/08/2016 0\n33 Select 01/08/2016-07/08/2016 0\n34 Not selected 01/08/2016-07/08/2016 0\n35 Select 25/07/2016-31/07/2016 30\n36 Select 01/08/2016-07/08/2016 40\n37 Select 01/08/2016-07/08/2016 0\n38 Select 01/08/2016-07/08/2016 50\n39 Select 01/08/2016-07/08/2016 0\n40 Select 01/08/2016-07/08/2016 20\n41 Select 08/08/2016-14/08/2016 0\n42 Select 01/08/2016-07/08/2016 0\n43 Select 01/08/2016-07/08/2016 0\n44 Not selected 08/08/2016-14/08/2016 0\n45 Select 01/08/2016-07/08/2016 0\n46 Select 08/08/2016-14/08/2016 0\n47 Select 08/08/2016-14/08/2016 0\n48 Not selected 25/07/2016-31/07/2016 0\n49 Select 25/07/2016-31/07/2016 0\n50 Not selected 25/07/2016-31/07/2016 0\n51 Select 01/08/2016-07/08/2016 10\n52 Select 01/08/2016-07/08/2016 0\n53 Select 01/08/2016-07/08/2016 0\n54 Not selected 01/08/2016-07/08/2016 0\n55 Not selected 08/08/2016-14/08/2016 0\n56 Select 01/08/2016-07/08/2016 0\n57 Select 25/07/2016-31/07/2016 110\n58 Select 01/08/2016-07/08/2016 80\n59 Select 01/08/2016-07/08/2016 0\n60 Select 01/08/2016-07/08/2016 0\n61 Select 25/07/2016-31/07/2016 0\n62 Select 08/08/2016-14/08/2016 0\n TotalVisits Page Views Per Visit Average Time Per Visit\n1 0 0.00 0.00\n2 5 2.50 83.75\n3 2 2.00 4.00\n4 1 1.00 0.00\n5 2 1.00 0.00\n6 0 0.00 0.00\n7 2 2.00 6.00\n8 0 0.00 0.00\n9 2 2.00 3.00\n10 4 4.00 274.50\n11 8 8.00 193.86\n12 8 2.67 26.80\n13 11 11.00 130.00\n14 5 5.00 115.75\n15 1 1.00 0.00\n16 6 6.00 266.40\n17 0 0.00 0.00\n18 6 6.00 64.80\n19 6 3.00 318.00\n20 3 3.00 370.67\n21 1 1.00 0.00\n22 4 1.33 67.00\n23 1 1.00 0.00\n24 4 4.00 52.67\n25 6 1.50 396.00\n26 3 3.00 144.50\n27 4 2.00 100.50\n28 6 6.00 173.20\n29 5 5.00 266.60\n30 3 3.00 179.50\n31 7 3.50 147.33\n32 3 1.50 261.00\n33 4 2.00 52.00\n34 3 1.50 251.00\n35 4 2.00 35.50\n36 3 3.00 326.67\n37 4 4.00 301.50\n38 5 5.00 168.25\n39 2 2.00 310.50\n40 4 4.00 54.67\n41 3 3.00 191.00\n42 7 7.00 66.83\n43 5 5.00 153.60\n44 5 5.00 125.20\n45 6 3.00 253.50\n46 4 2.00 223.33\n47 2 2.00 2.00\n48 0 0.00 0.00\n49 6 6.00 78.40\n50 0 0.00 0.00\n51 0 0.00 0.00\n52 5 5.00 116.25\n53 6 2.00 64.00\n54 6 1.50 456.00\n55 7 2.33 296.25\n56 2 2.00 187.50\n57 13 13.00 103.75\n58 8 8.00 114.71\n59 17 8.50 219.13\n60 11 5.50 52.33\n61 4 4.00 164.33\n62 0 0.00 0.00\n Created On1 Modified On1 Last Activity1\n1 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n2 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n3 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n4 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n5 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Converted to Lead\n6 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n7 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n8 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n9 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n10 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n11 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n12 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n13 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n14 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n15 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Bounced\n16 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n17 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n18 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Link Clicked\n19 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n20 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n21 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n22 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n23 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Converted to Lead\n24 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Link Clicked\n25 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n26 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Form Submitted on Website\n27 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n28 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n29 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n30 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n31 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n32 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n33 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n34 25/07/2016-31/07/2016 08/08/2016-14/08/2016 Email Opened\n35 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n36 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n37 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n38 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n39 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Link Clicked\n40 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n41 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n42 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unsubscribed\n43 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n44 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n45 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n46 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n47 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n48 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n49 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n50 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n51 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n52 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n53 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n54 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n55 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n56 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n57 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Form Submitted on Website\n58 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n59 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n60 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n61 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Form Submitted on Website\n62 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n Last Activity Date1\n1 25/07/2016-31/07/2016\n2 08/08/2016-14/08/2016\n3 01/08/2016-07/08/2016\n4 01/08/2016-07/08/2016\n5 01/08/2016-07/08/2016\n6 25/07/2016-31/07/2016\n7 01/08/2016-07/08/2016\n8 25/07/2016-31/07/2016\n9 01/08/2016-07/08/2016\n10 08/08/2016-14/08/2016\n11 01/08/2016-07/08/2016\n12 01/08/2016-07/08/2016\n13 01/08/2016-07/08/2016\n14 08/08/2016-14/08/2016\n15 01/08/2016-07/08/2016\n16 08/08/2016-14/08/2016\n17 25/07/2016-31/07/2016\n18 25/07/2016-31/07/2016\n19 01/08/2016-07/08/2016\n20 25/07/2016-31/07/2016\n21 01/08/2016-07/08/2016\n22 01/08/2016-07/08/2016\n23 25/07/2016-31/07/2016\n24 01/08/2016-07/08/2016\n25 08/08/2016-14/08/2016\n26 25/07/2016-31/07/2016\n27 08/08/2016-14/08/2016\n28 01/08/2016-07/08/2016\n29 08/08/2016-14/08/2016\n30 01/08/2016-07/08/2016\n31 08/08/2016-14/08/2016\n32 01/08/2016-07/08/2016\n33 01/08/2016-07/08/2016\n34 01/08/2016-07/08/2016\n35 25/07/2016-31/07/2016\n36 01/08/2016-07/08/2016\n37 01/08/2016-07/08/2016\n38 01/08/2016-07/08/2016\n39 01/08/2016-07/08/2016\n40 01/08/2016-07/08/2016\n41 08/08/2016-14/08/2016\n42 01/08/2016-07/08/2016\n43 01/08/2016-07/08/2016\n44 08/08/2016-14/08/2016\n45 01/08/2016-07/08/2016\n46 08/08/2016-14/08/2016\n47 08/08/2016-14/08/2016\n48 25/07/2016-31/07/2016\n49 25/07/2016-31/07/2016\n50 25/07/2016-31/07/2016\n51 01/08/2016-07/08/2016\n52 01/08/2016-07/08/2016\n53 01/08/2016-07/08/2016\n54 01/08/2016-07/08/2016\n55 08/08/2016-14/08/2016\n56 01/08/2016-07/08/2016\n57 25/07/2016-31/07/2016\n58 01/08/2016-07/08/2016\n59 01/08/2016-07/08/2016\n60 01/08/2016-07/08/2016\n61 25/07/2016-31/07/2016\n62 08/08/2016-14/08/2016\n [ reached getOption(\"max.print\") -- omitted 9178 rows ]\n","console":"<pre class='debug-source'>&gt;library(flipFormat)\n</pre>\n<pre class='debug-source'>&gt;library(flipTransformations)\n</pre>\n<pre class='debug-source'>&gt;if (length(unique(sapply(formVariables, length))) != 1)\n stop(&quot;All variables must be the same length and are not.&quot;)\n</pre>\n<pre class='debug-source'>&gt;rawdata = ProcessQVariables(data.frame(if (length(formVariables) == 1) formVariables[[1]] else formVariables, stringsAsFactors = FALSE))\n</pre>\n<pre class='debug-source'>&gt;rawdata = rawdata[QFilter,, drop = FALSE]\n</pre>\n<pre class='debug-source'>&gt;names(rawdata) &lt;- if(!formNames) lapply(formVariables, Labels) else lapply(formVariables, Names)\n</pre>\n<pre class='debug-source'>&gt;if (nrow(rawdata) * ncol(rawdata) &gt; 1000000)\n stop(&quot;Your table contains more than 1,000,000 cells. To get around this limitation, edit the R Code, or, create tables using RAW DATA.&quot;)\n</pre>\n<pre class='debug-source'>&gt;raw.data.3 &lt;- rawdata\n</pre>\n<pre class='debug-out'> Lead Score Lead Origin1 Do Not Email1 Do Not Call1\n1 105 API No No\n2 120 API No No\n3 150 Landing Page Submission No No\n4 60 Landing Page Submission No No\n5 80 Landing Page Submission No No\n6 0 API No No\n7 80 Landing Page Submission No No\n8 0 API No No\n9 80 Landing Page Submission No No\n10 145 API No No\n11 150 Landing Page Submission No No\n12 140 Landing Page Submission No No\n13 170 API No No\n14 300 Landing Page Submission No No\n15 60 Landing Page Submission Yes No\n16 140 API No No\n17 0 API No No\n18 135 API No No\n19 165 Landing Page Submission No No\n20 115 API No No\n21 60 Landing Page Submission No No\n22 90 API No No\n23 70 Landing Page Submission No No\n24 160 Landing Page Submission No No\n25 205 API No No\n26 75 Landing Page Submission No No\n27 140 Landing Page Submission No No\n28 125 Landing Page Submission No No\n29 215 Landing Page Submission No No\n30 80 API No No\n31 210 Landing Page Submission No No\n32 80 API No No\n33 90 API No No\n34 115 API No No\n35 100 Landing Page Submission No No\n36 90 API No No\n37 165 Landing Page Submission No No\n38 115 Landing Page Submission No No\n39 95 API No No\n40 85 Landing Page Submission No No\n41 90 API No No\n42 87 Landing Page Submission Yes No\n43 155 API No No\n44 190 Landing Page Submission No No\n45 200 Landing Page Submission No No\n46 175 Landing Page Submission No No\n47 140 Landing Page Submission No No\n48 0 API No No\n49 110 API No No\n50 0 API No No\n51 10 API No No\n52 95 Landing Page Submission No No\n53 150 Landing Page Submission No No\n54 100 API No No\n55 150 API No No\n56 60 API No No\n57 200 Landing Page Submission No No\n58 130 API No No\n59 230 Landing Page Submission No No\n60 170 Landing Page Submission No No\n61 85 API No No\n62 50 API No No\n Profile Score1 a free copy of Mastering The Interview1\n1 BLANK No\n2 BLANK No\n3 BLANK Yes\n4 BLANK No\n5 BLANK No\n6 BLANK No\n7 BLANK No\n8 BLANK No\n9 BLANK Yes\n10 BLANK No\n11 BLANK Yes\n12 BLANK Yes\n13 BLANK No\n14 BLANK Yes\n15 BLANK No\n16 BLANK No\n17 BLANK No\n18 BLANK No\n19 BLANK No\n20 BLANK No\n21 BLANK No\n22 BLANK No\n23 BLANK No\n24 BLANK No\n25 BLANK Yes\n26 BLANK No\n27 BLANK Yes\n28 BLANK No\n29 BLANK No\n30 BLANK No\n31 BLANK Yes\n32 BLANK No\n33 BLANK No\n34 BLANK No\n35 BLANK Yes\n36 BLANK No\n37 BLANK No\n38 BLANK No\n39 BLANK No\n40 BLANK No\n41 BLANK No\n42 BLANK Yes\n43 BLANK No\n44 BLANK No\n45 BLANK Yes\n46 BLANK No\n47 BLANK Yes\n48 BLANK No\n49 BLANK No\n50 BLANK No\n51 BLANK No\n52 BLANK No\n53 BLANK Yes\n54 BLANK No\n55 BLANK No\n56 BLANK No\n57 BLANK No\n58 BLANK No\n59 BLANK Yes\n60 BLANK Yes\n61 BLANK No\n62 BLANK No\n you to consider SomeSchool1 Last Visit Date1 Engagement Score\n1 Select 25/07/2016-31/07/2016 0\n2 Select 08/08/2016-14/08/2016 0\n3 Select 01/08/2016-07/08/2016 80\n4 Select 01/08/2016-07/08/2016 0\n5 Select 01/08/2016-07/08/2016 10\n6 Not selected 25/07/2016-31/07/2016 0\n7 Select 01/08/2016-07/08/2016 10\n8 Not selected 25/07/2016-31/07/2016 0\n9 Not selected 01/08/2016-07/08/2016 0\n10 Not selected 08/08/2016-14/08/2016 0\n11 Select 01/08/2016-07/08/2016 80\n12 Select 01/08/2016-07/08/2016 0\n13 Select 01/08/2016-07/08/2016 120\n14 Select 08/08/2016-14/08/2016 0\n15 Select 01/08/2016-07/08/2016 0\n16 Select 08/08/2016-14/08/2016 90\n17 Not selected 25/07/2016-31/07/2016 0\n18 Select 25/07/2016-31/07/2016 0\n19 Select 01/08/2016-07/08/2016 60\n20 Select 25/07/2016-31/07/2016 0\n21 Select 01/08/2016-07/08/2016 0\n22 Select 01/08/2016-07/08/2016 0\n23 Select 25/07/2016-31/07/2016 0\n24 Select 01/08/2016-07/08/2016 0\n25 Select 08/08/2016-14/08/2016 110\n26 Select 25/07/2016-31/07/2016 10\n27 Select 08/08/2016-14/08/2016 70\n28 Select 01/08/2016-07/08/2016 60\n29 Select 08/08/2016-14/08/2016 0\n30 Select 01/08/2016-07/08/2016 30\n31 Select 08/08/2016-14/08/2016 120\n32 Select 01/08/2016-07/08/2016 0\n33 Select 01/08/2016-07/08/2016 0\n34 Not selected 01/08/2016-07/08/2016 0\n35 Select 25/07/2016-31/07/2016 30\n36 Select 01/08/2016-07/08/2016 40\n37 Select 01/08/2016-07/08/2016 0\n38 Select 01/08/2016-07/08/2016 50\n39 Select 01/08/2016-07/08/2016 0\n40 Select 01/08/2016-07/08/2016 20\n41 Select 08/08/2016-14/08/2016 0\n42 Select 01/08/2016-07/08/2016 0\n43 Select 01/08/2016-07/08/2016 0\n44 Not selected 08/08/2016-14/08/2016 0\n45 Select 01/08/2016-07/08/2016 0\n46 Select 08/08/2016-14/08/2016 0\n47 Select 08/08/2016-14/08/2016 0\n48 Not selected 25/07/2016-31/07/2016 0\n49 Select 25/07/2016-31/07/2016 0\n50 Not selected 25/07/2016-31/07/2016 0\n51 Select 01/08/2016-07/08/2016 10\n52 Select 01/08/2016-07/08/2016 0\n53 Select 01/08/2016-07/08/2016 0\n54 Not selected 01/08/2016-07/08/2016 0\n55 Not selected 08/08/2016-14/08/2016 0\n56 Select 01/08/2016-07/08/2016 0\n57 Select 25/07/2016-31/07/2016 110\n58 Select 01/08/2016-07/08/2016 80\n59 Select 01/08/2016-07/08/2016 0\n60 Select 01/08/2016-07/08/2016 0\n61 Select 25/07/2016-31/07/2016 0\n62 Select 08/08/2016-14/08/2016 0\n TotalVisits Page Views Per Visit Average Time Per Visit\n1 0 0.00 0.00\n2 5 2.50 83.75\n3 2 2.00 4.00\n4 1 1.00 0.00\n5 2 1.00 0.00\n6 0 0.00 0.00\n7 2 2.00 6.00\n8 0 0.00 0.00\n9 2 2.00 3.00\n10 4 4.00 274.50\n11 8 8.00 193.86\n12 8 2.67 26.80\n13 11 11.00 130.00\n14 5 5.00 115.75\n15 1 1.00 0.00\n16 6 6.00 266.40\n17 0 0.00 0.00\n18 6 6.00 64.80\n19 6 3.00 318.00\n20 3 3.00 370.67\n21 1 1.00 0.00\n22 4 1.33 67.00\n23 1 1.00 0.00\n24 4 4.00 52.67\n25 6 1.50 396.00\n26 3 3.00 144.50\n27 4 2.00 100.50\n28 6 6.00 173.20\n29 5 5.00 266.60\n30 3 3.00 179.50\n31 7 3.50 147.33\n32 3 1.50 261.00\n33 4 2.00 52.00\n34 3 1.50 251.00\n35 4 2.00 35.50\n36 3 3.00 326.67\n37 4 4.00 301.50\n38 5 5.00 168.25\n39 2 2.00 310.50\n40 4 4.00 54.67\n41 3 3.00 191.00\n42 7 7.00 66.83\n43 5 5.00 153.60\n44 5 5.00 125.20\n45 6 3.00 253.50\n46 4 2.00 223.33\n47 2 2.00 2.00\n48 0 0.00 0.00\n49 6 6.00 78.40\n50 0 0.00 0.00\n51 0 0.00 0.00\n52 5 5.00 116.25\n53 6 2.00 64.00\n54 6 1.50 456.00\n55 7 2.33 296.25\n56 2 2.00 187.50\n57 13 13.00 103.75\n58 8 8.00 114.71\n59 17 8.50 219.13\n60 11 5.50 52.33\n61 4 4.00 164.33\n62 0 0.00 0.00\n Created On1 Modified On1 Last Activity1\n1 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n2 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n3 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n4 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n5 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Converted to Lead\n6 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n7 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n8 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n9 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n10 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n11 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n12 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n13 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n14 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n15 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Bounced\n16 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n17 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n18 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Link Clicked\n19 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n20 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n21 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n22 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n23 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Converted to Lead\n24 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Link Clicked\n25 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n26 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Form Submitted on Website\n27 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n28 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n29 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n30 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n31 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n32 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n33 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n34 25/07/2016-31/07/2016 08/08/2016-14/08/2016 Email Opened\n35 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n36 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n37 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n38 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n39 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Link Clicked\n40 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n41 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n42 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unsubscribed\n43 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n44 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n45 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n46 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n47 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n48 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n49 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n50 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n51 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n52 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n53 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Unreachable\n54 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Olark Chat Conversation\n55 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n56 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n57 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Form Submitted on Website\n58 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Page Visited on Website\n59 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n60 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n61 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Form Submitted on Website\n62 25/07/2016-31/07/2016 01/08/2016-07/08/2016 Email Opened\n Last Activity Date1\n1 25/07/2016-31/07/2016\n2 08/08/2016-14/08/2016\n3 01/08/2016-07/08/2016\n4 01/08/2016-07/08/2016\n5 01/08/2016-07/08/2016\n6 25/07/2016-31/07/2016\n7 01/08/2016-07/08/2016\n8 25/07/2016-31/07/2016\n9 01/08/2016-07/08/2016\n10 08/08/2016-14/08/2016\n11 01/08/2016-07/08/2016\n12 01/08/2016-07/08/2016\n13 01/08/2016-07/08/2016\n14 08/08/2016-14/08/2016\n15 01/08/2016-07/08/2016\n16 08/08/2016-14/08/2016\n17 25/07/2016-31/07/2016\n18 25/07/2016-31/07/2016\n19 01/08/2016-07/08/2016\n20 25/07/2016-31/07/2016\n21 01/08/2016-07/08/2016\n22 01/08/2016-07/08/2016\n23 25/07/2016-31/07/2016\n24 01/08/2016-07/08/2016\n25 08/08/2016-14/08/2016\n26 25/07/2016-31/07/2016\n27 08/08/2016-14/08/2016\n28 01/08/2016-07/08/2016\n29 08/08/2016-14/08/2016\n30 01/08/2016-07/08/2016\n31 08/08/2016-14/08/2016\n32 01/08/2016-07/08/2016\n33 01/08/2016-07/08/2016\n34 01/08/2016-07/08/2016\n35 25/07/2016-31/07/2016\n36 01/08/2016-07/08/2016\n37 01/08/2016-07/08/2016\n38 01/08/2016-07/08/2016\n39 01/08/2016-07/08/2016\n40 01/08/2016-07/08/2016\n41 08/08/2016-14/08/2016\n42 01/08/2016-07/08/2016\n43 01/08/2016-07/08/2016\n44 08/08/2016-14/08/2016\n45 01/08/2016-07/08/2016\n46 08/08/2016-14/08/2016\n47 08/08/2016-14/08/2016\n48 25/07/2016-31/07/2016\n49 25/07/2016-31/07/2016\n50 25/07/2016-31/07/2016\n51 01/08/2016-07/08/2016\n52 01/08/2016-07/08/2016\n53 01/08/2016-07/08/2016\n54 01/08/2016-07/08/2016\n55 08/08/2016-14/08/2016\n56 01/08/2016-07/08/2016\n57 25/07/2016-31/07/2016\n58 01/08/2016-07/08/2016\n59 01/08/2016-07/08/2016\n60 01/08/2016-07/08/2016\n61 25/07/2016-31/07/2016\n62 08/08/2016-14/08/2016\n [ reached getOption(&quot;max.print&quot;) -- omitted 9178 rows ]\n</pre>\r\n<div class=\"debug-summarystatistics\"><table>\r\n<tr><th>Started:</th><td class=utc-time>2018-12-06T01:04:19.091Z</td></tr>\r\n<tr><th>Finished:</th><td class=utc-time>2018-12-06T01:04:20.091Z</td></tr>\r\n<tr><th>Total time:</th><td>1.49s</td></tr>\r\n<tr><th>Time executing code:</th><td title=\"0.08s\">0.69s</td></tr>\r\n<tr><th>Other overhead on R server:</th><td>0.72s</td></tr>\r\n<tr><th>Time spent transferring data:</th><td>0.08s</td></tr>\r\n<tr><th>Data sent to R server:</th><td>761.5KB</td></tr>\r\n<tr><th>Data received from R server:</th><td>556.8KB</td></tr>\r\n</table></div>","message":"","warning":"","table":"{\"Dimensions\":[{\"IsStatistic\":true,\"Elements\":[{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement0\",\"Name\":\"Lead Score\",\"WrappedName\":[\"Lead Sco-\",\"re\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"API\",\"Landing Page Submission\",\"Lead Add Form\",\"Lead Import\",\"Quick Add Form\"],\"SeriesType\":0,\"Id\":\"StatisticsElement1\",\"Name\":\"Lead Origin1\",\"WrappedName\":[\"Lead Orig-\",\"in1\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"No\",\"Yes\"],\"SeriesType\":0,\"Id\":\"StatisticsElement2\",\"Name\":\"Do Not Email1\",\"WrappedName\":[\"Do Not\",\"Email1\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"No\",\"Yes\"],\"SeriesType\":0,\"Id\":\"StatisticsElement3\",\"Name\":\"Do Not Call1\",\"WrappedName\":[\"Do Not\",\"Call1\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"BLANK\",\"High\"],\"SeriesType\":0,\"Id\":\"StatisticsElement4\",\"Name\":\"Profile Score1\",\"WrappedName\":[\"Profile\",\"Score1\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"No\",\"Yes\"],\"SeriesType\":0,\"Id\":\"StatisticsElement5\",\"Name\":\"a free copy of Mastering The Interview1\",\"WrappedName\":[\"a free\",\"copy of\",\"Mastering\",\"The Inter-\",\"view1\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"Not selected\",\"Select\"],\"SeriesType\":0,\"Id\":\"StatisticsElement6\",\"Name\":\"you to consider SomeSchool1\",\"WrappedName\":[\"you to\",\"consider\",\"SomeSc-\",\"hool1\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"25/04/2016-01/05/2016\",\"02/05/2016-08/05/2016\",\"09/05/2016-15/05/2016\",\"16/05/2016-22/05/2016\",\"23/05/2016-29/05/2016\",\"30/05/2016-05/06/2016\",\"06/06/2016-12/06/2016\",\"13/06/2016-19/06/2016\",\"20/06/2016-26/06/2016\",\"27/06/2016-03/07/2016\",\"04/07/2016-10/07/2016\",\"11/07/2016-17/07/2016\",\"18/07/2016-24/07/2016\",\"25/07/2016-31/07/2016\",\"01/08/2016-07/08/2016\",\"08/08/2016-14/08/2016\"],\"SeriesType\":0,\"Id\":\"StatisticsElement7\",\"Name\":\"Last Visit Date1\",\"WrappedName\":[\"Last Visit\",\"Date1\"],\"IsText\":false},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement8\",\"Name\":\"Engagement Score\",\"WrappedName\":[\"Engage-\",\"ment\",\"Score\"],\"IsText\":false},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement9\",\"Name\":\"TotalVisits\",\"WrappedName\":[\"TotalV-\",\"isits\"],\"IsText\":false},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement10\",\"Name\":\"Page Views Per Visit\",\"WrappedName\":[\"Page Vie-\",\"ws Per\",\"Visit\"],\"IsText\":false},{\"IsNumber\":true,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":false,\"Categories\":[],\"SeriesType\":0,\"Id\":\"StatisticsElement11\",\"Name\":\"Average Time Per Visit\",\"WrappedName\":[\"Average\",\"Time Per\",\"Visit\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"25/04/2016-01/05/2016\",\"02/05/2016-08/05/2016\",\"09/05/2016-15/05/2016\",\"16/05/2016-22/05/2016\",\"23/05/2016-29/05/2016\",\"30/05/2016-05/06/2016\",\"06/06/2016-12/06/2016\",\"13/06/2016-19/06/2016\",\"20/06/2016-26/06/2016\",\"27/06/2016-03/07/2016\",\"04/07/2016-10/07/2016\",\"11/07/2016-17/07/2016\",\"18/07/2016-24/07/2016\",\"25/07/2016-31/07/2016\"],\"SeriesType\":0,\"Id\":\"StatisticsElement12\",\"Name\":\"Created On1\",\"WrappedName\":[\"Created\",\"On1\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"09/05/2016-15/05/2016\",\"16/05/2016-22/05/2016\",\"23/05/2016-29/05/2016\",\"30/05/2016-05/06/2016\",\"06/06/2016-12/06/2016\",\"13/06/2016-19/06/2016\",\"20/06/2016-26/06/2016\",\"27/06/2016-03/07/2016\",\"04/07/2016-10/07/2016\",\"11/07/2016-17/07/2016\",\"18/07/2016-24/07/2016\",\"25/07/2016-31/07/2016\",\"01/08/2016-07/08/2016\",\"08/08/2016-14/08/2016\"],\"SeriesType\":0,\"Id\":\"StatisticsElement13\",\"Name\":\"Modified On1\",\"WrappedName\":[\"Modified\",\"On1\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"Approached upfront\",\"Converted to Lead\",\"Email Bounced\",\"Email Link Clicked\",\"Email Marked Spam\",\"Email Opened\",\"Email Received\",\"Form Submitted on Website\",\"Had a Phone Conversation\",\"Olark Chat Conversation\",\"Page Visited on Website\",\"Resubscribed to emails\",\"SMS Sent\",\"Unreachable\",\"Unsubscribed\",\"View in browser link Clicked\",\"Visited Booth in Tradeshow\"],\"SeriesType\":0,\"Id\":\"StatisticsElement14\",\"Name\":\"Last Activity1\",\"WrappedName\":[\"Last Acti-\",\"vity1\"],\"IsText\":false},{\"IsNumber\":false,\"IsBoolean\":false,\"IsDateTime\":false,\"IsPercent\":false,\"HasDecimalPlaces\":true,\"DecimalPlaces\":1,\"MoneySymbol\":null,\"IsCategorical\":true,\"Categories\":[\"25/04/2016-01/05/2016\",\"02/05/2016-08/05/2016\",\"09/05/2016-15/05/2016\",\"16/05/2016-22/05/2016\",\"23/05/2016-29/05/2016\",\"30/05/2016-05/06/2016\",\"06/06/2016-12/06/2016\",\"13/06/2016-19/06/2016\",\"20/06/2016-26/06/2016\",\"27/06/2016-03/07/2016\",\"04/07/2016-10/07/2016\",\"11/07/2016-17/07/2016\",\"18/07/2016-24/07/2016\",\"25/07/2016-31/07/2016\",\"01/08/2016-07/08/2016\",\"08/08/2016-14/08/2016\"],\"SeriesType\":0,\"Id\":\"StatisticsElement15\",\"Name\":\"Last Activity Date1\",\"WrappedName\":[\"Last Acti-\",\"vity Date1\"],\"IsText\":false}],\"Id\":\"StatisticsDimensionID\",\"Name\":null,\"WrappedName\":null,\"Tiers\":[],\"Count\":16},{\"IsStatistic\":false,\"Elements\":[{\"Id\":\"RowDimensionElement0\",\"Name\":\"1\",\"WrappedName\":[\"1\"]},{\"Id\":\"RowDimensionElement1\",\"Name\":\"2\",\"WrappedName\":[\"2\"]},{\"Id\":\"RowDimensionElement2\",\"Name\":\"3\",\"WrappedName\":[\"3\"]},{\"Id\":\"RowDimensionElement3\",\"Name\":\"4\",\"WrappedName\":[\"4\"]},{\"Id\":\"RowDimensionElement4\",\"Name\":\"5\",\"WrappedName\":[\"5\"]}],\"Id\":\"RowCategoricalDimension\",\"Name\":null,\"WrappedName\":null,\"Tiers\":[],\"Count\":5}],\"DataPoints\":[[{\"Value\":105.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":120.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":150.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":60.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":80.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":0,\"WrappedText\":[\"API\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"API\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1,\"WrappedText\":[\"Landing Page\",\"Submission\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1,\"WrappedText\":[\"Landing Page\",\"Submission\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1,\"WrappedText\":[\"Landing Page\",\"Submission\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":0,\"WrappedText\":[\"BLANK\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"BLANK\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"BLANK\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"BLANK\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"BLANK\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1,\"WrappedText\":[\"Yes\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0,\"WrappedText\":[\"No\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":1,\"WrappedText\":[\"Select\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1,\"WrappedText\":[\"Select\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1,\"WrappedText\":[\"Select\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1,\"WrappedText\":[\"Select\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1,\"WrappedText\":[\"Select\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":13,\"WrappedText\":[\"25/07/2016-31/\",\"07/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":15,\"WrappedText\":[\"08/08/2016-14/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":14,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":14,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":14,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":0.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":80.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":10.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":0.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":5.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":2.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":2.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":0.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":2.5,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":2.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":0.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":83.75,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":4.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":0.0,\"WrappedText\":null,\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":13,\"WrappedText\":[\"25/07/2016-31/\",\"07/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":13,\"WrappedText\":[\"25/07/2016-31/\",\"07/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":13,\"WrappedText\":[\"25/07/2016-31/\",\"07/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":13,\"WrappedText\":[\"25/07/2016-31/\",\"07/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":13,\"WrappedText\":[\"25/07/2016-31/\",\"07/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":12,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":12,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":12,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":12,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":12,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":10,\"WrappedText\":[\"Page Visited on\",\"Website\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":5,\"WrappedText\":[\"Email Opened\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":5,\"WrappedText\":[\"Email Opened\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":13,\"WrappedText\":[\"Unreachable\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":1,\"WrappedText\":[\"Converted to\",\"Lead\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}],[{\"Value\":13,\"WrappedText\":[\"25/07/2016-31/\",\"07/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":15,\"WrappedText\":[\"08/08/2016-14/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":14,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":14,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null},{\"Value\":14,\"WrappedText\":[\"01/08/2016-07/\",\"08/2016\"],\"IsBlank\":null,\"Significance\":null,\"ExtraText\":null}]],\"Settings\":{\"CellDimensionId\":null,\"RowDimensionsIds\":[\"RowCategoricalDimension\"],\"ColumnDimensionsIds\":[\"StatisticsDimensionID\"],\"ColumnHeadersHidden\":false,\"Title\":null,\"Footnote\":\"Showing 1 to 5 of 9240 rows.\",\"IsRowHeadersSortable\":false,\"IsColumnHeadersSortable\":true,\"HeaderSorts\":[],\"IsRowHeadersFilterable\":false,\"IsColumnHeadersFilterable\":true,\"HeaderFilters\":[],\"PaginationParameters\":{\"StartElement\":0,\"EndElement\":4,\"TotalElements\":9240,\"IsRows\":true,\"ShowingElement\":null},\"TableStyleCssClass\":\"style-97ba0187-37c0-47a1-a4ad-31b0f5281e77-1-_-_\",\"LiveTableFormat\":{},\"AvailableWidth\":780,\"AvailableHeight\":395,\"TableWidth\":null}}"},"secondsTaken":1.4930749,"updated":"2018-12-06T01:04:20.1544785Z","lastUpdatedMessage":null,"executedCode":"library(flipFormat)\nlibrary(flipTransformations)\nif (length(unique(sapply(formVariables, length))) != 1)\n stop(\"All variables must be the same length and are not.\")\nrawdata = ProcessQVariables(data.frame(if (length(formVariables) == 1) formVariables[[1]] else formVariables, stringsAsFactors = FALSE))\nrawdata = rawdata[QFilter,, drop = FALSE]\nnames(rawdata) <- if(!formNames) lapply(formVariables, Labels) else lapply(formVariables, Names)\nif (nrow(rawdata) * ncol(rawdata) > 1000000)\n stop(\"Your table contains more than 1,000,000 cells. To get around this limitation, edit the R Code, or, create tables using RAW DATA.\")\nraw.data.3 <- rawdata","lastSavedCode":"library(flipFormat)\nlibrary(flipTransformations)\nif (length(unique(sapply(formVariables, length))) != 1)\n stop(\"All variables must be the same length and are not.\")\nrawdata = ProcessQVariables(data.frame(if (length(formVariables) == 1) formVariables[[1]] else formVariables, stringsAsFactors = FALSE))\nrawdata = rawdata[QFilter,, drop = FALSE]\nnames(rawdata) <- if(!formNames) lapply(formVariables, Labels) else lapply(formVariables, Names)\nif (nrow(rawdata) * ncol(rawdata) > 1000000)\n stop(\"Your table contains more than 1,000,000 cells. To get around this limitation, edit the R Code, or, create tables using RAW DATA.\")\nraw.data.3 <- rawdata","highlightedCodeSpans":[{"start":74,"length":13,"index":4},{"start":218,"length":13,"index":4},{"start":239,"length":13,"index":4},{"start":263,"length":13,"index":4},{"start":323,"length":7,"index":6},{"start":369,"length":9,"index":4},{"start":387,"length":13,"index":4},{"start":422,"length":13,"index":4}],"tableTransformations":"<TabularTransformer>\r\n <TabularTransform type=\"Truncation\" truncationHeaderType=\"Column\" />\r\n <TabularTransform />\r\n</TabularTransformer>","tabularFilteringOptions":null,"hasGuiControls":true,"guiControls":{"Code":"var displayr = Q.isOnTheWeb();\nvar variables_prompt = displayr ? \"Variables are shown in the 'Data' tree (bottom-left).\" :\n \"Variables are shown in the 'Variables and Questions' tab.\";\n\nform.setHeading('Raw Data');\nform.dropBox({label: \"Variables\", \n types:[\"Variable: Numeric, Date, Money, Categorical, OrderedCategorical, Text\"], \n name: \"formVariables\",\n multi:true, prompt: variables_prompt})\nform.checkBox({label: \"Variable names\", name: \"formNames\", default_value: false, prompt: \"Display names instead of labels\"})","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":"Raw Data","Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formVariables","Page":null,"Group":null,"Type":"DropBox","Label":"Variables","LabelEmphasised":false,"Value":null,"Allowed":null,"Multi":true,"Prompt":"Variables are shown in the 'Data' tree (bottom-left).","ErrorMessage":"Variables: Variables accepts only inputs which are of type Variable (Numeric, Date, Money, Categorical, Orderedcategorical or Text).","Invalid":null,"Required":true,"AllowedTypes":["Variable: Numeric, Date, Money, Categorical, OrderedCategorical, Text"],"OwnerRItemGuid":"72ba624b-5488-4f5b-9851-40a2f601e60f","MinInputs":1,"MaxInputs":2147483647,"Height":4,"Duplicates":false,"Values":["283ab64c-68de-44c0-a9d6-cbe847160e23","f425e128-b1b8-41f6-8bea-3b7b01e68c95","bdfc3958-33c6-4b33-b624-f3291c1fcae8","dca9a2ee-1b12-4bde-a4ec-c889114ac285","a5dc7ad0-bd32-43b6-b0e8-54a3d617d4ce","4536ddd0-26ae-494f-a3a0-18fb85c5866a","7b8a6300-3c0e-41bc-9e39-f887836139d0","6b006f42-41e9-4f05-add4-b8681e5af87a","6a890d6d-d174-4f5f-a613-6de18a27d70c","34330975-53b9-4c64-ad2d-0bd49416eeb1","3ed92c9d-3bb7-49da-8776-bfb71f41fc42","bae5cf06-789e-4b4b-bb52-0ce1f61b3a1b","6c6b4dfb-eefd-41a7-a979-9932bf3c17c4","097a1241-c5e3-45ea-94c5-b48652f00d0e","7a8f616a-bcd8-4e13-a0cb-21f76db0d805","15e72a2f-e8dc-430b-9150-48440a75815c"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formNames","Page":null,"Group":null,"Type":"CheckBox","Label":"Variable names","LabelEmphasised":false,"Value":false,"Allowed":null,"Multi":false,"Prompt":"Display names instead of labels","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":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}}