[{"tab":{"id":"7bbac36a5d4703e7236dd393dd123761","name":"Construction - Finances / Project Mgmt","layoutType":"grid","state":{"desktop":{"itemConfigs":[{"minHeight":210,"colSpan":6,"index":[0,0],"id":"gridklip-32fcf762bb90d1ce05038f6c49ceb405"},{"minHeight":79,"colSpan":6,"index":[0,1],"id":"gridklip-6f693022d7d55649d467a1280d384fa7"},{"minHeight":434,"colSpan":3,"index":[0,2],"id":"gridklip-223aae93a2befc103f779a503836e91d","height":551},{"minHeight":453,"colSpan":6,"index":[0,3],"id":"gridklip-bcc87f5fde500d534334edd54d8a14af"},{"minHeight":495,"colSpan":6,"index":[0,4],"id":"gridklip-2b6789fdfde2fe17a190b6a65cf2f5ed"},{"minHeight":363,"colSpan":3,"index":[0,5],"id":"gridklip-73f08b8b9db6b6e1b25377fa7db69a07"},{"minHeight":269,"colSpan":3,"index":[0,6],"id":"gridklip-be0cd151ccf6b8981a28fd04ffcac27a","height":526},{"minHeight":135,"colSpan":6,"index":[0,7],"id":"gridklip-3e16bd7e622fca0e2030e982784d3ca5"},{"minHeight":522,"colSpan":2,"index":[0,8],"id":"gridklip-58b113e70e59a17535901e751f9431eb"},{"minHeight":116,"colSpan":6,"index":[0,9],"id":"gridklip-3fda41c1fe5b9f96d66dfd577be3c995"},{"minHeight":406,"colSpan":6,"index":[0,10],"id":"gridklip-b9efc411fb02f883510abcddaa8ac83b"},{"minHeight":490,"colSpan":2,"index":[2,8],"id":"gridklip-297f1472224ba33b47d8adb582854e51","height":521},{"minHeight":552,"colSpan":3,"index":[3,2],"id":"gridklip-90f71bbcc6887132bdb987c1f075bb5e"},{"minHeight":900,"colSpan":3,"index":[3,5],"id":"gridklip-7fa8e69f287803cc16cb9851c94e1347"},{"minHeight":522,"colSpan":2,"index":[4,7],"id":"gridklip-26388a0fb27594a0d565c05688bd363a"}],"colWidths":["auto","auto","auto","auto","auto","auto"],"cols":6}},"master":"7bbac36a5d4703e7236dd393dd123761"},"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":"32fcf762bb90d1ce05038f6c49ceb405","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"685ef16df9cbec639ecf20b110cf9882"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["Displays the Net Profit and Gross Profit over time. 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 Net Profit and Gross Profit over time. 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":"a67537c7","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"817459f644d807b9d07b2f98b31461cd","id":"dsta67537c7"},"wrap":true},{"data":[["Net Profit & Gross Profit over Time"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Net Profit & Gross Profit over Time\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"817459f644d807b9d07b2f98b31461cd","id":"dstc27714d3"},"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":"c27714d3","wrap":true},{"data":[[""]],"displayName":"Label 3","formulas":[{"txt":"if(LAST(&'fd53edef')>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":"817459f644d807b9d07b2f98b31461cd","id":"dst9dc16630"},"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":"9dc16630","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":[[73686.0,41421.0,33299.0,53932.0,44577.0,-3611.0,17484.0,44804.0,99971.0,56962.0,42284.0,71760.0,98600.0]],"color":"#0d2e6e","displayName":"Net Profit ($)","seriesName":"Net Profit ($)","formulas":[{"txt":"lookup(&'1ed71bac',group(SELECT(&'6fa65303',&'6ed185eb'=\"Net Profit\")),groupby(SELECT(&'6fa65303',&'6ed185eb'=\"Net Profit\"),SELECT(&'1d2275b1',&'6ed185eb'=\"Net Profit\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"fd39b52b","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":"ac5c2725"},{"role":"series","data":[[105846.0,72393.0,65376.0,84266.0,74707.0,37121.0,46556.0,81818.0,128221.0,87232.0,69494.0,103230.0,129025.0]],"overrideColor":true,"displayName":"Gross Profit ($)","seriesName":"Gross Profit ($)","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"formulas":[{"txt":"lookup(&'1ed71bac',group(SELECT(&'6fa65303',&'9b007221'=\"Gross Profit\")),groupby(SELECT(&'6fa65303',&'9b007221'=\"Gross Profit\"),SELECT(&'1d2275b1',&'9b007221'=\"Gross Profit\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"id":"bb8ac8a0","type":"series_data","fmt":"cur","axis":"fd39b52b"},{"renderer":"line","showValues":true,"role":"series","data":[[39.19488933451773,30.048532068162526,20.186595213268994,39.436084177890876,33.53065952581538,-3.25362214373243,15.80903295809033,30.54394731639477,56.02122699661534,32.52963885145167,32.43707664337167,44.27497871395254,51.328502415458935]],"color":"cx-theme_blue_2","displayName":"Net Profit (%)","seriesName":"Net Profit (%)","formulas":[{"txt":"&'ac5c2725'/lookup(&'1ed71bac',group(SELECT(&'6fa65303',&'6ed185eb'=\"Income\")),groupby(SELECT(&'6fa65303',&'6ed185eb'=\"Income\"),SELECT(&'1d2275b1',&'6ed185eb'=\"Income\"),\"sum(values)\"))*100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"2d939a52","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":"fd53edef"},{"renderer":"line","showValues":true,"role":"series","data":[[56.301363305123964,52.516920934079096,39.63238681830306,61.616870676669734,56.19433746539897,33.44716355510704,42.09593562095936,55.77726724249593,71.85181449353327,49.81611348424972,53.31052417591691,63.69155591752119,67.166937364651]],"color":"cx-theme_orange_1","displayName":"Gross Profit (%)","seriesName":"Gross Profit (%)","formulas":[{"txt":"&'bb8ac8a0'/lookup(&'1ed71bac',group(SELECT(&'6fa65303',&'6ed185eb'=\"Income\")),groupby(SELECT(&'6fa65303',&'6ed185eb'=\"Income\"),SELECT(&'1d2275b1',&'6ed185eb'=\"Income\"),\"sum(values)\"))*100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"2d939a52","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":"910c479c"},{"role":"axis_x","data":[["Apr 2020","May 2020","Jun 2020","Jul 2020","Aug 2020","Sep 2020","Oct 2020","Nov 2020","Dec 2020","Jan 2021","Feb 2021","Mar 2021","Apr 2021"]],"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":"1ed71bac","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":"fd39b52b","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":"2d939a52","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","id":"ace6cb16","type":"chart_series","dstContext":{"kid":"817459f644d807b9d07b2f98b31461cd","id":"dstace6cb16"},"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":"6ed185eb"},{"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":"9b007221"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9]],"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":"b1159c8b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020"]],"displayName":"Date","formulas":[{"txt":"DATEVALUE(&'b1159c8b',\"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":"6fa65303"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["192096","63071","129025","2818","172","1154","3218","925","3023","137","1724","3202","1711","3883","952","682","6824","98600","162078","58848","103230","1401","726","2585","3922","2460","3414","3694","1921","492","706","1896","1014","658","6581","71760","130357","60863","69494","1458","2379","1885","2686","1575","2072","1417","167","2910","2840","1173","2125","411","4112","42284","175108","87876","87232","3159","1933","2794","1705","306","2815","3788","371","3745","3466","1294","208","426","4260","56962","178452","50231","128221","3465","3828","1307","708","869","829","1327","2496","2540","191","1201","2437","641","6411","99971","146687","64869","81818","1206","1941","3003","1777","3626","3895","1030"]],"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":"1d2275b1"}],"displayName":"Table","id":"ecee80a5","type":"table","dstContext":{"ops":[],"kid":"817459f644d807b9d07b2f98b31461cd","id":"dstecee80a5"}}],"isForked":false,"id":"2b6789fdfde2fe17a190b6a65cf2f5ed","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Profit over Time","usesSampleData":false,"master":"817459f644d807b9d07b2f98b31461cd"},{"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":"100efee6","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"dc7724275fb41dce660122df23d5c04f","id":"dst100efee6"},"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":"a743cb2f","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.618236E9]],"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":"6cfe21e9","type":"data_slot","fmt":"txt","dstContext":{"kid":"dc7724275fb41dce660122df23d5c04f","id":"dst6cfe21e9"}}],"maxRows":"10","displayName":"Table 2","showHeader":false,"id":"8adeaaea","type":"table","dstContext":{"ops":[],"kid":"dc7724275fb41dce660122df23d5c04f","id":"dst8adeaaea"}}],"isForked":false,"id":"3e16bd7e622fca0e2030e982784d3ca5","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Customers that account for more than 10% of Revenue","usesSampleData":false,"master":"dc7724275fb41dce660122df23d5c04f"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06","05eb33644786b6d75770879750fc0fde"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["A list of our top subcontractors, this allows us to quickly see which subcontractors 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 subcontractors, this allows us to quickly see which subcontractors are most important to our business.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"bebdc047","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"67aa71a6e9db8c77293b3c1977314fe8","id":"dstbebdc047"},"wrap":true},{"components":[{"components":[{"role":"customHeader","data":[["Subcontractors Name"]],"displayName":"Customer","formulas":[{"txt":"\"Subcontractors Name\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"67aa71a6e9db8c77293b3c1977314fe8","id":"dst1c423fa6"},"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":"1c423fa6","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_violet_3"}]}]}],"customHeader":true,"role":"tcol","data":[["Premium Contractors","Jackhammer Studios","Base Mountain Construction","Evergreen Designers","Red Wood Construction","Evolution Contractors","Fluid Homes","Dockside Stone","Secure Homes Inc.","The Details","Green Concrete Builder"]],"displayName":"Customer","formulas":[{"txt":"&'9b9cae2c'","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":"823f9298","renamed":true},{"components":[{"role":"customHeader","data":[["Total Value of Work"]],"displayName":"Total Value","formulas":[{"txt":"\"Total Value of Work\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"67aa71a6e9db8c77293b3c1977314fe8","id":"dstea0c9861"},"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":"ea0c9861","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_violet_3"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[55125.0,19479.0,18163.0,17223.0,4719.0,4715.0,4278.0,3744.0,2484.0,1821.0,1444.0]],"displayName":"Total Value","formulas":[{"txt":"&'cbd08660'","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":"90015171"},{"components":[{"role":"customHeader","data":[["Number of Projects"]],"displayName":"Number of Projects","formulas":[{"txt":"\"Number of Projects\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"67aa71a6e9db8c77293b3c1977314fe8","id":"dst693773a638"},"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":"693773a6-38","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_violet_3"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[["25","10","33","13","25","18","10","16","6","5","17"]],"displayName":"Number of Projects","formulas":[{"txt":"&'53790be7-40'","ver":2.0}],"autoFmt":true,"index":2.0,"type":"table_col","fmt":"num","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},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Number of Projects","id":"61d9c308-37"},{"components":[{"role":"customHeader","data":[["Duration"]],"displayName":"Average Price","formulas":[{"txt":"\"Duration\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"67aa71a6e9db8c77293b3c1977314fe8","id":"dst4d42d325"},"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":"4d42d325","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_violet_3"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[2.5657534246575344,7.693150684931507,3.9136986301369863,5.689041095890411,11.046575342465754,11.802739726027397,9.468493150684932,14.335616438356164,2.763013698630137,9.863013698630137,6.8712328767123285]],"displayName":"Average Price","formulas":[{"txt":"(today()-&'20bcc963')/(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":"c5338518"}],"maxRows":"10","displayName":"Table 2","id":"bbe6f9b4","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"args":[{"dim":"823f9298"},{"value":"\"\""}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"}],"f":"not","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"823f9298","variation":"condition"},{"sortBy":[{"dim":"90015171","dir":2.0}],"type":"sort"}],"kid":"67aa71a6e9db8c77293b3c1977314fe8","id":"dstbbe6f9b4"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6114932E9,1.6001784E9,1.6079508E9,1.592316E9,1.6032852E9,1.5872184E9,1.580562E9,1.5933528E9,1.5892056E9,1.6109748E9,1.5980184E9]],"displayName":"Date","formulas":[{"txt":"date(slice(05eb33644786b6d75770879750fc0fde@Subcontractors,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":"20bcc963"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Premium Contractors","Green Concrete Builder","Base Mountain Construction","The Details","Evergreen Designers","Evolution Contractors","Dockside Stone","Fluid Homes","Red Wood Construction","Secure Homes Inc.","Jackhammer Studios"]],"displayName":"Customer","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Subcontractors,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":"9b9cae2c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["55125","1444","18163","1821","17223","4715","3744","4278","4719","2484","19479"]],"displayName":"Sales Value","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Subcontractors,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":"cbd08660"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["25","17","33","5","13","18","16","10","25","6","10"]],"displayName":"Number of Projects","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Subcontractors,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":"Number of Projects","id":"53790be7-40"}],"displayName":"Table","id":"ab2025ff","type":"table","dstContext":{"ops":[],"kid":"67aa71a6e9db8c77293b3c1977314fe8","id":"dstab2025ff"}}],"isForked":false,"id":"26388a0fb27594a0d565c05688bd363a","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Top Subcontractors","usesSampleData":false,"master":"67aa71a6e9db8c77293b3c1977314fe8"},{"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":"f4284b47","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"414a9e1bbc1b833ac30cf1e1d8862a32","id":"dstf4284b47"},"wrap":true},{"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":"d7eb2cdc","type":"image","fmt":"txt","dstContext":{"kid":"414a9e1bbc1b833ac30cf1e1d8862a32","id":"dstd7eb2cdc"}},{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","size":"small","data":[["Bank Balance"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Bank Balance\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"e12262bf","type":"label","fmt":"txt","dstContext":{"kid":"414a9e1bbc1b833ac30cf1e1d8862a32","id":"dste12262bf"},"align":"c"},{"role":"secondary","size":"large","data":[[32619.72]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"2"},"formulas":[{"txt":"32619.72","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"dfda1c93","type":"label","fmt":"cur","dstContext":{"kid":"414a9e1bbc1b833ac30cf1e1d8862a32","id":"dstdfda1c93"},"align":"c"}],"displayName":"Value Pair","id":"bc8f3b5b","type":"simple_value","dstContext":{"id":"dstbc8f3b5b"}},{"data":[["Your Bank Balance has dropped below your minimum of $40,000."]],"displayName":"Label 2","formulas":[{"txt":"if(&'dfda1c93'<40000,CONCAT(\"Your Bank Balance has dropped below your minimum of $40,000.\"),\"\")","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":"414a9e1bbc1b833ac30cf1e1d8862a32","id":"dste4c42edf"},"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":"e4c42edf","wrap":true},{"data":[[""]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"\" //if(&'b811abf9'<40000,CONCAT(\"Action To Take: follow up on the $\",NUMBERFORMAT(SUMIF(&'9c883faf'=","dim":"7c1632c765","type":"op","value":{"var":"today"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"7c1632c765","variation":"condition"}],"kid":"d2128b48c03c4bf6bb4c07ba3593ca14","id":"dstc3ab75bd"}}],"isForked":false,"id":"90f71bbcc6887132bdb987c1f075bb5e","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Budgeted Project Costs vs Actual Costs","usesSampleData":false,"master":"d2128b48c03c4bf6bb4c07ba3593ca14"},{"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":"c8b56034","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"3f520036000cb64af0a4a8e62a76a50b","id":"dstc8b56034"},"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":"dst53dd70c1"},"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":"53dd70c1","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":[["Main Water & Power Inc","Armada Inc","WorldWide Inc","Moveable Parts Inc","Silver Goldenrod Systems","Artificial Horizon Works","Zink Systems","Magneto Inc","Gold Instant Industries","Blue Cutter Systems"]],"displayName":"Customer","formulas":[{"txt":"&'c5ce7c18'","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":"df1035fe","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":"dstad7fa559"},"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":"ad7fa559","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":[[14625.0,14516.0,14337.0,14291.0,13611.0,9862.0,9354.0,8584.0,5774.0,4748.0]],"displayName":"Total Value","formulas":[{"txt":"&'4aa2a401'","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":"c71ef98f"},{"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":"dst04ca5283"},"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":"04ca5283","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":[[11.704109589041096,4.867123287671233,8.975342465753425,8.712328767123287,19.660273972602738,3.847945205479452,21.92876712328767,5.294520547945205,3.289041095890411,7.758904109589041]],"displayName":"Average Price","formulas":[{"txt":"(today()-&'651b8f60')/(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":"e852c8fe"}],"maxRows":"10","displayName":"Table 2","id":"1bab6c1b","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"args":[{"dim":"df1035fe"},{"value":"\"\""}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"}],"f":"not","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"df1035fe","variation":"condition"},{"sortBy":[{"dim":"c71ef98f","dir":2.0}],"type":"sort"}],"kid":"3f520036000cb64af0a4a8e62a76a50b","id":"dst1bab6c1b"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5606072E9,1.5978456E9,1.5874776E9,1.6095924E9,1.59534E9,1.5665688E9,1.5946488E9,1.6081236E9,1.6054452E9,1.604322E9]],"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":"651b8f60"},{"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":"c5ce7c18"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["9354","4748","14625","5774","14291","13611","14337","9862","14516","8584"]],"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":"4aa2a401"}],"displayName":"Table","id":"e0301859","type":"table","dstContext":{"ops":[],"kid":"3f520036000cb64af0a4a8e62a76a50b","id":"dste0301859"}}],"isForked":false,"id":"297f1472224ba33b47d8adb582854e51","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Top Suppliers","usesSampleData":false,"master":"fa246e0095c8c0a07a5ad8addab4a779"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","a2d75942456c71f47060d9f50d075fd4","8936ec37ce3f53bcd37735e708201e06"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["Displays the Income over time. This allows us to quickly see when the business has an increase or decreaese in money flowing into the 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":"\"Displays the Income over time. This allows us to quickly see when the business has an increase or decreaese in money flowing into the business.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"c780911f","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"12611a83ab9afc1dfae7bd9c7fc98195","id":"dstc780911f"},"wrap":true},{"data":[["Revenue over Time"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Revenue over Time\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"12611a83ab9afc1dfae7bd9c7fc98195","id":"dst99e8e1ae"},"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":"99e8e1ae","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"renderer":"line","showValues":true,"role":"series","data":[[187999.0,137847.0,164956.0,136758.0,132944.0,110984.0,110595.0,146687.0,178452.0,175108.0,130357.0,162078.0,192096.0]],"color":"cx-theme_green_4","displayName":"Revenue","seriesName":"Revenue","formulas":[{"txt":"lookup(&'b134b444',group(SELECT(&'6c06d93b',&'076b079f'=\"Income\")),groupby(SELECT(&'6c06d93b',&'076b079f'=\"Income\"),SELECT(&'e0a5a905',&'076b079f'=\"Income\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"602dcbe4","chartStyle":"line_area","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":"a837db22"},{"role":"axis_x","data":[["Apr 2020","May 2020","Jun 2020","Jul 2020","Aug 2020","Sep 2020","Oct 2020","Nov 2020","Dec 2020","Jan 2021","Feb 2021","Mar 2021","Apr 2021"]],"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":"b134b444","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":"602dcbe4","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","id":"5e3f9f93","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","id":"73439e27","type":"chart_series","dstContext":{"kid":"12611a83ab9afc1dfae7bd9c7fc98195","id":"dst73439e27"},"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":"076b079f"},{"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":"b908a307"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6171956E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.6145172E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.612098E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6041492E9]],"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":"2c9e7900"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Apr 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Mar 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Feb 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Jan 2021","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Dec 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020","Nov 2020"]],"displayName":"Date","formulas":[{"txt":"DATEVALUE(&'2c9e7900',\"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":"6c06d93b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["192096","63071","129025","2818","172","1154","3218","925","3023","137","1724","3202","1711","3883","952","682","6824","98600","162078","58848","103230","1401","726","2585","3922","2460","3414","3694","1921","492","706","1896","1014","658","6581","71760","130357","60863","69494","1458","2379","1885","2686","1575","2072","1417","167","2910","2840","1173","2125","411","4112","42284","175108","87876","87232","3159","1933","2794","1705","306","2815","3788","371","3745","3466","1294","208","426","4260","56962","178452","50231","128221","3465","3828","1307","708","869","829","1327","2496","2540","191","1201","2437","641","6411","99971","146687","64869","81818","1206","1941","3003","1777","3626","3895","1030"]],"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":"e0a5a905"}],"displayName":"Table","id":"d5555e88","type":"table","dstContext":{"ops":[],"kid":"12611a83ab9afc1dfae7bd9c7fc98195","id":"dstd5555e88"}}],"isForked":false,"id":"bcc87f5fde500d534334edd54d8a14af","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Revenue","usesSampleData":false,"master":"12611a83ab9afc1dfae7bd9c7fc98195"},{"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":"d4f8e243","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"817f198380962fcae1012169107c30ae","id":"dstd4f8e243"},"wrap":true},{"components":[{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[["1617195600","1614517200","1612098000","1609419600","1606741200","1604149200","1601474400","1598882400","1596204000","1593525600","1590933600","1588255200","1585659600","1582981200"]],"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":"952e01b7","type":"proxy"},{"role":"labels","data":[["April 2021","March 2021","February 2021","January 2021","December 2020","November 2020","October 2020","September 2020","August 2020","July 2020","June 2020","May 2020","April 2020","March 2020"]],"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(&'952e01b7',\"MMMM yyyy\")","ver":2.0}],"autoFmt":false,"id":"b4ea736d","type":"proxy"}],"displayName":"User Input Control","scope":2.0,"inputLabel":"Date","inputType":1.0,"id":"dec528a9","type":"input","dstContext":{"kid":"817f198380962fcae1012169107c30ae","id":"dstdec528a9"},"propName":"plFilter"}],"displayName":"Layout Grid 2","id":"205ccd1f","type":"panel_grid","rows":1.0,"cols":3.0},{"components":[{"role":"data","data":[[3636.0,3625.0,3402.0,3290.0,3270.0,3140.0,2830.0,2526.0,1965.0,1146.0,650.0,187.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(&'fbd518ff',&'9ede5984'=\"Less Operating Expenses\"),SELECT(&'b383bed7',&'9ede5984'=\"Less Operating Expenses\"))","ver":2.0}],"autoFmt":false,"id":"3028771a","type":"series_data","fmt":"cur"},{"role":"labels","data":[["Motor Vehicle Expenses","Entertainment","Staff Well-Being & Amenities","Telephone and Internet","Staff Training","Staff Meetings","Office Expenses","Advertising","Bank Fees","Donations","Accounting","Client Gifts"]],"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(&'fbd518ff',&'9ede5984'=\"Less Operating Expenses\"))","ver":2.0}],"autoFmt":true,"id":"7f4de755","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":"5abb12ce","type":"chart_pie","dstContext":{"ops":[{"sortBy":[{"dim":"3028771a","dir":2.0}],"type":"sort"}],"kid":"817f198380962fcae1012169107c30ae","id":"dst5abb12ce"},"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":"9ede5984"},{"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":"fbd518ff"},{"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":"41380ea1"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["179139","71791","107348","650","2526","1965","187","1146","3625","3636","2830","3140","3270","3402","3290","511","5108","72062"]],"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":"b383bed7"}],"displayName":"Table","id":"edb07d73","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":"=","dim":"41380ea1","type":"op","value":{"var":"plFilter"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"41380ea1","variation":"condition"}],"kid":"817f198380962fcae1012169107c30ae","id":"dstedb07d73"}}],"isForked":false,"id":"73f08b8b9db6b6e1b25377fa7db69a07","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Operating Expenses","usesSampleData":false,"master":"ea9bbc47f92bf4726da6d51501333133"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9"],"dimensions":{"w":869.0}},"components":[{"components":[{"data":[],"displayName":"Label","formulas":[{"txt":"\"Filter all data on the dashboard based on date\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dst6d510803"},"layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"6d510803","wrap":true},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"array(\"This Week\",\"Last Week\",\"This Month\",\"Last Month\",\"This Quarter\",\"Last Quarter\",\"This Year\",\"Last Year\",\"Last 7 Days\", \"Last 30 Days\", \"Last 365 Days\")","ver":2.0}],"autoFmt":false,"id":"02406d45","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"7ccd5f04","type":"proxy"}],"displayName":"User Input Control 2","scope":2.0,"inputLabel":"Date Range","inputType":1.0,"id":"3d7bfb53","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dst3d7bfb53"},"propName":"dateSelector"},{"layoutConfig":{"x":0.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",\"d\",\"Yesterday\",\"d\",\"This Week\",\"d\",\"Last Week\",\"d\",\"This Month\",\"d\",\"Last Month\",\"d\",\"This Quarter\",\"m\",\"Last Quarter\",\"m\",\"This Year\",\"m\",\"Last Year\",\"m\",\"Last 7 Days\",\"d\", \"Last 30 Days\",\"d\", \"Last 365 Days\",\"m\")","ver":2.0}],"autoFmt":false,"id":"4466fa0f","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"8ac9f164","type":"proxy"}],"displayName":"User Input Control 5","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"a3b0184c","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dsta3b0184c"},"propName":"dateGroup"},{"layoutConfig":{"x":1.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",DATE_STARTOF(today(),\"4\",0),\"Last Week\",DATE_STARTOF(today(),\"4\",-1),\"This Month\",DATE_STARTOF(today(),\"3\",0),\"Last Month\",DATE_STARTOF(today(),\"3\",-1),\"This Quarter\",DATE_STARTOF(today(),\"2\",0),\"Last Quarter\",DATE_STARTOF(today(),\"2\",-1),\"This Year\",DATE_STARTOF(today(),\"1\",0),\"Last Year\",DATE_STARTOF(today(),\"1\",-1),\"Last 7 Days\",DATE_ADD(today(),\"5\",-7), \"Last 30 Days\",DATE_ADD(today(),\"5\",-30), \"Last 365 Days\",DATE_ADD(today(),\"5\",-365))","ver":2.0}],"autoFmt":false,"id":"deea4069","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"f623ad54","type":"proxy"}],"displayName":"User Input Control 3","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"bd2e8f4e","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dstbd2e8f4e"},"propName":"dateStart"},{"layoutConfig":{"x":2.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",today(),\"Last Week\",DATE_ENDOF(today(),\"4\",-1),\"This Month\",today(),\"Last Month\",DATE_ENDOF(today(),\"3\",-1),\"This Quarter\",today(),\"Last Quarter\",DATE_ENDOF(today(),\"2\",-1),\"This Year\",today(),\"Last Year\",DATE_ENDOF(today(),\"1\",-1),\"Last 7 Days\",today(), \"Last 30 Days\",today(), \"Last 365 Days\",today())","ver":2.0}],"autoFmt":false,"id":"ab955e69","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"36a873a3","type":"proxy"}],"displayName":"User Input Control 4","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"d1ebba48","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dstd1ebba48"},"propName":"dateEnd"}],"displayName":"Layout Grid","id":"9cf8c221","cellData":[{"w":2.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"3fda41c1fe5b9f96d66dfd577be3c995","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Filters","usesSampleData":false,"master":"eb62776ea1abc46c91e3f6df848ea566"},{"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":"c596c7e8","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"4bfd0b127ba1e00b8618c0aedeface93","id":"dstc596c7e8"},"wrap":true},{"data":[["Action To Take: follow up on the $5,320 sitting in overdue invoices that is owed."]],"displayName":"Label 3","formulas":[{"txt":"if(&'fba293b3'>0,CONCAT(\"Action To Take: follow up on the $\",NUMBERFORMAT(SUMIF(&'f17ad024' 30, &'0cf4aeff'),sumif(AND((&'f17ad024'-today())/86400 <= 30,(&'f17ad024'-today())/86400 > 14), &'0cf4aeff'), sumif(AND((&'f17ad024'-today())/86400 <= 14,(&'f17ad024'-today())/86400 > 7), &'0cf4aeff'),sumif(AND((&'f17ad024'-today())/86400 <= 7,(&'f17ad024'-today())/86400 >= 0), &'0cf4aeff'),sumif((&'f17ad024'-today())/86400 < 0, &'0cf4aeff'))","ver":2.0}],"autoFmt":false,"id":"9ce39ea5","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":"550aa10b","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":"650b34db","type":"chart_pie","dstContext":{"kid":"4bfd0b127ba1e00b8618c0aedeface93","id":"dst650b34db"},"overrideColors":true}],"displayName":"Layout Grid 3","id":"97aa3a94","type":"panel_grid","rows":2.0,"cols":1.0}],"displayName":"Layout Grid 2","id":"ec8df9bf-45","cellData":[{"w":2.0,"x":0.0,"y":1.0}],"type":"panel_grid","rows":2.0,"cols":2.0},{"displayName":"Separator","id":"1b3f2333","type":"separator"},{"data":[["Outstanding Invoices"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Outstanding Invoices\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"4bfd0b127ba1e00b8618c0aedeface93","id":"dst2934da8e"},"align":"c","layoutConfig":{"x":1.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"2934da8e","wrap":true},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"components":[{"role":"customHeader","data":[["Invoice"]],"displayName":"Invoice","formulas":[{"txt":"\"Invoice\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4bfd0b127ba1e00b8618c0aedeface93","id":"dst7d90da17"},"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":"7d90da17","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":"#d63044"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[["INV-45751","INV-29023","INV-24725","INV-39808","INV-65527","INV-36730","INV-52264","INV-27516","INV-46322"]],"displayName":"Invoice","formulas":[{"txt":"&'4fb80531'","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"txt","align":"left","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":"15%","name":"Invoice","id":"ab39776e","conditions":[{"predicates":[{"left":{"cx":"7f30b304"},"right":{"cx":"d9dd9184"},"type":"lt"}],"reactions":[{"type":"color","value":"#d63044"}]}]},{"components":[{"role":"customHeader","data":[["Client"]],"displayName":"Lost Reason","formulas":[{"txt":"\"Client\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4bfd0b127ba1e00b8618c0aedeface93","id":"dst32580af7"},"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":"32580af7","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":"#d63044"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[["Whirlwindustries","Silverecords","Radiantelligence","Owlimited","Cliff Technologies","Fairygold","Fairygold","Silverecords","Radiantelligence"]],"displayName":"Lost Reason","formulas":[{"txt":"&'ea788c4b'","ver":2.0}],"autoFmt":true,"index":1.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":"30%","name":"Product","id":"d00d1cbe","conditions":[{"predicates":[{"left":{"cx":"7f30b304"},"right":{"cx":"d9dd9184"},"type":"lt"}],"reactions":[{"type":"color","value":"#d63044"}]}],"renamed":true,"wrap":"active"},{"components":[{"role":"customHeader","data":[["Invoice Value"]],"displayName":"Occurances","formulas":[{"txt":"\"Invoice Value\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4bfd0b127ba1e00b8618c0aedeface93","id":"dst4b2462be"},"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":"4b2462be","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":"#d63044"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[[230.0,380.0,1900.0,1040.0,1600.0,170.0,140.0,1980.0,780.0]],"displayName":"Occurances","formulas":[{"txt":"&'0cf4aeff'","ver":2.0}],"autoFmt":false,"index":2.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":"a0c54fc0","conditions":[{"predicates":[{"left":{"cx":"7f30b304"},"right":{"cx":"d9dd9184"},"type":"lt"}],"reactions":[{"type":"color","value":"#d63044"}]}]},{"components":[{"role":"customHeader","data":[["Due Date"]],"displayName":"Due Date","formulas":[{"txt":"\"Due Date\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4bfd0b127ba1e00b8618c0aedeface93","id":"dst6208173e"},"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":"6208173e","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":"#d63044"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[["16/05/21","27/05/21","31/05/21","1/06/21","4/06/21","6/06/21","12/06/21","2/07/21","6/07/21"]],"displayName":"Due Date","formulas":[{"txt":"&'f17ad024'","ver":2.0}],"autoFmt":false,"index":3.0,"type":"table_col","fmt":"dat2","align":"r","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},"dateFormat":"custom","dateFormatCustom":"d/MM/yy","dateInputFormat":"epoch"},"name":"Due Date","id":"d6d0cf4e","conditions":[{"predicates":[{"left":{"cx":"7f30b304"},"right":{"cx":"d9dd9184"},"type":"lt"}],"reactions":[{"type":"color","value":"#d63044"}]}]},{"components":[{"role":"customHeader","data":[["Overdue"]],"displayName":"Overdue","formulas":[{"txt":"\"Overdue\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4bfd0b127ba1e00b8618c0aedeface93","id":"dst0448e646"},"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":"0448e646","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":"#d63044"}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[["True","True","True","True","True","True","False","False","False"]],"displayName":"Overdue","formulas":[{"txt":"if(&'7f30b304'=","dim":"766a7360","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}},{"op":"<=","dim":"766a7360","type":"op","value":{"var":"dateEnd"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"766a7360","variation":"condition"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dstf4681ee2"}}],"isForked":false,"id":"223aae93a2befc103f779a503836e91d","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Total Project Profitability","usesSampleData":false,"master":"b2e7bebc23effa2ca46d612500dde0de"},{"workspace":{"datasources":["773a7b4b52bcff4e6d67acb50b26c8a6","c7111b5ac1f526e9be25f3ed809f7877","05eb33644786b6d75770879750fc0fde"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["Displays the Net Cash Flow over time. This allows us to quickly identify 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 Net Cash Flow over time. This allows us to quickly identify cash flow issues.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"87a5364d","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"aa9ae461c24e6a3765e528fd4b3280b8","id":"dst87a5364d"},"wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"series","data":[[196100.0,182000.0,168800.0,136300.0,177500.0]],"color":"cx-theme_green_2","displayName":"Cash In","seriesName":"Cash In","formulas":[{"txt":"lookup(&'b3ed2ba5',group(SELECT(&'145d3c2b',&'1468814a'=\"Rec\")),groupby(SELECT(&'145d3c2b',&'1468814a'=\"Rec\"),SELECT(&'4bd4330c',&'1468814a'=\"Rec\"),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"a91cc86d","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"6b42d4d3","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"cx-theme_red_4"}]}]},{"role":"series","data":[[-148000.0,-167300.0,-151600.0,-195200.0,-104000.0]],"color":"cx-theme_red_1","displayName":"Cash Out","seriesName":"Cash Out","formulas":[{"txt":"lookup(&'b3ed2ba5',group(SELECT(&'145d3c2b',&'1468814a'=\"Pay\")),groupby(SELECT(&'145d3c2b',&'1468814a'=\"Pay\"),SELECT(&'4bd4330c',&'1468814a'=\"Pay\"),\"sum(values)\"))*-1","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"a91cc86d","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"e363fd7b"},{"renderer":"line","showValues":true,"role":"series","data":[[48100.0,14700.0,17200.0,-58900.0,73500.0]],"color":"cx-theme_blue_2","displayName":"Net Cash Flow","seriesName":"Net Cash Flow","formulas":[{"txt":"&'6b42d4d3' + &'e363fd7b'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"a91cc86d","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"f429e3a9"},{"role":"axis_x","data":[["Dec 2020","Jan 2021","Feb 2021","Mar 2021","Apr 2021"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(DATERANGE($dateStart,$dateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($dateStart,$dateEnd),\"3\")),\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"id":"b3ed2ba5","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"id":"a91cc86d","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Perc","formulas":[],"autoFmt":true,"axisPosition":"right","id":"6649a661","label":"Perc","type":"chart_axis","fmt":"pct","labelDrop":0.0}],"displayName":"Bar/Line Chart","id":"86e54c75","type":"chart_series","dstContext":{"kid":"aa9ae461c24e6a3765e528fd4b3280b8","id":"dst86e54c75"},"stackBars":"1","height":"3"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5916248E9,1.5972408E9,1.6128756E9,1.5909336E9,1.5981048E9,1.589292E9,1.6004376E9,1.6036308E9,1.5898104E9,1.5973272E9,1.61685E9,1.5946488E9,1.6120116E9,1.5936984E9,1.597068E9,1.5899832E9,1.6054452E9,1.594908E9,1.6198776E9,1.598796E9,1.591884E9,1.592316E9,1.6054452E9,1.6169364E9,1.6029396E9,1.5962904E9,1.6084692E9,1.6181496E9,1.5886008E9,1.6013016E9,1.6184952E9,1.6057908E9,1.600524E9,1.594044E9,1.6102836E9,1.603458E9,1.5955128E9,1.5899832E9,1.5950808E9,1.6017336E9,1.6144308E9,1.5956856E9,1.6180632E9,1.6008696E9,1.6080372E9,1.5987096E9,1.6158132E9,1.6108884E9,1.6089012E9,1.5988824E9,1.6109748E9,1.6114068E9,1.5954264E9,1.609938E9,1.5998328E9,1.6076052E9,1.5974136E9,1.5898968E9,1.600092E9,1.5924024E9,1.6032852E9,1.59318E9,1.612098E9,1.6024212E9,1.6006104E9,1.6022484E9,1.6035444E9,1.5894648E9,1.6061364E9,1.6010424E9,1.6148628E9,1.5961176E9,1.5926616E9,1.5908472E9,1.5930072E9,1.5945624E9,1.5939576E9,1.6141716E9,1.6166772E9,1.6022484E9,1.5891192E9,1.614258E9,1.5873912E9,1.6044084E9,1.6130484E9,1.6061364E9,1.6154676E9,1.613826E9,1.5991416E9,1.6109748E9,1.6079508E9,1.59318E9,1.6095924E9,1.5911064E9,1.5961176E9,1.6026804E9,1.5911928E9,1.5998328E9,1.58886E9,1.6089876E9]],"displayName":"Date_Raw","formulas":[{"txt":"date(slice(05eb33644786b6d75770879750fc0fde@Invoices,B:B;),\"yyyy/MM/dd\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"5c6304be"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jun 2020","Aug 2020","Feb 2021","Jun 2020","Aug 2020","May 2020","Sep 2020","Oct 2020","May 2020","Aug 2020","Mar 2021","Jul 2020","Jan 2021","Jul 2020","Aug 2020","May 2020","Nov 2020","Jul 2020","May 2021","Aug 2020","Jun 2020","Jun 2020","Nov 2020","Mar 2021","Oct 2020","Aug 2020","Dec 2020","Apr 2021","May 2020","Sep 2020","Apr 2021","Nov 2020","Sep 2020","Jul 2020","Jan 2021","Oct 2020","Jul 2020","May 2020","Jul 2020","Oct 2020","Feb 2021","Jul 2020","Apr 2021","Sep 2020","Dec 2020","Aug 2020","Mar 2021","Jan 2021","Dec 2020","Sep 2020","Jan 2021","Jan 2021","Jul 2020","Jan 2021","Sep 2020","Dec 2020","Aug 2020","May 2020","Sep 2020","Jun 2020","Oct 2020","Jun 2020","Feb 2021","Oct 2020","Sep 2020","Oct 2020","Oct 2020","May 2020","Nov 2020","Sep 2020","Mar 2021","Jul 2020","Jun 2020","May 2020","Jun 2020","Jul 2020","Jul 2020","Feb 2021","Mar 2021","Oct 2020","May 2020","Feb 2021","Apr 2020","Nov 2020","Feb 2021","Nov 2020","Mar 2021","Feb 2021","Sep 2020","Jan 2021","Dec 2020","Jun 2020","Jan 2021","Jun 2020","Jul 2020","Oct 2020","Jun 2020","Sep 2020","May 2020","Dec 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(&'5c6304be',\"d MMM yyyy\"),\"m\",DATEVALUE(&'5c6304be',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date","id":"145d3c2b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Rec","Pay","Pay","Rec","Pay","Rec","Pay","Rec","Rec","Rec","Rec","Pay","Rec","Rec","Rec","Pay","Pay","Rec","Pay","Pay","Rec","Pay","Pay","Pay","Rec","Pay","Rec","Pay","Pay","Pay","Pay","Pay","Rec","Rec","Rec","Pay","Pay","Pay","Rec","Pay","Rec","Pay","Pay","Pay","Pay","Pay","Rec","Pay","Rec","Rec","Pay","Rec","Rec","Pay","Pay","Rec","Rec","Rec","Pay","Pay","Rec","Pay","Pay","Pay","Rec","Rec","Pay","Rec","Rec","Rec","Pay","Pay","Rec","Rec","Rec","Pay","Pay","Rec","Rec","Pay","Rec","Rec","Pay","Rec","Pay","Rec","Pay","Rec","Rec","Rec","Rec","Rec","Pay","Rec","Rec","Pay","Rec","Rec","Pay","Pay"]],"displayName":"Type","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Invoices,F:F;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Type","id":"1468814a"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["6600","4500","4200","2500","1900","6900","3300","2800","3700","8800","8200","6700","1900","800","7700","5000","3800","400","9400","5900","4300","4200","7900","8200","5100","9900","1800","400","1300","7500","5100","7700","6500","1400","8000","1400","7600","2100","8600","8000","3200","9800","6300","8000","10000","8000","100","3900","9600","1100","7800","5900","2800","8800","2200","3400","4400","2800","900","5800","1900","3900","9700","3000","3400","3100","4900","9800","4700","9100","6400","4800","7300","3200","6300","500","6400","7800","2700","1100","5300","4500","4400","7700","1900","9700","1100","2000","7900","100","4500","9300","1000","4700","9800","5500","4800","9800","9800","8600"]],"displayName":"Value","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Invoices,E:E;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Value","id":"4bd4330c"}],"displayName":"Table","id":"d0473456","type":"table","dstContext":{"ops":[],"kid":"aa9ae461c24e6a3765e528fd4b3280b8","id":"dstd0473456"}}],"isForked":false,"id":"b9efc411fb02f883510abcddaa8ac83b","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Cash Flow","usesSampleData":false,"master":"bac86a79a88c2c5d0564f76e286f8ab1"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":1104.0}},"components":[{"size":"large","data":[["CONSTRUCTION - FINANCES / PROJECT MANAGEMENT"]],"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":"\"CONSTRUCTION - FINANCES / PROJECT MANAGEMENT\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"f1eefbbd","type":"label","fmt":"txt","dstContext":{"kid":"39375a77c71048e0a4c973911f530e90","id":"dstf1eefbbd"},"align":"c","wrap":true}],"isForked":false,"id":"6f693022d7d55649d467a1280d384fa7","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"39375a77c71048e0a4c973911f530e90"}]}]