[{"tab":{"id":"9112418a69cf8d12f50e02a963b72333","name":"Essential Metrics","layoutType":"grid","state":{"desktop":{"itemConfigs":[{"minHeight":238,"colSpan":6,"index":[0,0],"id":"gridklip-6dd9174c3ef832010e077b147fe5df41"},{"minHeight":79,"colSpan":6,"index":[0,1],"id":"gridklip-0a517fae67b601ef7006e753d8e7f74a"},{"minHeight":116,"colSpan":6,"index":[0,2],"id":"gridklip-8b3faedda442b5d33c5cb3a148c2c649"},{"minHeight":424,"colSpan":6,"index":[0,3],"id":"gridklip-7c0c6d1a88465b20058b2e2ba56ca244"},{"minHeight":498,"colSpan":2,"index":[0,4],"id":"gridklip-7d308c9952daac2898dce539a9fb5c57","height":508.994140625},{"minHeight":651,"colSpan":3,"index":[0,5],"id":"gridklip-a13b7a860f60bff9174932d72155d307"},{"minHeight":526,"colSpan":6,"index":[0,6],"id":"gridklip-bac33ac7991e71bb2a294f330d75a19d"},{"minHeight":471,"colSpan":3,"index":[0,7],"id":"gridklip-6e1a375077623de3c799cb7b90d03191"},{"minHeight":453,"colSpan":6,"index":[0,8],"id":"gridklip-0d834eaae5feff843e64c2cf923e76a9"},{"minHeight":314,"colSpan":6,"index":[0,9],"id":"gridklip-713a696e47b463b05be09a87d65343b9"},{"minHeight":406,"colSpan":4,"index":[2,4],"id":"gridklip-8c3ebee0f40c41d7f91f26d97bdb5077","height":509},{"minHeight":608,"colSpan":3,"index":[3,5],"id":"gridklip-baf74582f518d519ef9f8c25aefe1514","height":653.0000305175781},{"minHeight":471,"colSpan":3,"index":[3,7],"id":"gridklip-075c86cfdddcc486b8b20b4b869df1b5"}],"colWidths":["auto","auto","auto","auto","auto","auto"],"cols":6}},"master":"9112418a69cf8d12f50e02a963b72333"},"klips":[{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":550.0}},"components":[{"size":"large","data":[["ESSENTIAL 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":"\"ESSENTIAL METRICS DASHBOARD\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"32d5c3c6","type":"label","fmt":"txt","dstContext":{"kid":"b6413c0a79109b2bd80df224d8d46b52","id":"dst32d5c3c6"},"align":"c","wrap":true}],"isForked":false,"id":"0a517fae67b601ef7006e753d8e7f74a","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Sales Dashboard Title","usesSampleData":false,"master":"b6413c0a79109b2bd80df224d8d46b52"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":2113.0}},"components":[{"components":[],"displayName":"Layout Grid 2","id":"ec0ba0f5-1","type":"panel_grid","rows":2.0,"cols":3.0},{"components":[{"data":[["Common Systems: "]],"displayName":"Label","formulas":[{"txt":"\"Common Systems: \"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_000","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst6440a8ef1"},"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":"6440a8ef-1","wrap":true},{"layoutConfig":{"x":1.0,"y":0.0},"tpl":"

\n $\"Aroflo\"</img$ \n

","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"ceb3ab51-2","type":"html_data","dstContext":{"id":"dstceb3ab512"}}],"displayName":"HTML Template 2","id":"2433ee5d-1","type":"html_tpl2","dstContext":{"id":"dst2433ee5d1"}},{"enableClick":false,"data":[["https://dashboardmagic.com.au/wp-content/uploads/2022/03/Simpro_logo.png"]],"horizAlign":1.0,"displayName":"Image Copy","formulas":[{"txt":"\"https://dashboardmagic.com.au/wp-content/uploads/2022/03/Simpro_logo.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst7d2b1ca6"},"layoutConfig":{"x":2.0,"y":0.0},"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":"7d2b1ca6","customHeightVal":"25","height":"cust"},{"enableClick":false,"data":[["https://cdn.shopify.com/s/files/1/0549/8757/files/ServiceM8_Logo_Vertical_large.png?v=1522805104"]],"horizAlign":1.0,"displayName":"Image 4","formulas":[{"txt":"\"https://cdn.shopify.com/s/files/1/0549/8757/files/ServiceM8_Logo_Vertical_large.png?v=1522805104\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst42a279372"},"layoutConfig":{"x":3.0,"y":0.0},"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":"42a27937-2","customHeightVal":"50","height":"cust"},{"enableClick":false,"data":[["https://tradiewives.com.au/wp-content/uploads/2021/05/TT-logo-big-orange-500x160.png"]],"horizAlign":1.0,"displayName":"Image 5","formulas":[{"txt":"\"https://tradiewives.com.au/wp-content/uploads/2021/05/TT-logo-big-orange-500x160.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst663306a43"},"layoutConfig":{"x":4.0,"y":0.0},"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":"663306a4-3","customHeightVal":"50","height":"cust"},{"enableClick":false,"data":[["https://www.buildxact.com/wp-content/uploads/logo-horiz-dark.svg"]],"horizAlign":1.0,"displayName":"Image Copy 2","formulas":[{"txt":"\"https://www.buildxact.com/wp-content/uploads/logo-horiz-dark.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dstb8c8156f"},"layoutConfig":{"x":5.0,"y":0.0},"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":"b8c8156f","customHeightVal":"30","height":"cust"},{"enableClick":false,"data":[["https://www.assignar.com/wp-content/uploads/2018/09/logo-banner-200-t.png"]],"horizAlign":1.0,"displayName":"Image Copy 3","formulas":[{"txt":"\"https://www.assignar.com/wp-content/uploads/2018/09/logo-banner-200-t.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst11873fab"},"layoutConfig":{"x":6.0,"y":0.0},"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":"11873fab","customHeightVal":"25","height":"cust"},{"enableClick":false,"data":[["https://app.klipfolio.com/assets/file_cached/5f866fdfea968804e9c95b54/image3155776258136118639.png"]],"horizAlign":1.0,"displayName":"Image 2","formulas":[{"txt":"\"https://app.klipfolio.com/assets/file_cached/5f866fdfea968804e9c95b54/image3155776258136118639.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dstda3d79784"},"layoutConfig":{"x":7.0,"y":0.0},"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":"da3d7978-4","customHeightVal":"35","height":"cust"},{"enableClick":false,"data":[["https://dashboardmagic.com.au/wp-content/uploads/2022/03/MYOB_logo.png"]],"horizAlign":1.0,"displayName":"Image 2 Copy","formulas":[{"txt":"\"https://dashboardmagic.com.au/wp-content/uploads/2022/03/MYOB_logo.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst943e0cfe"},"layoutConfig":{"x":8.0,"y":0.0},"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":"943e0cfe","customHeightVal":"30","height":"cust"},{"enableClick":false,"data":[["https://app.klipfolio.com/assets/file_cached/5b2978efc1c0900f493536a6/image5502353411254158712.png"]],"horizAlign":1.0,"displayName":"Image 2 Copy 2","formulas":[{"txt":"\"https://app.klipfolio.com/assets/file_cached/5b2978efc1c0900f493536a6/image5502353411254158712.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst38a049fe"},"layoutConfig":{"x":9.0,"y":0.0},"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":"38a049fe","customHeightVal":"30","height":"cust"},{"enableClick":false,"data":[["https://cdn-icons-png.flaticon.com/512/2991/2991114.png"]],"horizAlign":1.0,"displayName":"Image 2 Copy 4","formulas":[{"txt":"\"https://cdn-icons-png.flaticon.com/512/2991/2991114.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dstc496db73"},"layoutConfig":{"x":10.0,"y":0.0},"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":"c496db73","customHeightVal":"35","height":"cust"},{"enableClick":false,"data":[["https://upload.wikimedia.org/wikipedia/commons/thumb/3/34/Microsoft_Office_Excel_%282019%E2%80%93present%29.svg/826px-Microsoft_Office_Excel_%282019%E2%80%93present%29.svg.png"]],"horizAlign":1.0,"displayName":"Image 3","formulas":[{"txt":"\"https://upload.wikimedia.org/wikipedia/commons/thumb/3/34/Microsoft_Office_Excel_%282019%E2%80%93present%29.svg/826px-Microsoft_Office_Excel_%282019%E2%80%93present%29.svg.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst13608d271"},"layoutConfig":{"x":11.0,"y":0.0},"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":"13608d27-1","customHeightVal":"30","height":"cust"},{"enableClick":false,"data":[["https://www.smartsheet.com/sites/default/files/smartsheet-logo-blue-new.svg"]],"horizAlign":1.0,"displayName":"Image 2 Copy 3","formulas":[{"txt":"\"https://www.smartsheet.com/sites/default/files/smartsheet-logo-blue-new.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dste301db07"},"layoutConfig":{"x":12.0,"y":0.0},"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":"e301db07","customHeightVal":"35","height":"cust"},{"enableClick":false,"data":[["https://upload.wikimedia.org/wikipedia/commons/thumb/c/c6/Monday_logo.svg/1200px-Monday_logo.svg.png"]],"horizAlign":1.0,"displayName":"Image 6","formulas":[{"txt":"\"https://upload.wikimedia.org/wikipedia/commons/thumb/c/c6/Monday_logo.svg/1200px-Monday_logo.svg.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst0608a83c4"},"layoutConfig":{"x":13.0,"y":0.0},"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":"0608a83c-4","customHeightVal":"35","height":"cust"},{"enableClick":false,"data":[["https://upload.wikimedia.org/wikipedia/commons/5/5d/Pipedrive_Logo.svg"]],"horizAlign":1.0,"displayName":"Image 7","formulas":[{"txt":"\"https://upload.wikimedia.org/wikipedia/commons/5/5d/Pipedrive_Logo.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dst2cd7fc505"},"layoutConfig":{"x":14.0,"y":0.0},"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":"2cd7fc50-5","customHeightVal":"35","height":"cust"},{"enableClick":false,"data":[["https://www.tnab.com.au/app/uploads/deputy-logo-full-color-rgb.png"]],"horizAlign":1.0,"displayName":"Image 8","formulas":[{"txt":"\"https://www.tnab.com.au/app/uploads/deputy-logo-full-color-rgb.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"type":"image","fmt":"txt","dstContext":{"kid":"067e0430db8137797d179c5b54f4669d","id":"dstac2d9f646"},"layoutConfig":{"x":15.0,"y":0.0},"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":"ac2d9f64-6","customHeightVal":"30","height":"cust"}],"displayName":"Layout Grid","widths":[{"w":"10%","x":0.0}],"id":"76cc75e6-2","cellData":[{"x":2.0,"y":0.0,"alignment":1.0},{"x":5.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":0.0,"alignment":1.0},{"x":6.0,"y":0.0,"alignment":1.0},{"x":7.0,"y":0.0,"alignment":1.0},{"x":8.0,"y":0.0,"alignment":1.0},{"x":10.0,"y":0.0,"alignment":1.0},{"x":12.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":0.0,"alignment":1.0},{"x":9.0,"y":0.0,"alignment":1.0},{"x":11.0,"y":0.0,"alignment":1.0},{"x":13.0,"y":0.0,"alignment":1.0},{"x":14.0,"y":0.0,"alignment":1.0},{"x":15.0,"y":0.0,"alignment":1.0},{"x":4.0,"y":0.0,"alignment":1.0},{"x":3.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":1.0,"cols":16.0},{"components":[],"displayName":"Layout Grid 3","id":"710929c3-2","type":"panel_grid","rows":2.0,"cols":3.0},{"tpl":"

We can get data from 99% of systems.

Let us know to see what we can do for your business.

\n\n

\nEmail: hello@dashboardmagic.com.au \nPhone: +613 9917 3737\n

\n","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"ae75038a-3","type":"html_data","dstContext":{"id":"dstae75038a3"}}],"displayName":"HTML Template","id":"eda5520f-2","type":"html_tpl2","dstContext":{"id":"dsteda5520f2"}}],"containerClassName":"metric","isForked":false,"id":"713a696e47b463b05be09a87d65343b9","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Construction NEW - Footer","usesSampleData":false,"master":"067e0430db8137797d179c5b54f4669d"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","896d40192f78f580758b903336f9a4e6"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["The number of leads acquired from each channel. This shows us which marketing channels are performing best in terms of lead generation."]],"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 leads acquired from each channel. This shows us which marketing channels are performing best in terms of lead generation.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"488a9e5d","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"3afe4fd9ad4e9fb8f6f5dd94b923716c","id":"dst488a9e5d"},"wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"displayName":"Separator","id":"4dd5eeb0","type":"separator"},{"components":[{"showValues":true,"role":"series","data":[[1.6,0.3,1.1,0.0,1.4,0.5,0.8,1.9,0.0,0.2,2.2,0.0,1.2,1.6,0.0,1.0,1.8,0.5,0.4,0.0,0.0,0.6,0.6,2.0,1.8,0.0,0.1,1.6,0.0,0.1,0.9]],"displayName":"Email","seriesName":"Email","formulas":[{"txt":"lookup(&'4c653784',group(SELECT(&'6085b462',&'9dcf5d45'=\"Email\")),groupby(SELECT(&'6085b462',&'9dcf5d45'=\"Email\"),SELECT(&'afb31599',&'9dcf5d45'=\"Email\"),\"sum(values)\"))/10","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"6704bcce","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"19e8015f","renamed":true},{"showValues":true,"role":"series","data":[["",0.0,15.0,"",4.0,3.0,"",6.0,3.0,10.0,"",7.0,1.0,13.0,"",9.0,5.0,"",12.0,19.0,"",6.0,1.0,7.0,8.0,10.0,5.0,3.0,17.0,4.0,22.0]],"color":"cx-theme_blue_3","displayName":"Facebook","seriesName":"Facebook","formulas":[{"txt":"lookup(&'4c653784',group(SELECT(&'6085b462',&'9dcf5d45'=\"Facebook\")),groupby(SELECT(&'6085b462',&'9dcf5d45'=\"Facebook\"),SELECT(&'afb31599',&'9dcf5d45'=\"Facebook\"),\"sum(values)\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"6704bcce","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"d2a7d369-38"},{"showValues":true,"role":"series","data":[[3.0,"","",10.0,"",9.0,"",6.0,5.0,9.0,"",6.0,14.0,"","","",9.0,3.0,0.0,"",5.0,3.0,"","","","",6.0,10.0,10.0,10.0,14.0]],"color":"cx-theme_green_3","displayName":"Google Ads","seriesName":"Google Ads","formulas":[{"txt":"lookup(&'4c653784',group(SELECT(&'6085b462',&'9dcf5d45'=\"Google Ads\")),groupby(SELECT(&'6085b462',&'9dcf5d45'=\"Google Ads\"),SELECT(&'afb31599',&'9dcf5d45'=\"Google Ads\"),\"sum(values)\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"6704bcce","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"cb6fb1a6-39"},{"showValues":true,"role":"series","data":[["","",8.0,3.0,"",7.0,9.0,7.0,"","","",2.0,"",1.0,"","","","",8.0,"","",2.0,2.0,2.0,"",2.0,8.0,14.0,2.0,"",""]],"color":"cx-theme_violet_3","displayName":"Instagram","seriesName":"Instagram","formulas":[{"txt":"lookup(&'4c653784',group(SELECT(&'6085b462',&'9dcf5d45'=\"Instagram\")),groupby(SELECT(&'6085b462',&'9dcf5d45'=\"Instagram\"),SELECT(&'afb31599',&'9dcf5d45'=\"Instagram\"),\"sum(values)\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"6704bcce","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"923c8171-40"},{"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":"4c653784","label":"Untitled","type":"chart_axis","fmt":"dat2","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"id":"6704bcce","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Goals","formulas":[],"autoFmt":true,"axisPosition":"right","id":"b8637b94","label":"Goals","type":"chart_axis","fmt":"num","labelDrop":0.0}],"displayName":"Bar/Line Chart","id":"a845dbb6","type":"chart_series","dstContext":{"kid":"3afe4fd9ad4e9fb8f6f5dd94b923716c","id":"dsta845dbb6"},"height":"3"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6300728E9,1.6452756E9,1.6292952E9,1.631628E9,1.6494264E9,1.6547832E9,1.6360308E9,1.6560792E9,1.6490808E9,1.642338E9,1.6425972E9,1.6433748E9,1.6297272E9,1.6321464E9,1.6279128E9,1.6450164E9,1.6313688E9,1.6439796E9,1.6438068E9,1.6511544E9,1.6390548E9,1.6291224E9,1.6305048E9,1.6330104E9,1.6269624E9,1.6467444E9,1.6413012E9,1.6275672E9,1.6297272E9,1.6492536E9,1.64934E9,1.6467444E9,1.6564248E9,1.647954E9,1.6382772E9,1.6511544E9,1.6346484E9,1.6376724E9,1.6503768E9,1.6557336E9,1.6313688E9,1.6470036E9,1.6468308E9,1.6328376E9,1.6577208E9,1.6362036E9,1.6565112E9,1.6445844E9,1.6330104E9,1.6346484E9,1.6513272E9,1.6330968E9,1.6540056E9,1.637154E9,1.6265304E9,1.6522776E9,1.6314552E9,1.6306776E9,1.6533144E9,1.6574616E9,1.6499448E9,1.6565112E9,1.646226E9,1.6312824E9,1.657116E9,1.648818E9,1.655388E9,1.6553016E9,1.6477812E9,1.641906E9,1.6473492E9,1.650636E9,1.6509816E9,1.634994E9,1.6372404E9,1.6343028E9,1.6304184E9,1.626876E9,1.6402644E9,1.6507224E9,1.64277E9,1.6514136E9,1.648818E9,1.6551288E9,1.6446708E9,1.6369812E9,1.6298136E9,1.6353396E9,1.6557336E9,1.641906E9,1.6486452E9,1.6336116E9,1.630764E9,1.6477812E9,1.648386E9,1.6518456E9,1.657116E9,1.637154E9,1.63845E9,1.644066E9]],"displayName":"Date_Raw","formulas":[{"txt":"DATE_ADD(slice(date(896d40192f78f580758b903336f9a4e6@Marketing,A:A;,\"yyyy/MM/dd\")),\"5\",4)","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.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":{},"defaultAggregate":"COUNT","fmt":"txt"}},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"03868dc3"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["28 Aug 2021","20 Feb 2022","19 Aug 2021","15 Sep 2021","9 Apr 2022","10 Jun 2022","5 Nov 2021","25 Jun 2022","5 Apr 2022","17 Jan 2022","20 Jan 2022","29 Jan 2022","24 Aug 2021","21 Sep 2021","3 Aug 2021","17 Feb 2022","12 Sep 2021","5 Feb 2022","3 Feb 2022","29 Apr 2022","10 Dec 2021","17 Aug 2021","2 Sep 2021","1 Oct 2021","23 Jul 2021","9 Mar 2022","5 Jan 2022","30 Jul 2021","24 Aug 2021","7 Apr 2022","8 Apr 2022","9 Mar 2022","29 Jun 2022","23 Mar 2022","1 Dec 2021","29 Apr 2022","20 Oct 2021","24 Nov 2021","20 Apr 2022","21 Jun 2022","12 Sep 2021","12 Mar 2022","10 Mar 2022","29 Sep 2021","14 Jul 2022","7 Nov 2021","30 Jun 2022","12 Feb 2022","1 Oct 2021","20 Oct 2021","1 May 2022","2 Oct 2021","1 Jun 2022","18 Nov 2021","18 Jul 2021","12 May 2022","13 Sep 2021","4 Sep 2021","24 May 2022","11 Jul 2022","15 Apr 2022","30 Jun 2022","3 Mar 2022","11 Sep 2021","7 Jul 2022","2 Apr 2022","17 Jun 2022","16 Jun 2022","21 Mar 2022","12 Jan 2022","16 Mar 2022","23 Apr 2022","27 Apr 2022","24 Oct 2021","19 Nov 2021","16 Oct 2021","1 Sep 2021","22 Jul 2021","24 Dec 2021","24 Apr 2022","22 Jan 2022","2 May 2022","2 Apr 2022","14 Jun 2022","13 Feb 2022","16 Nov 2021","25 Aug 2021","28 Oct 2021","21 Jun 2022","12 Jan 2022","31 Mar 2022","8 Oct 2021","5 Sep 2021","21 Mar 2022","28 Mar 2022","7 May 2022","7 Jul 2022","18 Nov 2021","3 Dec 2021","6 Feb 2022"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'03868dc3',\"d MMM yyyy\"),\"m\",DATEVALUE(!'03868dc3',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.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":"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":"6085b462"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Facebook","Google Ads","Email","Facebook","Email","Email","Email","Facebook","Facebook","Email","Email","Email","Facebook","Google Ads","Facebook","Email","Email","Email","Instagram","Instagram","Email","Instagram","Instagram","Google Ads","Instagram","Google Ads","Facebook","Instagram","Facebook","Email","Google Ads","Email","Email","Email","Facebook","Facebook","Facebook","Email","Google Ads","Instagram","Facebook","Google Ads","Email","Google Ads","Email","Email","Email","Email","Instagram","Instagram","Facebook","Google Ads","Email","Google Ads","Facebook","Instagram","Facebook","Email","Google Ads","Email","Email","Google Ads","Instagram","Email","Email","Instagram","Instagram","Instagram","Google Ads","Email","Email","Email","Email","Instagram","Email","Email","Instagram","Facebook","Email","Facebook","Google Ads","Email","Google Ads","Google Ads","Facebook","Email","Google Ads","Facebook","Email","Email","Instagram","Google Ads","Email","Instagram","Instagram","Facebook","Facebook","Instagram","Email","Email"]],"displayName":"Channel","formulas":[{"txt":"slice(896d40192f78f580758b903336f9a4e6@Marketing,B:B;)","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":"Channel","id":"9dcf5d45"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[8.0,5.0,7.0,0.0,2.0,3.0,1.0,5.0,8.0,3.0,5.0,1.0,7.0,8.0,9.0,8.0,10.0,4.0,6.0,7.0,7.0,1.0,1.0,2.0,7.0,8.0,6.0,2.0,7.0,7.0,7.0,5.0,1.0,2.0,1.0,7.0,8.0,4.0,7.0,7.0,0.0,0.0,4.0,4.0,9.0,4.0,9.0,10.0,8.0,9.0,0.0,10.0,1.0,6.0,5.0,7.0,3.0,3.0,5.0,10.0,9.0,2.0,10.0,6.0,10.0,8.0,3.0,4.0,5.0,1.0,10.0,9.0,0.0,7.0,6.0,2.0,9.0,9.0,4.0,0.0,5.0,1.0,9.0,3.0,5.0,5.0,9.0,1.0,1.0,6.0,1.0,4.0,5.0,5.0,6.0,8.0,1.0,5.0,4.0,1.0]],"displayName":"Leads","formulas":[{"txt":"ROUND(slice(896d40192f78f580758b903336f9a4e6@Marketing,F:F;/10))","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":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":"Leads","id":"afb31599"}],"displayName":"Table Copy","id":"f602e873","type":"table","dstContext":{"ops":[],"kid":"3afe4fd9ad4e9fb8f6f5dd94b923716c","id":"dstf602e873"}}],"isForked":false,"id":"7c0c6d1a88465b20058b2e2ba56ca244","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Leads by Channel","usesSampleData":false,"master":"3afe4fd9ad4e9fb8f6f5dd94b923716c"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[],"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":"\"A list of reasons as to why we lost sales.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"bb44927c","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"2b87dbcc759e79edf884e6637e71e5e7","id":"dstbb44927c"},"wrap":true},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"data","data":[],"displayName":"Values","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"}},"formulas":[{"txt":"&'6001035f'","ver":2.0}],"autoFmt":true,"id":"5270f123","type":"series_data","fmt":"num"},{"role":"labels","data":[],"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":"&'9be7424c'","ver":2.0}],"autoFmt":true,"id":"6db10699","type":"series_labels","fmt":"txt"}],"size":2.0,"displayName":"Pie Chart","id":"1d36def9","type":"chart_pie","dstContext":{"kid":"2b87dbcc759e79edf884e6637e71e5e7","id":"dst1d36def9"}},{"layoutConfig":{"x":1.0,"y":0.0},"orientation":"v","displayName":"Separator","id":"8a5aa79a","type":"separator"},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"components":[{"role":"customHeader","data":[],"displayName":"Lost Reason","formulas":[{"txt":"\"Reason\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"2b87dbcc759e79edf884e6637e71e5e7","id":"dste7e9a29a"},"align":"c","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"e7e9a29a","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_red_5"}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Lost Reason","formulas":[{"txt":"ARRAY(\"budget, not ideal fit, lost to competitor, decided not to proceed, other\")","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"txt","align":"c","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":"9be7424c","conditions":[{"predicates":[{"left":{"cx":"6001035f"},"right":{"raw":"10"},"type":"gteq"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_red_1"}]}],"renamed":true},{"components":[{"role":"customHeader","data":[],"displayName":"Occurances","formulas":[{"txt":"\"Occurances\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"2b87dbcc759e79edf884e6637e71e5e7","id":"dst5d61cd91"},"align":"r","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"5d61cd91","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_red_5"}]}],"wrap":false}],"customHeader":true,"role":"tcol","data":[],"displayName":"Occurances","formulas":[{"txt":"ARRAY(\"6,12,3,5,9\")","ver":2.0}],"autoFmt":true,"index":1.0,"type":"table_col","fmt":"num","align":"c","fw":"fixed","size":"x-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"}},"w":"25%","name":"Occurances","id":"6001035f","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"10"},"type":"gteq"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_red_1"}]}]}],"maxRows":"10","displayName":"Table 2","id":"b09084fb","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"args":[{"dim":"9be7424c"},{"value":"\"\""}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"}],"f":"not","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"9be7424c","variation":"condition"},{"sortBy":[{"dim":"6001035f","dir":2.0}],"type":"sort"}],"kid":"501dc74fe7617bf91b4f2235075b4c13","id":"dstb09084fb"}}],"displayName":"Layout Grid","widths":[{"w":30.0,"x":1.0}],"id":"5c6ee2bf","cellData":[{"x":1.0,"h":1.0,"y":0.0},{"x":0.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":3.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"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":"4d61fdb6"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"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":"4a4d0ba3"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Date","formulas":[{"txt":"SWITCH($TM_DateGroup,\"d\",DATEVALUE(!'4a4d0ba3',\"d MMM yyyy\"),\"m\",DATEVALUE(!'4a4d0ba3',\"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":"37d28ada"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Customer","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Sales,K:K;)","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":"Customer","id":"1a45066e"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"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":"573cba0a"}],"displayName":"Table","id":"47840b28","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","dim":"4a4d0ba3","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}},{"op":"<=","dim":"4a4d0ba3","type":"op","value":{"var":"dateEnd"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"4a4d0ba3","variation":"condition"}],"kid":"501dc74fe7617bf91b4f2235075b4c13","id":"dst47840b28"}}],"isForked":false,"id":"075c86cfdddcc486b8b20b4b869df1b5","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Sales Lost Reasons","usesSampleData":false,"master":"501dc74fe7617bf91b4f2235075b4c13"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":2173.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"tpl":"","components":[{"mixin":"label","role":"data","data":[[]],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"c38dc0a2-2","type":"html_data","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dstc38dc0a22"}}],"displayName":"Klip Animation","id":"a0a8eef7-1","type":"html_tpl2","dstContext":{"id":"dsta0a8eef71"},"renamed":true},{"layoutConfig":{"x":1.0,"y":0.0},"tpl":"","components":[{"role":"data","data":[["Lato"]],"displayName":"Font","formulas":[{"txt":"\"Lato\"","ver":2.0}],"autoFmt":true,"type":"html_data","fmt":"txt","dstContext":{"kid":"685ef16df9cbec639ecf20b110cf9882","id":"dstc3e2c9aa2"},"mixin":"label","dataId":"Font","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"}},"isDstRoot":true,"id":"c3e2c9aa-2"}],"dataModelType":"arr","displayName":"Style","id":"c8c34857-1","type":"html_tpl2","dstContext":{"id":"dstc8c348571"},"renamed":true},{"layoutConfig":{"x":2.0,"y":0.0},"tpl":"

\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":"

\n hello@dashboardmagic.com.au\n

","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":"6dd9174c3ef832010e077b147fe5df41","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"685ef16df9cbec639ecf20b110cf9882"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9"],"dimensions":{"w":869.0}},"components":[{"components":[{"data":[],"displayName":"Label","formulas":[{"txt":"\"Filter all data on the dashboard based on date\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dst4c3052c2"},"layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","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":"4c3052c2","wrap":true},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[],"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":"fe884a91","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"78f4302d","type":"proxy"}],"displayName":"User Input Control 2","scope":2.0,"inputLabel":"Date Range","inputType":1.0,"id":"ee8d5cd7","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dstee8d5cd7"},"propName":"dateSelector"},{"layoutConfig":{"x":0.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[],"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":"cba944ef","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"1e3d369d","type":"proxy"}],"displayName":"User Input Control 5","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"002d5ab7","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dst002d5ab7"},"propName":"dateGroup"},{"layoutConfig":{"x":1.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[],"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":"5774230b","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"8c39f62c","type":"proxy"}],"displayName":"User Input Control 3","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"b770d644","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dstb770d644"},"propName":"dateStart"},{"layoutConfig":{"x":2.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[],"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":"da36f16e","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"6d279d93","type":"proxy"}],"displayName":"User Input Control 4","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"f3a63334","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dstf3a63334"},"propName":"dateEnd"}],"displayName":"Layout Grid","id":"4151d2e9","cellData":[{"w":2.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"8b3faedda442b5d33c5cb3a148c2c649","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Filters","usesSampleData":false,"master":"d7a87e7731b986e3a07be1ee69b3b0dd"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","896d40192f78f580758b903336f9a4e6"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["The return on Ad Spend (ROAS) displays how much you earn in sales for each dollar you spend on advertising. This is a key indicator of marketing performance."]],"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 return on Ad Spend (ROAS) displays how much you earn in sales for each dollar you spend on advertising. This is a key indicator of marketing performance.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"ffd70341","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"5ccebcc2e1df5c06f535051fb161a35c","id":"dstffd70341"},"wrap":true},{"components":[{"data":[["Revenue Split"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Revenue Split\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"5ccebcc2e1df5c06f535051fb161a35c","id":"dstd5fa12e7"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"small","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":"d5fa12e7","wrap":true},{"data":[["Return on Ad Spend (ROAS)"]],"displayName":"Label 2","formulas":[{"txt":"\"Return on Ad Spend (ROAS)\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"5ccebcc2e1df5c06f535051fb161a35c","id":"dst6d54747a37"},"align":"c","layoutConfig":{"x":1.0,"y":0.0},"size":"small","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":"6d54747a-37","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"data","data":[[75.34,61.300000000000004,10.86]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"formulas":[{"txt":"lookup(&'d4fd03d3-36',group(&'7235b2f3'),groupby(&'7235b2f3',&'310af725',\"sum(values)\"))","ver":2.0}],"autoFmt":false,"id":"913ddbd9-35","type":"series_data","fmt":"cur"},{"role":"labels","data":[["Email","Facebook","Google Ads"]],"displayName":"Labels","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(&'7235b2f3')","ver":2.0}],"autoFmt":true,"id":"d4fd03d3-36","type":"series_labels","fmt":"txt"}],"size":"2","sliceColors":["cx-theme_orange_3","cx-theme_blue_3","cx-theme_green_3","cx-theme_violet_3","cx-theme_red_3","cx-theme_brown_3","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart","id":"550d8d25-34","type":"chart_pie","dstContext":{"kid":"5ccebcc2e1df5c06f535051fb161a35c","id":"dst550d8d2534"},"overrideColors":true},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"showValues":true,"role":"series","data":[["Infinity",2.120190229139646,5.402985074626866]],"color":"cx-theme_yellow_green_4","displayName":"Return on Ad Spend","seriesName":"Return on Ad Spend","formulas":[{"txt":"lookup(&'cdf22868',group(&'7235b2f3'),groupby(&'7235b2f3',&'310af725',\"sum(values)\")) / lookup(&'cdf22868',group(&'7235b2f3'),groupby(&'7235b2f3',&'d652cda4',\"sum(values)\"))","ver":2.0}],"autoFmt":true,"leaveGaps":true,"type":"series_data","fmt":"num","axis":"5d9d25e8","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"precision":"1"},"id":"0579d898"},{"role":"axis_x","data":[["Email","Facebook","Google Ads"]],"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(&'7235b2f3')","ver":2.0}],"autoFmt":true,"id":"cdf22868","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"cur","grid":true,"id":"52d18ef5","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"1","displayName":"ROAS","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Untitled","type":"chart_axis","fmt":"num","fmtArgs":{"precision":"1"},"id":"5d9d25e8","customInterval":false,"labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","invertAxes":1.0,"id":"1b944ddf","type":"chart_series","dstContext":{"kid":"5ccebcc2e1df5c06f535051fb161a35c","id":"dst1b944ddf"},"height":"3"}],"displayName":"Layout Grid","id":"adcfd136-33","type":"panel_grid","rows":2.0,"cols":2.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Facebook","Email","Facebook","Google Ads","Email","Facebook","Email"]],"displayName":"Channel","formulas":[{"txt":"slice(896d40192f78f580758b903336f9a4e6@Marketing,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.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":"7235b2f3"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Nov 23, 2020","Nov 23, 2020","Nov 22, 2020","Nov 22, 2020","Nov 23, 2020","Nov 23, 2020","Nov 23, 2020"]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(896d40192f78f580758b903336f9a4e6@Marketing,A:A;,\"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":"9e7e1c21"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["33.96","20.32","20.14","10.86","8.84","7.2","46.18"]],"displayName":"Sales Value","formulas":[{"txt":"slice(896d40192f78f580758b903336f9a4e6@Marketing,E:E;)","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":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales Value","id":"310af725"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["11.6625","0","8.2375","2.01","0","9.0125","0"]],"displayName":"Cost","formulas":[{"txt":"slice(896d40192f78f580758b903336f9a4e6@Marketing,D:D;)","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":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":"Cost","id":"d652cda4"}],"displayName":"Table","id":"d7dcb222","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","dim":"9e7e1c21","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"9e7e1c21","variation":"condition"}],"kid":"5ccebcc2e1df5c06f535051fb161a35c","id":"dstd7dcb222"}}],"isForked":false,"id":"7d308c9952daac2898dce539a9fb5c57","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Total Attributed Revenue & ROAS","usesSampleData":false,"master":"5ccebcc2e1df5c06f535051fb161a35c"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","896d40192f78f580758b903336f9a4e6"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["The conversion rate from leads to sales. This is displayed over time, as well as an overall average vs a pre-determined target."]],"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 conversion rate from leads to sales. This is displayed over time, as well as an overall average vs a pre-determined target.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"0bd8cd38","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"0a5f4ae3cc33971bce5fd34fb12ac7de","id":"dst0bd8cd38"},"wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"displayName":"Separator","id":"e4ebdeea","type":"separator"},{"components":[{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"values","data":[["Anne Simmons","Jessica Walker","John Smith","Tim Warner","Tom Jones"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"GROUP(slice(d98626e5c469c95e0374d45ff0b5da2a@Sales,C:C;))","ver":2.0}],"autoFmt":false,"id":"b66c83e0-30","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"cff5ef72-31","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Salesperson","inputType":1.0,"id":"e1960ed9-29","includeAllData":true,"type":"input","dstContext":{"kid":"0a5f4ae3cc33971bce5fd34fb12ac7de","id":"dste1960ed929"},"propName":"salesPersonFilter"},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[["Email","Facebook","Google Ads","Instagram"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"GROUP(slice(896d40192f78f580758b903336f9a4e6@Marketing,B:B;))","ver":2.0}],"autoFmt":false,"id":"b78c2173-33","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"aed74715-34","type":"proxy"}],"displayName":"User Input Control 2","scope":1.0,"inputLabel":"Channel","inputType":1.0,"id":"4676847a-32","includeAllData":true,"type":"input","dstContext":{"kid":"0a5f4ae3cc33971bce5fd34fb12ac7de","id":"dst4676847a32"},"propName":"channelFilter"}],"displayName":"Layout Grid","id":"e00bf575-25","type":"panel_grid","rows":1.0,"cols":3.0},{"displayName":"Separator 3","id":"4b91e670-43","type":"separator"},{"data":[["Average Conversion Rate"]],"displayName":"Label 2","formulas":[{"txt":"\"Average Conversion Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"0a5f4ae3cc33971bce5fd34fb12ac7de","id":"dste1cecbf144"},"align":"c","size":"small","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":"e1cecbf1-44","wrap":true},{"components":[{"role":"current","size":"medium","data":[[0.09794826694547792]],"displayName":"Current Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"1"},"formulas":[{"txt":"AVERAGE(&'19050739')/100","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"id":"fdd7ded8-36","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"fdd7ded836"}],"kid":"0a5f4ae3cc33971bce5fd34fb12ac7de","id":"dstfdd7ded836","aggs":{"fdd7ded836":"sum","5ddf6f7837":"sum"}}},{"role":"target","size":"xx-small","data":[[0.15]],"displayName":"Target Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"formulas":[{"txt":"0.15","ver":2.0,"src":{"c":[{"t":"l","v":"80"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_888","id":"5ddf6f78-37","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"5ddf6f7837"}],"kid":"0a5f4ae3cc33971bce5fd34fb12ac7de","id":"dst5ddf6f7837","aggs":{"5ddf6f7837":"sum"}}},{"role":"min","data":[[0.0]],"displayName":"Min Value","formulas":[{"txt":"0","src":{"c":[{"t":"l","v":"0"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"d488d24038"}],"kid":"0a5f4ae3cc33971bce5fd34fb12ac7de","id":"dstd488d24038","aggs":{"d488d24038":"auto"}},"size":"xx-small","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"}},"id":"d488d240-38"},{"role":"max","size":"xx-small","data":[],"displayName":"Max Value","formulas":[],"autoFmt":true,"font_colour":"cx-color_888","id":"dacfa063-39","font_style":"","type":"label","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"dacfa06339"}],"id":"dstdacfa06339","aggs":{}}}],"size":"1","displayName":"Gauge","id":"206db40f-35","type":"gauge","dstContext":{"id":"dst206db40f35"},"conditions":[{"predicates":[{"left":{"cx":"fdd7ded8-36"},"right":{"cx":"5ddf6f78-37"},"type":"gteq"}],"reactions":[{"type":"color","value":"cx-theme_green_3","isScalar":true}]},{"predicates":[{"left":{"cx":"fdd7ded8-36"},"right":{"cx":"5ddf6f78-37"},"type":"lt"}],"reactions":[{"type":"color","value":"cx-theme_red_3","isScalar":true}]}],"gaugeStyle":"hg"},{"displayName":"Separator 2","id":"479a7724-42","type":"separator"},{"components":[{"renderer":"line","showValues":true,"role":"series","data":[[3.961698547138978,16.35927698543905,7.337383780078696,7.737199421018226]],"color":"cx-theme_red_4","displayName":"Conversion Rate","seriesName":"Conversion Rate","formulas":[{"txt":"lookup(&'5772cde0',group(&'b23a3a63'),groupby(&'b23a3a63',&'19050739',\"average(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"a6d0e02f","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"49d6b685","renamed":true},{"role":"axis_x","data":[["Jul 2020","Aug 2020","Sep 2020","Oct 2020"]],"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":"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":"5772cde0","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"pct","grid":true,"fmtArgs":{},"id":"a6d0e02f","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Goals","formulas":[],"autoFmt":true,"axisPosition":"right","id":"ce666478","label":"Goals","type":"chart_axis","fmt":"num","labelDrop":0.0}],"displayName":"Bar/Line Chart","id":"771ff2cf","type":"chart_series","dstContext":{"kid":"0a5f4ae3cc33971bce5fd34fb12ac7de","id":"dst771ff2cf"},"height":"3"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6013016E9,1.5851412E9,1.5926616E9,1.5794388E9,1.5878232E9,1.5781428E9,1.5880824E9,1.58013E9,1.590156E9,1.5937848E9,1.5793524E9,1.602594E9,1.5971544E9,1.59534E9,1.5869592E9,1.5734772E9,1.6019892E9,1.593612E9,1.6012152E9,1.5756372E9,1.5903288E9,1.5974136E9,1.5984504E9,1.6044948E9,1.6006104E9,1.5794388E9,1.6045812E9,1.5786612E9,1.5896376E9,1.580994E9,1.5796116E9,1.5881688E9,1.5919704E9,1.5760692E9,1.579698E9,1.5926616E9,1.596636E9,1.5911928E9,1.5787476E9,1.584882E9,1.589292E9,1.588428E9,1.592748E9,1.5874776E9,1.5859188E9,1.576242E9,1.5924888E9,1.6013016E9,1.5976728E9,1.5803892E9,1.593612E9,1.579698E9,1.5961176E9,1.6016472E9,1.603458E9,1.5786612E9,1.5816852E9,1.5933528E9,1.6031124E9,1.6040628E9,1.5956856E9,1.5758964E9,1.6014744E9,1.5828084E9,1.5849684E9,1.5813396E9,1.6040628E9,1.600956E9,1.5906744E9,1.5777972E9,1.5893784E9,1.5906744E9,1.5735636E9,1.5746004E9,1.5855732E9,1.5964632E9,1.5894648E9,1.5796116E9,1.5773652E9,1.5941304E9,1.5951672E9,1.598796E9,1.5829812E9,1.578402E9,1.5900696E9,1.5767604E9,1.6020756E9,1.590156E9,1.5815124E9,1.5973272E9,1.586268E9,1.5809076E9,1.5947352E9,1.5849684E9,1.5899832E9,1.600956E9,1.583586E9,1.6041492E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(896d40192f78f580758b903336f9a4e6@Marketing,A:A;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.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":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"fe7aeb25"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Sep 2020","Mar 2020","Jun 2020","Jan 2020","Apr 2020","Jan 2020","Apr 2020","Jan 2020","May 2020","Jul 2020","Jan 2020","Oct 2020","Aug 2020","Jul 2020","Apr 2020","Nov 2019","Oct 2020","Jul 2020","Sep 2020","Dec 2019","May 2020","Aug 2020","Aug 2020","Nov 2020","Sep 2020","Jan 2020","Nov 2020","Jan 2020","May 2020","Feb 2020","Jan 2020","Apr 2020","Jun 2020","Dec 2019","Jan 2020","Jun 2020","Aug 2020","Jun 2020","Jan 2020","Mar 2020","May 2020","May 2020","Jun 2020","Apr 2020","Apr 2020","Dec 2019","Jun 2020","Sep 2020","Aug 2020","Jan 2020","Jul 2020","Jan 2020","Jul 2020","Oct 2020","Oct 2020","Jan 2020","Feb 2020","Jun 2020","Oct 2020","Oct 2020","Jul 2020","Dec 2019","Oct 2020","Feb 2020","Mar 2020","Feb 2020","Oct 2020","Sep 2020","May 2020","Jan 2020","May 2020","May 2020","Nov 2019","Nov 2019","Mar 2020","Aug 2020","May 2020","Jan 2020","Dec 2019","Jul 2020","Jul 2020","Aug 2020","Mar 2020","Jan 2020","May 2020","Dec 2019","Oct 2020","May 2020","Feb 2020","Aug 2020","Apr 2020","Feb 2020","Jul 2020","Mar 2020","May 2020","Sep 2020","Mar 2020","Nov 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'fe7aeb25',\"d MMM yyyy\"),\"m\",DATEVALUE(!'fe7aeb25',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.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":"Date","id":"b23a3a63"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Facebook","Google Ads","Google Ads","Facebook","Email","Facebook","Google Ads","Facebook","Google Ads","Email","Facebook","Facebook","Email","Email","Email","Email","Instagram","Facebook","Instagram","Facebook","Email","Google Ads","Facebook","Instagram","Email","Google Ads","Email","Facebook","Facebook","Google Ads","Google Ads","Email","Email","Facebook","Facebook","Google Ads","Email","Facebook","Email","Instagram","Google Ads","Facebook","Instagram","Email","Facebook","Google Ads","Facebook","Facebook","Email","Email","Facebook","Instagram","Instagram","Facebook","Email","Instagram","Facebook","Facebook","Facebook","Google Ads","Instagram","Facebook","Facebook","Email","Instagram","Instagram","Instagram","Facebook","Instagram","Google Ads","Email","Email","Email","Email","Facebook","Google Ads","Facebook","Facebook","Facebook","Facebook","Facebook","Email","Email","Google Ads","Facebook","Instagram","Email","Email","Email","Facebook","Facebook","Google Ads","Email","Instagram","Email","Email","Facebook","Email"]],"displayName":"Channel","formulas":[{"txt":"slice(896d40192f78f580758b903336f9a4e6@Marketing,B:B;)","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":"Channel","id":"60602f56"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons","Anne Simmons"]],"displayName":"Sales Person","formulas":[{"txt":"slice(d98626e5c469c95e0374d45ff0b5da2a@Sales,C:C;)","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":"Sales Person","id":"712f203d-26"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.2411764705882353,3.121428571428572,1.1440860215053763,15.211764705882354,6.86829268292683,5.052173913043479,2.4272727272727272,1.7904761904761903,8.648484848484848,5.692631578947368,2.8348837209302324,21.933333333333334,8.323333333333332,6.961111111111111,4.008,5.45,0.44137931034482764,1.3352112676056338,18.116666666666667,0.20240963855421684,0.40289855072463765,5.293023255813953,3.779746835443038,13.011111111111111,8.451162790697675,0.9775280898876404,3.417021276595744,20.6,1.9054054054054053,48.733333333333334,3.2521739130434786,7.697368421052632,2.988235294117647,1.7373134328358208,30.150000000000002,1.35,15.443478260869568,64.84444444444445,14.70625,57.66,1.0953488372093023,3.581395348837209,2.3585365853658535,23.799999999999997,6.1161290322580655,2.0869565217391304,3.7659574468085104,2.753191489361702,85.0,28.700000000000003,2.9814432989690727,2.7934065934065937,5.61578947368421,3.2956521739130435,2.686486486486486,22.055555555555557,4.013953488372094,3.9016393442622954,3.5054945054945055,13.5,5.866666666666667,14.912820512820513,6.885714285714286,8.121212121212121,28.070588235294117,2.734042553191489,5.036734693877552,11.340000000000002,7.67719298245614,2.8954545454545455,8.248484848484848,26.91428571428571,4.346236559139785,1.589189189189189,2.3278350515463915,10.191304347826087,5.383561643835616,11.905,1.636111111111111,1.5292929292929294,1.6280701754385964,0.8525252525252525,5.966666666666666,58.06666666666668,4.73469387755102,3.963636363636364,12.350000000000001,8.294444444444444,7.366101694915255,1.9908045977011497,1.2547619047619047,2.208421052631579,4.045070422535211,5.767567567567568,2.309677419354839,2.122105263157895,13.343589743589742,5.204938271604938]],"displayName":"Conv Rate","formulas":[{"txt":"slice(896d40192f78f580758b903336f9a4e6@Marketing,E:E;)/slice(896d40192f78f580758b903336f9a4e6@Marketing,F:F;)*10","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":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Conv Rate","id":"19050739"}],"displayName":"Table Copy","id":"0ed86556","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":"<","dim":"19050739","type":"op","value":"100"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"19050739","variation":"condition"},{"p":{"args":[{"args":[{"dim":"60602f56"},{"var":"channelFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"60602f56","variation":"condition"},{"p":{"args":[{"args":[{"dim":"712f203d26"},{"var":"salesPersonFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"712f203d26","variation":"condition"}],"kid":"0a5f4ae3cc33971bce5fd34fb12ac7de","id":"dst0ed86556"}}],"isForked":false,"id":"a13b7a860f60bff9174932d72155d307","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Conversion Rate","usesSampleData":false,"master":"0a5f4ae3cc33971bce5fd34fb12ac7de"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","a2d75942456c71f47060d9f50d075fd4"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["Displays the Income and Expenses over time, along with the Gross and Net Profit. This allows us to measure the business's profitability and highlights whennever there is an increase/decrease in profitability."]],"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 the Income and Expenses over time, along with the Gross and Net Profit. This allows us to measure the business's profitability and highlights whennever there is an increase/decrease in profitability.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"20225494","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"bfa56e74789925be6c0770c373db67b2","id":"dst20225494"},"wrap":true},{"data":[["Profit & Loss over Time"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Profit & Loss over Time\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"bfa56e74789925be6c0770c373db67b2","id":"dste18e36e1"},"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":"e18e36e1","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"series","data":[[73905.0,57364.0,56388.0,70188.0,74387.0,71516.0,53422.0,54522.0,69690.0,73555.0,58844.0,60228.0]],"color":"cx-theme_yellow_green_4","displayName":"Income","seriesName":"Income","formulas":[{"txt":"lookup(&'02269d57',group(SELECT(&'34fa0f99',&'c3e0d262'=\"Income\")),groupby(SELECT(&'34fa0f99',&'c3e0d262'=\"Income\"),SELECT(&'57668a40',&'c3e0d262'=\"Income\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"60686423","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"95c61d9b"},{"role":"series","data":[[17094.0,21480.0,16408.0,23328.0,16005.0,21994.0,15659.0,16498.0,19224.0,19525.0,21517.0,19725.0]],"overrideColor":true,"displayName":"Cost of Sales","seriesName":"Cost of Sales","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"formulas":[{"txt":"lookup(&'02269d57',group(SELECT(&'34fa0f99',&'9a053439'=\"Cost of Sales\")),groupby(SELECT(&'34fa0f99',&'9a053439'=\"Cost of Sales\"),SELECT(&'57668a40',&'9a053439'=\"Cost of Sales\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"id":"86591dd9","type":"series_data","fmt":"cur","axis":"60686423"},{"role":"series","data":[[23661.0,21443.0,23893.0,15046.0,24126.0,18827.0,20470.0,21875.0,22001.0,16690.0,22361.0,19200.0]],"color":"cx-theme_yellow_3","displayName":"Wages","seriesName":"Wages","formulas":[{"txt":"lookup(&'02269d57',group(SELECT(&'34fa0f99',&'9a053439'=\"Wages\")),groupby(SELECT(&'34fa0f99',&'9a053439'=\"Wages\"),SELECT(&'57668a40',&'9a053439'=\"Wages\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"60686423","lineDashes":"Dash","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"307c4201"},{"role":"series","data":[[11263.0,11742.0,11442.0,10394.0,12524.0,12728.0,13512.0,11557.0,12299.0,12092.0,12972.0,12299.0]],"color":"cx-theme_red_4","displayName":"Operating Expenses","seriesName":"Operating Expenses","formulas":[{"txt":"lookup(&'02269d57',group(SELECT(&'34fa0f99',&'9a053439'=\"Operating Expenses\")),groupby(SELECT(&'34fa0f99',&'9a053439'=\"Operating Expenses\"),SELECT(&'57668a40',&'9a053439'=\"Operating Expenses\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"60686423","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"da3eafb9"},{"renderer":"line","showValues":true,"role":"series","data":[[56811.0,35884.0,39980.0,46860.0,58382.0,49522.0,37763.0,38024.0,50466.0,54030.0,37327.0,40503.0]],"color":"cx-theme_blue_2","displayName":"Gross Profit","seriesName":"Gross Profit","formulas":[{"txt":"&'95c61d9b'-&'86591dd9'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"60686423","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"726e2e4a"},{"renderer":"line","showValues":true,"role":"series","data":[[21887.0,2699.0,4645.0,21420.0,21732.0,17967.0,3781.0,4592.0,16166.0,25248.0,1994.0,9004.0]],"color":"cx-theme_blue_4","displayName":"Net Profit","seriesName":"Net Profit","formulas":[{"txt":"&'726e2e4a'-&'307c4201'-&'da3eafb9'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"60686423","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"8586b8fc"},{"role":"axis_x","data":[["Aug 2021","Sep 2021","Oct 2021","Nov 2021","Dec 2021","Jan 2022","Feb 2022","Mar 2022","Apr 2022","May 2022","Jun 2022","Jul 2022"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"formulas":[{"txt":"//SWITCH($dateGroup,\"d\",DATEVALUE(DATERANGE($dateStart,$dateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($dateStart,$dateEnd),\"3\")),\"MMM yyyy\"))\nDATEVALUE(GROUP(DATE_STARTOF(DATERANGE(DATE_STARTOF(TODAY(),\"3\",-11),DATE_STARTOF(TODAY(),\"3\")),\"3\")),\"MMM yyyy\")","ver":2.0}],"autoFmt":false,"id":"02269d57","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"cur","grid":true,"fmtArgs":{},"id":"60686423","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","id":"925966ff","type":"chart_series","dstContext":{"kid":"bfa56e74789925be6c0770c373db67b2","id":"dst925966ff"},"height":"3"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense","Income","Less Cost of Sales","Expense","Expense"]],"displayName":"Category","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Xero,A:A;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.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"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Category","id":"c3e0d262"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses","Sales","Cost of Sales","Wages","Operating Expenses"]],"displayName":"Account","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Xero,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.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"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Account","id":"9a053439"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.643634E9,1.643634E9,1.643634E9,1.643634E9,1.6409556E9,1.6409556E9,1.6409556E9,1.6409556E9,1.6382772E9,1.6382772E9,1.6382772E9,1.6382772E9,1.6356852E9,1.6356852E9,1.6356852E9,1.6356852E9,1.6330104E9,1.6330104E9,1.6330104E9,1.6330104E9,1.6304184E9,1.6304184E9,1.6304184E9,1.6304184E9,1.62774E9,1.62774E9,1.62774E9,1.62774E9,1.6250616E9,1.6250616E9,1.6250616E9,1.6250616E9,1.6224696E9,1.6224696E9,1.6224696E9,1.6224696E9,1.6197912E9,1.6197912E9,1.6197912E9,1.6197912E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(a2d75942456c71f47060d9f50d075fd4@Xero,C:C;,\"d/MMM/yyyy\"))","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"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"aa2a9646"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","May 2022","May 2022","May 2022","May 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Feb 2022","Feb 2022","Feb 2022","Feb 2022","Jan 2022","Jan 2022","Jan 2022","Jan 2022","Dec 2021","Dec 2021","Dec 2021","Dec 2021","Nov 2021","Nov 2021","Nov 2021","Nov 2021","Oct 2021","Oct 2021","Oct 2021","Oct 2021","Sep 2021","Sep 2021","Sep 2021","Sep 2021","Aug 2021","Aug 2021","Aug 2021","Aug 2021","Jul 2021","Jul 2021","Jul 2021","Jul 2021","Jun 2021","Jun 2021","Jun 2021","Jun 2021","May 2021","May 2021","May 2021","May 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021"]],"displayName":"Date","formulas":[{"txt":"//SWITCH($dateGroup,\"d\",DATEVALUE(&'aa2a9646',\"d MMM yyyy\"),\"m\",)\nDATEVALUE(&'aa2a9646',\"MMM yyyy\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.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"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date","id":"34fa0f99"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["60228","19725","19200","12299","58844","21517","22361","12972","73555","19525","16690","12092","69690","19224","22001","12299","54522","16498","21875","11557","53422","15659","20470","13512","71516","21994","18827","12728","74387","16005","24126","12524","70188","23328","15046","10394","56388","16408","23893","11442","57364","21480","21443","11742","73905","17094","23661","11263","67755","18550","20313","13726","63274","15891","24328","12690","64362","21882","17269","13221","57855","20303","20729","12610","54708","24263","15592","13949","57416","18814","21170","12725","61269","22113","24006","11191"]],"displayName":"Value","formulas":[{"txt":"slice(a2d75942456c71f47060d9f50d075fd4@Xero,D:D;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.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"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Value","id":"57668a40"}],"displayName":"Table","id":"de497ee4","type":"table","dstContext":{"ops":[],"kid":"bfa56e74789925be6c0770c373db67b2","id":"dstde497ee4"}}],"isForked":false,"id":"0d834eaae5feff843e64c2cf923e76a9","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Profit & Loss","usesSampleData":false,"master":"bfa56e74789925be6c0770c373db67b2"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","a2d75942456c71f47060d9f50d075fd4"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[],"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":"\"A list of reasons as to why customers are purchasing from us.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"3087eea3","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"9e64dd5be63b2d9ebc7ec2af98ddb952","id":"dst3087eea3"},"wrap":true},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"data","data":[],"displayName":"Values","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"}},"formulas":[{"txt":"&'3ec87312'","ver":2.0}],"autoFmt":true,"id":"debb67d5","type":"series_data","fmt":"num"},{"role":"labels","data":[],"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":"&'237af2d2'","ver":2.0}],"autoFmt":true,"id":"c2028f7c","type":"series_labels","fmt":"txt"}],"size":2.0,"displayName":"Pie Chart Copy","id":"3b2b3144","type":"chart_pie","dstContext":{"kid":"9e64dd5be63b2d9ebc7ec2af98ddb952","id":"dst3b2b3144"}},{"layoutConfig":{"x":1.0,"y":0.0},"orientation":"v","displayName":"Separator Copy","id":"9c982c14","type":"separator"},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"components":[{"role":"customHeader","data":[],"displayName":"Won Reason","formulas":[{"txt":"\"Reason\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"9e64dd5be63b2d9ebc7ec2af98ddb952","id":"dst12cc21db"},"align":"c","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"12cc21db","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_green_4"}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Won Reason","formulas":[{"txt":"ARRAY(\"have 'x' problem, want 'y' outcome, need 'z' information, would like to achieve 'zz' goal, other\")","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"txt","align":"c","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":"237af2d2","conditions":[{"predicates":[{"left":{"cx":"3ec87312"},"right":{"raw":"10"},"type":"gteq"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_green_1"}]}],"renamed":true},{"components":[{"role":"customHeader","data":[],"displayName":"Occurances","formulas":[{"txt":"\"Occurances\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"9e64dd5be63b2d9ebc7ec2af98ddb952","id":"dstfe370759"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"fe370759","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_green_4"}]}],"wrap":false}],"customHeader":true,"role":"tcol","data":[],"displayName":"Occurances","formulas":[{"txt":"ARRAY(\"6,12,7,5,3\")","ver":2.0}],"autoFmt":true,"index":1.0,"type":"table_col","fmt":"num","align":"c","fw":"fixed","size":"x-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"}},"w":"25%","name":"Occurances","id":"3ec87312","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"10"},"type":"gteq"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_green_1"}]}]}],"maxRows":"10","displayName":"Table 2 Copy","id":"69827885","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"args":[{"dim":"237af2d2"},{"value":"\"\""}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"}],"f":"not","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"237af2d2","variation":"condition"},{"sortBy":[{"dim":"3ec87312","dir":2.0}],"type":"sort"}],"kid":"9e64dd5be63b2d9ebc7ec2af98ddb952","id":"dst69827885"}}],"displayName":"Layout Grid Copy","widths":[{"w":30.0,"x":1.0}],"id":"f87fb751","cellData":[{"x":1.0,"h":1.0,"y":0.0},{"x":0.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":3.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(a2d75942456c71f47060d9f50d075fd4@Marketing Spend,A:A;,\"yyyy/MM/dd\"))","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":"f39ee24f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'f39ee24f',\"d MMM yyyy\"),\"m\",DATEVALUE(!'f39ee24f',\"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":"6d528fff"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"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":"87f366a2"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"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":"e13ed71c"}],"displayName":"Table","id":"55d025f3","type":"table","dstContext":{"ops":[],"kid":"9e64dd5be63b2d9ebc7ec2af98ddb952","id":"dst55d025f3"}}],"isForked":false,"id":"6e1a375077623de3c799cb7b90d03191","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Motivating Reasons to Buy","usesSampleData":false,"master":"28e362c29b91353520d6ab9554d36267"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6"],"dimensions":{"w":1232.0}},"components":[{"size":"xx-small","data":[["The number and value of all sales. This is one of the most important metrics and allows us to see overall performance in a quick snapshot."]],"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 and value of all sales. This is one of the most important metrics and allows us to see overall performance in a quick snapshot.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"95add23c","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"f684db2892b15c04f0aa0169e76e0bb6","id":"dst95add23c"},"wrap":true},{"components":[{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[["Anne Simmons","Jessica Walker","John Smith","Tim Warner","Tom Jones"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"GROUP(slice(d98626e5c469c95e0374d45ff0b5da2a@Sales,C:C;))","ver":2.0}],"autoFmt":false,"id":"de2bc09d","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"1ea28e21","type":"proxy"}],"displayName":"User Input Control","scope":1.0,"inputLabel":"Salesperson","inputType":1.0,"id":"628b8131","includeAllData":true,"type":"input","dstContext":{"kid":"f684db2892b15c04f0aa0169e76e0bb6","id":"dst628b8131"},"propName":"salesPersonFilter"}],"displayName":"Layout Grid 2","id":"d1ef4068","type":"panel_grid","rows":1.0,"cols":3.0},{"displayName":"Separator 2","id":"093cd68b","type":"separator"},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","size":"small","data":[["Total Number of Sales"]],"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":"\"Total Number of Sales\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"13461a63","type":"label","fmt":"txt","dstContext":{"kid":"f684db2892b15c04f0aa0169e76e0bb6","id":"dst13461a63"},"align":"c"},{"role":"secondary","size":"large","data":[[46.0]],"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"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"COUNT(GROUP(SELECT(&'d029970e',BETWEEN(&'358bcb69',$dateStart,$dateEnd))))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"39672b3e","type":"label","fmt":"num","dstContext":{"kid":"f684db2892b15c04f0aa0169e76e0bb6","id":"dst39672b3e"},"align":"c"}],"displayName":"Value Pair","id":"e9f5660e","type":"simple_value","dstContext":{"id":"dste9f5660e"}},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"primary","size":"small","data":[["Total Sales Value"]],"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":"\"Total Sales Value\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"f7d4351d","type":"label","fmt":"txt","dstContext":{"kid":"f684db2892b15c04f0aa0169e76e0bb6","id":"dstf7d4351d"},"align":"c"},{"role":"secondary","size":"large","data":[[135118.05000000002]],"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":"0"},"formulas":[{"txt":"SUM(SELECT(&'5b39f55c',BETWEEN(&'358bcb69',$dateStart,$dateEnd)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"85128299","type":"label","fmt":"cur","dstContext":{"kid":"f684db2892b15c04f0aa0169e76e0bb6","id":"dst85128299"},"align":"c"}],"displayName":"Value Pair Copy","id":"7aab39f7","type":"simple_value","dstContext":{"id":"dst7aab39f7"}}],"displayName":"Layout Grid","id":"88dfde7a","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":2.0},{"layoutConfig":{"x":0.0,"y":1.0},"displayName":"Separator","id":"13887572","type":"separator"},{"components":[{"showValues":true,"role":"series","data":[["",3.0,1.0,1.0,1.0,2.0,1.0,2.0,1.0,1.0,"",1.0,2.0,"",1.0,1.0,5.0,3.0,2.0,"",2.0,1.0,1.0,2.0,2.0,"",1.0,1.0,4.0,2.0,2.0]],"color":"cx-theme_green_4","displayName":"Number of Sales","seriesName":"Number of Sales","formulas":[{"txt":"lookup(&'c657578c',group(&'37b2dee7'),groupby(&'37b2dee7',&'d029970e',\"count(group(values))\"))","ver":2.0}],"autoFmt":true,"leaveGaps":true,"type":"series_data","fmt":"num","axis":"ab83a2fc","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":"cf7c1a2f"},{"renderer":"line","showValues":true,"role":"series","data":[["",7418.199999999999,808.08,4134.02,904.2,7169.75,2127.72,2270.6600000000003,2818.08,6343.82,"",6300.36,6048.96,"",1661.1,5439.06,18887.570000000003,6621.98,4396.53,"",8163.74,1135.74,4969.8,2793.17,6304.0199999999995,"",2535.0,5627.76,10058.19,4532.18,5648.360000000001]],"color":"cx-theme_green_3","displayName":"Job Value","seriesName":"Sales Value","formulas":[{"txt":"lookup(&'c657578c',group(&'37b2dee7'),groupby(&'37b2dee7',&'5b39f55c',\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"667d7f47","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"0af37fd8","renamed":true},{"renderer":"line","role":"series","data":[[1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667,1.666666666666667]],"displayName":"Target","seriesName":"Target","formulas":[{"txt":"REPEAT(lookup(\"Sales volumes\",773a7b4b52bcff4e6d67acb50b26c8a6@Standard,D:D;,773a7b4b52bcff4e6d67acb50b26c8a6@Standard,H:H;)/SWITCH($dateGroup,\"d\",30,\"m\",1),count(!'c657578c')) / COUNT(GROUP(slice(d98626e5c469c95e0374d45ff0b5da2a@Sales,C:C;))) * COUNT(GROUP(&'a0c5260f'))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"ab83a2fc","lineDashes":"Dash","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"id":"c5cf436d"},{"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":"c657578c","label":"Untitled","type":"chart_axis","fmt":"dat2","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"cur","grid":true,"fmtArgs":{},"id":"667d7f47","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Count","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Untitled","type":"chart_axis","fmt":"num","fmtArgs":{},"id":"ab83a2fc","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","id":"44aa9e3b","type":"chart_series","dstContext":{"kid":"f684db2892b15c04f0aa0169e76e0bb6","id":"dst44aa9e3b"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["662181/2/7","1040021/8/6","1723849/4/13","1161048/10/31","2088423/6/19","1298697/2/14","1450938/7/22","748388/11/29","2287281/2/13","114331/8/31","1514708/8/19","1379494/2/24","490964/5/18","1912174/6/16","1525396/7/10","2553225/3/26","1474823/6/24","464036/1/11","1616375/1/12","1629848/10/14","1017093/6/16","1259299/11/11","411375/9/28","73809/5/30","2563170/10/10","304824/5/28","2689546/12/27","2136803/10/20","991167/1/28","2525373/7/31","1180963/6/19","1963428/3/15","567584/1/10","2485686/5/14","2637276/10/29","860941/3/8","978051/1/2","1619774/3/8","552145/11/21","2254189/4/8","691621/12/1","1810925/2/10","2580818/2/22","890881/4/22","2441623/12/19","1726698/1/16","1135141/5/11","1572757/12/20","2738375/8/12","1113622/3/17","27814/12/26","1144816/2/28","298523/11/18","744752/9/25","19987/12/17","956703/10/17","1362101/12/22","1018077/7/24","2539392/3/23","2251472/10/9","1491056/11/10","695662/1/4","582574/2/4","2635568/5/1","399630/10/24","725901/4/7","1666232/5/15","1814226/12/4","2315662/1/9","1137240/1/28","265815/2/24","2267705/7/24","2632230/2/14","1282073/10/26","1050715/10/7","1255730/5/27","937440/6/22","2567810/4/3","2546217/11/27","2075848/6/26","1190847/8/17","2081302/9/27","688327/12/26","2201030/1/23","1329222/1/7","2155669/7/18","637368/10/17","1779950/4/13","2275022/3/3","2165184/3/4","1120163/12/8","1388842/9/27","1607289/6/23","2526148/2/23","325619/2/17","2430265/10/23","147389/12/16","1884127/7/23","453261/11/29","2147047/9/19"]],"displayName":"ID","formulas":[{"txt":"slice(d98626e5c469c95e0374d45ff0b5da2a@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":"d029970e"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6599672E9,1.6599672E9,1.6598808E9,1.6598808E9,1.6598808E9,1.6598808E9,1.6598808E9,1.6597944E9,1.6597944E9,1.6597944E9,1.659708E9,1.6596216E9,1.6595352E9,1.6595352E9,1.6594488E9,1.659276E9,1.6590168E9,1.6589304E9,1.6587576E9,1.6587576E9,1.6586712E9,1.658412E9,1.6583256E9,1.6583256E9,1.6582392E9,1.6581528E9,1.6580664E9,1.6580664E9,1.6580664E9,1.6580664E9,1.65798E9,1.6578936E9,1.6578936E9,1.6578072E9,1.6577208E9,1.6577208E9,1.6576344E9,1.6576344E9,1.657548E9,1.657548E9,1.657548E9,1.657548E9,1.6574616E9,1.6573752E9,1.6572024E9,1.6572024E9,1.657116E9,1.657116E9,1.6570296E9,1.6569432E9,1.6568568E9,1.6568568E9,1.656684E9,1.656684E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565112E9,1.6565112E9,1.6565112E9,1.6565112E9,1.6565112E9,1.6564248E9,1.6563384E9,1.6561656E9,1.6561656E9,1.6560792E9,1.6559064E9,1.65582E9,1.6557336E9,1.6557336E9,1.6556472E9,1.6555608E9,1.6555608E9,1.6554744E9,1.655388E9,1.6553016E9,1.6552152E9,1.6552152E9,1.6552152E9,1.654956E9,1.6548696E9,1.6548696E9,1.6548696E9,1.6547832E9,1.6547832E9,1.6546968E9,1.6546968E9,1.6546968E9,1.6546104E9,1.6546104E9,1.6544376E9,1.6543512E9,1.6543512E9,1.6541784E9,1.6541784E9,1.6541784E9,1.654092E9,1.654092E9,1.6540056E9]],"displayName":"Date_Raw","formulas":[{"txt":"DATE_ADD(slice(date(d98626e5c469c95e0374d45ff0b5da2a@Sales,B:B;,\"yyyy/MM/dd\")),\"3\",1)","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":"358bcb69"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["9 Aug 2022","9 Aug 2022","8 Aug 2022","8 Aug 2022","8 Aug 2022","8 Aug 2022","8 Aug 2022","7 Aug 2022","7 Aug 2022","7 Aug 2022","6 Aug 2022","5 Aug 2022","4 Aug 2022","4 Aug 2022","3 Aug 2022","1 Aug 2022","29 Jul 2022","28 Jul 2022","26 Jul 2022","26 Jul 2022","25 Jul 2022","22 Jul 2022","21 Jul 2022","21 Jul 2022","20 Jul 2022","19 Jul 2022","18 Jul 2022","18 Jul 2022","18 Jul 2022","18 Jul 2022","17 Jul 2022","16 Jul 2022","16 Jul 2022","15 Jul 2022","14 Jul 2022","14 Jul 2022","13 Jul 2022","13 Jul 2022","12 Jul 2022","12 Jul 2022","12 Jul 2022","12 Jul 2022","11 Jul 2022","10 Jul 2022","8 Jul 2022","8 Jul 2022","7 Jul 2022","7 Jul 2022","6 Jul 2022","5 Jul 2022","4 Jul 2022","4 Jul 2022","2 Jul 2022","2 Jul 2022","1 Jul 2022","1 Jul 2022","1 Jul 2022","30 Jun 2022","30 Jun 2022","30 Jun 2022","30 Jun 2022","30 Jun 2022","29 Jun 2022","28 Jun 2022","26 Jun 2022","26 Jun 2022","25 Jun 2022","23 Jun 2022","22 Jun 2022","21 Jun 2022","21 Jun 2022","20 Jun 2022","19 Jun 2022","19 Jun 2022","18 Jun 2022","17 Jun 2022","16 Jun 2022","15 Jun 2022","15 Jun 2022","15 Jun 2022","12 Jun 2022","11 Jun 2022","11 Jun 2022","11 Jun 2022","10 Jun 2022","10 Jun 2022","9 Jun 2022","9 Jun 2022","9 Jun 2022","8 Jun 2022","8 Jun 2022","6 Jun 2022","5 Jun 2022","5 Jun 2022","3 Jun 2022","3 Jun 2022","3 Jun 2022","2 Jun 2022","2 Jun 2022","1 Jun 2022"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(&'358bcb69',\"d MMM yyyy\"),\"m\",DATEVALUE(&'358bcb69',\"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":"37b2dee7"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["4455.88","694.26","6103.68","2391.03","3938.94","3524.04","8173.94","2115.2","993.69","5153.52","4431.43","793.5","5097.36","1622","2192.94","776.14","1366.12","2468.64","5777.75","4929.6","608.97","649.75","479.75","2476.5","1011.96","779.76","2571.8","656.18","1413.4","5016.42","235.48","2793.23","1106.87","1329.63","2377.96","3270.4","2255.93","2276.25","3628.1","374.9","4409.29","1645.9","5627.76","2535","5856.57","447.45","667.04","2126.13","4969.8","1135.74","2344.98","5818.76","2476.18","1920.35","336","1927.66","4358.32","5324.59","986.44","6188.84","5022.82","1364.88","5439.06","1661.1","2302.65","3746.31","6300.36","6343.82","2818.08","2030.13","240.53","2127.72","2161.25","5008.5","904.2","4134.02","808.08","1611.36","2416.7","3390.14","3863.18","1166.2","211.06","529.98","2647.26","589.68","133.32","3141.04","2524.36","511.06","4969.08","6608.48","3292.2","1061.25","509.68","4328.7","525.95","247.9","2914","2142.71"]],"displayName":"Sales Value","formulas":[{"txt":"slice(d98626e5c469c95e0374d45ff0b5da2a@Sales,F:F;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.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":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales Value","id":"5b39f55c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Tim Warner","Jessica Walker","Tim Warner","Jessica Walker","John Smith","Jessica Walker","Jessica Walker","Jessica Walker","Jessica Walker","Tim Warner","Anne Simmons","Tim Warner","Anne Simmons","Tim Warner","Tim Warner","Jessica Walker","Tim Warner","Tim Warner","Tom Jones","Tim Warner","Tim Warner","Tim Warner","Anne Simmons","Tim Warner","Tom Jones","Jessica Walker","Jessica Walker","John Smith","Anne Simmons","Tim Warner","Tim Warner","Tim Warner","Jessica Walker","John Smith","Tim Warner","Anne Simmons","Anne Simmons","Jessica Walker","Anne Simmons","John Smith","Tom Jones","Tim Warner","Jessica Walker","Tim Warner","Tim Warner","John Smith","Jessica Walker","John Smith","John Smith","Jessica Walker","Tim Warner","Tim Warner","Jessica Walker","John Smith","John Smith","Jessica Walker","Tim Warner","Anne Simmons","Anne Simmons","Anne Simmons","Jessica Walker","Tim Warner","Jessica Walker","Tim Warner","Tom Jones","Tim Warner","Anne Simmons","Tim Warner","Tom Jones","Anne Simmons","Tom Jones","John Smith","Tim Warner","Anne Simmons","Jessica Walker","Jessica Walker","Tom Jones","Tim Warner","Anne Simmons","Anne Simmons","Tim Warner","Tim Warner","Jessica Walker","Anne Simmons","Anne Simmons","Tom Jones","Anne Simmons","Tom Jones","John Smith","Tim Warner","Jessica Walker","Jessica Walker","Jessica Walker","Tim Warner","Tim Warner","Tom Jones","John Smith","Jessica Walker","Tim Warner","Jessica Walker"]],"displayName":"Sales Person","formulas":[{"txt":"slice(d98626e5c469c95e0374d45ff0b5da2a@Sales,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.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":"Sales Person","id":"a0c5260f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["836","114","748","857","831","468","986","320","181","654","881","575","634","200","837","257","287","296","955","632","383","565","95","325","937","513","308","86","191","961","116","737","383","943","442","560","433","375","730","115","629","302","716","300","981","95","176","393","753","823","363","731","769","965","280","562","694","709","364","961","869","242","902","245","315","827","946","802","927","927","67","714","475","675","685","506","182","373","845","767","922","170","122","146","382","351","66","568","566","253","774","824","531","375","277","705","67","185","620","607"]],"displayName":"COS","formulas":[{"txt":"slice(d98626e5c469c95e0374d45ff0b5da2a@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":"6f21ed82"}],"displayName":"Table","id":"0145c3a7","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"a0c5260f"},{"var":"salesPersonFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"a0c5260f","variation":"condition"},{"sortBy":[{"dim":"37b2dee7","dir":2.0}],"type":"sort"}],"kid":"f684db2892b15c04f0aa0169e76e0bb6","id":"dst0145c3a7"}}],"isForked":false,"id":"bac33ac7991e71bb2a294f330d75a19d","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Total Sales","usesSampleData":false,"master":"f684db2892b15c04f0aa0169e76e0bb6"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","896d40192f78f580758b903336f9a4e6"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["Displays how long a contact spends in each stage on average. This helps highlight bottlenecks in the onboarding process and highlights contacts that need extra attention."]],"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 long a contact spends in each stage on average. This helps highlight bottlenecks in the onboarding process and highlights contacts that need extra attention.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"86c05c53","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"77f5ae1cfb5ddf017c3c28f7f6eba0bf","id":"dst86c05c53"},"wrap":true},{"components":[{"showValues":true,"role":"series","data":[[4.2,6.8,3.7,9.0,12.3]],"color":"cx-theme_blue_5","displayName":"Time in Stage","seriesName":"Time in Stage","formulas":[{"txt":"array(4.2, 6.8, 3.7, 9.0, 12.3)","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"6a5abffc-44","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"suffix":" days"},"id":"ae1695b8-42"},{"role":"axis_x","data":[["Stage 1","Stage 2","Stage 3","Stage 4","Stage 5"]],"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":"ARRAY(\"Stage 1\",\"Stage 2\",\"Stage 3\",\"Stage 4\",\"Stage 5\")","ver":2.0}],"autoFmt":true,"id":"44e7211c-43","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":"6a5abffc-44","labelDrop":0.0}],"displayName":"Bar/Line Chart 2","id":"d547ea3c-41","type":"chart_series","dstContext":{"kid":"77f5ae1cfb5ddf017c3c28f7f6eba0bf","id":"dstd547ea3c41"}},{"data":[["Stalled Contacts"]],"displayName":"Label 2","formulas":[{"txt":"\"Stalled Contacts\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"77f5ae1cfb5ddf017c3c28f7f6eba0bf","id":"dst9c22420058"},"align":"c","size":"small","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":"9c224200-58","wrap":true},{"components":[{"components":[{"role":"customHeader","data":[["Contact Name"]],"displayName":"Contact Name","formulas":[{"txt":"\"Contact Name\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"77f5ae1cfb5ddf017c3c28f7f6eba0bf","id":"dstd9d95d8e47"},"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":"d9d95d8e-47","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_4"}]}]}],"customHeader":true,"role":"tcol","data":[["Wilbur Cross","Jordan Cohen","Marty Weaver","Elise Lawrence","Ramona Fuller","Fiona Rowe"]],"displayName":"Contact Name","formulas":[{"txt":"ARRAY(\"Wilbur Cross\", \"Jordan Cohen\", \"Marty Weaver\", \"Elise Lawrence\", \"Ramona Fuller\", \"Fiona Rowe\")","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"txt","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"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Contact Name","id":"2b09e1e5-46","conditions":[{"predicates":[{"left":{"cx":"4d80c441-55"},"right":{"raw":"25"},"type":"gt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_1"}]},{"predicates":[{"left":{"cx":"4d80c441-55"},"right":{"raw":"30"},"type":"gt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_red_1"}]}]},{"components":[{"role":"customHeader","data":[["Current Stage"]],"displayName":"Current Stage","formulas":[{"txt":"\"Current Stage\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"77f5ae1cfb5ddf017c3c28f7f6eba0bf","id":"dst417e13eb50"},"align":"c","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":"417e13eb-50","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_4"}]}]}],"customHeader":true,"role":"tcol","data":[["Stage 5","Stage 2","Stage 4","Stage 5","Stage 4","Stage 5"]],"displayName":"Current Stage","formulas":[{"txt":"ARRAY(\"Stage 5\", \"Stage 2\", \"Stage 4\", \"Stage 5\", \"Stage 4\", \"Stage 5\")","ver":2.0}],"autoFmt":true,"index":1.0,"type":"table_col","fmt":"txt","align":"c","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"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Current Stage","id":"6e46e566-49","conditions":[{"predicates":[{"left":{"cx":"4d80c441-55"},"right":{"raw":"25"},"type":"gt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_1"}]},{"predicates":[{"left":{"cx":"4d80c441-55"},"right":{"raw":"30"},"type":"gt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_red_1"}]}]},{"components":[{"role":"customHeader","data":[["Days in Stage"]],"displayName":"Days in Stage","formulas":[{"txt":"\"Days in Stage\"","ver":2.0}],"font_colour":"cx-color_444","font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"77f5ae1cfb5ddf017c3c28f7f6eba0bf","id":"dst4d41cca156"},"align":"c","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":"4d41cca1-56","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_blue_4","isScalar":true},{"type":"color","isScalar":true,"value":"cx-theme_fff"}]}]}],"customHeader":true,"role":"tcol","data":[[37.0,29.0,22.0,21.0,18.0,18.0]],"displayName":"Days in Stage","formulas":[{"txt":"ARRAY(37, 29, 22, 21, 18, 18)","ver":2.0}],"autoFmt":true,"index":2.0,"type":"table_col","fmt":"num","align":"c","size":"x-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"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Days in Stage","id":"4d80c441-55","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"25"},"type":"gt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_1"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"30"},"type":"gt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_red_1"}]}]}],"displayName":"Table","id":"a3d03516-45","type":"table","dstContext":{"kid":"77f5ae1cfb5ddf017c3c28f7f6eba0bf","id":"dsta3d0351645"}}],"isForked":false,"id":"baf74582f518d519ef9f8c25aefe1514","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Average Time in Stage","usesSampleData":false,"master":"77f5ae1cfb5ddf017c3c28f7f6eba0bf"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","896d40192f78f580758b903336f9a4e6"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["The return on Ad Spend (ROAS) displays how much you earn in sales for each dollar you spend on advertising. This is a key indicator of marketing performance."]],"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 return on Ad Spend (ROAS) displays how much you earn in sales for each dollar you spend on advertising. This is a key indicator of marketing performance.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"63b30646","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"6717ceade40133d8881baea67f9e51f1","id":"dst63b30646"},"wrap":true},{"components":[{"renderer":"line","showValues":true,"role":"series","data":[["Infinity","Infinity","Infinity","Infinity"]],"displayName":"Email","seriesName":"Email","formulas":[{"txt":"lookup(&'ea7e37d3',group(SELECT(&'81d38267-33',&'63c7a456'=\"Email\")),groupby(SELECT(&'81d38267-33',&'63c7a456'=\"Email\"),SELECT(&'ebfbb10f',&'63c7a456'=\"Email\"),\"sum(values)\")) / lookup(&'ea7e37d3',group(SELECT(&'81d38267-33',&'63c7a456'=\"Email\")),groupby(SELECT(&'81d38267-33',&'63c7a456'=\"Email\"),SELECT(&'e5d38de7',&'63c7a456'=\"Email\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"leaveGaps":true,"type":"series_data","fmt":"num","axis":"6b97654f","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"precision":"0"},"id":"e9c1b26d","renamed":true},{"renderer":"line","showValues":true,"role":"series","data":[[4.235907088807739,3.9871252489369744,3.8480399011793214,4.120660478107286]],"color":"cx-theme_blue_3","displayName":"Facebook","seriesName":"Facebook","formulas":[{"txt":"lookup(&'ea7e37d3',group(SELECT(&'81d38267-33',&'63c7a456'=\"Facebook\")),groupby(SELECT(&'81d38267-33',&'63c7a456'=\"Facebook\"),SELECT(&'ebfbb10f',&'63c7a456'=\"Facebook\"),\"sum(values)\")) / lookup(&'ea7e37d3',group(SELECT(&'81d38267-33',&'63c7a456'=\"Facebook\")),groupby(SELECT(&'81d38267-33',&'63c7a456'=\"Facebook\"),SELECT(&'e5d38de7',&'63c7a456'=\"Facebook\"),\"sum(values)\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"6b97654f","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"precision":"2"},"id":"2a43ac48"},{"renderer":"line","showValues":true,"role":"series","data":[[5.6418705275420225,4.998270440251573,5.64815241607129,4.794299085301]],"color":"cx-theme_green_3","displayName":"Google Ads","seriesName":"Google Ads","formulas":[{"txt":"lookup(&'ea7e37d3',group(SELECT(&'81d38267-33',&'63c7a456'=\"Google Ads\")),groupby(SELECT(&'81d38267-33',&'63c7a456'=\"Google Ads\"),SELECT(&'ebfbb10f',&'63c7a456'=\"Google Ads\"),\"sum(values)\")) / lookup(&'ea7e37d3',group(SELECT(&'81d38267-33',&'63c7a456'=\"Google Ads\")),groupby(SELECT(&'81d38267-33',&'63c7a456'=\"Google Ads\"),SELECT(&'e5d38de7',&'63c7a456'=\"Google Ads\"),\"sum(values)\")) ","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"6b97654f","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"precision":"2"},"id":"b0071fed"},{"renderer":"line","showValues":true,"role":"series","data":[[4.795758852715288,4.744311011601874,5.502822751547005,3.3006812146403415]],"color":"cx-theme_violet_3","displayName":"Instagram","seriesName":"Instagram","formulas":[{"txt":"lookup(&'ea7e37d3',group(SELECT(&'81d38267-33',&'63c7a456'=\"Instagram\")),groupby(SELECT(&'81d38267-33',&'63c7a456'=\"Instagram\"),SELECT(&'ebfbb10f',&'63c7a456'=\"Instagram\"),\"sum(values)\")) / lookup(&'ea7e37d3',group(SELECT(&'81d38267-33',&'63c7a456'=\"Instagram\")),groupby(SELECT(&'81d38267-33',&'63c7a456'=\"Instagram\"),SELECT(&'e5d38de7',&'63c7a456'=\"Instagram\"),\"sum(values)\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"6b97654f","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"precision":"2"},"id":"58803278"},{"role":"axis_x","data":[["Jul 2020","Aug 2020","Sep 2020","Oct 2020"]],"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":"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":"ea7e37d3","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"id":"6b97654f","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Goals","formulas":[],"autoFmt":true,"axisPosition":"right","id":"ef7f7a84","label":"Goals","type":"chart_axis","fmt":"num","labelDrop":0.0}],"displayName":"Bar/Line Chart Copy","id":"0e38fe8b","type":"chart_series","dstContext":{"kid":"6717ceade40133d8881baea67f9e51f1","id":"dst0e38fe8b"},"height":"3"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Instagram","Facebook","Instagram","Email","Email","Email","Instagram","Instagram","Instagram","Email","Facebook","Facebook","Instagram","Instagram","Email","Email","Facebook","Email","Email","Google Ads","Email","Facebook","Email","Google Ads","Email","Instagram","Google Ads","Instagram","Instagram","Facebook","Instagram","Facebook","Facebook","Instagram","Email","Email","Facebook","Facebook","Email","Instagram","Instagram","Google Ads","Google Ads","Facebook","Facebook","Email","Google Ads","Instagram","Facebook","Facebook","Email","Instagram","Email","Facebook","Email","Email","Email","Instagram","Facebook","Facebook","Google Ads","Email","Email","Facebook","Facebook","Email","Google Ads","Email","Facebook","Facebook","Facebook","Email","Instagram","Google Ads","Facebook","Email","Instagram","Email","Facebook","Email","Email","Facebook","Facebook","Google Ads","Instagram","Google Ads","Email","Google Ads","Facebook","Facebook","Instagram","Email","Email","Instagram","Google Ads","Email","Facebook","Facebook","Email","Instagram"]],"displayName":"Channel","formulas":[{"txt":"slice(896d40192f78f580758b903336f9a4e6@Marketing,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.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":"63c7a456"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Aug 12, 2020","Sep 29, 2020","Jul 23, 2020","Sep 17, 2020","Nov 4, 2020","Aug 11, 2020","Sep 12, 2020","Aug 26, 2020","Sep 18, 2020","Sep 4, 2020","Nov 1, 2020","Sep 13, 2020","Sep 18, 2020","Nov 5, 2020","Sep 24, 2020","Jul 4, 2020","Aug 19, 2020","Aug 3, 2020","Sep 29, 2020","Sep 26, 2020","Oct 26, 2020","Oct 14, 2020","Aug 12, 2020","Oct 6, 2020","Jul 22, 2020","Aug 2, 2020","Aug 5, 2020","Oct 7, 2020","Aug 23, 2020","Jul 2, 2020","Jul 11, 2020","Jul 6, 2020","Oct 8, 2020","Sep 28, 2020","Jul 19, 2020","Oct 29, 2020","Jul 23, 2020","Aug 4, 2020","Oct 15, 2020","Jul 26, 2020","Jul 30, 2020","Sep 7, 2020","Aug 15, 2020","Sep 9, 2020","Aug 27, 2020","Oct 25, 2020","Nov 2, 2020","Nov 5, 2020","Aug 4, 2020","Sep 27, 2020","Sep 21, 2020","Oct 13, 2020","Sep 4, 2020","Jul 7, 2020","Sep 24, 2020","Aug 20, 2020","Nov 6, 2020","Oct 9, 2020","Sep 21, 2020","Oct 5, 2020","Jul 17, 2020","Jul 26, 2020","Aug 1, 2020","Jul 13, 2020","Jul 24, 2020","Sep 14, 2020","Aug 1, 2020","Sep 12, 2020","Aug 4, 2020","Aug 23, 2020","Oct 31, 2020","Nov 1, 2020","Jul 14, 2020","Jul 4, 2020","Oct 29, 2020","Aug 6, 2020","Sep 1, 2020","Nov 5, 2020","Nov 1, 2020","Aug 11, 2020","Sep 25, 2020","Jul 27, 2020","Oct 14, 2020","Aug 12, 2020","Jul 3, 2020","Nov 6, 2020","Nov 2, 2020","Sep 20, 2020","Sep 29, 2020","Jul 11, 2020","Sep 7, 2020","Nov 6, 2020","Aug 18, 2020","Jul 26, 2020","Jul 19, 2020","Sep 17, 2020","Jul 2, 2020","Oct 2, 2020","Jul 18, 2020","Jul 31, 2020"]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(896d40192f78f580758b903336f9a4e6@Marketing,A:A;,\"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":"99bbecce"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Aug 2020","Sep 2020","Jul 2020","Sep 2020","Nov 2020","Aug 2020","Sep 2020","Aug 2020","Sep 2020","Sep 2020","Nov 2020","Sep 2020","Sep 2020","Nov 2020","Sep 2020","Jul 2020","Aug 2020","Aug 2020","Sep 2020","Sep 2020","Oct 2020","Oct 2020","Aug 2020","Oct 2020","Jul 2020","Aug 2020","Aug 2020","Oct 2020","Aug 2020","Jul 2020","Jul 2020","Jul 2020","Oct 2020","Sep 2020","Jul 2020","Oct 2020","Jul 2020","Aug 2020","Oct 2020","Jul 2020","Jul 2020","Sep 2020","Aug 2020","Sep 2020","Aug 2020","Oct 2020","Nov 2020","Nov 2020","Aug 2020","Sep 2020","Sep 2020","Oct 2020","Sep 2020","Jul 2020","Sep 2020","Aug 2020","Nov 2020","Oct 2020","Sep 2020","Oct 2020","Jul 2020","Jul 2020","Aug 2020","Jul 2020","Jul 2020","Sep 2020","Aug 2020","Sep 2020","Aug 2020","Aug 2020","Oct 2020","Nov 2020","Jul 2020","Jul 2020","Oct 2020","Aug 2020","Sep 2020","Nov 2020","Nov 2020","Aug 2020","Sep 2020","Jul 2020","Oct 2020","Aug 2020","Jul 2020","Nov 2020","Nov 2020","Sep 2020","Sep 2020","Jul 2020","Sep 2020","Nov 2020","Aug 2020","Jul 2020","Jul 2020","Sep 2020","Jul 2020","Oct 2020","Jul 2020","Jul 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'99bbecce',\"d MMM yyyy\"),\"m\",DATEVALUE(!'99bbecce',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.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":"Date","id":"81d38267-33"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["26.1","4.22","10.34","48.26","10.14","51.32","41.3","37.54","2.82","33.06","17.3","12.14","44.68","6.04","42.08","54.08","18.6","37.62","26.82","3.96","16.02","26.32","49.94","0.74","50.12","5.14","9.44","1.28","48.56","9.48","1.2","44.02","58.44","21.74","19.8","29.84","13.74","35.2","32.08","10.94","53.88","39.74","22.76","19.34","29.86","19.74","2.18","46.84","16.18","8.86","36.34","20.38","30.98","6.36","51.04","47.5","16.06","9.92","27.12","36.52","41.5","20.94","35.1","50.9","23.22","24.64","56.9","58.52","8.64","54","32.04","35.84","16.96","33.82","37.76","35.52","39.48","46.46","19.78","31.54","59.24","16.84","14.12","6","52.9","37.1","11.98","26.48","12.94","44.5","25.04","34.18","51","46.5","33.4","29.9","28.92","12.8","40.28","42.68"]],"displayName":"Sales Value","formulas":[{"txt":"slice(896d40192f78f580758b903336f9a4e6@Marketing,E:E;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.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":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales Value","id":"ebfbb10f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["3.2","3.5","7.9","0","0","0","9.5625","1.975","0.675","0","3.425","10.85","1.6125","2.5","0","0","1.275","0","0","3.19","0","7.9625","0","9.92","0","5.9125","0.77","3.4125","10.8375","0.95","5.4375","9.975","9.825","6.15","0","0","0.9875","10.1875","0","8.5875","7.3375","7.92","4.96","8.625","8.1625","0","7.18","1.0875","6.4","2.6375","0","1.55","0","1.7625","0","0","0","3.3125","1.15","7.7","3.11","0","0","7.8875","0.9625","0","0.35","0","3.0125","3.4125","9.2875","0","8.275","6.29","5.725","0","0.5375","0","1.1375","0","0","9.3625","5.275","5.87","5.15","0.66","0","8.79","10.9375","4.475","11.7875","0","0","4.1875","8.61","0","12","6.2375","0","2.9"]],"displayName":"Cost","formulas":[{"txt":"slice(896d40192f78f580758b903336f9a4e6@Marketing,D:D;)","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":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Cost","id":"e5d38de7"}],"displayName":"Table","id":"f8cfdcb2","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","dim":"99bbecce","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"99bbecce","variation":"condition"}],"kid":"6717ceade40133d8881baea67f9e51f1","id":"dstf8cfdcb2"}}],"isForked":false,"id":"8c3ebee0f40c41d7f91f26d97bdb5077","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Return on Ad Spend over Tiime","usesSampleData":false,"master":"6717ceade40133d8881baea67f9e51f1"}]}]