[{"tab":{"id":"12ecc78ba896e7defcc7f43d7dd7c8ef","name":"Tradies - Construction","layoutType":"grid","state":{"desktop":{"itemConfigs":[{"minHeight":210,"colSpan":6,"index":[0,0],"id":"gridklip-1a8f59ba3cc7eb5ae8d8e2f44de2f4a5"},{"minHeight":79,"colSpan":6,"index":[0,1],"id":"gridklip-09a7c9c38152531ef13f3901e78ed0c8"},{"minHeight":116,"colSpan":6,"index":[0,2],"id":"gridklip-351d3e968891e743eacfcd8c2b826c6b"},{"minHeight":434,"colSpan":6,"index":[0,3],"id":"gridklip-845f895a147951a813c4f52d8c777265"},{"minHeight":502,"colSpan":6,"index":[0,4],"id":"gridklip-c77297f32365f1602642b16684ee6b4a"},{"minHeight":379,"colSpan":6,"index":[0,5],"id":"gridklip-61799ef887699565438389e2ae7504a4"},{"minHeight":402,"colSpan":3,"index":[0,6],"id":"gridklip-e86cd5f46569c9cb6fc7959b217a87a6","height":419},{"minHeight":149,"colSpan":6,"index":[0,7],"id":"gridklip-60f028f2335b47534afd58ad1a5c8954"},{"minHeight":301,"colSpan":6,"index":[0,8],"id":"gridklip-da049f2fa3ccfead50f7a5af62ed4d44"},{"minHeight":406,"colSpan":6,"index":[0,9],"id":"gridklip-c693022e42b00636b3e9ea70c66df4fb"},{"minHeight":443,"colSpan":3,"index":[0,10],"id":"gridklip-204182dae5e616da0a0e3377fd363782"},{"minHeight":242,"colSpan":6,"index":[0,11],"id":"gridklip-b473f446640318f47ec6598f89fed4ce"},{"minHeight":423,"colSpan":3,"index":[3,6],"id":"gridklip-61923a86c6e7a3b442095edb05e43e26"},{"minHeight":348,"colSpan":3,"index":[3,10],"id":"gridklip-05f7bf9da944a230d9007965280bf2e1","height":425}],"colWidths":["auto","auto","auto","auto","auto","auto"],"cols":6}},"master":"12ecc78ba896e7defcc7f43d7dd7c8ef"},"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":"1a8f59ba3cc7eb5ae8d8e2f44de2f4a5","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"685ef16df9cbec639ecf20b110cf9882"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":1104.0}},"components":[{"size":"large","data":[["TRADIES (CONSTRUCTION) DASHBOARD"]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"TRADIES (CONSTRUCTION) DASHBOARD\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"dbeddd74","type":"label","fmt":"txt","dstContext":{"kid":"ab75a403ac003cbcd89974d218b73e9d","id":"dstdbeddd74"},"align":"c","wrap":true}],"isForked":false,"id":"09a7c9c38152531ef13f3901e78ed0c8","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"ab75a403ac003cbcd89974d218b73e9d"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","773a7b4b52bcff4e6d67acb50b26c8a6","da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":1368.0}},"components":[{"size":"xx-small","data":[["The total value and number of tenders won across each state."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"The total value and number of tenders won across each state.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"e5adc299","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"ea512ecca53470b1f5f2d65c8481730c","id":"dste5adc299"},"wrap":true},{"components":[{"data":[["Number of Tenders Won"]],"displayName":"Label 2","formulas":[{"txt":"\"Number of Tenders Won\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"ea512ecca53470b1f5f2d65c8481730c","id":"dst252d0def87"},"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":"252d0def-87","wrap":true},{"data":[["Value of Tenders Won"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Value of Tenders Won\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"ea512ecca53470b1f5f2d65c8481730c","id":"dst95db4f56"},"align":"c","layoutConfig":{"x":1.0,"y":0.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"95db4f56","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"components":[{"role":"region_id","data":[["NT","SA","VIC"]],"displayName":"ID","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"group(&'0e7fb9ff')","ver":2.0}],"autoFmt":true,"id":"83d23597-71","type":"proxy","fmt":"txt"},{"role":"region_color","data":[[1.0,1.0,2.0]],"endColor":"cx-theme_red_5","displayName":"Color","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"formulas":[{"txt":"groupby(&'0e7fb9ff',&'9a5147a7',\"count(group(values))\")","ver":2.0}],"autoFmt":false,"valueType":"color","id":"f9c3c6d1-72","type":"map_tooltip_prop","fmt":"num","startColor":"cx-theme_orange_1"},{"role":"region_desc","data":[],"displayName":"Description","fmtArgs":{"prefix":""},"formulas":[],"autoFmt":true,"valueType":"description","id":"a07a66db-73","type":"map_tooltip_prop"},{"role":"region_xref","data":[],"displayName":"Link","formulas":[],"autoFmt":true,"id":"d23d2c6f-74","type":"map_link"}],"role":"tile_regions","displayName":"Regions","id":"7855513c-70","type":"map_region","dstContext":{"kid":"ea512ecca53470b1f5f2d65c8481730c","id":"dst7855513c70"}},{"components":[{"role":"marker_lat","data":[],"displayName":"Latitude","formulas":[],"autoFmt":true,"id":"51b183f3-76","type":"proxy"},{"role":"marker_lng","data":[],"displayName":"Longitude","formulas":[],"autoFmt":true,"id":"2d3d8149-77","type":"proxy"},{"role":"marker_name","data":[],"displayName":"Name","formulas":[],"autoFmt":true,"valueType":"name","id":"7345c0b8-78","type":"map_tooltip_prop"},{"role":"marker_color","data":[],"displayName":"Color","formulas":[],"autoFmt":true,"valueType":"color","id":"f223c558-79","type":"map_tooltip_prop","fmt":"num"},{"role":"marker_size","data":[],"displayName":"Size","formulas":[],"autoFmt":true,"valueType":"size","id":"4d61efac-80","type":"map_tooltip_prop","fmt":"num"},{"role":"marker_desc","data":[],"displayName":"Description","formulas":[],"autoFmt":true,"valueType":"description","id":"a2574d0f-81","type":"map_tooltip_prop"},{"role":"marker_xref","data":[],"displayName":"Link","formulas":[],"autoFmt":true,"id":"5d83d330-82","type":"map_link"}],"role":"tile_markers","displayName":"Markers","id":"237af019-75","type":"map_marker","dstContext":{"id":"dst237af01975"}}],"size":2.0,"customMapAsset":"82fbf6c089e2773aee2d25175e8ac754","displayName":"Map","mapId":"custom","id":"4c5123ef-69","type":"tile_map","dstContext":{"id":"dst4c5123ef69"}},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"role":"data","data":[[280000.0,864000.0,949000.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"}},"precision":"0"},"formulas":[{"txt":"groupby(&'0e7fb9ff',&'839decf3',\"sum(values)\")","ver":2.0}],"autoFmt":false,"id":"0f4fdd0f-85","type":"series_data","fmt":"cur"},{"role":"labels","data":[["NT","SA","VIC"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"group(&'0e7fb9ff')","ver":2.0}],"autoFmt":true,"id":"c81f2dc9-86","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["cx-theme_red_5","cx-theme_orange_4","cx-theme_yellow_3","cx-theme_brown_2","cx-theme_orange_3","cx-theme_yellow_5","cx-theme_orange_1","cx-theme_brown_5","#ada434"],"displayName":"Pie Chart","id":"61214be8-84","type":"chart_pie","dstContext":{"kid":"ea512ecca53470b1f5f2d65c8481730c","id":"dst61214be884"},"legend_items":"9","overrideColors":true}],"displayName":"Layout Grid","id":"f5eeb2f9-83","type":"panel_grid","rows":2.0,"cols":2.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jun 18, 2022","Jul 12, 2022","Jun 14, 2022","Jul 7, 2022"]],"displayName":"Date","formulas":[{"txt":"DATE_ADD(DATE(SLICE(da2557103f233f40be445efe38ed26f1@Tenders,A:A;),\"yyyy/MM/dd\"),\"3\",1)","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date","id":"75412e1a"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["fantastic project","thick project","defective project","filthy project"]],"displayName":"Project","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,D:D;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project","id":"9a5147a7"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["316000","280000","864000","633000"]],"displayName":"Value","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Value","id":"839decf3"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["VIC","NT","SA","VIC"]],"displayName":"State","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,G:G;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"State","id":"0e7fb9ff"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Won","Won","Won","Won"]],"displayName":"Status","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,E:E;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Status","id":"13e35933"}],"displayName":"Table Copy 2","id":"fb846a8e","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","dim":"75412e1a","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}},{"op":"<=","dim":"75412e1a","type":"op","value":{"var":"dateEnd"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"75412e1a","variation":"condition"},{"p":{"args":[{"dim":"13e35933"},{"args":[{"value":"\"Won\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"13e35933","variation":"member"}],"kid":"ea512ecca53470b1f5f2d65c8481730c","id":"dstfb846a8e"}}],"isForked":false,"id":"e86cd5f46569c9cb6fc7959b217a87a6","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Tenders Won by State","usesSampleData":false,"master":"ea512ecca53470b1f5f2d65c8481730c"},{"workspace":{"datasources":["da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":1139.0}},"components":[{"size":"xx-small","data":[["A visual representation of cash flow per project - this allows us to see where expenses occur and when we receive income for the project."]],"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 visual representation of cash flow per project - this allows us to see where expenses occur and when we receive income for the project.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"7726ee66","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"6b8e178541615b4127af3e7601530ef0","id":"dst7726ee66"},"wrap":true},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"showValues":true,"role":"series","data":[[11800.0,19900.0,43800.0,45200.0,53400.0,53400.0,68900.0,81100.0,88800.0,100200.0,105200.0,106600.0,116000.0,116700.0,116700.0,120600.0,126100.0,126600.0,126600.0,136000.0,142600.0,145800.0,161200.0,161200.0,167400.0,178200.0,191100.0,202800.0,204300.0,213200.0,213200.0]],"color":"cx-theme_green_4","displayName":"Income","seriesName":"Income","formulas":[{"txt":"CUMULATIVE(lookup(!'3c080241',group(select(&'d2956ddb',&'121344c7'=\"Income\")),groupby(select(&'d2956ddb',&'121344c7'=\"Income\"),select(&'872e0b48',&'121344c7'=\"Income\"),\"sum(values)\")))","ver":2.0}],"autoFmt":false,"leaveGaps":true,"type":"series_data","fmt":"cur","axis":"1206124b","chartStyle":"line_area","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":"56c1e1ee"},{"showValues":true,"role":"series","data":[[0.0,0.0,0.0,2900.0,2900.0,2900.0,9900.0,9900.0,9900.0,16600.0,26400.0,26400.0,34800.0,34800.0,34800.0,42900.0,45600.0,53000.0,53000.0,53000.0,53000.0,53000.0,53000.0,53600.0,53600.0,53600.0,53600.0,53600.0,53600.0,63600.0,63600.0]],"color":"cx-theme_yellow_3","displayName":"Wages","seriesName":"Wages","formulas":[{"txt":"CUMULATIVE(lookup(!'3c080241',group(select(&'d2956ddb',&'121344c7'=\"Wages\")),groupby(select(&'d2956ddb',&'121344c7'=\"Wages\"),select(&'872e0b48',&'121344c7'=\"Wages\"),\"sum(values)\")))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"1206124b","chartStyle":"line_area","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":"f8072820"},{"renderer":"line","showValues":true,"role":"series","data":[[0.0,0.0,0.0,0.0,5400.0,5400.0,10100.0,10100.0,10100.0,10100.0,10100.0,10100.0,10100.0,10100.0,15400.0,15400.0,15400.0,15400.0,15400.0,24900.0,24900.0,24900.0,24900.0,40100.0,40100.0,40100.0,40100.0,40100.0,48600.0,56300.0,56300.0]],"color":"cx-theme_violet_1","displayName":"Material Costs","seriesName":"Material Costs","formulas":[{"txt":"CUMULATIVE(lookup(!'3c080241',group(select(&'d2956ddb',&'121344c7'=\"Materials\")),groupby(select(&'d2956ddb',&'121344c7'=\"Materials\"),select(&'872e0b48',&'121344c7'=\"Materials\"),\"sum(values)\")))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"1206124b","chartStyle":"line_area","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":"e758c5e0","renamed":true},{"renderer":"line","showValues":true,"role":"series","data":[[0.0,0.0,0.0,3300.0,3300.0,3300.0,7100.0,8800.0,8800.0,8800.0,8800.0,8800.0,17800.0,17800.0,17800.0,23200.0,23200.0,23200.0,23200.0,23200.0,32000.0,32000.0,32000.0,32000.0,33000.0,33000.0,33000.0,33000.0,33000.0,33000.0,33000.0]],"color":"cx-theme_red_2","displayName":"Contractor Costs","seriesName":"Contractor Costs","formulas":[{"txt":"CUMULATIVE(lookup(!'3c080241',group(select(&'d2956ddb',&'121344c7'=\"Contractor Costs\")),groupby(select(&'d2956ddb',&'121344c7'=\"Contractor Costs\"),select(&'872e0b48',&'121344c7'=\"Contractor Costs\"),\"sum(values)\")))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"1206124b","chartStyle":"line_area","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":"c04ea2b6"},{"showValues":true,"role":"series","data":[[11800.0,19900.0,43800.0,39000.0,41800.0,41800.0,41800.0,52300.0,60000.0,64700.0,59900.0,61300.0,53300.0,54000.0,48700.0,39100.0,41900.0,35000.0,35000.0,34900.0,32700.0,35900.0,51300.0,35500.0,40700.0,51500.0,64400.0,76100.0,69100.0,60300.0,60300.0]],"color":"cx-theme_blue_3","displayName":"Gross Profit","seriesName":"Gross Profit","formulas":[{"txt":"&'56c1e1ee'-(&'f8072820'+&'e758c5e0'+&'c04ea2b6')","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"1206124b","lineDashes":"ShortDash","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":"54761cb9-39"},{"role":"axis_x","data":[["14 Jun 2022","15 Jun 2022","16 Jun 2022","17 Jun 2022","18 Jun 2022","19 Jun 2022","20 Jun 2022","21 Jun 2022","22 Jun 2022","23 Jun 2022","24 Jun 2022","25 Jun 2022","26 Jun 2022","27 Jun 2022","28 Jun 2022","29 Jun 2022","30 Jun 2022","1 Jul 2022","2 Jul 2022","3 Jul 2022","4 Jul 2022","5 Jul 2022","6 Jul 2022","7 Jul 2022","8 Jul 2022","9 Jul 2022","10 Jul 2022","11 Jul 2022","12 Jul 2022","13 Jul 2022","14 Jul 2022"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(DATERANGE($dateStart,$dateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($dateStart,$dateEnd),\"3\")),\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"id":"3c080241","label":"Untitled","type":"chart_axis","fmt":"dat2","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"cur","grid":true,"fmtArgs":{},"id":"1206124b","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart Copy","id":"42f082c8","type":"chart_series","dstContext":{"kid":"6b8e178541615b4127af3e7601530ef0","id":"dst42f082c8"},"height":"3"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6306776E9,1.6455348E9,1.6395732E9,1.6349076E9,1.6351668E9,1.6359444E9,1.650204E9,1.6461396E9,1.6413876E9,1.6476084E9,1.6446708E9,1.6398324E9,1.6521048E9,1.6365492E9,1.6330104E9,1.6457076E9,1.6438932E9,1.6298136E9,1.6473492E9,1.6379316E9,1.6301592E9,1.632924E9,1.6482132E9,1.6447572E9,1.63206E9,1.640178E9,1.6333524E9,1.6318872E9,1.634994E9,1.6373268E9,1.6507224E9,1.6437204E9,1.659708E9,1.6522776E9,1.6317144E9,1.6344756E9,1.6489044E9,1.6305912E9,1.6348212E9,1.6356852E9,1.646658E9,1.637154E9,1.6407828E9,1.6471764E9,1.6300728E9,1.6465716E9,1.6578072E9,1.6565112E9,1.6578936E9,1.6559928E9,1.6394004E9,1.6342164E9,1.6499448E9,1.6517592E9,1.64493E9,1.6437204E9,1.6547832E9,1.6508088E9,1.6334388E9,1.654956E9,1.6459668E9,1.654524E9,1.6292952E9,1.6538328E9,1.659708E9,1.6565976E9,1.637586E9,1.6444116E9,1.6387956E9,1.645362E9,1.631628E9,1.6430292E9,1.630332E9,1.659276E9,1.6495128E9,1.6508088E9,1.6521912E9,1.66014E9,1.6525368E9,1.659276E9,1.64934E9,1.6489044E9,1.6568568E9,1.6538328E9,1.631628E9,1.6415604E9,1.6333524E9,1.6353396E9,1.6531416E9,1.6437204E9,1.657548E9,1.634994E9,1.6580664E9,1.6325784E9,1.6522776E9,1.6476084E9,1.6342164E9,1.652796E9,1.6524504E9,1.6362036E9]],"displayName":"Date_Raw","formulas":[{"txt":"DATE_ADD(slice(date(da2557103f233f40be445efe38ed26f1@Cashflow,A:A;,\"yyyy/MM/dd\")),\"3\",1)","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"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"a395927b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["4 Sep 2021","23 Feb 2022","16 Dec 2021","23 Oct 2021","26 Oct 2021","4 Nov 2021","18 Apr 2022","2 Mar 2022","6 Jan 2022","19 Mar 2022","13 Feb 2022","19 Dec 2021","10 May 2022","11 Nov 2021","1 Oct 2021","25 Feb 2022","4 Feb 2022","25 Aug 2021","16 Mar 2022","27 Nov 2021","29 Aug 2021","30 Sep 2021","26 Mar 2022","14 Feb 2022","20 Sep 2021","23 Dec 2021","5 Oct 2021","18 Sep 2021","24 Oct 2021","20 Nov 2021","24 Apr 2022","2 Feb 2022","6 Aug 2022","12 May 2022","16 Sep 2021","18 Oct 2021","3 Apr 2022","3 Sep 2021","22 Oct 2021","1 Nov 2021","8 Mar 2022","18 Nov 2021","30 Dec 2021","14 Mar 2022","28 Aug 2021","7 Mar 2022","15 Jul 2022","30 Jun 2022","16 Jul 2022","24 Jun 2022","14 Dec 2021","15 Oct 2021","15 Apr 2022","6 May 2022","16 Feb 2022","2 Feb 2022","10 Jun 2022","25 Apr 2022","6 Oct 2021","12 Jun 2022","28 Feb 2022","7 Jun 2022","19 Aug 2021","30 May 2022","6 Aug 2022","1 Jul 2022","23 Nov 2021","10 Feb 2022","7 Dec 2021","21 Feb 2022","15 Sep 2021","25 Jan 2022","31 Aug 2021","1 Aug 2022","10 Apr 2022","25 Apr 2022","11 May 2022","11 Aug 2022","15 May 2022","1 Aug 2022","8 Apr 2022","3 Apr 2022","4 Jul 2022","30 May 2022","15 Sep 2021","8 Jan 2022","5 Oct 2021","28 Oct 2021","22 May 2022","2 Feb 2022","12 Jul 2022","24 Oct 2021","18 Jul 2022","26 Sep 2021","12 May 2022","19 Mar 2022","15 Oct 2021","18 May 2022","14 May 2022","7 Nov 2021"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(&'a395927b',\"d MMM yyyy\"),\"m\",DATEVALUE(&'a395927b',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"d2956ddb"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["shiny project","gentle project","receptive project","defective project","","upset project","majestic project","maniacal project","","breezy project","materialistic project","receptive project","luxuriant project","thick project","breezy project","receptive project","squalid project","shiny project","breezy project","fantastic project","materialistic project","upset project","wacky project","shiny project","majestic project","defective project","luxuriant project","shiny project","materialistic project","upset project","luxuriant project","majestic project","thick project","shiny project","defective project","breezy project","squalid project","","squalid project","upset project","materialistic project","materialistic project","","receptive project","late project","gentle project","majestic project","breezy project","materialistic project","late project","breezy project","majestic project","","squalid project","gentle project","receptive project","shiny project","materialistic project","materialistic project","filthy project","fantastic project","gentle project","gentle project","materialistic project","squalid project","breezy project","shiny project","","breezy project","fantastic project","wacky project","breezy project","receptive project","","shiny project","materialistic project","gentle project","maniacal project","late project","defective project","fantastic project","luxuriant project","fantastic project","filthy project","receptive project","luxuriant project","defective project","shiny project","maniacal project","receptive project","fantastic project","receptive project","realistic project","","thick project","maniacal project","filthy project","squalid project","breezy project","breezy project"]],"displayName":"Project","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Cashflow,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project","id":"8700a9d0"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["7100","7600","1300","9400","5700","800","400","9800","6300","5300","10000","6100","2200","6600","8000","8200","8800","4200","7700","1000","9100","100","100","3200","2300","8000","7800","600","400","5900","10000","9700","4600","10000","900","7400","2400","6600","8600","300","2500","7200","9100","2800","7600","5200","800","5500","10000","9400","5100","7300","7100","6700","9800","1500","2900","200","4000","6500","1400","8900","3500","700","8100","7400","6700","9400","8300","9100","7300","5800","8400","3700","6400","900","1500","10000","4500","9100","7800","9000","4200","2000","3500","7300","9500","2500","2700","2100","8500","3100","2000","7200","4400","4200","7400","6800","9800","9700"]],"displayName":"Value","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Cashflow,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":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Value","id":"872e0b48"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Income","Wages","Income","Income","Income","Income","Materials","Income","Income","Wages","Wages","Income","Wages","Materials","Wages","Income","Income","Materials","Wages","Contractor Costs","Income","Income","Income","Materials","Income","Contractor Costs","Income","Income","Income","Wages","Income","Materials","Wages","Wages","Income","Income","Income","Wages","Income","Wages","Income","Income","Income","Materials","Income","Income","Income","Income","Wages","Wages","Wages","Income","Income","Income","Income","Wages","Income","Contractor Costs","Income","Contractor Costs","Income","Wages","Wages","Income","Income","Wages","Income","Contractor Costs","Income","Income","Income","Wages","Income","Income","Income","Materials","Income","Wages","Income","Materials","Wages","Income","Income","Income","Contractor Costs","Income","Wages","Wages","Wages","Income","Materials","Income","Income","Wages","Wages","Materials","Wages","Contractor Costs","Income","Income"]],"displayName":"Type","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Cashflow,E:E;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Type","id":"121344c7"}],"displayName":"Table Copy","id":"bb5b0324","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"8700a9d0"},{"var":"tm_ProjectFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"8700a9d0","variation":"condition"}],"kid":"6b8e178541615b4127af3e7601530ef0","id":"dstbb5b0324"}}],"isForked":false,"id":"c693022e42b00636b3e9ea70c66df4fb","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Project Cash Flow","usesSampleData":false,"master":"6b8e178541615b4127af3e7601530ef0"},{"workspace":{"datasources":["da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":869.0}},"components":[{"components":[{"data":[["Filter all data on the dashboard based on date"]],"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":"ffead281312bdccbf49e6bdc9a0c2713","id":"dstb89cc0a2"},"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":"b89cc0a2","wrap":true},{"layoutConfig":{"x":2.0,"y":0.0},"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":"b46314ac","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"e06b8b17","type":"proxy"}],"displayName":"User Input Control 2","scope":2.0,"inputLabel":"Date Range","inputType":1.0,"id":"c5d2635e","type":"input","dstContext":{"kid":"ffead281312bdccbf49e6bdc9a0c2713","id":"dstc5d2635e"},"propName":"dateSelector"},{"layoutConfig":{"x":0.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":"0ff17a11","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"4fa4e997","type":"proxy"}],"displayName":"User Input Control 5","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"e6093b89","type":"input","dstContext":{"kid":"ffead281312bdccbf49e6bdc9a0c2713","id":"dste6093b89"},"propName":"dateGroup"},{"layoutConfig":{"x":1.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1602939600"]],"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":"d1252e40","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"1a617c7f","type":"proxy"}],"displayName":"User Input Control 3","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"8e824709","type":"input","dstContext":{"kid":"ffead281312bdccbf49e6bdc9a0c2713","id":"dst8e824709"},"propName":"dateStart"},{"layoutConfig":{"x":2.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1603026000"]],"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":"5f1b2250","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"52f03a77","type":"proxy"}],"displayName":"User Input Control 4","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"9dca4388","type":"input","dstContext":{"kid":"ffead281312bdccbf49e6bdc9a0c2713","id":"dst9dca4388"},"propName":"dateEnd"}],"displayName":"Layout Grid","id":"2572d4cf","cellData":[{"w":2.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"351d3e968891e743eacfcd8c2b826c6b","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Filters","usesSampleData":false,"master":"ffead281312bdccbf49e6bdc9a0c2713"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","773a7b4b52bcff4e6d67acb50b26c8a6","da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":1055.0}},"components":[{"size":"xx-small","data":[["The number of tenders submitted and the percentage of tenders that are won. This allows us to keep track of how effective our tendering process is and how much of the tendered work we are losing."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"The number of tenders submitted and the percentage of tenders that are won. This allows us to keep track of how effective our tendering process is and how much of the tendered work we are losing.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"3b785a36","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dst3b785a36"},"wrap":true},{"components":[{"data":[["Overall Tender Win Rate"]],"displayName":"Label 2","formulas":[{"txt":"\"Overall Tender Win Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dste464b00b"},"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":"e464b00b","wrap":true},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"showValues":true,"role":"series","data":[[1.0,"","","",1.0,"","","","","","","","","","","","","","","","","","",1.0,"","","","",1.0,"",1.0]],"color":"cx-theme_blue_4","displayName":"Tenders Submitted","seriesName":"Tenders Submitted","formulas":[{"txt":"lookup(&'908242b8',group(&'b850c4ec'),groupby(&'b850c4ec',&'5b16988e',\"count(values)\"))","ver":2.0}],"autoFmt":true,"leaveGaps":true,"type":"series_data","fmt":"num","axis":"fea42481","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"c95c738b"},{"showValues":true,"role":"series","data":[[1.0,"","","",1.0,"","","","","","","","","","","","","","","","","","",1.0,"","","","",1.0,"",""]],"color":"cx-theme_green_4","displayName":"Projects Won","seriesName":"Projects Won","formulas":[{"txt":"lookup(&'908242b8',group(select(&'b850c4ec',&'4df42b1d'=\"Won\")),groupby(select(&'b850c4ec',&'4df42b1d'=\"Won\"),select(&'5b16988e',&'4df42b1d'=\"Won\"),\"count(values)\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"fea42481","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"61a3186f-52"},{"renderer":"line","showValues":true,"role":"series","data":[[100.0,"NaN","NaN","NaN",100.0,"NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN","NaN",100.0,"NaN","NaN","NaN","NaN",100.0,"NaN",0.0]],"color":"cx-theme_blue_2","displayName":"% Won","seriesName":"% of Tenders Won","formulas":[{"txt":"lookup(&'908242b8',group(SELECT(&'b850c4ec',&'4df42b1d'=\"Won\")),groupby(SELECT(&'b850c4ec',&'4df42b1d'=\"Won\"),SELECT(&'5b16988e',&'4df42b1d'=\"Won\"),\"count(values)\"))/&'c95c738b'*100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"7bb9d5e0","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"precision":"0"},"id":"207b528f","renamed":true},{"renderer":"line","role":"series","data":[[35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0,35.0]],"displayName":"Target % Won","seriesName":"Target % Won","formulas":[{"txt":"REPEAT(LOOKUP(\"Jobs quoted / worked\",773a7b4b52bcff4e6d67acb50b26c8a6@Tradies,D:D;,773a7b4b52bcff4e6d67acb50b26c8a6@Tradies,H:H;),COUNT(!'908242b8'))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"7bb9d5e0","lineDashes":"Dash","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"082fea73"},{"role":"axis_x","data":[["14 Jun 2022","15 Jun 2022","16 Jun 2022","17 Jun 2022","18 Jun 2022","19 Jun 2022","20 Jun 2022","21 Jun 2022","22 Jun 2022","23 Jun 2022","24 Jun 2022","25 Jun 2022","26 Jun 2022","27 Jun 2022","28 Jun 2022","29 Jun 2022","30 Jun 2022","1 Jul 2022","2 Jul 2022","3 Jul 2022","4 Jul 2022","5 Jul 2022","6 Jul 2022","7 Jul 2022","8 Jul 2022","9 Jul 2022","10 Jul 2022","11 Jul 2022","12 Jul 2022","13 Jul 2022","14 Jul 2022"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(DATERANGE($dateStart,$dateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($dateStart,$dateEnd),\"3\")),\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"id":"908242b8","label":"Untitled","type":"chart_axis","fmt":"dat2","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"pct","grid":true,"fmtArgs":{},"id":"7bb9d5e0","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Count","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Untitled","type":"chart_axis","fmt":"num","fmtArgs":{},"id":"fea42481","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","id":"e2d1e4ea","type":"chart_series","dstContext":{"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dste2d1e4ea"}},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"current","size":"x-large","data":[[0.8]],"displayName":"Current Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"formulas":[{"txt":"COUNT(select(&'5b16988e',AND(BETWEEN(&'70cac9de',$dateStart,$dateEnd),&'4df42b1d'=\"Won\")))/COUNT(select(&'5b16988e',BETWEEN(&'70cac9de',$dateStart,$dateEnd)))","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"id":"b2e52ab1","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"b2e52ab1"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dstb2e52ab1","aggs":{"b2e52ab1":"sum","56969107":"sum"}}},{"role":"target","size":"medium","data":[[0.35]],"displayName":"Target Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"formulas":[{"txt":"LOOKUP(\"Jobs quoted / worked\",773a7b4b52bcff4e6d67acb50b26c8a6@Tradies,D:D;,773a7b4b52bcff4e6d67acb50b26c8a6@Tradies,H:H;)/100","ver":2.0,"src":{"c":[{"t":"l","v":"80"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_888","id":"56969107","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"56969107"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dst56969107","aggs":{"56969107":"sum"}}},{"role":"min","data":[[0.0]],"displayName":"Min Value","formulas":[{"txt":"0","ver":2.0,"src":{"c":[{"t":"l","v":"0"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"3852eaad"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dst3852eaad","aggs":{"b3c60f96":"sum","3852eaad":"sum","b2e52ab1":"sum","56969107":"sum"}},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"id":"3852eaad"},{"role":"max","data":[[1.0]],"displayName":"Max Value","formulas":[{"txt":"1","ver":2.0}],"autoFmt":false,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"b3c60f96"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dstb3c60f96","aggs":{"b3c60f96":"sum","b2e52ab1":"sum","56969107":"sum"}},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"id":"b3c60f96"},{"components":[{"role":"start","data":[[0.0]],"displayName":"Start 1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0","ver":2.0}],"autoFmt":false,"id":"a8c253a3","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"a8c253a3"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dsta8c253a3","aggs":{"a8c253a3":"sum"}}},{"role":"end","data":[[0.2]],"displayName":"End 1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.2","ver":2.0}],"autoFmt":false,"id":"757270d5","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"757270d5"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dst757270d5","aggs":{"757270d5":"sum"}}}],"rangeId":1.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_red_3","displayName":"Range 1","formulas":[],"autoFmt":true,"id":"628b6407","type":"range"},{"components":[{"role":"start","data":[[0.2]],"displayName":"Start 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.2","ver":2.0}],"autoFmt":false,"id":"f0a82c3d","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"f0a82c3d"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dstf0a82c3d","aggs":{"f0a82c3d":"sum"}}},{"role":"end","data":[[0.4]],"displayName":"End 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.4","ver":2.0}],"autoFmt":false,"id":"57608107","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"57608107"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dst57608107","aggs":{"57608107":"sum"}}}],"rangeId":2.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_yellow_3","displayName":"Range 2","formulas":[],"autoFmt":true,"id":"43b8aeb0","type":"range"},{"components":[{"role":"start","data":[[0.4]],"displayName":"Start 3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.4","ver":2.0}],"autoFmt":false,"id":"15888afb","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"15888afb"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dst15888afb","aggs":{"15888afb":"sum"}}},{"role":"end","data":[[1.0]],"displayName":"End 3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"1","ver":2.0}],"autoFmt":false,"id":"b4aaa482","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"b4aaa482"}],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dstb4aaa482","aggs":{"b4aaa482":"sum"}}}],"rangeId":3.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_green_3","displayName":"Range 3","formulas":[],"autoFmt":true,"id":"45669d60","type":"range"}],"size":2.0,"displayName":"Gauge","id":"56551362","type":"gauge","dstContext":{"id":"dst56551362"},"gaugeStyle":"ag"}],"displayName":"Layout Grid","id":"aaeceab4","cellData":[{"w":2.0,"x":1.0,"h":2.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6438068E9,1.6288632E9,1.6577208E9,1.6459668E9,1.6435476E9,1.6299864E9,1.6391412E9,1.6347348E9,1.6395732E9,1.6472628E9,1.6554744E9,1.657548E9,1.652364E9,1.634994E9,1.6508088E9,1.6297272E9,1.6309368E9,1.6302456E9,1.6336116E9,1.6325784E9,1.64277E9,1.6598808E9,1.6430292E9,1.6498584E9,1.6524504E9,1.638018E9,1.6543512E9,1.6357716E9,1.6551288E9,1.64934E9,1.65798E9,1.6317144E9,1.6583256E9,1.6450164E9,1.633698E9,1.6459668E9,1.657116E9,1.6308504E9,1.6368948E9,1.6528824E9]],"displayName":"Date_Raw","formulas":[{"txt":"DATE_ADD(slice(date(da2557103f233f40be445efe38ed26f1@Tenders,A:A;,\"yyyy/MM/dd\")),\"3\",1)","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"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"70cac9de"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["3 Feb 2022","14 Aug 2021","14 Jul 2022","28 Feb 2022","31 Jan 2022","27 Aug 2021","11 Dec 2021","21 Oct 2021","16 Dec 2021","15 Mar 2022","18 Jun 2022","12 Jul 2022","13 May 2022","24 Oct 2021","25 Apr 2022","24 Aug 2021","7 Sep 2021","30 Aug 2021","8 Oct 2021","26 Sep 2021","22 Jan 2022","8 Aug 2022","25 Jan 2022","14 Apr 2022","14 May 2022","28 Nov 2021","5 Jun 2022","2 Nov 2021","14 Jun 2022","8 Apr 2022","17 Jul 2022","16 Sep 2021","21 Jul 2022","17 Feb 2022","9 Oct 2021","28 Feb 2022","7 Jul 2022","6 Sep 2021","15 Nov 2021","19 May 2022"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(&'70cac9de',\"d MMM yyyy\"),\"m\",DATEVALUE(&'70cac9de',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Date","id":"b850c4ec"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["breezy project","dreary project","giant project","uppity project","receptive project","delicate project","wacky project","shiny project","drunk project","languid project","fantastic project","thick project","curved project","hurt project","squalid project","majestic project","different project","hissing project","brief project","gentle project","male project","awful project","materialistic project","blushing project","southern project","late project","familiar project","encouraging project","defective project","uttermost project","scared project","sharp project","realistic project","adaptable project","upset project","maniacal project","filthy project","conscious project","yielding project","luxuriant project"]],"displayName":"Project","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,D:D;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project","id":"5b16988e"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["239000","970000","972000","221000","399000","935000","990000","260000","126000","903000","316000","280000","191000","557000","328000","669000","450000","188000","861000","774000","879000","499000","564000","380000","188000","815000","620000","470000","864000","621000","525000","516000","233000","243000","880000","490000","633000","872000","704000","658000"]],"displayName":"Value","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,C:C;)","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"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Value","id":"20792b76"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Residential","Commercial","Industrial","Commercial","Commercial","Commercial","Commercial","Renovation","Commercial","Residential","Residential","Residential","Commercial","Industrial","Industrial","Industrial","Industrial","Commercial","Renovation","Industrial","Industrial","Residential","Commercial","Renovation","Commercial","Industrial","Residential","Commercial","Residential","Commercial","Renovation","Industrial","Industrial","Residential","Industrial","Residential","Renovation","Industrial","Commercial","Commercial"]],"displayName":"Type","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,H:H;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Type","id":"6bee2484"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Won","Lost","Lost","Lost","Won","Lost","Won","Won","Lost","Lost","Won","Won","Lost","Lost","Won","Won","Lost","Lost","Lost","Won","Lost","Lost","Won","Lost","Lost","Won","Lost","Lost","Won","Lost","Lost","Lost","Won","Lost","Won","Won","Won","Lost","Lost","Won"]],"displayName":"Status","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,E:E;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":5.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Status","id":"4df42b1d"}],"displayName":"Table Copy","id":"16bf8e60","type":"table","dstContext":{"ops":[],"kid":"3a16ee8d58d6af7d02cc171b5e0e8207","id":"dst16bf8e60"}}],"isForked":false,"id":"61799ef887699565438389e2ae7504a4","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Tenders and Job Win Rate","usesSampleData":false,"master":"3a16ee8d58d6af7d02cc171b5e0e8207"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","773a7b4b52bcff4e6d67acb50b26c8a6","da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":1368.0}},"components":[{"size":"xx-small","data":[["The total value and number of tenders won across the different project types in the selected time period in the filter at the top of the page."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"The total value and number of tenders won across the different project types in the selected time period in the filter at the top of the page.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"9dd39d77","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"b94d248d18207673431aff1cd4645b70","id":"dst9dd39d77"},"wrap":true},{"components":[{"showValues":true,"role":"series","data":[[1.0,3.0]],"color":"cx-theme_violet_4","displayName":"Number of Tenders","seriesName":"Number of Tenders","formulas":[{"txt":"lookup(&'d351a249-43',group(&'89f36d1f'),GROUPBY(&'89f36d1f',&'c4cf464f',\"count(group(values))\"))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"5fd19bf7-44","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"ad56dec8-42"},{"showValues":true,"role":"series","data":[[633000.0,1460000.0]],"color":"cx-theme_yellow_green_4","displayName":"Value of Tenders","seriesName":"Value of Tenders","formulas":[{"txt":"lookup(&'d351a249-43',group(&'89f36d1f'),GROUPBY(&'89f36d1f',&'12e0b903',\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"bf1e7b56-46","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":"541e081b-45"},{"role":"axis_x","data":[["Renovation","Residential"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"group(&'89f36d1f')","ver":2.0}],"autoFmt":true,"id":"d351a249-43","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Count","formulas":[],"autoFmt":true,"label":"Count","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"id":"5fd19bf7-44","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Value","type":"chart_axis","fmt":"cur","fmtArgs":{},"id":"bf1e7b56-46","labelDrop":0.0}],"displayName":"Bar/Line Chart","id":"adf16edb-41","type":"chart_series","dstContext":{"kid":"b94d248d18207673431aff1cd4645b70","id":"dstadf16edb41"},"height":"3"},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jun 18, 2022","Jul 12, 2022","Jun 14, 2022","Jul 7, 2022"]],"displayName":"Date","formulas":[{"txt":"DATE_ADD(DATE(SLICE(da2557103f233f40be445efe38ed26f1@Tenders,A:A;),\"yyyy/MM/dd\"),\"3\",1)","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date","id":"e9178d7b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["fantastic project","thick project","defective project","filthy project"]],"displayName":"Project","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,D:D;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project","id":"c4cf464f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["316000","280000","864000","633000"]],"displayName":"Value","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Value","id":"12e0b903"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Residential","Residential","Residential","Renovation"]],"displayName":"Category","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,H:H;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Category","id":"89f36d1f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Won","Won","Won","Won"]],"displayName":"Status","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Tenders,E:E;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Status","id":"abe7de57"}],"displayName":"Table Copy 2","id":"33677a82","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","dim":"e9178d7b","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}},{"op":"<=","dim":"e9178d7b","type":"op","value":{"var":"dateEnd"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"e9178d7b","variation":"condition"},{"p":{"args":[{"dim":"abe7de57"},{"args":[{"value":"\"Won\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"type":"filter","filterBy":"abe7de57","variation":"member"}],"kid":"b94d248d18207673431aff1cd4645b70","id":"dst33677a82"}}],"isForked":false,"id":"61923a86c6e7a3b442095edb05e43e26","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Tenders Won by Category","usesSampleData":false,"master":"b94d248d18207673431aff1cd4645b70"},{"workspace":{"datasources":[],"dimensions":{"w":1720.0}},"components":[{"size":"xx-small","data":[["Below are some of the datasources that we can use to populate your dashboard. We can also connect to any other datasource that offers an API or makes use of a SQL database."]],"displayName":"Label 2","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":"\"Below are some of the datasources that we can use to populate your dashboard. We can also connect to any other datasource that offers an API or makes use of a SQL database.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"c2783f6c","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dstc2783f6c"},"wrap":true},{"components":[{"data":[["Project Management/CRM Tools"]],"displayName":"Label","formulas":[{"txt":"\"Project Management/CRM Tools\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dst9a624d0a"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"9a624d0a","wrap":true},{"layoutConfig":{"x":7.0,"y":0.0},"orientation":"v","displayName":"Separator","id":"781b74ce","type":"separator"},{"data":[["Accounting Tools"]],"displayName":"Label Copy","formulas":[{"txt":"\"Accounting Tools\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dst5cd7fc00"},"align":"c","layoutConfig":{"x":8.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":"5cd7fc00","wrap":true},{"data":[["https://upload.wikimedia.org/wikipedia/commons/5/5d/Pipedrive_Logo.svg"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image","formulas":[{"txt":"\"https://upload.wikimedia.org/wikipedia/commons/5/5d/Pipedrive_Logo.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dstdc9167a4"},"layoutConfig":{"x":0.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"dc9167a4","resizeHeight":"100"},{"data":[["https://software-advice.imgix.net/managed/products/logos/logo_34522_hd.png?auto=format&w=310"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy","formulas":[{"txt":"\"https://software-advice.imgix.net/managed/products/logos/logo_34522_hd.png?auto=format&w=310\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dst1d311508"},"layoutConfig":{"x":1.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"1d311508","resizeHeight":"100"},{"data":[["https://www.brand2global.com/wp-content/uploads/2017/07/hubspot-logo-1.png"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 2","formulas":[{"txt":"\"https://www.brand2global.com/wp-content/uploads/2017/07/hubspot-logo-1.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dsta5a388ff"},"layoutConfig":{"x":2.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"a5a388ff","resizeHeight":"100"},{"data":[["https://media-exp1.licdn.com/dms/image/C4D0BAQEptRNYZU8UIw/company-logo_200_200/0?e=2159024400&v=beta&t=fIgAHMhgi4_yKLIyk6EuilTLq0YcX8eZbFdQGc5ga9g"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 3","formulas":[{"txt":"\"https://media-exp1.licdn.com/dms/image/C4D0BAQEptRNYZU8UIw/company-logo_200_200/0?e=2159024400&v=beta&t=fIgAHMhgi4_yKLIyk6EuilTLq0YcX8eZbFdQGc5ga9g\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dst3d9774ab"},"layoutConfig":{"x":3.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"3d9774ab","resizeHeight":"100"},{"data":[["https://www.devicemagic.com/wp-content/uploads/2017/01/salesforce.png"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 4","formulas":[{"txt":"\"https://www.devicemagic.com/wp-content/uploads/2017/01/salesforce.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dstdaebe3ba"},"layoutConfig":{"x":4.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"daebe3ba","resizeHeight":"100"},{"data":[["https://media-exp1.licdn.com/dms/image/C4E0BAQGgbHJeqz71SQ/company-logo_200_200/0?e=2159024400&v=beta&t=jF-lvmZbsjyCVja4-Gwu25Ew0-ajyYlgjpGoo36STHc"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 12","formulas":[{"txt":"\"https://media-exp1.licdn.com/dms/image/C4E0BAQGgbHJeqz71SQ/company-logo_200_200/0?e=2159024400&v=beta&t=jF-lvmZbsjyCVja4-Gwu25Ew0-ajyYlgjpGoo36STHc\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dst1286e1d7"},"layoutConfig":{"x":5.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"1286e1d7","resizeHeight":"100"},{"data":[["https://www.marketingsolved.com/wp-content/uploads/2017/01/Active-Campaign-.jpg"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 11","formulas":[{"txt":"\"https://www.marketingsolved.com/wp-content/uploads/2017/01/Active-Campaign-.jpg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dsta73c7fa4"},"layoutConfig":{"x":6.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"a73c7fa4","resizeHeight":"100"},{"data":[["https://upload.wikimedia.org/wikipedia/en/thumb/9/9f/Xero_software_logo.svg/1200px-Xero_software_logo.svg.png"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 5","formulas":[{"txt":"\"https://upload.wikimedia.org/wikipedia/en/thumb/9/9f/Xero_software_logo.svg/1200px-Xero_software_logo.svg.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dst0b632309"},"layoutConfig":{"x":8.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"0b632309","resizeHeight":"100"},{"data":[["https://res-5.cloudinary.com/crunchbase-production/image/upload/c_lpad,h_256,w_256,f_auto,q_auto:eco/ba93usm0dchibdfrb4i8"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 6","formulas":[{"txt":"\"https://res-5.cloudinary.com/crunchbase-production/image/upload/c_lpad,h_256,w_256,f_auto,q_auto:eco/ba93usm0dchibdfrb4i8\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dstdc61c860"},"layoutConfig":{"x":9.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"dc61c860","resizeHeight":"100"},{"data":[["https://www.nicepng.com/png/detail/457-4573752_read-more-on-how-you-can-use-your.png"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 7","formulas":[{"txt":"\"https://www.nicepng.com/png/detail/457-4573752_read-more-on-how-you-can-use-your.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ff79da9035fcb558f72fa8b04472e76b","id":"dstaabcc142"},"layoutConfig":{"x":10.0,"y":1.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"aabcc142","resizeHeight":"100"}],"displayName":"Layout Grid","widths":[{"w":50.0,"x":7.0}],"id":"5ef8bdaa","cellData":[{"w":6.0,"x":0.0,"y":0.0},{"x":7.0,"h":2.0,"y":0.0},{"w":3.0,"x":8.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":11.0}],"isForked":false,"id":"b473f446640318f47ec6598f89fed4ce","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Datasource Options","usesSampleData":false,"master":"ff79da9035fcb558f72fa8b04472e76b"},{"workspace":{"datasources":["da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":1139.0}},"components":[{"size":"xx-small","data":[["Displays the amount of time spent on a project for each team member. This allows us to see who is contributing the most time to each project."]],"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 amount of time spent on a project for each team member. This allows us to see who is contributing the most time to each project.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"72c12585","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"13a2174e6790fa4cd7a795ef1d0e7415","id":"dst72c12585"},"wrap":true},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"showValues":true,"role":"series","data":[[653.0,482.0,583.0,436.0,215.0]],"color":"cx-theme_violet_2","displayName":"Hours Worked","seriesName":"Hours Worked","formulas":[{"txt":"lookup(!'d960fecc',group(&'0371f8d4-33'),groupby(&'0371f8d4-33',&'01f23211',\"sum(values)\"))","ver":2.0}],"autoFmt":false,"leaveGaps":true,"type":"series_data","fmt":"num","axis":"576a2695","chartStyle":"line_area","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","suffix":" hours"},"id":"91606004"},{"role":"axis_x","data":[["Anne Simmons","Jessica Walker","John Smith","Tim Warner","Tom Jones"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"GROUP(&'0371f8d4-33')","ver":2.0}],"autoFmt":true,"id":"d960fecc","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":"576a2695","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart Copy","id":"cf3f36a7","type":"chart_series","dstContext":{"kid":"13a2174e6790fa4cd7a795ef1d0e7415","id":"dstcf3f36a7"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jun 18, 2020","Jul 29, 2020","Mar 16, 2020","May 20, 2020","Jun 7, 2020","Apr 18, 2020","Aug 1, 2020","Sep 8, 2020","Feb 24, 2020","May 16, 2020","Sep 15, 2020","Jul 23, 2020","Jun 1, 2020","Jul 1, 2020","Sep 27, 2020","Aug 24, 2020","Apr 16, 2020","Apr 2, 2020","Mar 20, 2020","Jul 3, 2020","Apr 29, 2020","Aug 8, 2020","Sep 14, 2020","Sep 22, 2020","Sep 9, 2020","May 16, 2020","Jul 26, 2020","Apr 7, 2020","Apr 30, 2020","Apr 28, 2020","Mar 11, 2020","Apr 13, 2020","Apr 29, 2020","Mar 13, 2020","Jul 18, 2020","Apr 30, 2020","Sep 18, 2020","Apr 23, 2020","Sep 19, 2020","Jul 24, 2020","Apr 5, 2020","May 1, 2020","May 7, 2020","Oct 7, 2020","Aug 9, 2020","Jul 24, 2020","Jul 7, 2020","May 25, 2020","Jul 8, 2020","Sep 3, 2020","Apr 18, 2020","Jul 6, 2020","May 5, 2020","Jul 31, 2020","Sep 22, 2020","Sep 13, 2020","Aug 29, 2020","Apr 22, 2020","Aug 12, 2020","Jun 21, 2020","Oct 1, 2020","Oct 1, 2020","Apr 14, 2020","May 7, 2020","May 19, 2020","Jun 6, 2020","Feb 24, 2020","Apr 13, 2020","Jul 8, 2020","Jun 10, 2020","Jun 12, 2020","Jun 21, 2020","Sep 22, 2020","Sep 13, 2020","Sep 28, 2020","Aug 14, 2020","Sep 14, 2020","Mar 8, 2020","Jul 30, 2020","Jul 10, 2020","Apr 17, 2020","Sep 4, 2020","Jun 19, 2020","Mar 15, 2020","Aug 19, 2020","Apr 19, 2020","Aug 6, 2020","Apr 20, 2020","Oct 6, 2020","Sep 23, 2020","Sep 5, 2020","Feb 23, 2020","Jun 28, 2020","Mar 13, 2020","May 24, 2020","Apr 6, 2020","Oct 8, 2020","Sep 21, 2020","Aug 22, 2020","Oct 4, 2020"]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(da2557103f233f40be445efe38ed26f1@Timesheets,A:A;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"7ddeea09"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jun 2020","Jul 2020","Mar 2020","May 2020","Jun 2020","Apr 2020","Aug 2020","Sep 2020","Feb 2020","May 2020","Sep 2020","Jul 2020","Jun 2020","Jul 2020","Sep 2020","Aug 2020","Apr 2020","Apr 2020","Mar 2020","Jul 2020","Apr 2020","Aug 2020","Sep 2020","Sep 2020","Sep 2020","May 2020","Jul 2020","Apr 2020","Apr 2020","Apr 2020","Mar 2020","Apr 2020","Apr 2020","Mar 2020","Jul 2020","Apr 2020","Sep 2020","Apr 2020","Sep 2020","Jul 2020","Apr 2020","May 2020","May 2020","Oct 2020","Aug 2020","Jul 2020","Jul 2020","May 2020","Jul 2020","Sep 2020","Apr 2020","Jul 2020","May 2020","Jul 2020","Sep 2020","Sep 2020","Aug 2020","Apr 2020","Aug 2020","Jun 2020","Oct 2020","Oct 2020","Apr 2020","May 2020","May 2020","Jun 2020","Feb 2020","Apr 2020","Jul 2020","Jun 2020","Jun 2020","Jun 2020","Sep 2020","Sep 2020","Sep 2020","Aug 2020","Sep 2020","Mar 2020","Jul 2020","Jul 2020","Apr 2020","Sep 2020","Jun 2020","Mar 2020","Aug 2020","Apr 2020","Aug 2020","Apr 2020","Oct 2020","Sep 2020","Sep 2020","Feb 2020","Jun 2020","Mar 2020","May 2020","Apr 2020","Oct 2020","Sep 2020","Aug 2020","Oct 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'7ddeea09',\"d MMM yyyy\"),\"m\",DATEVALUE(!'7ddeea09',\"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"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date","id":"1a93c604"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["hurt project","awful project","hurt project","","awful project","sharp project","thick project","drunk project","maniacal project","hissing project","drunk project","hissing project","realistic project","realistic project","maniacal project","hurt project","","sharp project","defective project","maniacal project","filthy project","defective project","male project","","giant project","","male project","male project","drunk project","drunk project","drunk project","giant project","filthy project","familiar project","thick project","drunk project","giant project","hissing project","thick project","drunk project","hurt project","","thick project","male project","defective project","","","curved project","defective project","giant project","realistic project","male project","","male project","filthy project","curved project","thick project","realistic project","hissing project","realistic project","filthy project","","hurt project","","drunk project","defective project","","maniacal project","","maniacal project","","awful project","curved project","maniacal project","scared project","familiar project","familiar project","curved project","realistic project","giant project","hissing project","hissing project","male project","defective project","hurt project","giant project","awful project","hissing project","sharp project","filthy project","hurt project","male project","hissing project","curved project","maniacal project","awful project","","drunk project","defective project","thick project"]],"displayName":"Project","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Timesheets,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project","id":"7967ce35"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["1","7","4","2","7","2","2","4","4","3","1","6","8","6","8","2","4","4","5","3","2","8","7","2","5","6","8","8","6","6","2","7","6","1","6","8","1","3","2","7","4","2","5","4","5","6","7","7","6","8","3","4","7","4","2","1","4","3","5","4","8","1","7","4","4","2","4","8","5","2","5","3","1","5","6","3","6","1","5","8","5","3","4","1","2","8","5","8","1","1","2","4","7","8","6","3","8","5","4","2"]],"displayName":"Time","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Timesheets,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":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Time","id":"01f23211"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Anne Simmons","Jessica Walker","Tim Warner","Tom Jones","Jessica Walker","Anne Simmons","Anne Simmons","Jessica Walker","Anne Simmons","Jessica Walker","Anne Simmons","John Smith","Anne Simmons","Jessica Walker","Jessica Walker","Tom Jones","Jessica Walker","Anne Simmons","John Smith","Tim Warner","John Smith","John Smith","Tim Warner","Tim Warner","Tim Warner","Tim Warner","Tim Warner","John Smith","Tim Warner","Jessica Walker","Jessica Walker","Tom Jones","Tom Jones","John Smith","Anne Simmons","John Smith","Jessica Walker","John Smith","Jessica Walker","Tim Warner","John Smith","Anne Simmons","John Smith","Tim Warner","Tim Warner","John Smith","Tim Warner","John Smith","Tim Warner","John Smith","Jessica Walker","John Smith","Anne Simmons","Jessica Walker","Anne Simmons","Anne Simmons","John Smith","Jessica Walker","John Smith","Tim Warner","Tom Jones","Tim Warner","Anne Simmons","Tom Jones","Jessica Walker","John Smith","John Smith","Anne Simmons","Tom Jones","John Smith","Tom Jones","Anne Simmons","John Smith","Jessica Walker","John Smith","Anne Simmons","Anne Simmons","Tom Jones","Anne Simmons","John Smith","Anne Simmons","John Smith","John Smith","Tom Jones","John Smith","Tim Warner","Anne Simmons","Anne Simmons","John Smith","John Smith","John Smith","Tim Warner","Anne Simmons","Tom Jones","John Smith","Anne Simmons","Anne Simmons","Tom Jones","Tom Jones","Tim Warner"]],"displayName":"Team Member","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Timesheets,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Team Member","id":"0371f8d4-33"}],"displayName":"Table Copy","id":"8ceb8550","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"7967ce35"},{"var":"tm_ProjectFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"7967ce35","variation":"condition"},{"p":{"args":[{"op":">=","dim":"7ddeea09","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}},{"op":"<=","dim":"7ddeea09","type":"op","value":{"var":"dateEnd"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"7ddeea09","variation":"condition"}],"kid":"13a2174e6790fa4cd7a795ef1d0e7415","id":"dst8ceb8550"}}],"isForked":false,"id":"05f7bf9da944a230d9007965280bf2e1","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Hours Worked by Team Member","usesSampleData":false,"master":"13a2174e6790fa4cd7a795ef1d0e7415"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","773a7b4b52bcff4e6d67acb50b26c8a6","da2557103f233f40be445efe38ed26f1","05eb33644786b6d75770879750fc0fde"],"dimensions":{"w":1368.0}},"components":[{"size":"xx-small","data":[["The total value of all projects during the selected period as well as the profit from these values."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"The total value of all projects during the selected period as well as the profit from these values.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"bdb205e5","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dstbdb205e5"},"wrap":true},{"components":[{"data":[["Total Project Value"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Total Project Value\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dstd85f7ada"},"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":"d85f7ada","wrap":true},{"data":[["Total Project Profit"]],"displayName":"Label 2 Copy 2","formulas":[{"txt":"\"Total Project Profit\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dst85e3db0b"},"align":"c","layoutConfig":{"x":1.0,"y":0.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"85e3db0b","wrap":true},{"data":[[1943870.0]],"displayName":"Value","formulas":[{"txt":"sum(&'1d3d3aeb')","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dstbe2aa23573"},"align":"c","layoutConfig":{"x":0.0,"y":1.0},"size":"x-large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"be2aa235-73","renamed":true,"wrap":true},{"data":[[101770.0]],"displayName":"Profit","formulas":[{"txt":"sum(&'1d3d3aeb')-sum(&'3b23ede5-55')","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dstca815ab5"},"align":"c","layoutConfig":{"x":1.0,"y":1.0},"size":"x-large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"ca815ab5","renamed":true,"wrap":true},{"layoutConfig":{"x":0.0,"y":2.0},"displayName":"Separator","id":"f88990da-33","type":"separator"},{"data":[["Project Profitability %"]],"displayName":"Label 2","formulas":[{"txt":"\"Project Profitability %\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dstdec4c941"},"align":"c","layoutConfig":{"x":0.0,"y":3.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":"dec4c941","wrap":true},{"layoutConfig":{"x":0.0,"y":4.0},"components":[{"role":"current","size":"x-large","data":[[0.052354324106035896]],"displayName":"Current Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"formulas":[{"txt":"&'ca815ab5'/&'be2aa235-73'","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"id":"075838ee","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"075838ee"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dst075838ee","aggs":{"075838ee":"sum","7c4ee2f2":"sum"}}},{"role":"target","size":"medium","data":[[0.15]],"displayName":"Target Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"formulas":[{"txt":"LOOKUP(\"TOTAL PROJECT PROFIT / LOSS SUMMARY\",773a7b4b52bcff4e6d67acb50b26c8a6@Tradies,D:D;,773a7b4b52bcff4e6d67acb50b26c8a6@Tradies,H:H;)/100","ver":2.0,"src":{"c":[{"t":"l","v":"80"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_888","id":"7c4ee2f2","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"7c4ee2f2"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dst7c4ee2f2","aggs":{"7c4ee2f2":"sum"}}},{"role":"min","data":[[0.0]],"displayName":"Min Value","formulas":[{"txt":"0","ver":2.0,"src":{"c":[{"t":"l","v":"0"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"9424ae0b"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dst9424ae0b","aggs":{"9424ae0b":"sum","1a3f104b":"sum","075838ee":"sum","7c4ee2f2":"sum"}},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"id":"9424ae0b"},{"role":"max","data":[[0.5]],"displayName":"Max Value","formulas":[{"txt":"0.5","ver":2.0}],"autoFmt":false,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"1a3f104b"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dst1a3f104b","aggs":{"1a3f104b":"sum","075838ee":"sum","7c4ee2f2":"sum"}},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"id":"1a3f104b"},{"components":[{"role":"start","data":[[0.0]],"displayName":"Start 1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0","ver":2.0}],"autoFmt":false,"id":"736fec62","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"736fec62"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dst736fec62","aggs":{"736fec62":"sum"}}},{"role":"end","data":[[0.1]],"displayName":"End 1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.1","ver":2.0}],"autoFmt":false,"id":"19a6e3a3","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"19a6e3a3"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dst19a6e3a3","aggs":{"19a6e3a3":"sum"}}}],"rangeId":1.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_red_3","displayName":"Range 1","formulas":[],"autoFmt":true,"id":"85eb86af","type":"range"},{"components":[{"role":"start","data":[[0.1]],"displayName":"Start 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.1","ver":2.0}],"autoFmt":false,"id":"78a81578","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"78a81578"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dst78a81578","aggs":{"78a81578":"sum"}}},{"role":"end","data":[[0.3]],"displayName":"End 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.3","ver":2.0}],"autoFmt":false,"id":"aa564663","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"aa564663"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dstaa564663","aggs":{"aa564663":"sum"}}}],"rangeId":2.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_yellow_3","displayName":"Range 2","formulas":[],"autoFmt":true,"id":"22e34b30","type":"range"},{"components":[{"role":"start","data":[[0.3]],"displayName":"Start 3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.3","ver":2.0}],"autoFmt":false,"id":"bce3f8f0","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"bce3f8f0"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dstbce3f8f0","aggs":{"bce3f8f0":"sum"}}},{"role":"end","data":[[0.5]],"displayName":"End 3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.5","ver":2.0}],"autoFmt":false,"id":"11e634bf","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"11e634bf"}],"kid":"b2e7bebc23effa2ca46d612500dde0de","id":"dst11e634bf","aggs":{"11e634bf":"sum"}}}],"rangeId":3.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_green_3","displayName":"Range 3","formulas":[],"autoFmt":true,"id":"1e6726ff","type":"range"}],"size":"2","displayName":"Gauge","id":"392cd6e1","type":"gauge","dstContext":{"id":"dst392cd6e1"},"gaugeStyle":"hg"}],"displayName":"Layout Grid 2","id":"e8c9029a-61","cellData":[{"x":1.0,"y":1.0,"alignment":1.0},{"x":0.0,"y":1.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":4.0},{"w":2.0,"x":0.0,"y":3.0},{"w":2.0,"x":0.0,"y":2.0}],"type":"panel_grid","rows":5.0,"cols":2.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Project 2","Project 17","Project 26","Project 29","Project 31","Project 32","Project 40","Project 45","Project 58","Project 69","Project 73","Project 78","Project 85","Project 86","Project 93"]],"displayName":"Project","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Projects,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project","id":"b7620fa8-49"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Feb 17, 2021","Jan 7, 2021","Mar 14, 2021","Jan 29, 2021","Mar 27, 2021","Feb 8, 2021","Feb 11, 2021","Mar 23, 2021","Dec 29, 2020","Jan 18, 2021","Mar 26, 2021","Jan 29, 2021","Feb 26, 2021","Mar 25, 2021","Mar 19, 2021"]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(05eb33644786b6d75770879750fc0fde@Projects,A:A;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"766a7360"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[136130.0,149300.0,164910.0,52550.0,175530.0,116350.0,95750.0,172450.0,187790.0,165750.0,83550.0,46520.0,81600.0,173290.0,142400.0]],"displayName":"Value","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Projects,F:F;)+slice(05eb33644786b6d75770879750fc0fde@Projects,J:J;)+slice(05eb33644786b6d75770879750fc0fde@Projects,N:N;)+slice(05eb33644786b6d75770879750fc0fde@Projects,R:R;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Value","id":"1d3d3aeb"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[160100.0,155300.0,147000.0,44400.0,171000.0,102200.0,96200.0,161700.0,159900.0,164500.0,74600.0,42900.0,82200.0,154500.0,125600.0]],"displayName":"Cost","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Projects,E:E;)+slice(05eb33644786b6d75770879750fc0fde@Projects,I:I;)+slice(05eb33644786b6d75770879750fc0fde@Projects,M:M;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Cost","id":"3b23ede5-55"}],"displayName":"Table Copy","id":"f4681ee2","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","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":"845f895a147951a813c4f52d8c777265","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Total Project Profitability","usesSampleData":false,"master":"b2e7bebc23effa2ca46d612500dde0de"},{"workspace":{"datasources":["da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":943.0}},"components":[{"size":"xx-small","data":[["Please filter a project to display all proceeding data based on your selection."]],"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":"\"Please filter a project to display all proceeding data based on your selection.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"c78ff9e3-5","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"c1e4019c135aa4bab95a2811f30fce0e","id":"dstc78ff9e35"},"wrap":true},{"components":[{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[["conscious project","curved project","delicate project","different project","encouraging project","familiar project","fantastic project","giant project","hissing project","hurt project","majestic project","maniacal project","materialistic project","realistic project","shiny project","southern project","yielding project"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"GROUP(SLICE(da2557103f233f40be445efe38ed26f1@Projects,D:D;))","ver":2.0}],"autoFmt":false,"id":"de86647f-3","type":"proxy"},{"role":"labels","data":[["Project 1","Project 2","Project 3","Project 4","Project 5","Project 6","Project 7","Project 8","Project 9","Project 10","Project 11","Project 12","Project 13","Project 14","Project 15","Project 16",""]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"ARRAY(\"Project 1\",\"Project 2\",\"Project 3\",\"Project 4\",\"Project 5\",\"Project 6\",\"Project 7\",\"Project 8\",\"Project 9\",\"Project 10\",\"Project 11\",\"Project 12\",\"Project 13\",\"Project 14\",\"Project 15\",\"Project 16\")","ver":2.0}],"autoFmt":false,"id":"80b8dc20-4","type":"proxy"}],"displayName":"User Input Control","scope":2.0,"inputLabel":"Project","inputType":1.0,"id":"b68ba0fa-2","type":"input","dstContext":{"kid":"c1e4019c135aa4bab95a2811f30fce0e","id":"dstb68ba0fa2"},"propName":"tm_ProjectFilter"}],"displayName":"Layout Grid","id":"8f86b0bf-1","type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"60f028f2335b47534afd58ad1a5c8954","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"TC - Project Filter","usesSampleData":false,"master":"c1e4019c135aa4bab95a2811f30fce0e"},{"workspace":{"datasources":["da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":1139.0}},"components":[{"size":"xx-small","data":[["Displays the amount of time spent on a project each month. This allows us to see where the amount of time being spent on a project spikes and where it drops off."]],"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 amount of time spent on a project each month. This allows us to see where the amount of time being spent on a project spikes and where it drops off.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"50efdcd1","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"d94273c067dc9c880432f785020407de","id":"dst50efdcd1"},"wrap":true},{"components":[{"role":"primary","data":[["Total Hours Worked"]],"displayName":"Primary Value","formulas":[{"txt":"\"Total Hours Worked\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"d94273c067dc9c880432f785020407de","id":"dst4dd3338843"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"4dd33388-43"},{"role":"secondary","size":"large","data":[[0.0]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":" hours"},"formulas":[{"txt":"sum(&'8e5f473c')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"a85f914f-44","type":"label","fmt":"num","dstContext":{"kid":"d94273c067dc9c880432f785020407de","id":"dsta85f914f44"},"align":"c"}],"displayName":"Value Pair","id":"b86c09bc-42","type":"simple_value","dstContext":{"id":"dstb86c09bc42"}},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"showValues":true,"role":"series","data":[["","","",""]],"color":"cx-theme_violet_3","displayName":"Hours Worked","seriesName":"Hours Worked","formulas":[{"txt":"lookup(!'60b565e5',group(&'a64d4883'),groupby(&'a64d4883',&'f1381fbc',\"sum(values)\"))","ver":2.0}],"autoFmt":false,"leaveGaps":true,"type":"series_data","fmt":"num","axis":"9b31b59c","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"precision":"0","suffix":" hours"},"id":"8e5f473c"},{"role":"axis_x","data":[["Jul 2020","Aug 2020","Sep 2020","Oct 2020"]],"displayName":"Untitled","fmtArgs":{"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":"60b565e5","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":"9b31b59c","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart Copy","id":"897f9c36","type":"chart_series","dstContext":{"kid":"d94273c067dc9c880432f785020407de","id":"dst897f9c36"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(da2557103f233f40be445efe38ed26f1@Timesheets,A:A;,\"yyyy/MM/dd\"))","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"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"b36db46f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(&'b36db46f',\"d MMM yyyy\"),\"m\",DATEVALUE(&'b36db46f',\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date","id":"a64d4883"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[]],"displayName":"Project","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Timesheets,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project","id":"3d54adc5"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[]],"displayName":"Time","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Timesheets,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":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Time","id":"f1381fbc"}],"displayName":"Table Copy","id":"c700d35a","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"3d54adc5"},{"var":"tm_ProjectFilter"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"3d54adc5","variation":"condition"}],"kid":"d94273c067dc9c880432f785020407de","id":"dstc700d35a"}}],"isForked":false,"id":"204182dae5e616da0a0e3377fd363782","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Hours Worked by Date","usesSampleData":false,"master":"d94273c067dc9c880432f785020407de"},{"workspace":{"datasources":["da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":1139.0}},"components":[{"size":"xx-small","data":[["A quick snapshot of the selected project"]],"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 quick snapshot of the selected project\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"a3d7ffd6-4","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dsta3d7ffd64"},"wrap":true},{"components":[{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"primary","data":[["Project"]],"displayName":"Primary Value","formulas":[{"txt":"\"Project\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dst62c5ca388"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"62c5ca38-8"},{"role":"secondary","size":"large","data":[["Project 1"]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"LOOKUP($tm_ProjectFilter,&'7a98ec80-2',&'4b46b8f8-5')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"46eb0a2f-9","type":"label","fmt":"txt","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dst46eb0a2f9"},"align":"c"}],"displayName":"Value Pair 2","id":"f5f35ca5-7","type":"simple_value","dstContext":{"id":"dstf5f35ca57"}},{"layoutConfig":{"x":0.0,"y":1.0},"displayName":"Separator","id":"d56b4e07-10","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"primary","data":[["Duration"]],"displayName":"Primary Value","formulas":[{"txt":"\"Duration\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dst995ae7d2"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"995ae7d2"},{"role":"secondary","data":[[49.0]],"displayName":"Secondary Value","formulas":[{"txt":"(lookup($tm_ProjectFilter,da2557103f233f40be445efe38ed26f1@Projects,D:D;,date(da2557103f233f40be445efe38ed26f1@Projects,F:F;,\"yyyy/MM/dd\"))-lookup($tm_ProjectFilter,da2557103f233f40be445efe38ed26f1@Projects,D:D;,date(da2557103f233f40be445efe38ed26f1@Projects,A:A;,\"yyyy/MM/dd\")))/86400","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dstc668ec0f"},"align":"c","size":"large","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"},"precision":"0","suffix":" days"},"id":"c668ec0f","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"180"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_red_4","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"180"},"type":"lteq"}],"reactions":[{"type":"color","value":"cx-theme_green_4","isScalar":true}]}]}],"displayName":"Value Pair Copy 2","id":"f6fa8f52","type":"simple_value","dstContext":{"id":"dstf6fa8f52"}},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"primary","data":[["Value"]],"displayName":"Primary Value","formulas":[{"txt":"\"Value\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dstb08974ad"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"b08974ad"},{"role":"secondary","size":"large","data":[[791000.0]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0","suffix":""},"formulas":[{"txt":"lookup($tm_ProjectFilter,da2557103f233f40be445efe38ed26f1@Projects,D:D;,da2557103f233f40be445efe38ed26f1@Projects,C:C;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"07ff0771","type":"label","fmt":"cur","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dst07ff0771"},"align":"c"}],"displayName":"Value Pair Copy 3","id":"ee5bd502","type":"simple_value","dstContext":{"id":"dstee5bd502"}},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"role":"primary","data":[["Status"]],"displayName":"Primary Value","formulas":[{"txt":"\"Status\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dst04b96c052"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"04b96c05-2"},{"role":"secondary","data":[["Stage 3"]],"displayName":"Secondary Value","formulas":[{"txt":"lookup($tm_ProjectFilter,da2557103f233f40be445efe38ed26f1@Projects,D:D;,da2557103f233f40be445efe38ed26f1@Projects,K:K;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dstb1c3a38e3"},"align":"c","size":"large","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":"b1c3a38e-3","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"Closed"},"type":"contain"}],"reactions":[{"type":"color","value":"cx-theme_red_4","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"Closed"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_green_4","isScalar":true}]}]}],"displayName":"Value Pair","id":"7b279ba4-1","type":"simple_value","dstContext":{"id":"dst7b279ba41"}},{"layoutConfig":{"x":3.0,"y":2.0},"components":[{"role":"primary","data":[["Budget"]],"displayName":"Primary Value","formulas":[{"txt":"\"Budget\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dstdd6ce0be"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"dd6ce0be"},{"role":"secondary","data":[["Under Budget"]],"displayName":"Secondary Value","formulas":[{"txt":"if(lookup($tm_ProjectFilter,da2557103f233f40be445efe38ed26f1@Projects,D:D;,da2557103f233f40be445efe38ed26f1@Projects,I:I;)>lookup($tm_ProjectFilter,da2557103f233f40be445efe38ed26f1@Projects,D:D;,da2557103f233f40be445efe38ed26f1@Projects,J:J;),\"Over Budget\",\"Under Budget\")","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dst92b29c8a"},"align":"c","size":"large","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":"92b29c8a","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"Over Budget"},"type":"contain"}],"reactions":[{"type":"color","value":"cx-theme_red_4","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"Under Budget"},"type":"contain"}],"reactions":[{"type":"color","value":"cx-theme_green_4","isScalar":true}]}]}],"displayName":"Value Pair Copy","id":"f603fb09","type":"simple_value","dstContext":{"id":"dstf603fb09"}}],"displayName":"Layout Grid","id":"49ac38f1-5","cellData":[{"w":4.0,"x":0.0,"y":1.0},{"w":2.0,"x":1.0,"y":0.0}],"type":"panel_grid","rows":3.0,"cols":4.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["adaptable project","blushing project","brief project","drunk project","encouraging project","fantastic project","filthy project","gentle project","giant project","hissing project","languid project","maniacal project","receptive project","scared project","uppity project","upset project"]],"displayName":"Unnamed 1","formulas":[{"txt":"GROUP(SLICE(da2557103f233f40be445efe38ed26f1@Projects,D:D;))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","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"}},"name":"Unnamed 1","id":"7a98ec80-2"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Project 1","Project 2","Project 3","Project 4","Project 5","Project 6","Project 7","Project 8","Project 9","Project 10","Project 11","Project 12","Project 13","Project 14","Project 15","Project 16"]],"displayName":"Unnamed 2","formulas":[{"txt":"ARRAY(\"Project 1\",\"Project 2\",\"Project 3\",\"Project 4\",\"Project 5\",\"Project 6\",\"Project 7\",\"Project 8\",\"Project 9\",\"Project 10\",\"Project 11\",\"Project 12\",\"Project 13\",\"Project 14\",\"Project 15\",\"Project 16\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","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"}},"name":"Unnamed 2","id":"4b46b8f8-5"}],"displayName":"Table","id":"e59d1336-1","type":"table","dstContext":{"kid":"43b8c45a9748c40139bfab50c1b3db36","id":"dste59d13361"}}],"isForked":false,"id":"da049f2fa3ccfead50f7a5af62ed4d44","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Project Status","usesSampleData":false,"master":"43b8c45a9748c40139bfab50c1b3db36"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","773a7b4b52bcff4e6d67acb50b26c8a6","da2557103f233f40be445efe38ed26f1"],"dimensions":{"w":1368.0}},"components":[{"size":"xx-small","data":[["The total cost for all active projects compared to the budget for these jobs. This highlights when costs run over budget, for more detail, this is broken down by individual project in the table.It shows any total amount over budget in a negative in red and any total cost undet budget shows in green as a positive amount."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"The total cost for all active projects compared to the budget for these jobs. This highlights when costs run over budget, for more detail, this is broken down by individual project in the table.It shows any total amount over budget in a negative in red and any total cost undet budget shows in green as a positive amount.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"fbab77a3","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"0bcd655e47f3034d499b9ecf48db41a2","id":"dstfbab77a3"},"wrap":true},{"components":[{"role":"primary","data":[["Total Over Budget"]],"displayName":"Primary Value","formulas":[{"txt":"CONCAT(\"Total\",if(&'df9ed7aa-81'<0,\" Over \",\" Under \"),\"Budget\")","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"0bcd655e47f3034d499b9ecf48db41a2","id":"dst94dcbd3c80"},"align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"prefix":"","prefixFontStyle":"bold","autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"prefixFontColour":"cx-color_000"},"id":"94dcbd3c-80","conditions":[{"predicates":[{"left":{"cx":"df9ed7aa-81"},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"cx-theme_red_4","isScalar":true}]},{"predicates":[{"left":{"cx":"df9ed7aa-81"},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_green_4","isScalar":true}]}]},{"role":"secondary","data":[[-31460.0]],"displayName":"Secondary Value","formulas":[{"txt":"Sum(&'db3e7bd3-67')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"0bcd655e47f3034d499b9ecf48db41a2","id":"dstdf9ed7aa81"},"align":"c","size":"large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"df9ed7aa-81","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"cx-theme_red_4","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_green_4","isScalar":true}]}]}],"displayName":"Value Pair","id":"fbc4e142-79","type":"simple_value","dstContext":{"id":"dstfbc4e14279"}},{"components":[{"components":[{"role":"customHeader","data":[["Project Name"]],"displayName":"Project Name","formulas":[{"txt":"\"Project Name\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"0bcd655e47f3034d499b9ecf48db41a2","id":"dstc94ef9d059"},"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":"c94ef9d0-59","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"cx-bgcolor_orange_4","isScalar":true},{"type":"color","isScalar":true,"value":"cx-theme_fff"}]}]}],"customHeader":true,"role":"tcol","data":[["drunk project","brief project","defective project","uttermost project","yielding project"]],"displayName":"Project Name","formulas":[{"txt":"&'d6c675e2'","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"txt","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project Name","id":"63c1354b-58"},{"components":[{"role":"customHeader","data":[["Total Budget Cost"]],"displayName":"Total Cost","formulas":[{"txt":"\"Total Budget Cost\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"0bcd655e47f3034d499b9ecf48db41a2","id":"dsta32c999162"},"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":"a32c9991-62","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_orange_4"}]}]}],"customHeader":true,"role":"tcol","data":[[146880.0,186000.0,532000.0,265200.0,281500.0]],"displayName":"Total Cost","formulas":[{"txt":"&'fd082af3'","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 Cost","id":"5ba3378a-61"},{"components":[{"role":"customHeader","data":[["Total Actual Costs"]],"displayName":"Total Budget","formulas":[{"txt":"\"Total Actual Costs\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"0bcd655e47f3034d499b9ecf48db41a2","id":"dstbf55ebde65"},"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":"bf55ebde-65","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_orange_4"}]}]}],"customHeader":true,"role":"tcol","data":[[161160.0,153760.0,357000.0,410800.0,360320.0]],"displayName":"Total Budget","formulas":[{"txt":"&'6926b981'","ver":2.0}],"autoFmt":false,"index":2.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 Budget","id":"2dcbbfbc-64"},{"components":[{"role":"customHeader","data":[["Over / Under Budget"]],"displayName":"Over / Under Budget","formulas":[{"txt":"\"Over / Under Budget\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"0bcd655e47f3034d499b9ecf48db41a2","id":"dst55c9bdb768"},"align":"c","mixin":"label","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"55c9bdb7-68","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_orange_4"}]}]}],"customHeader":true,"role":"tcol","data":[[-14280.0,32240.0,175000.0,-145600.0,-78820.0]],"displayName":"Over / Under Budget","formulas":[{"txt":"&'5ba3378a-61'-&'2dcbbfbc-64'","ver":2.0}],"autoFmt":false,"index":3.0,"type":"table_col","fmt":"cur","align":"c","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Over / Under Budget","id":"db3e7bd3-67","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"cx-theme_red_4"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_green_4"}]}]}],"displayName":"Table 2","id":"044b44aa-57","type":"table","dstContext":{"kid":"0bcd655e47f3034d499b9ecf48db41a2","id":"dst044b44aa57"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["drunk project","brief project","defective project","uttermost project","yielding project"]],"displayName":"Project","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Projects,D:D;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project","id":"d6c675e2"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jul 5, 2020","Nov 19, 2020","Sep 14, 2020","May 28, 2020","Jan 3, 2020"]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(da2557103f233f40be445efe38ed26f1@Projects,F:F;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"c7999952"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["204000","248000","700000","520000","563000"]],"displayName":"Value","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Projects,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Value","id":"fdd43496"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["161160","153760","357000","410800","360320"]],"displayName":"Cost","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Projects,I:I;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Cost","id":"6926b981"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["146880","186000","532000","265200","281500"]],"displayName":"Budget","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Projects,J:J;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Budget","id":"fd082af3"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Renovation","Renovation","Industrial","Residential","Residential"]],"displayName":"Type","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Projects,H:H;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":5.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Type","id":"97d7ba2b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Stage 3","Stage 1","Stage 1","Stage 3","Stage 3"]],"displayName":"Stage","formulas":[{"txt":"slice(da2557103f233f40be445efe38ed26f1@Projects,K:K;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":6.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Stage","id":"5ca83631"}],"displayName":"Table Copy","id":"d7d7c0c0","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"args":[{"dim":"5ca83631"},{"value":"\"\""}],"f":"matches_insensitive","type":"f"},{"args":[{"dim":"5ca83631"},{"value":"\"closed\""}],"f":"matches_insensitive","type":"f"}],"f":"or","type":"f"}],"f":"not","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"5ca83631","variation":"condition"}],"kid":"0bcd655e47f3034d499b9ecf48db41a2","id":"dstd7d7c0c0"}}],"isForked":false,"id":"c77297f32365f1602642b16684ee6b4a","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Budgeted Project Costs vs Actual Costs","usesSampleData":false,"master":"0bcd655e47f3034d499b9ecf48db41a2"}]}]