[{"tab":{"id":"762ab910776475df2fa2bee355b24a47","name":"Finances","layoutType":"grid","state":{"desktop":{"itemConfigs":[{"minHeight":210,"colSpan":6,"index":[0,0],"id":"gridklip-5da11171e52f802bd418ccef1f59e115"},{"minHeight":118,"colSpan":6,"index":[0,1],"id":"gridklip-f92113a80be225540bbb1b69f0de0fd6"},{"minHeight":506,"colSpan":6,"index":[0,2],"id":"gridklip-8efb9c7ff2171eb585bbc818ffe02854"},{"minHeight":406,"colSpan":6,"index":[0,3],"id":"gridklip-50eed3bba1adab3876601e0f6af6d23f"},{"minHeight":510,"colSpan":6,"index":[0,4],"id":"gridklip-856bcf9197a4a5da31ec7be36107f64f"},{"minHeight":363,"colSpan":3,"index":[0,5],"id":"gridklip-bfdb608d8c8275fcc1cd3cfba12d5f57"},{"minHeight":477,"colSpan":3,"index":[0,6],"id":"gridklip-2e002bbc46274adf7fe1cf048fab7641"},{"minHeight":150,"colSpan":6,"index":[0,7],"id":"gridklip-5fad9a4a213e3faadc2587b8c39cc928"},{"minHeight":256,"colSpan":3,"index":[0,8],"id":"gridklip-064ba3582668d7ca7b05552e97a62508","height":335},{"minHeight":784,"colSpan":6,"index":[0,9],"id":"gridklip-f8c2b89d0e9d1d03fec0bb3ece7eae0f"},{"minHeight":297,"colSpan":6,"index":[0,10],"id":"gridklip-fb7f9bf70e71bf6ef2d8f95c71bde503"},{"minHeight":256,"colSpan":3,"index":[3,5],"id":"gridklip-8397dc25f83b4e9070e2d9dfe6ac8532"},{"minHeight":472,"colSpan":3,"index":[3,6],"id":"gridklip-0241d5b52d8a707810dc9623ad1bf581","height":503},{"minHeight":283,"colSpan":3,"index":[3,8],"id":"gridklip-6b628d19101a0202fe7cc6da0a80155b"}],"colWidths":["auto","auto","auto","auto","auto","auto"],"cols":6}},"master":"762ab910776475df2fa2bee355b24a47"},"klips":[{"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":"

","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":"5da11171e52f802bd418ccef1f59e115","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"685ef16df9cbec639ecf20b110cf9882"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["A list of our top customers, this allows us to quickly see which customers are most important to our business."]],"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 our top customers, this allows us to quickly see which customers are most important to our business.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"6e58bf98","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"85670611977c276a483b237490f2ddd9","id":"dst6e58bf98"},"wrap":true},{"components":[{"components":[{"role":"customHeader","data":[["Customer Name"]],"displayName":"Customer","formulas":[{"txt":"\"Customer Name\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"85670611977c276a483b237490f2ddd9","id":"dst427ded1f"},"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":"427ded1f","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_yellow_green_5"}]}]}],"customHeader":true,"role":"tcol","data":[["Vine Networks","Wonderland Inc","Metal Age Services","Red Moment Systems","Cliff Technologies","Wild Child Mix","New Helio Factory","Whirlwindustries","Quadshine","Radiantelligence","Fairygold","Silverecords","Peachbooks","Owlimited","Iron Lighting"]],"displayName":"Customer","formulas":[{"txt":"&'4be47cc0'","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"txt","fw":"fixed","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"w":"40%","name":"Product","id":"617deb4e","renamed":true},{"components":[{"role":"customHeader","data":[["Total Value of Sales"]],"displayName":"Total Value","formulas":[{"txt":"\"Total Value of Sales\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"85670611977c276a483b237490f2ddd9","id":"dst536dd3f8"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"536dd3f8","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_yellow_green_5"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[55125.0,19589.0,19479.0,18391.0,18163.0,17791.0,17693.0,17223.0,4719.0,4715.0,4278.0,3744.0,2484.0,1821.0,1444.0]],"displayName":"Total Value","formulas":[{"txt":"&'5a375b6f'","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"cur","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"name":"Total Value","id":"9ea7fd33"},{"components":[{"role":"customHeader","data":[["# of Sales"]],"displayName":"% of Sales","formulas":[{"txt":"\"# of Sales\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"85670611977c276a483b237490f2ddd9","id":"dstfb0004ab"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"fb0004ab","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_yellow_green_5"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[27.0,20.0,38.0,10.0,15.0,39.0,5.0,39.0,33.0,15.0,11.0,32.0,6.0,5.0,36.0]],"displayName":"% of Sales","formulas":[{"txt":"&'60c49e4f-57'","ver":2.0}],"autoFmt":false,"index":2.0,"type":"table_col","fmt":"num","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},"precision":"0"},"name":"Number of Sales","id":"89209cff","renamed":true},{"components":[{"role":"customHeader","data":[["Duration"]],"displayName":"Average Price","formulas":[{"txt":"\"Duration\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"85670611977c276a483b237490f2ddd9","id":"dst51f4a597"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"51f4a597","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_yellow_green_5"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[7.134246575342465,4.535616438356165,11.736986301369862,13.708219178082192,5.982191780821918,2.76027397260274,10.421917808219177,13.14931506849315,9.961643835616439,12.032876712328767,5.784931506849315,12.493150684931507,6.804109589041096,10.389041095890411,5.752054794520548]],"displayName":"Average Price","formulas":[{"txt":"(today()-&'a5140d12')/(86400*365/12)","ver":2.0}],"autoFmt":false,"index":3.0,"type":"table_col","fmt":"num","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0","suffix":" months"},"name":"Average Price","id":"b99f71e5"}],"maxRows":"10","displayName":"Table 2","id":"84a196e8","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"args":[{"dim":"617deb4e"},{"value":"\"\""}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"}],"f":"not","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"617deb4e","variation":"condition"},{"sortBy":[{"dim":"9ea7fd33","dir":2.0}],"type":"sort"}],"kid":"85670611977c276a483b237490f2ddd9","id":"dst84a196e8"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5860052E9,1.5896376E9,1.5890328E9,1.5774516E9,1.5701976E9,1.5731316E9,1.571922E9,1.5895512E9,1.5785748E9,1.5868728E9,1.5739092E9,1.5928344E9,1.5975E9,1.5773652E9,1.5687288E9]],"displayName":"Date","formulas":[{"txt":"date(slice(8936ec37ce3f53bcd37735e708201e06@Customers,F:F;),\"M/d/yy\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.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":"a5140d12"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Vine Networks","Iron Lighting","Cliff Technologies","Owlimited","Whirlwindustries","Radiantelligence","Silverecords","Fairygold","Quadshine","Peachbooks","Metal Age Services","Wonderland Inc","Wild Child Mix","New Helio Factory","Red Moment Systems"]],"displayName":"Customer","formulas":[{"txt":"slice(8936ec37ce3f53bcd37735e708201e06@Customers,A:A;)","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":"Customer","id":"4be47cc0"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["55125","1444","18163","1821","17223","4715","3744","4278","4719","2484","19479","19589","17791","17693","18391"]],"displayName":"Sales Value","formulas":[{"txt":"slice(8936ec37ce3f53bcd37735e708201e06@Customers,B:B;)","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"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales Value","id":"5a375b6f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["27","36","15","5","39","15","32","11","33","6","38","20","39","5","10"]],"displayName":"Sales","formulas":[{"txt":"slice(8936ec37ce3f53bcd37735e708201e06@Customers,E:E;)","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"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales","id":"60c49e4f-57"}],"displayName":"Table","id":"3217345b","type":"table","dstContext":{"ops":[],"kid":"85670611977c276a483b237490f2ddd9","id":"dst3217345b"}}],"isForked":false,"id":"2e002bbc46274adf7fe1cf048fab7641","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Top Customers","usesSampleData":false,"master":"85670611977c276a483b237490f2ddd9"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["Displays the current bank balances. This allows you to keep track of liquidity and cash flow issues."]],"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 current bank balances. This allows you to keep track of liquidity and cash flow issues.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"5eedcd16","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"1dabfc044b4c7bb57d441120e2713dbe","id":"dst5eedcd16"},"wrap":true},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"data":[["https://www.flaticon.com/svg/static/icons/svg/662/662622.svg"]],"horizAlign":1.0,"displayName":"Image","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":"\"https://www.flaticon.com/svg/static/icons/svg/662/662622.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"id":"60fc7b41-1","type":"image","fmt":"txt","dstContext":{"kid":"1dabfc044b4c7bb57d441120e2713dbe","id":"dst60fc7b411"}},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"primary","data":[["Your Bank Balance has dropped below your minimum of $40,000."]],"displayName":"Primary Value","formulas":[{"txt":"if(&'228165e4-28'<40000,CONCAT(\"Your Bank Balance has dropped below your minimum of $40,000.\"),\"\")","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#d63044","type":"label","fmt":"txt","dstContext":{"kid":"1dabfc044b4c7bb57d441120e2713dbe","id":"dst34bb5eb618"},"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":"34bb5eb6-18","wrap":"active"},{"role":"secondary","data":[["Action To Take: follow up on the $3,490 sitting in overdue invoices that is owed to you."]],"displayName":"Secondary Value","formulas":[{"txt":"if(&'228165e4-28'<40000,CONCAT(\"Action To Take: follow up on the $\",NUMBERFORMAT(SUMIF(&'3b6be08b'3)","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"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"w":"40%","name":"Product","id":"40b4f87d","conditions":[{"predicates":[{"left":{"cx":"b6fd6475"},"right":{"cx":"76e44028"},"type":"lt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_1"}]}],"renamed":true},{"components":[{"role":"customHeader","data":[["Total Spend"]],"displayName":"Occurances","formulas":[{"txt":"\"Total Spend\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"2f941ee5c03c72da0c21ccc5da1bad8f","id":"dstca4b2d37"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"ca4b2d37","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_orange_5"}]}],"wrap":false}],"customHeader":true,"role":"tcol","data":[[4719.0,1444.0,4278.0]],"displayName":"Occurances","formulas":[{"txt":"select(8936ec37ce3f53bcd37735e708201e06@Customers,B:B;,8936ec37ce3f53bcd37735e708201e06@Customers,D:D;>3)","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"cur","align":"left","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},"precision":"0"},"w":"20%","name":"Occurances","id":"d50bc827","conditions":[{"predicates":[{"left":{"cx":"b6fd6475"},"right":{"cx":"76e44028"},"type":"lt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_1"}]}]},{"components":[{"role":"customHeader","data":[["Frequency"]],"displayName":"Frequency","formulas":[{"txt":"\"Frequency\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"2f941ee5c03c72da0c21ccc5da1bad8f","id":"dst242814f0"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"242814f0","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_orange_5"}]}]}],"customHeader":true,"role":"tcol","data":[[7.2,5.3,4.8]],"displayName":"Frequency","formulas":[{"txt":"select(8936ec37ce3f53bcd37735e708201e06@Customers,D:D;,8936ec37ce3f53bcd37735e708201e06@Customers,D:D;>3)","ver":2.0}],"autoFmt":false,"index":2.0,"type":"table_col","fmt":"num","align":"r","size":"x-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},"dateFormat":"custom","dateFormatCustom":"d MMM yyyy","precision":"1","dateInputFormat":"epoch"},"name":"Due Date","id":"473c4b25","conditions":[{"predicates":[{"left":{"cx":"b6fd6475"},"right":{"cx":"76e44028"},"type":"lt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_1"}]}],"renamed":true},{"components":[{"role":"customHeader","data":[["Last Invoiced"]],"displayName":"Last Invoiced","formulas":[{"txt":"\"Last Invoiced\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"2f941ee5c03c72da0c21ccc5da1bad8f","id":"dstcf868afc42"},"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":"cf868afc-42","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_orange_5"}]}]}],"customHeader":true,"role":"tcol","data":[["26 Oct 2020","29 Oct 2020","20 Oct 2020"]],"displayName":"Last Invoiced","formulas":[{"txt":"select(8936ec37ce3f53bcd37735e708201e06@Customers,C:C;,8936ec37ce3f53bcd37735e708201e06@Customers,D:D;>3)","ver":2.0}],"autoFmt":true,"index":3.0,"type":"table_col","fmt":"dat2","align":"left","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"d MMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Last Invoiced","id":"f524a65c-41"},{"role":"data","data":[[1.604754E9]],"displayName":"Today","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"today()","ver":2.0}],"autoFmt":true,"name":"Today","isDstRoot":true,"id":"76e44028","type":"data_slot","fmt":"txt","dstContext":{"kid":"2f941ee5c03c72da0c21ccc5da1bad8f","id":"dst76e44028"}}],"maxRows":"10","displayName":"Table 2","id":"b30b5621","type":"table","dstContext":{"ops":[{"sortBy":[{"dim":"473c4b25","dir":2.0}],"type":"sort"}],"kid":"2f941ee5c03c72da0c21ccc5da1bad8f","id":"dstb30b5621"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Cliff Technologies","Owlimited","Whirlwindustries","Radiantelligence","Silverecords","Fairygold","Radiantelligence","Silverecords","Fairygold"]],"displayName":"Client","formulas":[{"txt":"select(a2d75942456c71f47060d9f50d075fd4@Invoices,D:D;,a2d75942456c71f47060d9f50d075fd4@Invoices,C:C;=\"Oustanding\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.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":"Client","id":"9ea9e6a0"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["INV-10861","INV-44457","INV-88060","INV-93371","INV-72262","INV-73682","INV-47508","INV-46214","INV-81155"]],"displayName":"Inv_number","formulas":[{"txt":"concat(\"INV-\",left(slice(a2d75942456c71f47060d9f50d075fd4@Invoices,B:B;),5))","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":"Inv_number","id":"c31ce5f8"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["550","190","1930","1030","170","370","1770","1700","1740"]],"displayName":"Amount","formulas":[{"txt":"select(a2d75942456c71f47060d9f50d075fd4@Invoices,E:E;,a2d75942456c71f47060d9f50d075fd4@Invoices,C:C;=\"Oustanding\")","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"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Amount","id":"c506e14e"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.60389E9,1.602594E9,1.6031124E9,1.6039764E9,1.6022484E9,1.6044084E9,1.60605E9,1.6070004E9,1.6055316E9]],"displayName":"Due Date","formulas":[{"txt":"select(DATE(a2d75942456c71f47060d9f50d075fd4@Invoices,F:F;,\"M/d/yy\"),a2d75942456c71f47060d9f50d075fd4@Invoices,C:C;=\"Oustanding\")","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":"Due Date","id":"117b5424"}],"displayName":"Table","id":"e45c05aa","type":"table","dstContext":{"kid":"2f941ee5c03c72da0c21ccc5da1bad8f","id":"dste45c05aa"}}],"isForked":false,"id":"064ba3582668d7ca7b05552e97a62508","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Reduced Frequency","usesSampleData":false,"master":"2f941ee5c03c72da0c21ccc5da1bad8f"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["Displays all outstanding invoices so that we can quickly see what is owing and how much of it is overdue."]],"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 all outstanding invoices so that we can quickly see what is owing and how much of it is overdue.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"51fb3cab","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"32cf4c2d4c7accd0bc16fa43bb845305","id":"dst51fb3cab"},"wrap":true},{"data":[["Action To Take: follow up on the $6,100 sitting in overdue invoices that is owed."]],"displayName":"Label 3","formulas":[{"txt":"if(&'1946575e'>0,CONCAT(\"Action To Take: follow up on the $\",NUMBERFORMAT(SUMIF(&'49fe8188' 30, &'bff784cb'),sumif(AND((&'49fe8188'-today())/86400 <= 30,(&'49fe8188'-today())/86400 > 14), &'bff784cb'), sumif(AND((&'49fe8188'-today())/86400 <= 14,(&'49fe8188'-today())/86400 > 7), &'bff784cb'),sumif(AND((&'49fe8188'-today())/86400 <= 7,(&'49fe8188'-today())/86400 >= 0), &'bff784cb'),sumif((&'49fe8188'-today())/86400 < 0, &'bff784cb'))","ver":2.0}],"autoFmt":false,"id":"146728f5-42","type":"series_data","fmt":"cur"},{"role":"labels","data":[["Due Date more than 30 Days away","Due in next 30 Days","Due in next 14 Days","Due in next 7 Days","Overdue"]],"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":"array(\"Due Date more than 30 Days away\",\"Due in next 30 Days\",\"Due in next 14 Days\",\"Due in next 7 Days\",\"Overdue\")","ver":2.0}],"autoFmt":true,"id":"5036a74d-43","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["#0d2e6e","#556c99","#9eabc5","#ffab40","#d63044","cx-theme_brown_3","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart","legend_labels":"2","id":"018b8340-41","type":"chart_pie","dstContext":{"kid":"32cf4c2d4c7accd0bc16fa43bb845305","id":"dst018b834041"},"overrideColors":true}],"displayName":"Layout Grid 3","id":"1cec9826-45","type":"panel_grid","rows":2.0,"cols":1.0},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"primary","data":[["Amount Overdue"]],"displayName":"Primary Value","formulas":[{"txt":"\"Amount Overdue\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#d63044","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"32cf4c2d4c7accd0bc16fa43bb845305","id":"dst74d2676a"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"74d2676a"},{"role":"secondary","data":[[6100.0]],"displayName":"Secondary Value","formulas":[{"txt":"SUMIF(&'49fe8188'today(),CUMULATIVE(LOOKUP(!'b3493db5-3',&'112f0fc4-6',&'8ef72cf7-15')),\"\")","ver":2.0}],"autoFmt":false,"leaveGaps":true,"type":"series_data","fmt":"cur","axis":"d766aea9-4","lineDashes":"Dash","chartStyle":"line","overrideColor":true,"lineWeight":"4","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"99732749-26"},{"role":"axis_x","data":[["1 Apr","2 Apr","3 Apr","4 Apr","5 Apr","6 Apr","7 Apr","8 Apr","9 Apr","10 Apr","11 Apr","12 Apr","13 Apr","14 Apr","15 Apr","16 Apr","17 Apr","18 Apr","19 Apr","20 Apr","21 Apr","22 Apr","23 Apr","24 Apr","25 Apr","26 Apr","27 Apr","28 Apr","29 Apr","30 Apr"]],"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"},"isDSTApplied":true},"dateFormat":"custom","dateFormatCustom":"d MMM","dateInputFormat":"epoch"},"formulas":[{"txt":"DATERANGE(DATE_STARTOF(today(),\"3\"),DATE_ENDOF(today(),\"3\"))","ver":2.0}],"autoFmt":false,"id":"b3493db5-3","label":"Untitled","type":"chart_axis","fmt":"dat2","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"cur","grid":true,"fmtArgs":{},"id":"d766aea9-4","labelDrop":0.0}],"displayName":"Bar/Line Chart","id":"578e4762-1","type":"chart_series","dstContext":{"kid":"35e736ae5ade385b4be119c4ba5a9ec5","id":"dst578e47621"},"stackBars":"1","height":"4"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6171956E9,1.617282E9,1.6173684E9,1.6174548E9,1.6175448E9,1.6176312E9,1.6177176E9,1.617804E9,1.6178904E9,1.6179768E9,1.6180632E9,1.6181496E9,1.618236E9,1.6183224E9,1.6184088E9,1.6184952E9,1.6185816E9,1.618668E9,1.6187544E9,1.6188408E9,1.6189272E9,1.6190136E9,1.6191E9,1.6191864E9,1.6192728E9,1.6193592E9,1.6194456E9,1.619532E9,1.6196184E9,1.6197048E9,""]],"displayName":"Date","formulas":[{"txt":"DATERANGE(DATE_STARTOF(today(),\"3\"),DATE_ENDOF(today(),\"3\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date","id":"112f0fc4-6"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[135.0,1223.0,1501.0,1522.0,1508.0,1207.0,260.0,1807.0,591.0,1246.0,705.0,1715.0,1253.0,1864.0,307.0,715.0,69.0,1394.0,742.0,775.0,1031.0,1461.0,890.0,1430.0,1957.0,1005.0,1749.0,11.0,763.0,1448.0,214.0]],"displayName":"Revenue","formulas":[{"txt":"ARRAY(\"135\", \"1223\", \"1501\", \"1522\", \"1508\", \"1207\", \"260\", \"1807\", \"591\", \"1246\", \"705\", \"1715\", \"1253\", \"1864\", \"307\", \"715\", \"69\", \"1394\", \"742\", \"775\", \"1031\", \"1461\", \"890\", \"1430\", \"1957\", \"1005\", \"1749\", \"11\", \"763\", \"1448\", \"214\")","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":1.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"}}},"name":"Revenue","id":"575e4bc9-9"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["687","515","1666","1915","1203","1352","779","16","1167","673","1912","1347","629","824","1480","1843","679","1521","1240","372","281","1765","464","1339","1959","1415","545","985","784","681","243"]],"displayName":"Forecast","formulas":[{"txt":"ARRAY(\"687\", \"515\", \"1666\", \"1915\", \"1203\", \"1352\", \"779\", \"16\", \"1167\", \"673\", \"1912\", \"1347\", \"629\", \"824\", \"1480\", \"1843\", \"679\", \"1521\", \"1240\", \"372\", \"281\", \"1765\", \"464\", \"1339\", \"1959\", \"1415\", \"545\", \"985\", \"784\", \"681\", \"243\")","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"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Forecast","id":"8ef72cf7-15"}],"displayName":"Table","id":"b9a1b601-5","type":"table","dstContext":{"kid":"35e736ae5ade385b4be119c4ba5a9ec5","id":"dstb9a1b6015"}}],"isForked":false,"id":"8efb9c7ff2171eb585bbc818ffe02854","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Revenue this Month","usesSampleData":false,"master":"35e736ae5ade385b4be119c4ba5a9ec5"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["This report highlights all customers that account for more than 10% of total revenue. This highlights the risks associated with a non-diversified client base."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"This report highlights all customers that account for more than 10% of total revenue. This highlights the risks associated with a non-diversified client base.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"603521be","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"207ecd051470a882779209cfd11bdd4b","id":"dst603521be"},"wrap":true},{"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["Vine Networks accounts for 26.67% of Total Revenue"]],"displayName":"Lost Reason","formulas":[{"txt":"concat(select(slice(8936ec37ce3f53bcd37735e708201e06@Customers,A:A;),(SLICE(8936ec37ce3f53bcd37735e708201e06@Customers,B:B;)/SUM(8936ec37ce3f53bcd37735e708201e06@Customers,B:B;))>0.1),\" accounts for \",ROUND(select((SLICE(8936ec37ce3f53bcd37735e708201e06@Customers,B:B;)/SUM(8936ec37ce3f53bcd37735e708201e06@Customers,B:B;)),(SLICE(8936ec37ce3f53bcd37735e708201e06@Customers,B:B;)/SUM(8936ec37ce3f53bcd37735e708201e06@Customers,B:B;))>0.1)*100,2),\"% of Total Revenue\")","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"txt","align":"c","size":"medium","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"}},"w":"40%","name":"Product","id":"611447da","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_red_1","isScalar":true}]}],"renamed":true,"wrap":"active"},{"role":"data","data":[[1.604754E9]],"displayName":"Today","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"today()","ver":2.0}],"autoFmt":true,"name":"Today","isDstRoot":true,"id":"25865ead","type":"data_slot","fmt":"txt","dstContext":{"kid":"207ecd051470a882779209cfd11bdd4b","id":"dst25865ead"}}],"maxRows":"10","displayName":"Table 2","showHeader":false,"id":"4ad55629","type":"table","dstContext":{"ops":[],"kid":"207ecd051470a882779209cfd11bdd4b","id":"dst4ad55629"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Cliff Technologies","Owlimited","Whirlwindustries","Radiantelligence","Silverecords","Fairygold","Radiantelligence","Silverecords","Fairygold"]],"displayName":"Client","formulas":[{"txt":"select(a2d75942456c71f47060d9f50d075fd4@Invoices,D:D;,a2d75942456c71f47060d9f50d075fd4@Invoices,C:C;=\"Oustanding\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.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":"Client","id":"08aa5418"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["INV-96852","INV-60021","INV-50477","INV-71625","INV-46379","INV-86463","INV-33479","INV-14358","INV-49040"]],"displayName":"Inv_number","formulas":[{"txt":"concat(\"INV-\",left(slice(a2d75942456c71f47060d9f50d075fd4@Invoices,B:B;),5))","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":"Inv_number","id":"e7896cc6"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["1080","620","670","1430","1370","300","160","160","690"]],"displayName":"Amount","formulas":[{"txt":"select(a2d75942456c71f47060d9f50d075fd4@Invoices,E:E;,a2d75942456c71f47060d9f50d075fd4@Invoices,C:C;=\"Oustanding\")","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"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Amount","id":"40efa8a8"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6042356E9,1.60389E9,1.603026E9,1.6044084E9,1.6037172E9,1.6045812E9,1.6057044E9,1.6050132E9,1.6063092E9]],"displayName":"Due Date","formulas":[{"txt":"select(DATE(a2d75942456c71f47060d9f50d075fd4@Invoices,F:F;,\"M/d/yy\"),a2d75942456c71f47060d9f50d075fd4@Invoices,C:C;=\"Oustanding\")","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":"Due Date","id":"7f2a64c3"}],"displayName":"Table","id":"994e7fbd","type":"table","dstContext":{"kid":"207ecd051470a882779209cfd11bdd4b","id":"dst994e7fbd"}}],"isForked":false,"id":"5fad9a4a213e3faadc2587b8c39cc928","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Customers that account for more than 10% of Revenue","usesSampleData":false,"master":"207ecd051470a882779209cfd11bdd4b"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06"],"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":"1f66ba7e","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"23581b1636159590d2e633002a1d8dac","id":"dst1f66ba7e"},"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":"23581b1636159590d2e633002a1d8dac","id":"dstd7687757"},"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":"d7687757","wrap":true},{"data":[[""]],"displayName":"Label 3","formulas":[{"txt":"if(LAST(&'f9af6822')>10,\"\",\"Warning - Net Profit Margin has dropped below minimum of 10% for the current month\")","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#d63044","type":"label","fmt":"txt","dstContext":{"kid":"23581b1636159590d2e633002a1d8dac","id":"dst2d9e2a8e43"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"2d9e2a8e-43","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"Warning"},"type":"contain"}],"reactions":[{"type":"icon","value":"ind-triangle-warning-red","isScalar":true},{"pos":"right","type":"icon","isScalar":true,"value":"ind-triangle-warning-red"}]}],"wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"series","data":[[140759.0,112693.0,143984.0,187909.0,152282.0,160749.0,169483.0,163248.0,193727.0,156158.0,115737.0,181557.0,106757.0]],"color":"#0d2e6e","displayName":"Income","seriesName":"Income","formulas":[{"txt":"lookup(&'53cade9f',group(SELECT(&'daca5a59',&'a8326c7e'=\"Income\")),groupby(SELECT(&'daca5a59',&'a8326c7e'=\"Income\"),SELECT(&'4b0c6c1d',&'a8326c7e'=\"Income\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"90cecec8","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":"01718a58"},{"role":"series","data":[[59021.0,75968.0,93769.0,78501.0,64797.0,98574.0,84466.0,81521.0,77186.0,70230.0,80165.0,92172.0,65503.0]],"color":"#ffab40","displayName":"Cost of Sales","seriesName":"Cost of Sales","formulas":[{"txt":"lookup(&'53cade9f',group(SELECT(&'daca5a59',&'337525eb'=\"Cost of Sales\")),groupby(SELECT(&'daca5a59',&'337525eb'=\"Cost of Sales\"),SELECT(&'4b0c6c1d',&'337525eb'=\"Cost of Sales\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"90cecec8","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":"e90ea6cd"},{"role":"series","data":[[25966.0,23843.0,24889.0,28480.0,34579.0,22099.0,21277.0,26645.0,25128.0,33605.0,19364.0,28284.0,26959.0]],"color":"#d63044","displayName":"Operating Expenses","seriesName":"Operating Expenses","formulas":[{"txt":"lookup(&'53cade9f',group(SELECT(&'daca5a59',&'a8326c7e'=\"Less Operating Expenses\")),groupby(SELECT(&'daca5a59',&'a8326c7e'=\"Less Operating Expenses\"),SELECT(&'4b0c6c1d',&'a8326c7e'=\"Less Operating Expenses\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"90cecec8","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":"5857a78e"},{"renderer":"line","showValues":true,"role":"series","data":[[39.6223332078233,11.431056054945737,17.589454383820424,43.06765508836724,34.74212316623107,24.93079272654884,37.60849170713287,33.74130157796726,47.18650472056037,33.50644859693387,14.004164614600345,33.65389381847023,13.390222655188888]],"color":"#e40046","displayName":"Net Profit","seriesName":"Net Profit","formulas":[{"txt":"(&'01718a58'-&'5857a78e'-&'e90ea6cd')/&'01718a58'*100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"9c2d2005-42","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"f9af6822"},{"role":"axis_x","data":[["Jul 2021","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"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"DATEVALUE(GROUP(DATE_STARTOF(DATERANGE(DATE_ADD(today(),\"1\",-1),today()),\"3\")),\"MMM yyyy\")","ver":2.0}],"autoFmt":true,"id":"53cade9f","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":"90cecec8","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Perc","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Untitled","type":"chart_axis","fmt":"pct","fmtArgs":{},"id":"9c2d2005-42","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","id":"2482b3bc","type":"chart_series","dstContext":{"kid":"23581b1636159590d2e633002a1d8dac","id":"dst2482b3bc"},"height":"3"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Income","Less Cost of Sales","Gross Profit","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Employment Expenses","Employment Expenses","Net Profit","Income","Less Cost of Sales","Gross Profit","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Employment Expenses","Employment Expenses","Net Profit","Income","Less Cost of Sales","Gross Profit","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Employment Expenses","Employment Expenses","Net Profit","Income","Less Cost of Sales","Gross Profit","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Employment Expenses","Employment Expenses","Net Profit","Income","Less Cost of Sales","Gross Profit","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Employment Expenses","Employment Expenses","Net Profit","Income","Less Cost of Sales","Gross Profit","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses"]],"displayName":"Category","formulas":[{"txt":"8936ec37ce3f53bcd37735e708201e06@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":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Category","id":"a8326c7e"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Sales","Cost of Sales","Gross Profit","Accounting","Advertising","Bank Fees","Client Gifts","Donations","Entertainment","Motor Vehicle Expenses","Office Expenses","Staff Meetings","Staff Training","Staff Well-Being & Amenities","Telephone and Internet","Superannuation","Wages and Salaries","Net Profit","Sales","Cost of Sales","Gross Profit","Accounting","Advertising","Bank Fees","Client Gifts","Donations","Entertainment","Motor Vehicle Expenses","Office Expenses","Staff Meetings","Staff Training","Staff Well-Being & Amenities","Telephone and Internet","Superannuation","Wages and Salaries","Net Profit","Sales","Cost of Sales","Gross Profit","Accounting","Advertising","Bank Fees","Client Gifts","Donations","Entertainment","Motor Vehicle Expenses","Office Expenses","Staff Meetings","Staff Training","Staff Well-Being & Amenities","Telephone and Internet","Superannuation","Wages and Salaries","Net Profit","Sales","Cost of Sales","Gross Profit","Accounting","Advertising","Bank Fees","Client Gifts","Donations","Entertainment","Motor Vehicle Expenses","Office Expenses","Staff Meetings","Staff Training","Staff Well-Being & Amenities","Telephone and Internet","Superannuation","Wages and Salaries","Net Profit","Sales","Cost of Sales","Gross Profit","Accounting","Advertising","Bank Fees","Client Gifts","Donations","Entertainment","Motor Vehicle Expenses","Office Expenses","Staff Meetings","Staff Training","Staff Well-Being & Amenities","Telephone and Internet","Superannuation","Wages and Salaries","Net Profit","Sales","Cost of Sales","Gross Profit","Accounting","Advertising","Bank Fees","Client Gifts","Donations","Entertainment","Motor Vehicle Expenses"]],"displayName":"Account","formulas":[{"txt":"8936ec37ce3f53bcd37735e708201e06@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":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Account","id":"337525eb"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6565976E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6540056E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6513272E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6487316E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.6460532E9,1.643634E9,1.643634E9,1.643634E9,1.643634E9,1.643634E9,1.643634E9,1.643634E9,1.643634E9,1.643634E9,1.643634E9]],"displayName":"Date_Raw","formulas":[{"txt":"date(8936ec37ce3f53bcd37735e708201e06@Xero,C:C;,\"M/d/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":"19dcb32b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jul 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","Jun 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","May 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Apr 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Mar 2022","Feb 2022","Feb 2022","Feb 2022","Feb 2022","Feb 2022","Feb 2022","Feb 2022","Feb 2022","Feb 2022","Feb 2022"]],"displayName":"Date","formulas":[{"txt":"DATEVALUE(&'19dcb32b',\"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":"daca5a59"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["106757","65503","41254","3072","2178","981","3831","1267","2264","1660","3190","3180","1876","2650","810","446","4459","9390","181557","92172","89385","2100","1488","3078","3800","128","3447","3405","1087","594","3733","2446","2978","426","4263","56412","115737","80165","35572","3585","3527","2106","3431","297","341","1291","606","1031","111","819","2219","610","6103","9495","156158","70230","85928","3733","3134","861","3188","3390","3140","1899","3356","3387","2816","1783","2918","621","6211","45491","193727","77186","116541","547","1580","2324","2736","3735","604","2375","3152","1926","3195","1845","1109","676","6757","83980","163248","81521","81727","1290","2704","1268","3786","3866","2909","756"]],"displayName":"Value","formulas":[{"txt":"8936ec37ce3f53bcd37735e708201e06@Xero,D:D;","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":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Value","id":"4b0c6c1d"}],"displayName":"Table","id":"128a20b2","type":"table","dstContext":{"ops":[],"kid":"23581b1636159590d2e633002a1d8dac","id":"dst128a20b2"}}],"isForked":false,"id":"856bcf9197a4a5da31ec7be36107f64f","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Profit & Loss","usesSampleData":false,"master":"23581b1636159590d2e633002a1d8dac"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["A list of our top suppliers, this allows us to quickly see which suppliers are most important to our business."]],"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 our top suppliers, this allows us to quickly see which suppliers are most important to our business.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"b04f100e","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"3f520036000cb64af0a4a8e62a76a50b","id":"dstb04f100e"},"wrap":true},{"components":[{"components":[{"role":"customHeader","data":[["Supplier Name"]],"displayName":"Customer","formulas":[{"txt":"\"Supplier Name\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"3f520036000cb64af0a4a8e62a76a50b","id":"dst822178f6"},"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":"822178f6","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":[["Armada Inc","Gold Instant Industries","Blue Cutter Systems","Zink Systems","WorldWide Inc","Silver Goldenrod Systems","Moveable Parts Inc","Main Water & Power Inc","Artificial Horizon Works","Magneto Inc"]],"displayName":"Customer","formulas":[{"txt":"&'e13ac0cf'","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"txt","fw":"fixed","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"w":"40%","name":"Product","id":"35a8d0b5","renamed":true},{"components":[{"role":"customHeader","data":[["Total Value of Purchases"]],"displayName":"Total Value","formulas":[{"txt":"\"Total Value of Purchases\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"3f520036000cb64af0a4a8e62a76a50b","id":"dst1b9c4a9f"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"1b9c4a9f","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"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[14834.0,13482.0,12125.0,7855.0,7018.0,4521.0,4315.0,3934.0,2701.0,1044.0]],"displayName":"Total Value","formulas":[{"txt":"&'7e38bc66'","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"cur","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"name":"Total Value","id":"0a775d3b"},{"components":[{"role":"customHeader","data":[["Duration"]],"displayName":"Average Price","formulas":[{"txt":"\"Duration\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"3f520036000cb64af0a4a8e62a76a50b","id":"dst26b00dcc"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"26b00dcc","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"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[13.084931506849315,3.4178082191780823,8.449315068493151,1.773972602739726,9.895890410958904,6.015068493150685,17.48904109589041,11.736986301369862,1.5438356164383562,5.028767123287671]],"displayName":"Average Price","formulas":[{"txt":"(today()-&'dace679c')/(86400*365/12)","ver":2.0}],"autoFmt":false,"index":2.0,"type":"table_col","fmt":"num","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0","suffix":" months"},"name":"Average Price","id":"487da65a"}],"maxRows":"10","displayName":"Table 2","id":"6ea29f99","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"args":[{"dim":"35a8d0b5"},{"value":"\"\""}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"}],"f":"not","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"35a8d0b5","variation":"condition"},{"sortBy":[{"dim":"0a775d3b","dir":2.0}],"type":"sort"}],"kid":"3f520036000cb64af0a4a8e62a76a50b","id":"dst6ea29f99"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.600092E9,1.5825492E9,1.5739092E9,1.595772E9,1.5587928E9,1.5889464E9,1.5787476E9,1.6006968E9,1.5703668E9,1.5915384E9]],"displayName":"Date","formulas":[{"txt":"date(slice(8936ec37ce3f53bcd37735e708201e06@Suppliers,C:C;),\"M/d/yy\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.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":"dace679c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Zink Systems","Blue Cutter Systems","Main Water & Power Inc","Gold Instant Industries","Moveable Parts Inc","Silver Goldenrod Systems","WorldWide Inc","Artificial Horizon Works","Armada Inc","Magneto Inc"]],"displayName":"Customer","formulas":[{"txt":"slice(8936ec37ce3f53bcd37735e708201e06@Suppliers,A:A;)","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":"Customer","id":"e13ac0cf"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["7855","12125","3934","13482","4315","4521","7018","2701","14834","1044"]],"displayName":"Sales Value","formulas":[{"txt":"slice(8936ec37ce3f53bcd37735e708201e06@Suppliers,B:B;)","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"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Sales Value","id":"7e38bc66"}],"displayName":"Table","id":"18cc003a","type":"table","dstContext":{"ops":[],"kid":"3f520036000cb64af0a4a8e62a76a50b","id":"dst18cc003a"}}],"isForked":false,"id":"0241d5b52d8a707810dc9623ad1bf581","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Top Suppliers","usesSampleData":false,"master":"3f520036000cb64af0a4a8e62a76a50b"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06"],"dimensions":{"w":1360.0}},"components":[{"size":"xx-small","data":[["Displays a breakdown of the top operating expenses for the selected month."]],"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 a breakdown of the top operating expenses for the selected month.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"fe77bfb2","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"817f198380962fcae1012169107c30ae","id":"dstfe77bfb2"},"wrap":true},{"components":[{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[["1604149200","1601474400","1598882400","1596204000","1593525600","1590933600","1588255200","1585659600","1582981200","1580475600","1577797200","1575118800","1572526800","1569852000"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}}},"formulas":[{"txt":"REVERSE(GROUP(DATE_STARTOF(DATERANGE(DATE_ADD(today(),\"3\",-13),today()),\"3\")))","ver":2.0}],"autoFmt":false,"id":"e5057dc8","type":"proxy"},{"role":"labels","data":[["November 2020","October 2020","September 2020","August 2020","July 2020","June 2020","May 2020","April 2020","March 2020","February 2020","January 2020","December 2019","November 2019","October 2019"]],"displayName":"Labels","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":"DATEVALUE(&'e5057dc8',\"MMMM yyyy\")","ver":2.0}],"autoFmt":false,"id":"13d81f9c","type":"proxy"}],"displayName":"User Input Control","scope":2.0,"inputLabel":"Date","inputType":1.0,"id":"cac9a684","type":"input","dstContext":{"kid":"817f198380962fcae1012169107c30ae","id":"dstcac9a684"},"propName":"plFilter"}],"displayName":"Layout Grid 2","id":"34fd2c18","type":"panel_grid","rows":1.0,"cols":3.0},{"components":[{"role":"data","data":[[3656.0,3041.0,2940.0,2916.0,2550.0,2445.0,2175.0,1746.0,817.0,212.0,149.0,135.0]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"formulas":[{"txt":"GROUPBY(SELECT(&'ae47a84c',&'583163a9'=\"Less Operating Expenses\"),SELECT(&'8b700be1',&'583163a9'=\"Less Operating Expenses\"))","ver":2.0}],"autoFmt":false,"id":"2bdde6da-98","type":"series_data","fmt":"cur"},{"role":"labels","data":[["Accounting","Motor Vehicle Expenses","Office Expenses","Advertising","Donations","Staff Well-Being & Amenities","Staff Training","Staff Meetings","Entertainment","Client Gifts","Bank Fees","Telephone and Internet"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"GROUP(SELECT(&'ae47a84c',&'583163a9'=\"Less Operating Expenses\"))","ver":2.0}],"autoFmt":true,"id":"30d917ca-99","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["cx-theme_blue_3","cx-theme_green_3","cx-theme_orange_3","cx-theme_red_3","cx-theme_violet_3","cx-theme_brown_3","#cc527b","#33867f","cx-theme_warm_gray_4"],"displayName":"Pie Chart","id":"9d38c55a-97","type":"chart_pie","dstContext":{"ops":[{"sortBy":[{"dim":"2bdde6da98","dir":2.0}],"type":"sort"}],"kid":"817f198380962fcae1012169107c30ae","id":"dst9d38c55a97"},"legend_items":"9","overrideColors":true},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Income","Less Cost of Sales","Gross Profit","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Less Operating Expenses","Employment Expenses","Employment Expenses","Net Profit"]],"displayName":"Type","formulas":[{"txt":"8936ec37ce3f53bcd37735e708201e06@Xero,A:A;","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Type","id":"583163a9"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Sales","Cost of Sales","Gross Profit","Accounting","Advertising","Bank Fees","Client Gifts","Donations","Entertainment","Motor Vehicle Expenses","Office Expenses","Staff Meetings","Staff Training","Staff Well-Being & Amenities","Telephone and Internet","Superannuation","Wages and Salaries","Net Profit"]],"displayName":"Acc","formulas":[{"txt":"8936ec37ce3f53bcd37735e708201e06@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":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Acc","id":"ae47a84c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5935256E9]],"displayName":"Date","formulas":[{"txt":"date(8936ec37ce3f53bcd37735e708201e06@Xero,C:C;,\"M/d/yyyy\")","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":2.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":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"name":"Date","id":"f745c397"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["175369","73809","101560","3656","2916","149","212","2550","817","3041","2940","1746","2175","2445","135","563","5634","72581"]],"displayName":"Rev","formulas":[{"txt":"8936ec37ce3f53bcd37735e708201e06@Xero,D:D;","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":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Rev","id":"8b700be1"}],"displayName":"Table","id":"81916ff6","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":"=","dim":"f745c397","type":"op","value":{"var":"plFilter"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"f745c397","variation":"condition"}],"kid":"817f198380962fcae1012169107c30ae","id":"dst81916ff6"}}],"isForked":false,"id":"bfdb608d8c8275fcc1cd3cfba12d5f57","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Operating Expenses","usesSampleData":false,"master":"817f198380962fcae1012169107c30ae"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["Displays customers that have made the fewest purchases over the past 12 months. This can help us identify customers where we may be able to upsell."]],"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 customers that have made the fewest purchases over the past 12 months. This can help us identify customers where we may be able to upsell.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"577a182a","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"1911fe2b39e1c436264930aca0d2e9aa","id":"dst577a182a"},"wrap":true},{"components":[{"components":[{"role":"customHeader","data":[["Client"]],"displayName":"Lost Reason","formulas":[{"txt":"\"Client\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1911fe2b39e1c436264930aca0d2e9aa","id":"dstc595fd76"},"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":"c595fd76","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_4"}]}]}],"customHeader":true,"role":"tcol","data":[["Owlimited","New Helio Factory","Peachbooks","Silverecords","Fairygold","Iron Lighting"]],"displayName":"Lost Reason","formulas":[{"txt":"select(slice(8936ec37ce3f53bcd37735e708201e06@Customers,A:A;),SLICE(8936ec37ce3f53bcd37735e708201e06@Customers,E:E;)<10)","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"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"w":"40%","name":"Product","id":"90f3f6c8","conditions":[{"predicates":[{"left":{},"right":{"cx":"3ccc3e04"},"type":"lt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_1"}]}],"renamed":true},{"components":[{"role":"customHeader","data":[["Total Spend"]],"displayName":"Occurances","formulas":[{"txt":"\"Total Spend\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1911fe2b39e1c436264930aca0d2e9aa","id":"dst8a86d526"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"8a86d526","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_4"}]}],"wrap":false}],"customHeader":true,"role":"tcol","data":[[1821.0,17693.0,2484.0,3744.0,4278.0,1444.0]],"displayName":"Occurances","formulas":[{"txt":"select(slice(8936ec37ce3f53bcd37735e708201e06@Customers,B:B;),SLICE(8936ec37ce3f53bcd37735e708201e06@Customers,E:E;)<10)","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"cur","align":"left","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},"precision":"0"},"w":"20%","name":"Occurances","id":"a387c6d0","conditions":[{"predicates":[{"left":{},"right":{"cx":"3ccc3e04"},"type":"lt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_1"}]}]},{"components":[{"role":"customHeader","data":[["Total Purchases - Past 12 months"]],"displayName":"Frequency","formulas":[{"txt":"\"Total Purchases - Past 12 months\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1911fe2b39e1c436264930aca0d2e9aa","id":"dstb6a4a62b"},"align":"r","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"b6a4a62b","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_4"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[5.0,5.0,6.0,7.0,8.0,9.0]],"displayName":"Frequency","formulas":[{"txt":"select(slice(8936ec37ce3f53bcd37735e708201e06@Customers,E:E;),SLICE(8936ec37ce3f53bcd37735e708201e06@Customers,E:E;)<10)","ver":2.0}],"autoFmt":false,"index":2.0,"type":"table_col","fmt":"num","align":"r","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},"dateFormat":"custom","dateFormatCustom":"d MMM yyyy","precision":"1","dateInputFormat":"epoch"},"name":"Due Date","id":"b80c8abc","conditions":[{"predicates":[{"left":{},"right":{"cx":"3ccc3e04"},"type":"lt"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_1"}]}],"renamed":true},{"components":[{"role":"customHeader","data":[["Last Invoiced"]],"displayName":"Last Invoiced","formulas":[{"txt":"\"Last Invoiced\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"1911fe2b39e1c436264930aca0d2e9aa","id":"dst2a0eef83"},"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":"2a0eef83","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_4"}]}]}],"customHeader":true,"role":"tcol","data":[["8 Oct 2020","2 Oct 2020","27 Sep 2020","23 Oct 2020","20 Oct 2020","29 Oct 2020"]],"displayName":"Last Invoiced","formulas":[{"txt":"select(slice(8936ec37ce3f53bcd37735e708201e06@Customers,C:C;),SLICE(8936ec37ce3f53bcd37735e708201e06@Customers,E:E;)<10)","ver":2.0}],"autoFmt":true,"index":3.0,"type":"table_col","fmt":"dat2","align":"left","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"d MMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Last Invoiced","id":"969770b2"},{"role":"data","data":[[1.604754E9]],"displayName":"Today","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"today()","ver":2.0}],"autoFmt":true,"name":"Today","isDstRoot":true,"id":"3ccc3e04","type":"data_slot","fmt":"txt","dstContext":{"kid":"1911fe2b39e1c436264930aca0d2e9aa","id":"dst3ccc3e04"}}],"maxRows":"10","displayName":"Table 2","id":"f8bd4cb5","type":"table","dstContext":{"ops":[{"sortBy":[{"dim":"b80c8abc","dir":1.0}],"type":"sort"}],"kid":"1911fe2b39e1c436264930aca0d2e9aa","id":"dstf8bd4cb5"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Cliff Technologies","Owlimited","Whirlwindustries","Radiantelligence","Silverecords","Fairygold","Radiantelligence","Silverecords","Fairygold"]],"displayName":"Client","formulas":[{"txt":"select(a2d75942456c71f47060d9f50d075fd4@Invoices,D:D;,a2d75942456c71f47060d9f50d075fd4@Invoices,C:C;=\"Oustanding\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.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":"Client","id":"5da91bc5"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["INV-10861","INV-44457","INV-88060","INV-93371","INV-72262","INV-73682","INV-47508","INV-46214","INV-81155"]],"displayName":"Inv_number","formulas":[{"txt":"concat(\"INV-\",left(slice(a2d75942456c71f47060d9f50d075fd4@Invoices,B:B;),5))","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":"Inv_number","id":"983cc91e"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["550","190","1930","1030","170","370","1770","1700","1740"]],"displayName":"Amount","formulas":[{"txt":"select(a2d75942456c71f47060d9f50d075fd4@Invoices,E:E;,a2d75942456c71f47060d9f50d075fd4@Invoices,C:C;=\"Oustanding\")","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"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Amount","id":"603c028c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.60389E9,1.602594E9,1.6031124E9,1.6039764E9,1.6022484E9,1.6044084E9,1.60605E9,1.6070004E9,1.6055316E9]],"displayName":"Due Date","formulas":[{"txt":"select(DATE(a2d75942456c71f47060d9f50d075fd4@Invoices,F:F;,\"M/d/yy\"),a2d75942456c71f47060d9f50d075fd4@Invoices,C:C;=\"Oustanding\")","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":"Due Date","id":"9f6e5983"}],"displayName":"Table","id":"f1fa4687","type":"table","dstContext":{"kid":"1911fe2b39e1c436264930aca0d2e9aa","id":"dstf1fa4687"}}],"isForked":false,"id":"6b628d19101a0202fe7cc6da0a80155b","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Least Active Customers","usesSampleData":false,"master":"1911fe2b39e1c436264930aca0d2e9aa"}]}]