\n $\"${Series1}$ \n

\n

\n\n","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"c65d1ca2-4","type":"html_data","dstContext":{"kid":"a5e99afa9619fd463982e2f825e272d1","id":"dstc65d1ca24"}}],"overflow":"ns","displayName":"Logo","id":"408318bb-3","type":"html_tpl2","dstContext":{"id":"dst408318bb3"},"renamed":true},{"layoutConfig":{"x":7.0,"y":0.0},"vis":false,"components":[{"role":"values","data":[["This Week","Last Week","This Month","Last Month","This Quarter","Last Quarter","This Year","Last Year","Last 7 Days","Last 30 Days","Last 365 Days"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"array(\"This Week\",\"Last Week\",\"This Month\",\"Last Month\",\"This Quarter\",\"Last Quarter\",\"This Year\",\"Last Year\",\"Last 7 Days\", \"Last 30 Days\", \"Last 365 Days\")","ver":2.0}],"autoFmt":false,"id":"0afe3d96","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"bd700b96","type":"proxy"}],"displayName":"User Input Control 2 Copy","scope":2.0,"inputLabel":"Date Range","controlHidden":"hidden","inputType":1.0,"id":"c344e36a","type":"input","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dstc344e36a"},"propName":""},{"layoutConfig":{"x":1.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["d"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",\"d\",\"Yesterday\",\"d\",\"This Week\",\"d\",\"Last Week\",\"d\",\"This Month\",\"d\",\"Last Month\",\"d\",\"This Quarter\",\"m\",\"Last Quarter\",\"m\",\"This Year\",\"m\",\"Last Year\",\"m\",\"Last 7 Days\",\"d\", \"Last 30 Days\",\"d\", \"Last 365 Days\",\"m\")","ver":2.0}],"autoFmt":false,"id":"6c144227","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"8e236155","type":"proxy"}],"displayName":"User Input Control 5 Copy","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"a996613c","type":"input","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dsta996613c"},"propName":""},{"layoutConfig":{"x":2.0,"y":1.0},"tpl":"

","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"3196fe1d-2","type":"html_data","dstContext":{"id":"dst3196fe1d2"}}],"overflow":"ns","displayName":"HTML Template 2","id":"c98139ff-1","type":"html_tpl2","dstContext":{"id":"dstc98139ff1"}},{"layoutConfig":{"x":3.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1654005600"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",DATE_STARTOF(today(),\"4\",0),\"Last Week\",DATE_STARTOF(today(),\"4\",-1),\"This Month\",DATE_STARTOF(today(),\"3\",0),\"Last Month\",DATE_STARTOF(today(),\"3\",-1),\"This Quarter\",DATE_STARTOF(today(),\"2\",0),\"Last Quarter\",DATE_STARTOF(today(),\"2\",-1),\"This Year\",DATE_STARTOF(today(),\"1\",0),\"Last Year\",DATE_STARTOF(today(),\"1\",-1),\"Last 7 Days\",DATE_ADD(today(),\"5\",-7), \"Last 30 Days\",DATE_ADD(today(),\"5\",-30), \"Last 365 Days\",DATE_ADD(today(),\"5\",-365))","ver":2.0}],"autoFmt":false,"id":"12b91e77","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"bbd7f3d9","type":"proxy"}],"displayName":"User Input Control 3 Copy","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"808e6b72","type":"input","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dst808e6b72"},"propName":""},{"layoutConfig":{"x":4.0,"y":1.0},"tpl":"

\nhttps://dashboardmagic.com.au/\n

\n +613 9917 3737\n

","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"fc1b399e-4","type":"html_data","dstContext":{"kid":"a5e99afa9619fd463982e2f825e272d1","id":"dstfc1b399e4"}}],"displayName":"HTML Template 3","id":"89189951-3","type":"html_tpl2","dstContext":{"id":"dst891899513"}},{"layoutConfig":{"x":7.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1656511200"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",today(),\"Last Week\",DATE_ENDOF(today(),\"4\",-1),\"This Month\",today(),\"Last Month\",DATE_ENDOF(today(),\"3\",-1),\"This Quarter\",today(),\"Last Quarter\",DATE_ENDOF(today(),\"2\",-1),\"This Year\",today(),\"Last Year\",DATE_ENDOF(today(),\"1\",-1),\"Last 7 Days\",today(), \"Last 30 Days\",today(), \"Last 365 Days\",today())","ver":2.0}],"autoFmt":false,"id":"aeec633a","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"da6439b1","type":"proxy"}],"displayName":"User Input Control 4 Copy","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"76da41b1","type":"input","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dst76da41b1"},"propName":""}],"displayName":"Layout Grid 2","widths":[{"w":"5%","x":8.0},{"w":"5%","x":0.0},{"w":"20%","x":4.0},{"w":"20%","x":2.0},{"w":"20%","x":6.0}],"id":"d87da40f-1","cellData":[{"x":7.0,"y":0.0,"alignment":1.0},{"x":8.0,"y":0.0},{"x":4.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":0.0},{"x":3.0,"y":0.0},{"x":4.0,"y":1.0,"alignment":2.0},{"w":5.0,"x":2.0,"y":0.0},{"x":2.0,"y":1.0,"alignment":2.0},{"x":6.0,"y":1.0,"alignment":2.0},{"x":3.0,"y":1.0,"alignment":1.0},{"x":5.0,"y":1.0}],"type":"panel_grid","rows":2.0,"cols":9.0}],"containerClassName":"logo","isForked":false,"id":"d83c5a62e8fe509432f5d767ff97a6e8","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"685ef16df9cbec639ecf20b110cf9882"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["The number of sales, sales value and gross profit margin per product. This allows us to see more details for our most valuable products."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"The number of sales, sales value and gross profit margin per product. This allows us to see more details for our most valuable products.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"cc4494b8","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dstcc4494b8"},"wrap":true},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","size":"x-small","data":[["Top Grossing Product"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Top Grossing Product\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"a44ef29e","type":"label","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dsta44ef29e"},"align":"c"},{"role":"secondary","size":"medium","data":[["Product B"]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"select(&'e5b359c1',&'e139851a'=max(&'e139851a'))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"9f017e9a","type":"label","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dst9f017e9a"},"align":"c"}],"displayName":"Value Pair","id":"ea5bb962","type":"simple_value","dstContext":{"id":"dstea5bb962"}},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"primary","size":"x-small","data":[["Highest Average Value Product"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Highest Average Value Product\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"8bf46d0e","type":"label","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dst8bf46d0e"},"align":"c"},{"role":"secondary","size":"medium","data":[["Product F"]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"precision":"0"},"formulas":[{"txt":"select(&'e5b359c1',&'20ade947'=max(&'20ade947'))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"e459a4ac","type":"label","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dste459a4ac"},"align":"c"}],"displayName":"Value Pair Copy","id":"28452ed1","type":"simple_value","dstContext":{"id":"dst28452ed1"}},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"primary","size":"x-small","data":[["Highest Margin Product"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Highest Margin Product\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"df43cfdf","type":"label","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dstdf43cfdf"},"align":"c"},{"role":"secondary","size":"medium","data":[["Product F"]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"select(&'e5b359c1',&'3142cea7'=max(&'3142cea7'))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"083a6edb","type":"label","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dst083a6edb"},"align":"c"}],"displayName":"Value Pair Copy 2","id":"e6322048","type":"simple_value","dstContext":{"id":"dste6322048"}}],"displayName":"Layout Grid","id":"cf883a7c","cellData":[{"x":0.0,"y":0.0,"cellPadding":[5.0,5.0,5.0,5.0]},{"x":1.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":3.0},{"components":[{"components":[{"role":"customHeader","data":[["Product"]],"displayName":"Product","formulas":[{"txt":"\"Product\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dsted4fed50"},"align":"l","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"ed4fed50","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_blue_5"}]}]}],"customHeader":true,"role":"tcol","data":[["Product B","Product C","Product D","Product A","Product F","Product E"]],"displayName":"Product","formulas":[{"txt":"group(&'a5f6553b')","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"txt","fw":"fixed","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"w":"40%","name":"Product","id":"e5b359c1"},{"components":[{"role":"customHeader","data":[["Total Value"]],"displayName":"Total Value","formulas":[{"txt":"\"Total Value\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dst2fc8cbbe"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"2fc8cbbe","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_blue_5"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[362334.4600000002,271024.21,220747.96999999994,120044.75000000001,72181.10000000002,58270.93000000001]],"displayName":"Total Value","formulas":[{"txt":"groupby(&'a5f6553b',&'3724aabe',\"sum(values)\")","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"cur","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"name":"Total Value","id":"e139851a"},{"components":[{"role":"customHeader","data":[["% of Sales"]],"displayName":"% of Sales","formulas":[{"txt":"\"% of Sales\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dst71249195"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"71249195","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_blue_5"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[0.3280222145247388,0.24535883656778826,0.19984364162117108,0.10867678646151575,0.06534571475435048,0.05275280607043567]],"displayName":"% of Sales","formulas":[{"txt":"&'e139851a'/sum(&'e139851a')","ver":2.0}],"autoFmt":false,"index":2.0,"type":"table_col","fmt":"pct","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"name":"Number of Sales","id":"4cf2650f","renamed":true},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[71262.0,57519.0,43735.0,25971.0,13950.0,12245.0]],"displayName":"Cost of Sales","formulas":[{"txt":"groupby(&'a5f6553b',&'0b0dfe55',\"sum(values)\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Cost of Sales","id":"7c5f80d1-79"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[130.0,112.0,81.0,53.0,24.0,24.0]],"displayName":"number of sales","formulas":[{"txt":"groupby(&'a5f6553b',&'3724aabe',\"count(values)\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"number of sales","id":"86517a0e-85"},{"components":[{"role":"customHeader","data":[["Average Price"]],"displayName":"Average Price","formulas":[{"txt":"\"Average Price\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dst2627bbd3"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"2627bbd3","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_blue_5"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[2787.1881538461553,2419.859017857143,2725.283580246913,2264.995283018868,3007.545833333334,2427.955416666667]],"displayName":"Average Price","formulas":[{"txt":"&'e139851a'/&'86517a0e-85'","ver":2.0}],"autoFmt":false,"index":5.0,"type":"table_col","fmt":"cur","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"name":"Average Price","id":"20ade947"},{"components":[{"role":"customHeader","data":[["Gross Profit %"]],"displayName":"Gross Profit %","formulas":[{"txt":"\"Gross Profit %\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dstcda963b9"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"cda963b9","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_blue_5"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[4.08453958631529,3.7119075435942905,4.047398422316221,3.6222613684494247,4.174272401433694,3.7587529603919974]],"displayName":"Gross Profit %","formulas":[{"txt":"&'e139851a'/&'7c5f80d1-79'-1","ver":2.0}],"autoFmt":false,"index":6.0,"type":"table_col","fmt":"pct","align":"left","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"name":"Gross Profit %","id":"3142cea7"},{"components":[{"role":"customHeader","data":[["Gross Profit $"]],"displayName":"Gross Profit $","formulas":[{"txt":"\"Gross Profit $\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dst88bebf1573"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"88bebf15-73","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_blue_5"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[291072.4600000002,213505.21000000002,177012.96999999994,94073.75000000001,58231.10000000002,46025.93000000001]],"displayName":"Gross Profit $","formulas":[{"txt":"&'e139851a'-&'7c5f80d1-79'","ver":2.0}],"autoFmt":false,"index":7.0,"type":"table_col","fmt":"cur","align":"left","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"name":"Gross Profit $","id":"4f43c536-72"}],"maxRows":"10","displayName":"Table 2","id":"307e4a27","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">","dim":"3142cea7","type":"op","value":"0"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"3142cea7","variation":"condition"},{"sortBy":[{"dim":"e139851a","dir":2.0}],"type":"sort"}],"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dst307e4a27"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["207344/9/9","540233/1/31","88849/1/15","675480/9/30","910963/11/14","1275471/11/8","972635/10/16","1453547/7/20","2040868/1/6","1821023/7/19","1325796/3/16","2189715/1/12","393767/1/13","473719/1/10","488099/10/4","1084136/9/14","1365188/8/26","1691508/7/14","1740656/12/20","493812/7/2","1389429/5/28","185489/11/22","475773/2/19","1445591/10/14","2707830/5/12","1289371/6/7","657782/12/8","1726803/8/20","1910530/7/31","57293/1/6","1362258/9/18","2483886/8/15","1159701/7/5","1024011/1/3","2643832/4/21","1564795/9/8","1335810/5/15","2447324/3/7","1268045/12/22","1807768/1/26","4799/2/23","956629/9/7","2285264/3/24","191644/12/1","1361100/3/18","2030393/8/6","1923572/5/9","1108817/2/9","2179373/7/25","506540/7/19","2002531/5/8","1879598/5/24","629539/10/5","54710/12/26","1762040/12/4","613861/7/8","1570667/4/28","1590552/6/8","1298063/1/28","548855/11/26","837473/7/4","812970/1/18","2199110/2/23","2104043/4/2","165347/10/31","136945/7/27","2613504/10/23","1957334/2/27","1043819/1/8","2648314/1/1","1089339/7/27","2704144/6/17","396351/9/26","197874/12/4","2310282/12/18","1752374/8/24","717208/1/27","1291577/6/6","2107415/1/4","2714381/10/24","1436166/2/13","8921/8/16","997333/3/7","152653/2/2","1938227/4/11","1422944/4/18","354501/6/26","1474552/5/6","805499/1/23","647072/1/12","1720060/11/7","2609010/6/16","1174082/12/24","2234184/2/29","316817/7/12","1794834/7/30","2666293/10/29","325380/3/2","117395/3/24","2337344/8/19"]],"displayName":"ID","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Sales,A:A;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"yyyy/M/d","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"yyyy/M/d","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"ID","id":"e8ed8462"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6037172E9,1.5973272E9,1.5991416E9,1.6018164E9,1.600092E9,1.5902424E9,1.5847956E9,1.5911928E9,1.5772788E9,1.5869592E9,1.5747732E9,1.5974136E9,1.6006968E9,1.5841044E9,1.5877368E9,1.58013E9,1.5998328E9,1.5912792E9,1.5864408E9,1.577538E9,1.5746004E9,1.5874776E9,1.600092E9,1.58445E9,1.5961176E9,1.5860952E9,1.582722E9,1.5981048E9,1.5817716E9,1.5849684E9,1.59102E9,1.5845364E9,1.5909336E9,1.5978456E9,1.5819444E9,1.5947352E9,1.596636E9,1.5920568E9,1.5860952E9,1.5769332E9,1.5905016E9,1.5763284E9,1.572786E9,1.5730452E9,1.5899832E9,1.583586E9,1.589724E9,1.5772788E9,1.6015608E9,1.5883416E9,1.603458E9,1.6022484E9,1.598796E9,1.5929208E9,1.576674E9,1.5936984E9,1.58229E9,1.5898968E9,1.6016472E9,1.5976728E9,1.5781428E9,1.5879096E9,1.6018164E9,1.5842772E9,1.5930936E9,1.5824628E9,1.6037172E9,1.6003512E9,1.5873912E9,1.5795252E9,1.6010424E9,1.5747732E9,1.5961176E9,1.6004376E9,1.5889464E9,1.5934392E9,1.6006968E9,1.6028532E9,1.593612E9,1.602594E9,1.5812532E9,1.5777108E9,1.5968088E9,1.5947352E9,1.589292E9,1.5834996E9,1.5760692E9,1.5995736E9,1.5920568E9,1.5821172E9,1.5747732E9,1.601388E9,1.5746868E9,1.5808212E9,1.5968952E9,1.5756372E9,1.5737364E9,1.5812532E9,1.5728724E9,1.5902424E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(a2d75942456c71f47060d9f50d075fd4@Sales,B:B;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"601d57c8"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["27 Oct 2020","14 Aug 2020","4 Sep 2020","5 Oct 2020","15 Sep 2020","24 May 2020","22 Mar 2020","4 Jun 2020","26 Dec 2019","16 Apr 2020","27 Nov 2019","15 Aug 2020","22 Sep 2020","14 Mar 2020","25 Apr 2020","28 Jan 2020","12 Sep 2020","5 Jun 2020","10 Apr 2020","29 Dec 2019","25 Nov 2019","22 Apr 2020","15 Sep 2020","18 Mar 2020","31 Jul 2020","6 Apr 2020","27 Feb 2020","23 Aug 2020","16 Feb 2020","24 Mar 2020","2 Jun 2020","19 Mar 2020","1 Jun 2020","20 Aug 2020","18 Feb 2020","15 Jul 2020","6 Aug 2020","14 Jun 2020","6 Apr 2020","22 Dec 2019","27 May 2020","15 Dec 2019","4 Nov 2019","7 Nov 2019","21 May 2020","8 Mar 2020","18 May 2020","26 Dec 2019","2 Oct 2020","2 May 2020","24 Oct 2020","10 Oct 2020","31 Aug 2020","24 Jun 2020","19 Dec 2019","3 Jul 2020","22 Feb 2020","20 May 2020","3 Oct 2020","18 Aug 2020","5 Jan 2020","27 Apr 2020","5 Oct 2020","16 Mar 2020","26 Jun 2020","24 Feb 2020","27 Oct 2020","18 Sep 2020","21 Apr 2020","21 Jan 2020","26 Sep 2020","27 Nov 2019","31 Jul 2020","19 Sep 2020","9 May 2020","30 Jun 2020","22 Sep 2020","17 Oct 2020","2 Jul 2020","14 Oct 2020","10 Feb 2020","31 Dec 2019","8 Aug 2020","15 Jul 2020","13 May 2020","7 Mar 2020","12 Dec 2019","9 Sep 2020","14 Jun 2020","20 Feb 2020","27 Nov 2019","30 Sep 2020","26 Nov 2019","5 Feb 2020","9 Aug 2020","7 Dec 2019","15 Nov 2019","10 Feb 2020","5 Nov 2019","24 May 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($TM_DateGroup,\"d\",DATEVALUE(&'601d57c8',\"d MMM yyyy\"),\"m\",DATEVALUE(&'601d57c8',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"c1978bff"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Product A","Product C","Product C","Product B","Product A","Product B","Product D","Product D","Product B","Product F","Product A","Product F","Product B","Product B","Product B","Product D","Product E","Product C","Product B","Product C","Product A","Product C","Product C","Product B","Product B","Product C","Product E","Product B","Product F","Product B","Product B","Product C","Product B","Product C","Product B","Product C","Product C","Product D","Product D","Product B","Product B","Product A","Product F","Product E","Product C","Product D","Product D","Product C","Product D","Product C","Product C","Product B","Product C","Product D","Product B","Product B","Product B","Product F","Product A","Product C","Product C","Product B","Product D","Product F","Product E","Product D","Product D","Product C","Product E","Product B","Product B","Product B","Product A","Product C","Product D","Product B","Product D","Product D","Product D","Product F","Product B","Product A","Product B","Product D","Product B","Product D","Product B","Product D","Product F","Product B","Product C","Product F","Product A","Product B","Product C","Product C","Product A","Product D","Product B","Product B"]],"displayName":"Product","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Sales,E:E;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Product","id":"a5f6553b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["2956.08","1299.27","1630.56","3805.45","521.28","1609.52","569.94","1216.95","1406.14","796.18","2189.2","7260","2054.46","180.12","5774.56","510","1768","2922.48","202.32","175.46","1206.24","814.33","2308.23","2727.48","5614.5","1540.66","1998","2358.75","2778.88","241.31","1574.91","826.2","1247.35","2219.04","5431.53","557.46","5119.52","4761.53","3805.56","1882.32","3789.3","1317.38","3103.56","5952.22","902.4","798.18","2259.9","5178.6","3114.72","656.37","1989.18","7560.45","6307.29","2315.12","922.3","6127.2","4344.33","3054.51","413.54","642.95","4075.84","286","2761.9","552.47","3170.6","4841.03","2455.25","279.18","3049.2","1433.13","4200","1143.36","1844.7","2906.4","1007.76","469.95","4066.14","6110.56","2765.68","1597.4","2292.44","268.8","1829.56","415","864.6","7954.06","3676.32","1576.17","266.43","5415.2","2116.7","3627","4686.18","7157","1426.95","3788.12","2166.75","2128.12","437.84","5209.02"]],"displayName":"Sales Value","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Sales,F:F;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales Value","id":"3724aabe"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["452","161","688","629","96","682","413","427","421","242","260","968","353","158","748","408","260","902","72","62","359","673","747","764","985","517","360","629","668","59","513","306","505","536","741","163","784","629","558","713","743","331","666","718","235","753","310","959","412","351","387","951","759","673","230","888","537","729","62","385","542","200","389","101","382","577","305","198","990","201","750","288","430","346","884","65","802","724","764","980","514","120","863","83","660","998","666","633","249","967","694","650","941","842","189","652","321","332","52","774"]],"displayName":"COS","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Sales,D:D;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":5.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"COS","id":"0b0dfe55"}],"displayName":"Table","id":"da253f88","type":"table","dstContext":{"ops":[],"kid":"1e95298696b0fc25ebc2ed3395b73072","id":"dstda253f88"}}],"isForked":false,"id":"1f30c2b7adc6554f74a8daad0362d59d","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Top Product Details","usesSampleData":false,"master":"1e95298696b0fc25ebc2ed3395b73072"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":550.0}},"components":[{"size":"large","data":[["ULTIMATE METRICS DASHBOARD"]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"ULTIMATE METRICS DASHBOARD\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"923a4e85","type":"label","fmt":"txt","dstContext":{"kid":"9221bdc30bc2e74c0a2ebeeb0ef1cea1","id":"dst923a4e85"},"align":"c","wrap":true}],"isForked":false,"id":"1dc997c30a2db5facb7001044eb66d3e","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Sales Dashboard Title","usesSampleData":false,"master":"9221bdc30bc2e74c0a2ebeeb0ef1cea1"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","a2d75942456c71f47060d9f50d075fd4"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["This displays how much is being spent across the various marketing channels. This allows us to keep track of our spend and ensure we are not overspending on less efficient channels"]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"This displays how much is being spent across the various marketing channels. This allows us to keep track of our spend and ensure we are not overspending on less efficient channels\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"64dc762d","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"656c0423680ad608539bf303a65164fd","id":"dst64dc762d"},"wrap":true},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","data":[["Total Leads"]],"displayName":"Primary Value","formulas":[{"txt":"\"Total Leads\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"656c0423680ad608539bf303a65164fd","id":"dst78087c0f78"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"78087c0f-78"},{"role":"secondary","size":"large","data":[["530"]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"count(GROUP(&'f894c9f6'))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"b0101ce6-79","type":"label","fmt":"txt","dstContext":{"kid":"656c0423680ad608539bf303a65164fd","id":"dstb0101ce679"},"align":"c"}],"displayName":"Value Pair","id":"2377085a-77","type":"simple_value","dstContext":{"id":"dst2377085a77"}},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"primary","data":[["Average Cost Per Lead"]],"displayName":"Primary Value","formulas":[{"txt":"\"Average Cost Per Lead\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"656c0423680ad608539bf303a65164fd","id":"dst34428512"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"34428512"},{"role":"secondary","size":"large","data":[[6.081132075471698]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"2"},"formulas":[{"txt":"SUM(&'ab8485f2')/&'b0101ce6-79'","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"5d73929a","type":"label","fmt":"cur","dstContext":{"kid":"656c0423680ad608539bf303a65164fd","id":"dst5d73929a"},"align":"c"}],"displayName":"Value Pair Copy","id":"e19e7734","type":"simple_value","dstContext":{"id":"dste19e7734"}}],"displayName":"Layout Grid","id":"255d89e5-65","type":"panel_grid","rows":1.0,"cols":2.0},{"displayName":"Separator 2","id":"d2bf4800-80","type":"separator"},{"components":[{"data":[["Leads and CPL by Channel"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Leads and CPL by Channel\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"656c0423680ad608539bf303a65164fd","id":"dst760b26dd"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"760b26dd","wrap":true},{"data":[["Leads and CPL Over Time"]],"displayName":"Label 2","formulas":[{"txt":"\"Leads and CPL Over Time\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"656c0423680ad608539bf303a65164fd","id":"dst3c6f903e"},"align":"c","layoutConfig":{"x":1.0,"y":0.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"3c6f903e","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"showValues":true,"role":"series","data":[[14.466666666666667,5.785714285714286,7.36734693877551,0.0,5.824074074074074,9.25,0.0]],"color":"cx-theme_yellow_green_4","displayName":"Cost per Lead","seriesName":"Cost per Lead","formulas":[{"txt":"lookup(&'e40cb278-35',group(&'ad410194'),groupby(&'ad410194',&'ab8485f2'))/lookup(&'e40cb278-35',group(&'48ad2f33'),groupby(&'48ad2f33',&'f894c9f6',\"count(group(values))\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"471dbf7c-62","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"450c47b6-34"},{"showValues":true,"role":"series","data":[[45.0,56.0,49.0,62.0,108.0,136.0,74.0]],"color":"cx-theme_orange_2","displayName":"Number of Leads","seriesName":"Number of Leads","formulas":[{"txt":"lookup(&'e40cb278-35',group(&'48ad2f33'),groupby(&'48ad2f33',&'f894c9f6',\"count(group(values))\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"62f4e320-36","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"f0e3e6cd-61"},{"role":"axis_x","data":[["Google","Newsletter","Referral","Salesperson","Social Media","Website","Word of Mouth"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"group(&'48ad2f33')","ver":2.0}],"autoFmt":true,"id":"e40cb278-35","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"id":"62f4e320-36","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Cost","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Cost","type":"chart_axis","fmt":"cur","fmtArgs":{},"id":"471dbf7c-62","labelDrop":0.0}],"displayName":"Bar/Line Chart 2","id":"14c14998-33","type":"chart_series","dstContext":{"kid":"656c0423680ad608539bf303a65164fd","id":"dst14c1499833"},"height":"3"},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"role":"series","data":[["","","","","","",1.0,"","","","",1.0,"","","",1.0,"","","","","","","","","","","","","",1.0,""]],"color":"cx-theme_orange_2","displayName":"Google","seriesName":"Google","formulas":[{"txt":"lookup(&'eb7a56c3',group(SELECT(&'d87b8bea',&'48ad2f33'=\"Google\")),groupby(SELECT(&'d87b8bea',&'48ad2f33'=\"Google\"),SELECT(&'f894c9f6',&'48ad2f33'=\"Google\"),\"count(group(values))\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"a130c938","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"b05f5334-64"},{"role":"series","data":[["","","","","","","","","","",1.0,"","","","","","","","","","",1.0,1.0,"","","","","","","",""]],"color":"cx-theme_green_2","displayName":"Newsletter","seriesName":"Newsletter","formulas":[{"txt":"lookup(&'eb7a56c3',group(SELECT(&'d87b8bea',&'48ad2f33'=\"Newsletter\")),groupby(SELECT(&'d87b8bea',&'48ad2f33'=\"Newsletter\"),SELECT(&'f894c9f6',&'48ad2f33'=\"Newsletter\"),\"count(group(values))\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"a130c938","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"cd36c470"},{"role":"series","data":[["","","","","",1.0,"","","","","","","","","","",1.0,"","","","","","",1.0,"","","","",1.0,"",""]],"color":"cx-theme_violet_1","displayName":"Referral","seriesName":"Referral","formulas":[{"txt":"lookup(&'eb7a56c3',group(SELECT(&'d87b8bea',&'48ad2f33'=\"Referral\")),groupby(SELECT(&'d87b8bea',&'48ad2f33'=\"Referral\"),SELECT(&'f894c9f6',&'48ad2f33'=\"Referral\"),\"count(group(values))\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"a130c938","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"033a409e-63"},{"role":"series","data":[["",2.0,"","","","","","","","","","","","","","","","","","",1.0,1.0,"","","","",1.0,"","","",""]],"color":"cx-theme_blue_1","displayName":"Social Media","seriesName":"Social Media","formulas":[{"txt":"lookup(&'eb7a56c3',group(SELECT(&'d87b8bea',&'48ad2f33'=\"Social Media\")),groupby(SELECT(&'d87b8bea',&'48ad2f33'=\"Social Media\"),SELECT(&'f894c9f6',&'48ad2f33'=\"Social Media\"),\"count(group(values))\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"a130c938","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"813eaa51"},{"role":"series","data":[["","","",2.0,"",1.0,"","","",1.0,"",1.0,"","","","",1.0,"",1.0,"","","","","","","","","","","",""]],"color":"cx-theme_yellow_3","displayName":"Salesperson","seriesName":"Salesperson","formulas":[{"txt":"lookup(&'eb7a56c3',group(SELECT(&'d87b8bea',&'48ad2f33'=\"Salesperson\")),groupby(SELECT(&'d87b8bea',&'48ad2f33'=\"Salesperson\"),SELECT(&'f894c9f6',&'48ad2f33'=\"Salesperson\"),\"count(group(values))\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"a130c938","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"ef8c12d1-65"},{"role":"series","data":[["",2.0,"","",1.0,"","",1.0,1.0,2.0,"",2.0,"",1.0,"","",1.0,"","","","","","","","","",1.0,"","","",""]],"color":"cx-theme_red_1","displayName":"Website","seriesName":"Website","formulas":[{"txt":"lookup(&'eb7a56c3',group(SELECT(&'d87b8bea',&'48ad2f33'=\"Website\")),groupby(SELECT(&'d87b8bea',&'48ad2f33'=\"Website\"),SELECT(&'f894c9f6',&'48ad2f33'=\"Website\"),\"count(group(values))\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"a130c938","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"76d96090"},{"role":"series","data":[["","","",1.0,"","","","","","","","","","",1.0,"","","","","",1.0,"",1.0,"","",1.0,"","","","",""]],"color":"cx-theme_blue_3","displayName":"Word of Mouth","seriesName":"Word of Mouth","formulas":[{"txt":"lookup(&'eb7a56c3',group(SELECT(&'d87b8bea',&'48ad2f33'=\"Word of Mouth\")),groupby(SELECT(&'d87b8bea',&'48ad2f33'=\"Word of Mouth\"),SELECT(&'f894c9f6',&'48ad2f33'=\"Word of Mouth\"),\"count(group(values))\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"a130c938","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"adb5efc9-66"},{"renderer":"line","showValues":true,"role":"series","data":[["NaN",58.0,"NaN",37.0,86.0,73.5,105.0,77.0,35.0,102.0,61.0,84.75,"NaN",114.0,49.0,43.0,91.0,"NaN",96.0,"NaN",60.5,129.0,76.5,140.0,"NaN",98.0,62.5,"NaN",104.0,150.0,"NaN"]],"color":"cx-theme_green_4","displayName":"Cost per Lead","seriesName":"Cost per Lead","formulas":[{"txt":"lookup(&'eb7a56c3',group(&'d87b8bea'),groupby(&'d87b8bea',&'ab8485f2',\"sum(values)\"))/lookup(&'eb7a56c3',group(&'d87b8bea'),groupby(&'d87b8bea',&'f894c9f6',\"count(group(values))\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"f994b006","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"precision":"0"},"id":"66bcf2d8-67"},{"renderer":"line","role":"series","data":[["","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]],"displayName":"CPL Target","seriesName":"CPL Target","formulas":[{"txt":"repeat(lookup(\"Cost Per Lead by marketing channel\",773a7b4b52bcff4e6d67acb50b26c8a6@Top Metrics,D:D;,773a7b4b52bcff4e6d67acb50b26c8a6@Top Metrics,I:I;),count(!'eb7a56c3'))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"f994b006","lineDashes":"Dash","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"precision":"0"},"id":"962791a6-68"},{"role":"axis_x","data":[["14 Jun 2022","15 Jun 2022","16 Jun 2022","17 Jun 2022","18 Jun 2022","19 Jun 2022","20 Jun 2022","21 Jun 2022","22 Jun 2022","23 Jun 2022","24 Jun 2022","25 Jun 2022","26 Jun 2022","27 Jun 2022","28 Jun 2022","29 Jun 2022","30 Jun 2022","1 Jul 2022","2 Jul 2022","3 Jul 2022","4 Jul 2022","5 Jul 2022","6 Jul 2022","7 Jul 2022","8 Jul 2022","9 Jul 2022","10 Jul 2022","11 Jul 2022","12 Jul 2022","13 Jul 2022","14 Jul 2022"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(DATERANGE($dateStart,$dateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($dateStart,$dateEnd),\"3\")),\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"id":"eb7a56c3","label":"Untitled","type":"chart_axis","fmt":"dat2","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Lead","formulas":[],"autoFmt":true,"label":"Leads","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"id":"a130c938","labelDrop":0.0,"renamed":true},{"customRange":true,"role":"axis_y","data":[],"dataDisabled":true,"displayName":"CPL","formulas":[],"autoFmt":true,"axisPosition":"right","label":"CPL","type":"chart_axis","fmt":"cur","min":"0","fmtArgs":{},"id":"f994b006","labelDrop":0.0,"renamed":true}],"stackAreas":"1","displayName":"Bar/Line Chart","id":"1346d45f","type":"chart_series","dstContext":{"kid":"656c0423680ad608539bf303a65164fd","id":"dst1346d45f"},"stackBars":"1","height":"3"}],"displayName":"Layout Grid 2","id":"69169ab3","cellData":[{"x":0.0,"y":0.0},{"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":0.0},{"w":2.0,"x":1.0,"y":1.0}],"type":"panel_grid","rows":2.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"displayName":"Separator","id":"995f34e4","type":"separator"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jul 7, 2022","Jun 25, 2022","Jul 13, 2022","Jun 15, 2022","Jun 15, 2022","Jul 2, 2022","Jun 21, 2022","Jul 10, 2022","Jul 4, 2022","Jun 22, 2022","Jul 12, 2022","Jun 15, 2022","Jun 23, 2022","Jun 23, 2022","Jul 9, 2022","Jul 6, 2022","Jun 25, 2022","Jul 10, 2022","Jun 27, 2022","Jun 17, 2022","Jun 30, 2022","Jun 18, 2022","Jun 15, 2022","Jun 17, 2022","Jun 28, 2022","Jul 6, 2022","Jul 5, 2022","Jun 30, 2022","Jun 25, 2022","Jun 24, 2022","Jul 4, 2022","Jun 30, 2022","Jun 19, 2022","Jun 20, 2022","Jun 17, 2022","Jun 29, 2022","Jun 23, 2022","Jun 19, 2022","Jun 25, 2022","Jul 5, 2022"]],"displayName":"Date_Raw","formulas":[{"txt":"DATE_ADD(slice(date(a2d75942456c71f47060d9f50d075fd4@Marketing Spend,A:A;,\"yyyy/MM/dd\")),\"3\",1)","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"6b3125bc"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["7 Jul 2022","25 Jun 2022","13 Jul 2022","15 Jun 2022","15 Jun 2022","2 Jul 2022","21 Jun 2022","10 Jul 2022","4 Jul 2022","22 Jun 2022","12 Jul 2022","15 Jun 2022","23 Jun 2022","23 Jun 2022","9 Jul 2022","6 Jul 2022","25 Jun 2022","10 Jul 2022","27 Jun 2022","17 Jun 2022","30 Jun 2022","18 Jun 2022","15 Jun 2022","17 Jun 2022","28 Jun 2022","6 Jul 2022","5 Jul 2022","30 Jun 2022","25 Jun 2022","24 Jun 2022","4 Jul 2022","30 Jun 2022","19 Jun 2022","20 Jun 2022","17 Jun 2022","29 Jun 2022","23 Jun 2022","19 Jun 2022","25 Jun 2022","5 Jul 2022"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'6b3125bc',\"d MMM yyyy\"),\"m\",DATEVALUE(!'6b3125bc',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"d87b8bea"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["140.00","78.00","150.00","96.00","27.00","96.00","77.00","63.00","54.00","35.00","104.00","37.00","37.00","150.00","98.00","63.00","95.00","62.00","114.00","36.00","43.00","86.00","72.00","39.00","49.00","90.00","146.00","113.00","75.00","61.00","67.00","117.00","89.00","105.00","36.00","43.00","119.00","58.00","91.00","112.00"]],"displayName":"Spend","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Marketing Spend,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Spend","id":"ab8485f2"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Website","Newsletter","Social Media","Website","Social Media","Google","Referral","Newsletter","Google","Newsletter","Website","Website","Referral","Website","Social Media","Social Media","Website","Website","Google","Google","Referral","Google","Website","Website","Website","Google","Website","Referral","Website","Website","Social Media","Google","Website","Social Media","Newsletter","Website","Social Media","Google","Referral","Newsletter"]],"displayName":"Channel","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Marketing Spend,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Channel","id":"ad410194"}],"displayName":"Table","id":"2a688878","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","dim":"6b3125bc","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}},{"op":"<=","dim":"6b3125bc","type":"op","value":{"var":"dateEnd"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"6b3125bc","variation":"condition"}],"kid":"656c0423680ad608539bf303a65164fd","id":"dst2a688878"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jun 26, 2022","Jun 28, 2022","Jul 9, 2022","Jun 22, 2022","Jul 6, 2022","Jul 4, 2022","Jun 16, 2022","Jun 30, 2022","Jul 14, 2022","Jul 6, 2022","Jul 2, 2022","Jun 16, 2022","Jun 29, 2022","Jul 14, 2022","Jun 28, 2022","Jun 21, 2022","Jul 11, 2022","Jul 7, 2022","Jul 9, 2022","Jun 23, 2022","Jul 5, 2022","Jun 30, 2022","Jul 9, 2022","Jul 2, 2022","Jun 24, 2022","Jul 8, 2022","Jun 22, 2022","Jun 30, 2022","Jun 21, 2022","Jul 6, 2022","Jun 16, 2022","Jun 25, 2022","Jun 20, 2022","Jun 30, 2022","Jul 10, 2022","Jul 7, 2022","Jun 28, 2022","Jun 15, 2022","Jun 27, 2022","Jul 5, 2022","Jun 18, 2022","Jun 23, 2022","Jul 9, 2022","Jul 2, 2022","Jun 23, 2022","Jun 22, 2022","Jul 3, 2022","Jul 1, 2022","Jun 14, 2022","Jul 11, 2022","Jul 1, 2022","Jun 21, 2022","Jun 22, 2022","Jun 28, 2022","Jun 16, 2022","Jun 27, 2022","Jun 17, 2022","Jul 9, 2022","Jul 11, 2022","Jun 19, 2022","Jun 30, 2022","Jun 26, 2022","Jun 21, 2022","Jun 21, 2022","Jun 23, 2022","Jun 16, 2022","Jun 24, 2022","Jun 20, 2022","Jun 23, 2022","Jun 16, 2022","Jun 25, 2022","Jun 20, 2022","Jul 9, 2022","Jun 18, 2022","Jun 25, 2022","Jun 29, 2022","Jul 4, 2022","Jul 6, 2022","Jul 5, 2022","Jun 30, 2022","Jun 30, 2022","Jul 6, 2022","Jun 20, 2022","Jul 9, 2022","Jun 18, 2022","Jun 24, 2022","Jul 4, 2022","Jul 12, 2022","Jul 13, 2022","Jul 2, 2022","Jul 12, 2022","Jul 11, 2022","Jul 6, 2022","Jun 15, 2022","Jul 1, 2022","Jul 12, 2022","Jun 29, 2022","Jun 25, 2022","Jul 7, 2022","Jul 2, 2022"]],"displayName":"Date_Raw","formulas":[{"txt":"DATE_ADD(SLICE(date(a2d75942456c71f47060d9f50d075fd4@Leads,A:A;,\"yyyy/MM/dd\")),\"3\",1)","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"c91aeee0"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["26 Jun 2022","28 Jun 2022","9 Jul 2022","22 Jun 2022","6 Jul 2022","4 Jul 2022","16 Jun 2022","30 Jun 2022","14 Jul 2022","6 Jul 2022","2 Jul 2022","16 Jun 2022","29 Jun 2022","14 Jul 2022","28 Jun 2022","21 Jun 2022","11 Jul 2022","7 Jul 2022","9 Jul 2022","23 Jun 2022","5 Jul 2022","30 Jun 2022","9 Jul 2022","2 Jul 2022","24 Jun 2022","8 Jul 2022","22 Jun 2022","30 Jun 2022","21 Jun 2022","6 Jul 2022","16 Jun 2022","25 Jun 2022","20 Jun 2022","30 Jun 2022","10 Jul 2022","7 Jul 2022","28 Jun 2022","15 Jun 2022","27 Jun 2022","5 Jul 2022","18 Jun 2022","23 Jun 2022","9 Jul 2022","2 Jul 2022","23 Jun 2022","22 Jun 2022","3 Jul 2022","1 Jul 2022","14 Jun 2022","11 Jul 2022","1 Jul 2022","21 Jun 2022","22 Jun 2022","28 Jun 2022","16 Jun 2022","27 Jun 2022","17 Jun 2022","9 Jul 2022","11 Jul 2022","19 Jun 2022","30 Jun 2022","26 Jun 2022","21 Jun 2022","21 Jun 2022","23 Jun 2022","16 Jun 2022","24 Jun 2022","20 Jun 2022","23 Jun 2022","16 Jun 2022","25 Jun 2022","20 Jun 2022","9 Jul 2022","18 Jun 2022","25 Jun 2022","29 Jun 2022","4 Jul 2022","6 Jul 2022","5 Jul 2022","30 Jun 2022","30 Jun 2022","6 Jul 2022","20 Jun 2022","9 Jul 2022","18 Jun 2022","24 Jun 2022","4 Jul 2022","12 Jul 2022","13 Jul 2022","2 Jul 2022","12 Jul 2022","11 Jul 2022","6 Jul 2022","15 Jun 2022","1 Jul 2022","12 Jul 2022","29 Jun 2022","25 Jun 2022","7 Jul 2022","2 Jul 2022"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'c91aeee0',\"d MMM yyyy\"),\"m\",DATEVALUE(!'c91aeee0',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"65f7d109"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["81826759222@email.com","80948844479@email.com","56717048311@email.com","10104971801@email.com","42204869050@email.com","92263761896@email.com","11767371684@email.com","90827795122@email.com","66037058113@email.com","93586806866@email.com","78235679715@email.com","24810531053@email.com","92559305868@email.com","69505160087@email.com","45894165999@email.com","38058558037@email.com","90756166878@email.com","67747656631@email.com","66919367975@email.com","83196655131@email.com","91043436977@email.com","724703986@email.com","1237179824@email.com","25180373817@email.com","40463209005@email.com","19151176283@email.com","94863089839@email.com","47866859526@email.com","1748704215@email.com","84857778970@email.com","54028078087@email.com","98471711331@email.com","94604530181@email.com","94166566642@email.com","17177371736@email.com","8048524233@email.com","32029546626@email.com","95661966551@email.com","58904271819@email.com","26071906247@email.com","44383188929@email.com","7337144209@email.com","51150346313@email.com","9434221937@email.com","87636167533@email.com","91744891540@email.com","67317317480@email.com","74645116454@email.com","8657440837@email.com","73169972732@email.com","97936902859@email.com","29723544153@email.com","51610477860@email.com","73127542064@email.com","11999934098@email.com","85044556549@email.com","41199646572@email.com","1153807213@email.com","15897707159@email.com","95807326236@email.com","67898157157@email.com","44865775485@email.com","20669598030@email.com","44077813597@email.com","37520699449@email.com","62350904983@email.com","21042811958@email.com","41238476507@email.com","54739713288@email.com","88821093285@email.com","34075641944@email.com","89862076946@email.com","76069940185@email.com","3995382343@email.com","78122360647@email.com","92881778126@email.com","68068829384@email.com","98275541014@email.com","5864049643@email.com","53848026769@email.com","63546885125@email.com","52844260469@email.com","36517151638@email.com","94564911448@email.com","56805439401@email.com","71806166841@email.com","73565017649@email.com","57538860978@email.com","38132768827@email.com","20564688909@email.com","71791638204@email.com","89185951162@email.com","22757709589@email.com","6523151916@email.com","20342729444@email.com","44361158163@email.com","56949350399@email.com","74098464913@email.com","40283458722@email.com","19968096196@email.com"]],"displayName":"email","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Leads,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"email","id":"f894c9f6"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Referral","Website","Google","Website","Social Media","Salesperson","Website","Website","Social Media","Website","Referral","Social Media","Website","Website","Word of Mouth","Word of Mouth","Salesperson","Social Media","Website","Word of Mouth","Website","Website","Website","Salesperson","Word of Mouth","Newsletter","Social Media","Salesperson","Website","Newsletter","Word of Mouth","Referral","Referral","Google","Salesperson","Google","Salesperson","Salesperson","Google","Newsletter","Salesperson","Referral","Social Media","Referral","Salesperson","Salesperson","Newsletter","Salesperson","Salesperson","Google","Social Media","Social Media","Salesperson","Social Media","Newsletter","Google","Website","Newsletter","Newsletter","Google","Google","Social Media","Referral","Social Media","Website","Salesperson","Social Media","Social Media","Salesperson","Salesperson","Social Media","Newsletter","Salesperson","Google","Website","Newsletter","Website","Website","Website","Newsletter","Social Media","Salesperson","Website","Word of Mouth","Referral","Social Media","Website","Word of Mouth","Website","Salesperson","Salesperson","Word of Mouth","Social Media","Google","Newsletter","Website","Website","Salesperson","Website","Website"]],"displayName":"Channel","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Leads,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Channel","id":"48ad2f33"}],"displayName":"Table Copy","id":"545920b2","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","dim":"c91aeee0","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}},{"op":"<=","dim":"c91aeee0","type":"op","value":{"var":"dateEnd"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"c91aeee0","variation":"condition"}],"kid":"656c0423680ad608539bf303a65164fd","id":"dst545920b2"}}],"isForked":false,"id":"3b79773bccd4f83535a919e46f22032f","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Cost per Lead (CPL)","usesSampleData":false,"master":"656c0423680ad608539bf303a65164fd"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["Displays how much revenue each product accounts for. This allows us to quickly see our top products"]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Displays how much revenue each product accounts for. This allows us to quickly see our top products\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"254ad503","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"ee9b98e11749602acb4374bdd229a7ed","id":"dst254ad503"},"wrap":true},{"components":[{"role":"data","data":[[255169.7800000001,231765.12000000008,208453.75999999998,136904.31,50384.25,35999.33000000001,2166.37,607.88]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"formulas":[{"txt":"GROUPBY(&'aca9fecf',&'f8841f55',\"sum(values)\")","ver":2.0}],"autoFmt":false,"id":"b9038936-90","type":"series_data","fmt":"cur"},{"role":"labels","data":[["Product B","Product C","Product D","Product A","Product E","Product F","Product R","Product S"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"GROUP(&'aca9fecf')","ver":2.0}],"autoFmt":true,"id":"09203caa-91","type":"series_labels","fmt":"txt"}],"size":"3","sliceColors":["cx-theme_blue_4","cx-theme_violet_3","cx-theme_green_3","cx-theme_yellow_green_4","cx-theme_green_5","cx-theme_violet_2","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart","id":"9a5aa6e1-89","type":"chart_pie","dstContext":{"ops":[{"sortBy":[{"dim":"b903893690","dir":2.0}],"type":"sort"}],"kid":"ee9b98e11749602acb4374bdd229a7ed","id":"dst9a5aa6e189"},"overrideColors":true},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["1362969/5/12","2684560/8/4","963540/10/31","1565416/11/16","289118/5/29","998537/6/6","1808864/5/19","476828/10/8","519796/3/28","840914/10/22","2282171/6/6","2250591/1/8","8148/2/25","1108463/12/22","443596/1/24","1367014/4/15","1729833/7/3","1599558/9/24","507059/5/14","1550227/11/7","1794573/2/3","2162710/3/6","901261/1/3","998950/5/20","811748/5/24","2298592/9/23","1403357/5/14","1360101/1/4","2419297/12/20","2340346/10/9","1446950/7/25","2490456/3/22","389353/11/22","902930/8/28","2666856/6/16","1618397/11/2","1154383/11/30","2330183/12/14","1993069/10/30","2449284/3/26","1905708/5/5","1343102/6/20","141902/11/17","734748/12/23","2160888/10/29","1017913/9/17","669560/8/23","669915/7/28","1133606/11/11","1676140/5/6","2255007/6/25","1355170/12/13","2042334/11/18","2340070/1/16","1002486/7/21","1914149/11/25","774506/2/4","1269937/2/21","2099459/10/8","658264/11/11","879213/5/28","2558017/1/16","1123105/12/12","1241986/11/13","981662/10/10","1379781/11/21","1743877/7/17","1409711/7/11","630754/8/27","2164055/11/13","505578/8/10","1968862/7/14","141831/11/25","2079459/5/22","1814554/5/28","1295847/5/11","1863788/11/20","415001/1/24","634705/4/25","987677/9/27","1246528/9/20","824904/2/11","271998/2/6","2267843/8/30","1827189/9/14","210569/10/31","1530484/5/16","2505083/4/27","1040240/3/17","1214104/6/26","1769428/8/26","857317/3/23","1076862/12/30","975555/7/8","32706/6/8","1470963/6/24","2258321/11/15","2058282/1/20","2019605/8/27","1538617/12/16"]],"displayName":"ID","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Sales,A:A;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"yyyy/M/d","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"yyyy/M/d","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"ID","id":"eb53f388"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Aug 17, 2020","May 22, 2020","Jul 29, 2020","Jul 13, 2020","Mar 14, 2020","Apr 19, 2020","Jun 6, 2020","Jun 15, 2020","Aug 11, 2020","Jun 10, 2020","Jun 10, 2020","Apr 20, 2020","Jul 21, 2020","May 15, 2020","Oct 17, 2020","May 19, 2020","Aug 3, 2020","Apr 9, 2020","Sep 5, 2020","Jun 4, 2020","May 2, 2020","Mar 31, 2020","Aug 11, 2020","Sep 2, 2020","Oct 7, 2020","Sep 23, 2020","Apr 17, 2020","May 9, 2020","Apr 27, 2020","Jul 17, 2020","Aug 21, 2020","Mar 7, 2020","Jul 13, 2020","Sep 24, 2020","Sep 15, 2020","Jun 28, 2020","Oct 7, 2020","Mar 29, 2020","Apr 28, 2020","Jun 7, 2020","Aug 15, 2020","Mar 19, 2020","Jul 14, 2020","Jul 26, 2020","Sep 6, 2020","Jul 11, 2020","May 21, 2020","Mar 29, 2020","Sep 28, 2020","Aug 31, 2020","May 29, 2020","Sep 17, 2020","Aug 11, 2020","Mar 7, 2020","Sep 7, 2020","Mar 23, 2020","Oct 15, 2020","Jun 3, 2020","Apr 15, 2020","Aug 13, 2020","Jul 9, 2020","May 18, 2020","Apr 15, 2020","Sep 15, 2020","Sep 18, 2020","Aug 23, 2020","Jun 18, 2020","Mar 16, 2020","Apr 1, 2020","Apr 23, 2020","Mar 6, 2020","Sep 15, 2020","Sep 8, 2020","Apr 24, 2020","May 6, 2020","Aug 13, 2020","Mar 24, 2020","Jul 10, 2020","Oct 15, 2020","Aug 4, 2020","Aug 19, 2020","Apr 19, 2020","Jul 18, 2020","Jul 7, 2020","Jun 7, 2020","Oct 4, 2020","May 6, 2020","May 25, 2020","Oct 13, 2020","Oct 5, 2020","May 20, 2020","Mar 29, 2020","Oct 2, 2020","Jul 23, 2020","Aug 5, 2020","Apr 15, 2020","Jun 22, 2020","Mar 14, 2020","Apr 10, 2020","May 1, 2020"]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(a2d75942456c71f47060d9f50d075fd4@Sales,B:B;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"e872adb9"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["17 Aug 2020","22 May 2020","29 Jul 2020","13 Jul 2020","14 Mar 2020","19 Apr 2020","6 Jun 2020","15 Jun 2020","11 Aug 2020","10 Jun 2020","10 Jun 2020","20 Apr 2020","21 Jul 2020","15 May 2020","17 Oct 2020","19 May 2020","3 Aug 2020","9 Apr 2020","5 Sep 2020","4 Jun 2020","2 May 2020","31 Mar 2020","11 Aug 2020","2 Sep 2020","7 Oct 2020","23 Sep 2020","17 Apr 2020","9 May 2020","27 Apr 2020","17 Jul 2020","21 Aug 2020","7 Mar 2020","13 Jul 2020","24 Sep 2020","15 Sep 2020","28 Jun 2020","7 Oct 2020","29 Mar 2020","28 Apr 2020","7 Jun 2020","15 Aug 2020","19 Mar 2020","14 Jul 2020","26 Jul 2020","6 Sep 2020","11 Jul 2020","21 May 2020","29 Mar 2020","28 Sep 2020","31 Aug 2020","29 May 2020","17 Sep 2020","11 Aug 2020","7 Mar 2020","7 Sep 2020","23 Mar 2020","15 Oct 2020","3 Jun 2020","15 Apr 2020","13 Aug 2020","9 Jul 2020","18 May 2020","15 Apr 2020","15 Sep 2020","18 Sep 2020","23 Aug 2020","18 Jun 2020","16 Mar 2020","1 Apr 2020","23 Apr 2020","6 Mar 2020","15 Sep 2020","8 Sep 2020","24 Apr 2020","6 May 2020","13 Aug 2020","24 Mar 2020","10 Jul 2020","15 Oct 2020","4 Aug 2020","19 Aug 2020","19 Apr 2020","18 Jul 2020","7 Jul 2020","7 Jun 2020","4 Oct 2020","6 May 2020","25 May 2020","13 Oct 2020","5 Oct 2020","20 May 2020","29 Mar 2020","2 Oct 2020","23 Jul 2020","5 Aug 2020","15 Apr 2020","22 Jun 2020","14 Mar 2020","10 Apr 2020","1 May 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($TM_DateGroup,\"d\",DATEVALUE(!'e872adb9',\"d MMM yyyy\"),\"m\",DATEVALUE(!'e872adb9',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"8902df9f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Product A","Product B","Product C","Product E","Product A","Product B","Product A","Product D","Product B","Product C","Product B","Product A","Product D","Product C","Product C","Product B","Product D","Product D","Product B","Product C","Product A","Product C","Product C","Product C","Product A","Product D","Product D","Product F","Product A","Product C","Product A","Product D","Product A","Product C","Product B","Product C","Product A","Product C","Product E","Product B","Product E","Product F","Product B","Product C","Product C","Product B","Product A","Product D","Product B","Product F","Product C","Product C","Product B","Product C","Product E","Product B","Product A","Product D","Product D","Product D","Product D","Product C","Product B","Product B","Product C","Product C","Product B","Product B","Product C","Product F","Product D","Product A","Product D","Product D","Product D","Product D","Product C","Product B","Product A","Product C","Product C","Product C","Product E","Product B","Product F","Product C","Product D","Product B","Product D","Product B","Product D","Product C","Product A","Product B","Product B","Product B","Product C","Product B","Product A","Product B"]],"displayName":"Product","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Sales,E:E;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Product","id":"aca9fecf"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["3689.64","526.35","1566.07","3522.31","1861.11","1647","4569.6","742.02","535.78","583.1","4044.45","284.26","503.97","3705","807.95","257.25","633.6","3925.44","1334.72","621.12","4967.91","2566.34","364.8","2867.4","1987.62","1285.24","2328.48","333.27","5036.59","3351.74","778.94","1282.7","3214.89","416.34","2596.16","5994","2951.44","2868.24","3276","760.32","2002","5920.2","1607.87","1805.15","3799.98","701.49","4831.32","3284.4","953.04","1251.6","1292.76","2992.08","572.24","731.85","4922.96","2975.78","1952.28","2391.66","3969.7","2583.35","1067.52","749.32","6752.1","1546.14","1873.71","3868.07","1837.74","605.68","508.38","3470.4","969.24","2679.72","6121.96","2547.6","4929.83","4105.46","7217.1","3080.72","3739.2","3334.31","295.96","791.43","6247.2","179.2","1987.39","3469.04","1643.2","506.6","968","1683.65","4239.8","1332.66","2308.28","1486.8","588.28","2716","4163.13","2278.55","3125.12","342.86"]],"displayName":"Sales Value","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Sales,F:F;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales Value","id":"f8841f55"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["666","121","253","451","339","270","896","498","178","170","885","61","471","494","143","175","120","752","172","647","867","322","76","531","633","254","432","63","731","623","158","202","567","257","488","925","467","629","546","704","572","715","311","457","681","201","978","920","264","420","162","546","311","255","596","779","612","774","530","305","128","286","951","353","573","503","843","226","229","720","591","326","793","660","799","881","990","388","456","763","151","111","760","128","353","412","632","85","484","223","986","266","772","472","77","350","907","995","608","79"]],"displayName":"COS","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Sales,D:D;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":5.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"COS","id":"f7785b0d"}],"displayName":"Table","id":"8f877d32","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","dim":"e872adb9","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}},{"op":"<=","dim":"e872adb9","type":"op","value":{"var":"dateEnd"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"e872adb9","variation":"condition"}],"kid":"ee9b98e11749602acb4374bdd229a7ed","id":"dst8f877d32"}}],"isForked":false,"id":"a013d34b2b1de81281cd65c7db844472","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Top Products","usesSampleData":false,"master":"ee9b98e11749602acb4374bdd229a7ed"}]}]