[{"tab":{"id":"fcc413c7b7e4b4d59868ac8a9b3791b3","name":"Tradies - Maintenance","layoutType":"grid","state":{"desktop":{"itemConfigs":[{"minHeight":210,"colSpan":6,"index":[0,0],"id":"gridklip-de9301e01ffa08ddbb0f7c7f5c5924f6"},{"minHeight":79,"colSpan":6,"index":[0,1],"id":"gridklip-1a951aed833fd23c13f25ab86d691470"},{"minHeight":149,"colSpan":6,"index":[0,2],"id":"gridklip-66e1ebaac6b99eaf96a42767cb31f722"},{"minHeight":464,"colSpan":6,"index":[0,3],"id":"gridklip-35a4c54138e48391b58df866a41ac5c3"},{"minHeight":379,"colSpan":6,"index":[0,4],"id":"gridklip-3cf21c7902d3dfeefa1f705375323815"},{"minHeight":482,"colSpan":4,"index":[0,5],"id":"gridklip-3093c0bd727b36a7e242166a64f2bd2b"},{"minHeight":541,"colSpan":6,"index":[0,6],"id":"gridklip-043c7ba45a28fcf5f68b72805578ef66"},{"minHeight":242,"colSpan":6,"index":[0,7],"id":"gridklip-be0005b6b0a914ef74eadcddd1f02388"},{"minHeight":368,"colSpan":2,"index":[4,5],"id":"gridklip-3a1c62e361845440f5fe806a8e9e2ba8","height":400.9921875}],"colWidths":["auto","auto","auto","auto","auto","auto"],"cols":6}},"master":"fcc413c7b7e4b4d59868ac8a9b3791b3"},"klips":[{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9"],"dimensions":{"w":1329.0}},"components":[{"size":"xx-small","data":[["This displays which job types are being worked the most. It also displays the % of quotes that are won and the average job value per job type - if both of these values are low, it suggests that the effor being spent on these quotes may not be worthwhile."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"This displays which job types are being worked the most. It also displays the % of quotes that are won and the average job value per job type - if both of these values are low, it suggests that the effor being spent on these quotes may not be worthwhile.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"ee1de54e","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"4b9ded487bcf6ce35225e46c342ff7a6","id":"dstee1de54e"},"wrap":true},{"components":[{"data":[["Jobs worked by Type"]],"displayName":"Label 2","formulas":[{"txt":"\"Jobs worked by Type\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"4b9ded487bcf6ce35225e46c342ff7a6","id":"dstc88a3f7445"},"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":"c88a3f74-45","wrap":true},{"data":[["% of Quotes Won and Average Value by Job Type"]],"displayName":"Label 2 Copy 2","formulas":[{"txt":"\"% of Quotes Won and Average Value by Job Type\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"4b9ded487bcf6ce35225e46c342ff7a6","id":"dstdc6d3e94"},"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":"dc6d3e94","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"data","data":[[1.0,1.0]],"displayName":"Values","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"}},"formulas":[{"txt":"GROUPBY(select(&'a30ff66c',BETWEEN(&'0b766dba',$TM_DateStart,$TM_DateEnd)),select(&'a30ff66c',BETWEEN(&'0b766dba',$TM_DateStart,$TM_DateEnd)),\"count(values)\")","ver":2.0}],"autoFmt":true,"id":"1c334854-42","type":"series_data","fmt":"num"},{"role":"labels","data":[["installation","repair"]],"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(select(&'a30ff66c',BETWEEN(&'0b766dba',$TM_DateStart,$TM_DateEnd)))","ver":2.0}],"autoFmt":true,"id":"263094c6-43","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["cx-theme_yellow_3","cx-theme_orange_3","cx-theme_red_3","cx-theme_violet_3","cx-theme_orange_1","cx-theme_red_1","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart","id":"4c8bec56-41","type":"chart_pie","dstContext":{"kid":"4b9ded487bcf6ce35225e46c342ff7a6","id":"dst4c8bec5641"},"overrideColors":true},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"showValues":true,"role":"series","data":[["NaN",66.66666666666666,0.0,0.0]],"displayName":"Percentage of Quotes Won","seriesName":"Percentage of Quotes Won","formulas":[{"txt":"lookup(&'271c90a0-51',group(select(&'a30ff66c',AND(BETWEEN(&'b1b93131',$TM_DateStart,$TM_DateEnd),&'67e4cdca-76'=\"Won\"))),groupby(select(&'a30ff66c',AND(BETWEEN(&'b1b93131',$TM_DateStart,$TM_DateEnd),&'67e4cdca-76'=\"Won\")),select(&'a30ff66c',AND(BETWEEN(&'b1b93131',$TM_DateStart,$TM_DateEnd),&'67e4cdca-76'=\"Won\")),\"count(values)\"))/lookup(&'271c90a0-51',group(select(&'a30ff66c',BETWEEN(&'b1b93131',$TM_DateStart,$TM_DateEnd))),groupby(select(&'a30ff66c',BETWEEN(&'b1b93131',$TM_DateStart,$TM_DateEnd)),select(&'a30ff66c',BETWEEN(&'b1b93131',$TM_DateStart,$TM_DateEnd)),\"count(values)\"))*100","ver":2.0}],"autoFmt":false,"leaveGaps":true,"type":"series_data","fmt":"pct","axis":"225a03cb-52","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"e3df1c82-50"},{"showValues":true,"role":"series","data":[["NaN",823.0,1271.0,"NaN"]],"color":"cx-theme_yellow_3","displayName":"Average Job Value","seriesName":"Average Job Value","formulas":[{"txt":"lookup(&'271c90a0-51',group(select(&'a30ff66c',BETWEEN(&'0b766dba',$TM_DateStart,$TM_DateEnd))),groupby(select(&'a30ff66c',BETWEEN(&'0b766dba',$TM_DateStart,$TM_DateEnd)),select(&'c03d157c',BETWEEN(&'0b766dba',$TM_DateStart,$TM_DateEnd)),\"sum(values)\"))/lookup(&'271c90a0-51',group(select(&'a30ff66c',BETWEEN(&'0b766dba',$TM_DateStart,$TM_DateEnd))),groupby(select(&'a30ff66c',BETWEEN(&'0b766dba',$TM_DateStart,$TM_DateEnd)),select(&'a30ff66c',BETWEEN(&'0b766dba',$TM_DateStart,$TM_DateEnd)),\"count(values)\"))","ver":2.0}],"autoFmt":false,"leaveGaps":true,"type":"series_data","fmt":"cur","axis":"cd56fe5d-81","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"3634929f-80"},{"role":"axis_x","data":[["call back","installation","repair","warranty"]],"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(select(&'7e982d71',BETWEEN(&'b1b93131',$TM_DateStart,$TM_DateEnd)))","ver":2.0}],"autoFmt":true,"id":"271c90a0-51","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Perc","formulas":[],"autoFmt":true,"label":"Perc","type":"chart_axis","fmt":"pct","grid":true,"fmtArgs":{},"id":"225a03cb-52","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":"cd56fe5d-81","labelDrop":0.0}],"displayName":"Bar/Line Chart","id":"39aa79e2-49","type":"chart_series","dstContext":{"kid":"4b9ded487bcf6ce35225e46c342ff7a6","id":"dst39aa79e249"}}],"displayName":"Layout Grid","id":"8d23e28f-44","cellData":[{"w":2.0,"x":1.0,"y":1.0},{"w":2.0,"x":1.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5956856E9,1.5945624E9,1.5937848E9,1.5949944E9,1.5959448E9,1.5959448E9,1.5993144E9,1.5955128E9,1.600092E9,1.5961176E9,1.5959448E9,1.598796E9,1.5954264E9,1.600524E9,1.598364E9,1.6017336E9,1.6008696E9,1.5958584E9,1.5984504E9,1.6004376E9,1.6011288E9,1.6006968E9,1.599228E9,1.5995736E9,1.5967224E9,1.5963768E9,1.6018164E9,1.5937848E9,1.597932E9,1.5975864E9,1.6004376E9,1.5954264E9,1.5975E9,1.594044E9,1.5952536E9,1.5972408E9,1.5985368E9,1.5967224E9,1.5954264E9,1.5959448E9,1.600092E9,1.5994008E9,1.5954264E9,1.6013016E9,1.6012152E9,1.6012152E9,1.5995736E9,1.5988824E9,1.59534E9,1.6003512E9,1.596636E9,1.596204E9,1.5997464E9,1.599228E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(e81016948df440cd06e1fcdc846f01b9@Sales,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":"0b766dba"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["26 Jul 2020","13 Jul 2020","4 Jul 2020","18 Jul 2020","29 Jul 2020","29 Jul 2020","6 Sep 2020","24 Jul 2020","15 Sep 2020","31 Jul 2020","29 Jul 2020","31 Aug 2020","23 Jul 2020","20 Sep 2020","26 Aug 2020","4 Oct 2020","24 Sep 2020","28 Jul 2020","27 Aug 2020","19 Sep 2020","27 Sep 2020","22 Sep 2020","5 Sep 2020","9 Sep 2020","7 Aug 2020","3 Aug 2020","5 Oct 2020","4 Jul 2020","21 Aug 2020","17 Aug 2020","19 Sep 2020","23 Jul 2020","16 Aug 2020","7 Jul 2020","21 Jul 2020","13 Aug 2020","28 Aug 2020","7 Aug 2020","23 Jul 2020","29 Jul 2020","15 Sep 2020","7 Sep 2020","23 Jul 2020","29 Sep 2020","28 Sep 2020","28 Sep 2020","9 Sep 2020","1 Sep 2020","22 Jul 2020","18 Sep 2020","6 Aug 2020","1 Aug 2020","11 Sep 2020","5 Sep 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($TM_DateGroup,\"d\",DATEVALUE(&'0b766dba',\"d MMM yyyy\"),\"m\",DATEVALUE(&'0b766dba',\"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":"22b16ffe"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Tom Jones","John Smith","Anne Simmons","Tim Warner","Jessica Walker","John Smith","Jessica Walker","Tim Warner","John Smith","Tom Jones","Tim Warner","Jessica Walker","Tom Jones","Tom Jones","John Smith","Jessica Walker","Jessica Walker","Tom Jones","Tim Warner","Jessica Walker","Tom Jones","Tom Jones","John Smith","Jessica Walker","Tom Jones","John Smith","Anne Simmons","Tim Warner","Jessica Walker","John Smith","Jessica Walker","Tim Warner","Jessica Walker","Tom Jones","Tom Jones","John Smith","Jessica Walker","Jessica Walker","Tom Jones","Tim Warner","Jessica Walker","Tom Jones","Tom Jones","John Smith","Jessica Walker","Tom Jones","John Smith","Anne Simmons","Tim Warner","Jessica Walker","John Smith","Jessica Walker","Tim Warner","Jessica Walker"]],"displayName":"Employee","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Employee","id":"65ae73eb"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["998","1563","1759","964","1095","1552","1870","968","187","1803","138","855","434","1181","677","1271","165","147","336","186","542","834","1012","1921","731","903","823","908","814","688","1158","1481","631","468","544","598","1927","1206","1720","1789","1174","978","1399","518","181","1216","600","341","1345","1100","938","1220","1347","1902"]],"displayName":"Value","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,C:C;)","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":"c03d157c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["warranty","call back","installation","repair","warranty","call back","installation","repair","installation","repair","warranty","installation","repair","repair","repair","repair","call back","installation","warranty","call back","installation","repair","warranty","call back","installation","repair","installation","repair","warranty","installation","repair","repair","repair","repair","call back","installation","warranty","call back","installation","repair","warranty","call back","installation","repair","installation","repair","warranty","installation","repair","repair","repair","repair","call back","installation"]],"displayName":"Type","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,D:D;)","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":"a30ff66c"}],"displayName":"Table","id":"c8891c5d","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"65ae73eb"},{"var":"TM_Employee"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"65ae73eb","variation":"condition"}],"kid":"4b9ded487bcf6ce35225e46c342ff7a6","id":"dstc8891c5d"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5997464E9,1.5973272E9,1.5964632E9,1.6008696E9,1.5943896E9,1.5994872E9,1.594476E9,1.5969816E9,1.5946488E9,1.59966E9,1.598796E9,1.5937848E9,1.5984504E9,1.5995736E9,1.600524E9,1.5943032E9,1.5962904E9,1.5968088E9,1.6020756E9,1.5958584E9,1.6019028E9,1.5943896E9,1.5952536E9,1.5945624E9,1.5948216E9,1.6006104E9,1.5989688E9,1.5993144E9,1.5952536E9,1.598364E9,1.599228E9,1.6007832E9,1.5987096E9,1.6004376E9,1.6015608E9,1.6017336E9,1.6010424E9,1.5964632E9,1.6020756E9,1.6019892E9,1.5942168E9,1.5935256E9,1.593612E9,1.6020756E9,1.6010424E9,1.601388E9,1.594044E9,1.595772E9,1.5946488E9,1.5988824E9,1.5973272E9,1.5985368E9,1.594476E9,1.5998328E9,1.5990552E9,1.5959448E9,1.5961176E9,1.5969816E9,1.5955992E9,1.597068E9,1.598796E9,1.596636E9,1.5980184E9,1.5991416E9,1.5968088E9,1.6002648E9,1.5938712E9,1.5965496E9,1.6000056E9,1.5998328E9,1.6007832E9,1.5965496E9,1.600092E9,1.596636E9,1.5991416E9,1.6015608E9,1.6007832E9,1.600092E9,1.5998328E9,1.5971544E9,1.5943032E9,1.5984504E9,1.5997464E9,1.5946488E9,1.6011288E9,1.5948216E9,1.594476E9,1.6004376E9,1.5955992E9,1.5991416E9,1.5998328E9,1.5968952E9,1.5989688E9,1.5977592E9,1.6006968E9,1.5975864E9,1.5972408E9,1.6007832E9,1.5955992E9,1.6007832E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(e81016948df440cd06e1fcdc846f01b9@Quotes,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":"b1b93131"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["11 Sep 2020","14 Aug 2020","4 Aug 2020","24 Sep 2020","11 Jul 2020","8 Sep 2020","12 Jul 2020","10 Aug 2020","14 Jul 2020","10 Sep 2020","31 Aug 2020","4 Jul 2020","27 Aug 2020","9 Sep 2020","20 Sep 2020","10 Jul 2020","2 Aug 2020","8 Aug 2020","8 Oct 2020","28 Jul 2020","6 Oct 2020","11 Jul 2020","21 Jul 2020","13 Jul 2020","16 Jul 2020","21 Sep 2020","2 Sep 2020","6 Sep 2020","21 Jul 2020","26 Aug 2020","5 Sep 2020","23 Sep 2020","30 Aug 2020","19 Sep 2020","2 Oct 2020","4 Oct 2020","26 Sep 2020","4 Aug 2020","8 Oct 2020","7 Oct 2020","9 Jul 2020","1 Jul 2020","2 Jul 2020","8 Oct 2020","26 Sep 2020","30 Sep 2020","7 Jul 2020","27 Jul 2020","14 Jul 2020","1 Sep 2020","14 Aug 2020","28 Aug 2020","12 Jul 2020","12 Sep 2020","3 Sep 2020","29 Jul 2020","31 Jul 2020","10 Aug 2020","25 Jul 2020","11 Aug 2020","31 Aug 2020","6 Aug 2020","22 Aug 2020","4 Sep 2020","8 Aug 2020","17 Sep 2020","5 Jul 2020","5 Aug 2020","14 Sep 2020","12 Sep 2020","23 Sep 2020","5 Aug 2020","15 Sep 2020","6 Aug 2020","4 Sep 2020","2 Oct 2020","23 Sep 2020","15 Sep 2020","12 Sep 2020","12 Aug 2020","10 Jul 2020","27 Aug 2020","11 Sep 2020","14 Jul 2020","27 Sep 2020","16 Jul 2020","12 Jul 2020","19 Sep 2020","25 Jul 2020","4 Sep 2020","12 Sep 2020","9 Aug 2020","2 Sep 2020","19 Aug 2020","22 Sep 2020","17 Aug 2020","13 Aug 2020","23 Sep 2020","25 Jul 2020","23 Sep 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($TM_DateGroup,\"d\",DATEVALUE(&'b1b93131',\"d MMM yyyy\"),\"m\",DATEVALUE(&'b1b93131',\"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":"a97e6781"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["John Smith","Tim Warner","Anne Simmons","Anne Simmons","Anne Simmons","Tim Warner","Anne Simmons","John Smith","Tom Jones","Tim Warner","John Smith","Tim Warner","Anne Simmons","John Smith","Tim Warner","Anne Simmons","Tim Warner","Tim Warner","Tom Jones","Tom Jones","Tom Jones","Tim Warner","Anne Simmons","Anne Simmons","John Smith","Tim Warner","John Smith","John Smith","Tim Warner","Tim Warner","Tim Warner","Tom Jones","Anne Simmons","Tim Warner","John Smith","John Smith","John Smith","John Smith","Tom Jones","Tom Jones","John Smith","John Smith","John Smith","Tim Warner","Tim Warner","Tom Jones","Tim Warner","John Smith","Anne Simmons","John Smith","Anne Simmons","Anne Simmons","Tim Warner","Tim Warner","Tim Warner","Anne Simmons","John Smith","Tom Jones","Tom Jones","John Smith","Tim Warner","Tom Jones","Anne Simmons","Tom Jones","John Smith","John Smith","Tim Warner","Anne Simmons","John Smith","Tim Warner","Tim Warner","John Smith","Anne Simmons","John Smith","John Smith","John Smith","Tim Warner","Tom Jones","Tom Jones","John Smith","Tom Jones","Tim Warner","Tom Jones","John Smith","Tim Warner","Anne Simmons","Anne Simmons","Tom Jones","John Smith","John Smith","Anne Simmons","Tim Warner","Tim Warner","Anne Simmons","Anne Simmons","Tim Warner","Anne Simmons","Tim Warner","Tim Warner","John Smith"]],"displayName":"Employee","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Quotes,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Employee","id":"64f21c8b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["1595","4157","840","1687","3037","2146","1096","3339","1983","1908","394","4496","4659","4866","4625","1862","1154","2047","2452","1043","1503","2572","3984","3079","869","3355","1674","2029","476","476","2914","953","3465","580","4445","4623","2783","429","4158","1242","2804","790","3728","4211","3588","3184","4524","4466","4152","1749","4150","2490","2702","2087","977","4797","1167","914","4198","2068","1792","2492","2862","4885","3134","768","4152","2298","2817","3195","1234","2499","4599","662","539","1232","2784","3600","3134","2900","353","4599","1412","3711","4441","2306","3377","3029","1625","829","3651","1260","3677","1822","1667","1435","4505","1479","895","2235"]],"displayName":"Value","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Quotes,C:C;)","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":"b3750e18"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["warranty","installation","repair","repair","call back","repair","installation","call back","call back","call back","warranty","repair","call back","warranty","repair","call back","installation","repair","call back","warranty","warranty","repair","warranty","call back","repair","call back","call back","warranty","repair","repair","call back","call back","warranty","warranty","call back","warranty","call back","repair","warranty","repair","repair","installation","warranty","repair","installation","call back","warranty","warranty","call back","call back","repair","warranty","repair","call back","repair","repair","repair","warranty","repair","warranty","call back","warranty","warranty","call back","call back","repair","installation","warranty","repair","repair","warranty","warranty","installation","call back","installation","call back","warranty","repair","installation","call back","call back","warranty","call back","repair","call back","call back","installation","call back","warranty","repair","warranty","call back","installation","warranty","call back","call back","call back","repair","warranty","call back"]],"displayName":"Type","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Quotes,D:D;)","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":"7e982d71"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Lost","Won","Won","Won","Lost","Lost","Lost","Lost","Lost","Lost","Won","Lost","Lost","Won","Lost","Won","Lost","Lost","Lost","Lost","Won","Lost","Lost","Won","Won","Lost","Won","Won","Won","Lost","Lost","Lost","Lost","Won","Lost","Lost","Lost","Won","Won","Lost","Lost","Won","Lost","Lost","Won","Lost","Won","Lost","Lost","Won","Lost","Lost","Lost","Won","Lost","Lost","Lost","Lost","Won","Lost","Lost","Won","Lost","Lost","Won","Lost","Lost","Lost","Lost","Won","Lost","Won","Lost","Lost","Lost","Won","Lost","Lost","Lost","Won","Won","Lost","Won","Lost","Lost","Lost","Lost","Won","Won","Won","Lost","Won","Won","Won","Lost","Lost","Won","Won","Won","Lost"]],"displayName":"Status","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Quotes,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":"67e4cdca-76"}],"displayName":"Table Copy","id":"130ef671","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"64f21c8b"},{"var":"TM_Employee"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"64f21c8b","variation":"condition"}],"kid":"4b9ded487bcf6ce35225e46c342ff7a6","id":"dst130ef671"}}],"isForked":false,"id":"3093c0bd727b36a7e242166a64f2bd2b","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Jobs Worked by Type","usesSampleData":false,"master":"4b9ded487bcf6ce35225e46c342ff7a6"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","773a7b4b52bcff4e6d67acb50b26c8a6"],"dimensions":{"w":1329.0}},"components":[{"size":"xx-small","data":[["This displays how revenue is attributed throughout the business. Additionally, we can use this to keep track of spikes in Wages or Consumables that cut into the Net Profit of the business."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"This displays how revenue is attributed throughout the business. Additionally, we can use this to keep track of spikes in Wages or Consumables that cut into the Net Profit of the business.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"50ecb6a1","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst50ecb6a1"},"wrap":true},{"components":[{"data":[["Wages as a % of Total Revenue"]],"displayName":"Label 2","formulas":[{"txt":"\"Wages as a % of Total Revenue\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstaead4285"},"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":"aead4285","wrap":true},{"data":[["Consumables as a % of Total Revenue"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Consumables as a % of Total Revenue\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstc6fe8ede"},"align":"c","layoutConfig":{"x":3.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":"c6fe8ede","wrap":true},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"role":"current","size":"x-large","data":[["NaN"]],"displayName":"Current Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SUM(select(&'2cdefd64',AND(BETWEEN(&'51be7b3f',$TM_DateStart,$TM_DateEnd),&'2868bb57'=\"Wages\")))/SUM(select(&'2cdefd64',AND(BETWEEN(&'51be7b3f',$TM_DateStart,$TM_DateEnd),&'2868bb57'=\"Sales\")))","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"id":"737fca00-51","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"737fca0051"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst737fca0051","aggs":{"737fca0051":"sum"}}},{"role":"target","size":"medium","data":[[0.3]],"displayName":"Target 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":"LOOKUP(\"Wages as % of revenue\",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":"16a0c625-52","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"16a0c62552"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst16a0c62552","aggs":{"77cfe33a53":"sum","737fca0051":"sum","f464acdc54":"sum","16a0c62552":"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":"77cfe33a53"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst77cfe33a53","aggs":{"77cfe33a53":"sum","737fca0051":"sum","f464acdc54":"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":"77cfe33a-53"},{"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":"f464acdc54"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstf464acdc54","aggs":{"737fca0051":"sum","f464acdc54":"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":"f464acdc-54"},{"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":"d79b7665-74","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"d79b766574"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstd79b766574","aggs":{"d79b766574":"sum"}}},{"role":"end","data":[[0.15]],"displayName":"End 1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.15","ver":2.0}],"autoFmt":false,"id":"bdba3d15-75","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"bdba3d1575"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstbdba3d1575","aggs":{"bdba3d1575":"sum"}}}],"rangeId":1.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_yellow_3","displayName":"Range 1","formulas":[],"autoFmt":true,"id":"99ff8613-73","type":"range"},{"components":[{"role":"start","data":[[0.15]],"displayName":"Start 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.15","ver":2.0}],"autoFmt":false,"id":"94d19a54-77","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"94d19a5477"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst94d19a5477","aggs":{"94d19a5477":"sum"}}},{"role":"end","data":[[0.35]],"displayName":"End 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.35","ver":2.0}],"autoFmt":false,"id":"98c7232e-78","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"98c7232e78"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst98c7232e78","aggs":{"98c7232e78":"sum"}}}],"rangeId":2.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_green_3","displayName":"Range 2","formulas":[],"autoFmt":true,"id":"74541a5a-76","type":"range"},{"components":[{"role":"start","data":[[0.35]],"displayName":"Start 3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.35","ver":2.0}],"autoFmt":false,"id":"59ac8c71-80","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"59ac8c7180"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst59ac8c7180","aggs":{"59ac8c7180":"sum"}}},{"role":"end","data":[[0.45]],"displayName":"End 3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.45","ver":2.0}],"autoFmt":false,"id":"a34315b0-81","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"a34315b081"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dsta34315b081","aggs":{"a34315b081":"sum"}}}],"rangeId":3.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_yellow_3","displayName":"Range 3","formulas":[],"autoFmt":true,"id":"47b81bad-79","type":"range"},{"components":[{"role":"start","data":[[0.45]],"displayName":"Start 4","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.45","ver":2.0}],"autoFmt":false,"id":"08cb4591-83","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"08cb459183"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst08cb459183","aggs":{"08cb459183":"sum"}}},{"role":"end","data":[[1.0]],"displayName":"End 4","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":"50d0ee98-84","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"50d0ee9884"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst50d0ee9884","aggs":{"50d0ee9884":"sum"}}}],"rangeId":4.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_red_3","displayName":"Range 4","formulas":[],"autoFmt":true,"id":"ed5e15d4-82","type":"range"},{"components":[{"role":"start","data":[[0.0]],"displayName":"Start 5","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":"c15a4a69-86","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"c15a4a6986"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstc15a4a6986","aggs":{"c15a4a6986":"sum"}}},{"role":"end","data":[[0.05]],"displayName":"End 5","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.05","ver":2.0}],"autoFmt":false,"id":"3544dc83-87","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"3544dc8387"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst3544dc8387","aggs":{"3544dc8387":"sum"}}}],"rangeId":5.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_red_3","displayName":"Range 5","formulas":[],"autoFmt":true,"id":"215c7b13-85","type":"range"}],"size":"2","displayName":"Gauge","id":"5efcb8f3-50","type":"gauge","dstContext":{"id":"dst5efcb8f350"},"gaugeStyle":"hg"},{"layoutConfig":{"x":3.0,"y":1.0},"components":[{"role":"current","size":"x-large","data":[["NaN"]],"displayName":"Current Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true}},"formulas":[{"txt":"SUM(select(&'2cdefd64',AND(BETWEEN(&'51be7b3f',$TM_DateStart,$TM_DateEnd),&'2868bb57'=\"Cost of Sales\")))/SUM(select(&'2cdefd64',AND(BETWEEN(&'51be7b3f',$TM_DateStart,$TM_DateEnd),&'2868bb57'=\"Sales\")))","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"id":"a4e2d322","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"a4e2d322"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dsta4e2d322","aggs":{"a4e2d322":"sum"}}},{"role":"target","size":"medium","data":[[0.3]],"displayName":"Target 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":"LOOKUP(\"Consumables as % of revenue\",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":"98659333","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"98659333"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst98659333","aggs":{"a4e2d322":"sum","94bee7da":"sum","98659333":"sum","6b6dbf00":"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":"94bee7da"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst94bee7da","aggs":{"a4e2d322":"sum","94bee7da":"sum","6b6dbf00":"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":"94bee7da"},{"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":"6b6dbf00"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst6b6dbf00","aggs":{"a4e2d322":"sum","6b6dbf00":"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":"6b6dbf00"},{"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":"28a0bd10","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"28a0bd10"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst28a0bd10","aggs":{"28a0bd10":"sum"}}},{"role":"end","data":[[0.15]],"displayName":"End 1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.15","ver":2.0}],"autoFmt":false,"id":"5af162af","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"5af162af"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst5af162af","aggs":{"5af162af":"sum"}}}],"rangeId":1.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_yellow_3","displayName":"Range 1","formulas":[],"autoFmt":true,"id":"e1fafced","type":"range"},{"components":[{"role":"start","data":[[0.15]],"displayName":"Start 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.15","ver":2.0}],"autoFmt":false,"id":"587bab3e","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"587bab3e"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst587bab3e","aggs":{"587bab3e":"sum"}}},{"role":"end","data":[[0.35]],"displayName":"End 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.35","ver":2.0}],"autoFmt":false,"id":"914df8b6","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"914df8b6"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst914df8b6","aggs":{"914df8b6":"sum"}}}],"rangeId":2.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_green_3","displayName":"Range 2","formulas":[],"autoFmt":true,"id":"55755827","type":"range"},{"components":[{"role":"start","data":[[0.35]],"displayName":"Start 3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.35","ver":2.0}],"autoFmt":false,"id":"289c6bbd","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"289c6bbd"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst289c6bbd","aggs":{"289c6bbd":"sum"}}},{"role":"end","data":[[0.45]],"displayName":"End 3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.45","ver":2.0}],"autoFmt":false,"id":"43f4cf8e","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"43f4cf8e"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst43f4cf8e","aggs":{"43f4cf8e":"sum"}}}],"rangeId":3.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_yellow_3","displayName":"Range 3","formulas":[],"autoFmt":true,"id":"2f0046bd","type":"range"},{"components":[{"role":"start","data":[[0.45]],"displayName":"Start 4","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.45","ver":2.0}],"autoFmt":false,"id":"5e481ba9","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"5e481ba9"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst5e481ba9","aggs":{"5e481ba9":"sum"}}},{"role":"end","data":[[1.0]],"displayName":"End 4","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":"d480f8e5","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"d480f8e5"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstd480f8e5","aggs":{"d480f8e5":"sum"}}}],"rangeId":4.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_red_3","displayName":"Range 4","formulas":[],"autoFmt":true,"id":"65c7b067","type":"range"},{"components":[{"role":"start","data":[[0.0]],"displayName":"Start 5","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":"caff629a","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"caff629a"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstcaff629a","aggs":{"caff629a":"sum"}}},{"role":"end","data":[[0.05]],"displayName":"End 5","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.05","ver":2.0}],"autoFmt":false,"id":"cf29cee4","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"cf29cee4"}],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstcf29cee4","aggs":{"cf29cee4":"sum"}}}],"rangeId":5.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_red_3","displayName":"Range 5","formulas":[],"autoFmt":true,"id":"78acd4b9","type":"range"}],"size":"2","displayName":"Gauge Copy 2","id":"4f104a3c","type":"gauge","dstContext":{"id":"dst4f104a3c"},"gaugeStyle":"hg"}],"displayName":"Layout Grid","widths":[{"w":"10%","x":4.0},{"w":"10%","x":2.0},{"w":"10%","x":0.0}],"id":"33bff8bd-49","cellData":[{"x":4.0,"y":1.0},{"x":2.0,"y":0.0},{"x":0.0,"y":1.0}],"type":"panel_grid","rows":2.0,"cols":5.0},{"components":[{"showValues":true,"role":"series","data":[[11466.0]],"color":"cx-theme_green_4","displayName":"Net Profit","seriesName":"Net Profit","formulas":[{"txt":"lookup(&'5078bab0-90',group(SELECT(&'f1882253',&'2868bb57'=\"Sales\")),groupby(SELECT(&'f1882253',&'2868bb57'=\"Sales\"),SELECT(&'2cdefd64',&'2868bb57'=\"Sales\")))-&'3d405c59-92'-&'84f4aa48-93'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"1dd5f9e9-91","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":"0baca0eb-89"},{"showValues":true,"role":"series","data":[[26497.0]],"color":"cx-theme_violet_3","displayName":"Wages","seriesName":"Wages","formulas":[{"txt":"lookup(&'5078bab0-90',group(SELECT(&'f1882253',&'2868bb57'=\"Wages\")),groupby(SELECT(&'f1882253',&'2868bb57'=\"Sales\"),SELECT(&'2cdefd64',&'2868bb57'=\"Wages\")))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"1dd5f9e9-91","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":"3d405c59-92"},{"showValues":true,"role":"series","data":[[38732.0]],"color":"cx-theme_orange_4","displayName":"Consumables","seriesName":"Consumables","formulas":[{"txt":"lookup(&'5078bab0-90',group(SELECT(&'f1882253',&'2868bb57'=\"Cost of Sales\")),groupby(SELECT(&'f1882253',&'2868bb57'=\"Sales\"),SELECT(&'2cdefd64',&'2868bb57'=\"Cost of Sales\")))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"1dd5f9e9-91","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":"84f4aa48-93"},{"role":"axis_x","data":[["Nov 2020"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($TM_DateStart,$TM_DateEnd),\"3\")),\"MMM yyyy\")","ver":2.0}],"autoFmt":true,"id":"5078bab0-90","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"cur","grid":true,"fmtArgs":{},"id":"1dd5f9e9-91","labelDrop":0.0}],"displayName":"Bar/Line Chart","id":"9de58c87-88","type":"chart_series","dstContext":{"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dst9de58c8788"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6171956E9,1.6171956E9,1.6171956E9,1.6145172E9,1.6145172E9,1.6145172E9,1.612098E9,1.612098E9,1.612098E9,1.6094196E9,1.6094196E9,1.6094196E9,1.6067412E9,1.6067412E9,1.6067412E9,1.6041492E9,1.6041492E9,1.6041492E9,1.6014744E9,1.6014744E9,1.6014744E9,1.5988824E9,1.5988824E9,1.5988824E9,1.596204E9,1.596204E9,1.596204E9,1.5935256E9,1.5935256E9,1.5935256E9,1.5909336E9,1.5909336E9,1.5909336E9,1.5882552E9,1.5882552E9,1.5882552E9,1.5856596E9,1.5856596E9,1.5856596E9,1.5829812E9,1.5829812E9,1.5829812E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(e81016948df440cd06e1fcdc846f01b9@Xero,C:C;,\"d/MMM/yyyy\"))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"51be7b3f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Apr 2021","Apr 2021","Apr 2021","Mar 2021","Mar 2021","Mar 2021","Feb 2021","Feb 2021","Feb 2021","Jan 2021","Jan 2021","Jan 2021","Dec 2020","Dec 2020","Dec 2020","Nov 2020","Nov 2020","Nov 2020","Oct 2020","Oct 2020","Oct 2020","Sep 2020","Sep 2020","Sep 2020","Aug 2020","Aug 2020","Aug 2020","Jul 2020","Jul 2020","Jul 2020","Jun 2020","Jun 2020","Jun 2020","May 2020","May 2020","May 2020","Apr 2020","Apr 2020","Apr 2020","Mar 2020","Mar 2020","Mar 2020"]],"displayName":"Date","formulas":[{"txt":"DATEVALUE(&'51be7b3f',\"MMM yyyy\")","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date","id":"f1882253"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense","Income","Less Cost of Sales","Expense"]],"displayName":"Type","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Xero,A:A;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Type","id":"25da819e"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages","Sales","Cost of Sales","Wages"]],"displayName":"Account","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Xero,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Account","id":"2868bb57"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["70596","21791","18743","71165","23160","23477","61239","19319","16088","70889","24007","28402","61650","20448","26492","76695","38732","26497","65187","25332","29467","65028","38596","25462","75654","31297","20143","72004","28512","23871","74991","25797","25944","66508","26772","17504","60074","39140","23417","76036","33377","19856"]],"displayName":"Value","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Xero,D:D;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Value","id":"2cdefd64"}],"displayName":"Table","id":"ae49cf60","type":"table","dstContext":{"ops":[],"kid":"9ef4ce8b7d43fcebfbf9bd43492dffb1","id":"dstae49cf60"}}],"isForked":false,"id":"043c7ba45a28fcf5f68b72805578ef66","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Expenses Tracking","usesSampleData":false,"master":"9ef4ce8b7d43fcebfbf9bd43492dffb1"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","773a7b4b52bcff4e6d67acb50b26c8a6"],"dimensions":{"w":1149.0}},"components":[{"size":"xx-small","data":[["The number and value of jobs worked. This allows us to keep track of how busy each of the employees are."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"The number and value of jobs worked. This allows us to keep track of how busy each of the employees are.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"0590cdc7-41","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dst0590cdc741"},"wrap":true},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","size":"small","data":[["Total Number of Jobs Worked"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Total Number of Jobs Worked\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"ff496d7e-44","type":"label","fmt":"txt","dstContext":{"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dstff496d7e44"},"align":"c"},{"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"}},"formulas":[{"txt":"COUNT(SELECT(&'dd6bfcd7-8',BETWEEN(&'311797b2-2',$TM_DateStart,$TM_DateEnd)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"93829991-45","type":"label","fmt":"num","dstContext":{"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dst9382999145"},"align":"c"}],"displayName":"Value Pair","id":"9389f2c9-43","type":"simple_value","dstContext":{"id":"dst9389f2c943"}},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"primary","size":"small","data":[["Total Value of Jobs Worked"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Total Value of Jobs Worked\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"75e9a063","type":"label","fmt":"txt","dstContext":{"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dst75e9a063"},"align":"c"},{"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"}},"precision":"0"},"formulas":[{"txt":"SUM(SELECT(&'4c4f076f-11',BETWEEN(&'311797b2-2',$TM_DateStart,$TM_DateEnd)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"dfdb745a","type":"label","fmt":"cur","dstContext":{"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dstdfdb745a"},"align":"c"}],"displayName":"Value Pair Copy","id":"3571e3a6","type":"simple_value","dstContext":{"id":"dst3571e3a6"}},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"primary","size":"small","data":[["Average Revenue per Job"]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Average Revenue per Job\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"caf8baab","type":"label","fmt":"txt","dstContext":{"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dstcaf8baab"},"align":"c"},{"role":"secondary","size":"large","data":[["NaN"]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"precision":"0"},"formulas":[{"txt":"SUM(SELECT(&'4c4f076f-11',BETWEEN(&'311797b2-2',$TM_DateStart,$TM_DateEnd)))/COUNT(SELECT(&'dd6bfcd7-8',BETWEEN(&'311797b2-2',$TM_DateStart,$TM_DateEnd)))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"cacc15a7","type":"label","fmt":"cur","dstContext":{"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dstcacc15a7"},"align":"c"}],"displayName":"Value Pair Copy 2","id":"8829bd95","type":"simple_value","dstContext":{"id":"dst8829bd95"}}],"displayName":"Layout Grid","id":"582a1279-41","cellData":[{"x":0.0,"y":0.0,"cellPadding":[5.0,5.0,5.0,5.0]},{"x":1.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":3.0},{"layoutConfig":{"x":0.0,"y":1.0},"displayName":"Separator","id":"b1c657e8-48","type":"separator"},{"components":[{"showValues":true,"role":"series","data":[["","",""]],"color":"cx-theme_green_4","displayName":"Jobs Worked","seriesName":"Jobs Worked","formulas":[{"txt":"lookup(&'a23c4b96-16',group(&'7dc838dc-5'),groupby(&'7dc838dc-5',&'dd6bfcd7-8',\"count(values)\"))","ver":2.0}],"autoFmt":true,"leaveGaps":true,"type":"series_data","fmt":"txt","axis":"3ba76d23-23","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"f858949a-15"},{"renderer":"line","showValues":true,"role":"series","data":[["","",""]],"color":"cx-theme_green_3","displayName":"Job Value","seriesName":"Job Value","formulas":[{"txt":"lookup(&'a23c4b96-16',group(&'7dc838dc-5'),groupby(&'7dc838dc-5',&'4c4f076f-11',\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"0d4d578b-17","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"precision":"0"},"id":"f42d4946-22","renamed":true},{"renderer":"line","role":"series","data":[[0.0,0.0,0.0]],"displayName":"Target (# Jobs Worked)","seriesName":"Target (# Jobs Worked)","formulas":[{"txt":"REPEAT(SUM(&'09bdfaed-45')/SWITCH($TM_DateGroup,\"d\",30,\"m\",1),COUNT(!'a23c4b96-16'))","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"3ba76d23-23","lineDashes":"Dash","lineWeight":"3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"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"},"id":"1a494d15-60"},{"role":"axis_x","data":[["22 Nov 2020","23 Nov 2020","24 Nov 2020"]],"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($TM_DateGroup,\"d\",DATEVALUE(DATERANGE($TM_DateStart,$TM_DateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($TM_DateStart,$TM_DateEnd),\"3\")),\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"id":"a23c4b96-16","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":"0d4d578b-17","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Count","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Untitled","type":"chart_axis","fmt":"txt","fmtArgs":{},"id":"3ba76d23-23","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","id":"f8373219-14","type":"chart_series","dstContext":{"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dstf837321914"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Anne Simmons","Jessica Walker","John Smith","Tim Warner","Tom Jones"]],"displayName":"Target_User","formulas":[{"txt":"group(slice(e81016948df440cd06e1fcdc846f01b9@Sales,M:M;))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Target_User","id":"b3b22274-42"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["","","","",""]],"displayName":"Sales_Target","formulas":[{"txt":"repeat(lookup(\"Sales by Team member\",773a7b4b52bcff4e6d67acb50b26c8a6@Tradies,D:D;,773a7b4b52bcff4e6d67acb50b26c8a6@Tradies,H:H;),count(&'b3b22274-42'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Sales_Target","id":"09bdfaed-45"}],"displayName":"Table 2","id":"56a4b2e9-41","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"b3b2227442"},{"var":"TM_Employee"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"b3b2227442","variation":"condition"}],"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dst56a4b2e941"}},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6328376E9,1.6284312E9,1.6451028E9,1.6463988E9,1.6495128E9,1.6444116E9,1.6555608E9,1.6442388E9,1.6282584E9,1.6450164E9,1.628172E9,1.6513272E9,1.6298136E9,1.6263576E9,1.6495992E9,1.6431156E9,1.6421652E9,1.6539192E9,1.6543512E9,1.6495992E9,1.6572888E9,1.6407828E9,1.6399188E9,1.6474356E9,1.6456212E9,1.6438932E9,1.6279128E9,1.6567704E9,1.6267896E9,1.6433748E9,1.6512408E9,1.6276536E9,1.6481268E9,1.6310232E9,1.6338708E9,1.6334388E9,1.6438932E9,1.649772E9,1.645362E9,1.6494264E9,1.6292952E9,1.6525368E9,1.6351668E9,1.6349076E9,1.6321464E9,1.6305048E9,1.6494264E9,1.6522776E9,1.6433748E9,1.6482996E9,1.635858E9,1.6520184E9,1.6531416E9,1.630764E9,1.6374996E9,1.6525368E9,1.632492E9,1.637154E9,1.6438932E9,1.6481268E9,1.6274808E9,1.6430292E9,1.63845E9,1.6476084E9,1.628604E9,1.628172E9,1.6569432E9,1.6420788E9,1.6450164E9,1.6540056E9,1.6335252E9,1.6451892E9,1.6426836E9,1.6263576E9,1.650204E9,1.6324056E9,1.6308504E9,1.6306776E9,1.6398324E9,1.6461396E9,1.6527096E9,1.6283448E9,1.6494264E9,1.6392276E9,1.633698E9,1.6283448E9,1.6528824E9,1.6425108E9,1.6362036E9,1.639314E9,1.6305912E9,1.642338E9,1.6459668E9,1.6456212E9,1.6383636E9,1.6325784E9,1.632924E9,1.6517592E9,1.6288632E9,1.6454484E9]],"displayName":"Date_Raw","formulas":[{"txt":"DATE_ADD(slice(date(e81016948df440cd06e1fcdc846f01b9@Sales,A:A;,\"yyyy/MM/dd\")),\"5\",2)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Date_Raw","id":"311797b2-2"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["29 Sep 2021","9 Aug 2021","18 Feb 2022","5 Mar 2022","10 Apr 2022","10 Feb 2022","19 Jun 2022","8 Feb 2022","7 Aug 2021","17 Feb 2022","6 Aug 2021","1 May 2022","25 Aug 2021","16 Jul 2021","11 Apr 2022","26 Jan 2022","15 Jan 2022","31 May 2022","5 Jun 2022","11 Apr 2022","9 Jul 2022","30 Dec 2021","20 Dec 2021","17 Mar 2022","24 Feb 2022","4 Feb 2022","3 Aug 2021","3 Jul 2022","21 Jul 2021","29 Jan 2022","30 Apr 2022","31 Jul 2021","25 Mar 2022","8 Sep 2021","11 Oct 2021","6 Oct 2021","4 Feb 2022","13 Apr 2022","21 Feb 2022","9 Apr 2022","19 Aug 2021","15 May 2022","26 Oct 2021","23 Oct 2021","21 Sep 2021","2 Sep 2021","9 Apr 2022","12 May 2022","29 Jan 2022","27 Mar 2022","3 Nov 2021","9 May 2022","22 May 2022","5 Sep 2021","22 Nov 2021","15 May 2022","25 Sep 2021","18 Nov 2021","4 Feb 2022","25 Mar 2022","29 Jul 2021","25 Jan 2022","3 Dec 2021","19 Mar 2022","11 Aug 2021","6 Aug 2021","5 Jul 2022","14 Jan 2022","17 Feb 2022","1 Jun 2022","7 Oct 2021","19 Feb 2022","21 Jan 2022","16 Jul 2021","18 Apr 2022","24 Sep 2021","6 Sep 2021","4 Sep 2021","19 Dec 2021","2 Mar 2022","17 May 2022","8 Aug 2021","9 Apr 2022","12 Dec 2021","9 Oct 2021","8 Aug 2021","19 May 2022","19 Jan 2022","7 Nov 2021","13 Dec 2021","3 Sep 2021","17 Jan 2022","28 Feb 2022","24 Feb 2022","2 Dec 2021","26 Sep 2021","30 Sep 2021","6 May 2022","14 Aug 2021","22 Feb 2022"]],"displayName":"Date","formulas":[{"txt":"SWITCH($TM_DateGroup,\"d\",DATEVALUE(&'311797b2-2',\"d MMM yyyy\"),\"m\",DATEVALUE(&'311797b2-2',\"MMM yyyy\"))","ver":2.0}],"autoFmt":false,"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":{"dateInputFormatCustom":"d MMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"dateInputFormatCustom":"d MMMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMMM yyyy","dateInputFormat":"custom"},"name":"Date","id":"7dc838dc-5"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Tim Warner","Anne Simmons","Tim Warner","Anne Simmons","Tim Warner","Tim Warner","John Smith","John Smith","Jessica Walker","Anne Simmons","John Smith","Jessica Walker","Anne Simmons","Jessica Walker","Anne Simmons","Tom Jones","Anne Simmons","John Smith","John Smith","Jessica Walker","Anne Simmons","John Smith","Tim Warner","John Smith","Anne Simmons","Anne Simmons","Tom Jones","Tom Jones","Anne Simmons","Tom Jones","Tom Jones","John Smith","Jessica Walker","Jessica Walker","Anne Simmons","Anne Simmons","Jessica Walker","John Smith","Tim Warner","John Smith","Jessica Walker","Tim Warner","Jessica Walker","Tim Warner","Anne Simmons","John Smith","Tom Jones","John Smith","Jessica Walker","Anne Simmons","Tom Jones","Anne Simmons","Tom Jones","Tom Jones","Anne Simmons","John Smith","Anne Simmons","Anne Simmons","Jessica Walker","Tim Warner","John Smith","Anne Simmons","Anne Simmons","Tom Jones","Anne Simmons","Tim Warner","Tim Warner","Tom Jones","Tim Warner","Tim Warner","Tim Warner","John Smith","Jessica Walker","Anne Simmons","Jessica Walker","Anne Simmons","John Smith","John Smith","Tom Jones","Tim Warner","John Smith","Jessica Walker","Tom Jones","John Smith","Jessica Walker","Anne Simmons","Anne Simmons","Anne Simmons","Jessica Walker","Anne Simmons","Jessica Walker","Tom Jones","Jessica Walker","John Smith","Tim Warner","Tim Warner","Anne Simmons","Tom Jones","Tom Jones","Jessica Walker"]],"displayName":"Employee","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Employee","id":"dd6bfcd7-8"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["158","160","759","272","972","376","90","205","933","961","597","657","701","304","509","636","120","202","439","945","725","709","742","827","769","399","59","589","399","127","579","874","346","959","820","584","641","87","337","123","686","193","405","396","937","81","317","371","888","311","498","747","797","448","741","395","61","125","639","854","347","867","244","947","907","374","212","818","674","491","738","615","629","204","358","130","1000","225","83","251","587","702","649","631","434","346","824","654","721","182","864","602","892","174","738","263","193","445","328","204"]],"displayName":"Value","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Value","id":"4c4f076f-11"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Warranty","Repair","Warranty","Warranty","Installation","Call Back","Repair","Repair","Warranty","Warranty","Installation","Installation","Warranty","Repair","Installation","Repair","Installation","Call Back","Warranty","Installation","Warranty","Repair","Call Back","Warranty","Warranty","Installation","Warranty","Installation","Call Back","Repair","Repair","Repair","Warranty","Repair","Repair","Warranty","Installation","Repair","Installation","Repair","Call Back","Installation","Installation","Repair","Repair","Call Back","Call Back","Repair","Warranty","Installation","Repair","Installation","Call Back","Call Back","Installation","Installation","Call Back","Installation","Call Back","Installation","Call Back","Repair","Call Back","Call Back","Repair","Warranty","Call Back","Call Back","Call Back","Call Back","Installation","Installation","Installation","Repair","Warranty","Repair","Call Back","Installation","Call Back","Installation","Repair","Installation","Installation","Call Back","Repair","Warranty","Repair","Installation","Repair","Repair","Warranty","Installation","Repair","Installation","Repair","Repair","Warranty","Repair","Repair","Call Back"]],"displayName":"Type","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,D:D;)","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"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Type","id":"b0100d5b-17"}],"displayName":"Table","id":"0f0e9ffd-1","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"dd6bfcd78"},{"var":"TM_Employee"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"dd6bfcd78","variation":"condition"}],"kid":"a3ae4589bae60324b9d1484e3bdfaf78","id":"dst0f0e9ffd1"}}],"isForked":false,"id":"35a4c54138e48391b58df866a41ac5c3","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Jobs Worked","usesSampleData":false,"master":"a3ae4589bae60324b9d1484e3bdfaf78"},{"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":"487917f6-5","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"041d8c2733cb4e381a34c31ef10975bf","id":"dst487917f65"},"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":"041d8c2733cb4e381a34c31ef10975bf","id":"dstb6356c4e2"},"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":"b6356c4e-2","wrap":true},{"layoutConfig":{"x":6.0,"y":0.0},"orientation":"v","displayName":"Separator","id":"0d3e67cd-4","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst75b9af21"},"align":"c","layoutConfig":{"x":7.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":"75b9af21","wrap":true},{"layoutConfig":{"x":10.0,"y":0.0},"orientation":"v","displayName":"Separator Copy","id":"d9d36227","type":"separator"},{"data":[["Time Management Tools"]],"displayName":"Label Copy 2","formulas":[{"txt":"\"Time Management 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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst6599b472"},"align":"c","layoutConfig":{"x":11.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":"6599b472","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst58ca5a723"},"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":"58ca5a72-3","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst57eb4ba3"},"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":"57eb4ba3","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst2e30b5a1"},"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":"2e30b5a1","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst14fb1f08"},"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":"14fb1f08","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dstf5118f38"},"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":"f5118f38","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst35978c0c"},"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":"35978c0c","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dstd7717db2"},"layoutConfig":{"x":7.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":"d7717db2","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dstdcfc3eb7"},"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":"dcfc3eb7","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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst0e70dc5c"},"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":"0e70dc5c","resizeHeight":"100"},{"data":[["https://www.getharvest.com/assets/press/harvest-logo-icon-aea5eea5a1905ec4fe999116981098fb63ef9bfd95bccc3cba442d531864819f.png"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 8","formulas":[{"txt":"\"https://www.getharvest.com/assets/press/harvest-logo-icon-aea5eea5a1905ec4fe999116981098fb63ef9bfd95bccc3cba442d531864819f.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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst66fd402f"},"layoutConfig":{"x":11.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":"66fd402f","resizeHeight":"100"},{"data":[["https://everhour.com/assets/images/everhour_mark_on_white@2x.png"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 9","formulas":[{"txt":"\"https://everhour.com/assets/images/everhour_mark_on_white@2x.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":"041d8c2733cb4e381a34c31ef10975bf","id":"dstdc319bc5"},"layoutConfig":{"x":12.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":"dc319bc5","resizeHeight":"100"},{"data":[["https://businesstechninjas.com/wp-content/uploads/2018/05/Toggl-201x201.png"]],"resizeWidth":"100","horizAlign":1.0,"displayName":"Image Copy 10","formulas":[{"txt":"\"https://businesstechninjas.com/wp-content/uploads/2018/05/Toggl-201x201.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":"041d8c2733cb4e381a34c31ef10975bf","id":"dst372ebf05"},"layoutConfig":{"x":13.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":"372ebf05","resizeHeight":"100"}],"displayName":"Layout Grid","widths":[{"w":50.0,"x":6.0},{"w":50.0,"x":10.0}],"id":"958ecbe1-1","cellData":[{"w":6.0,"x":0.0,"y":0.0},{"x":6.0,"h":2.0,"y":0.0},{"w":3.0,"x":7.0,"y":0.0},{"w":3.0,"x":11.0,"y":0.0},{"x":10.0,"h":2.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":14.0}],"isForked":false,"id":"be0005b6b0a914ef74eadcddd1f02388","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Datasource Options","usesSampleData":false,"master":"041d8c2733cb4e381a34c31ef10975bf"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9"],"dimensions":{"w":869.0}},"components":[{"size":"xx-small","data":[["Filter all data on the dashboard based on employee and date"]],"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":"\"Filter all data on the dashboard based on employee and date\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"693f4dd1-4","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"8761ec0e4231264443a6069ccb5aa381","id":"dst693f4dd14"},"wrap":true},{"components":[{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"values","data":[["Anne Simmons","Jessica Walker","John Smith","Tim Warner","Tom Jones"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"group(slice(e81016948df440cd06e1fcdc846f01b9@Sales,B:B;))","ver":2.0}],"autoFmt":false,"id":"2a6529f2-7","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"4070ec9d-8","type":"proxy"}],"displayName":"User Input Control","scope":2.0,"inputLabel":"Employee","inputType":1.0,"id":"be9c8c5e-6","includeAllData":true,"type":"input","dstContext":{"kid":"8761ec0e4231264443a6069ccb5aa381","id":"dstbe9c8c5e6"},"propName":"TM_Employee"},{"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":"5e157b4b-10","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"966f0d1a-11","type":"proxy"}],"displayName":"User Input Control 2","scope":2.0,"inputLabel":"Date Range","inputType":1.0,"id":"16e7bc49-9","type":"input","dstContext":{"kid":"8761ec0e4231264443a6069ccb5aa381","id":"dst16e7bc499"},"propName":"TM_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($TM_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":"7dee5a5b-2","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"0955fa9e-3","type":"proxy"}],"displayName":"User Input Control 5","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"b9501b8a-1","type":"input","dstContext":{"kid":"8761ec0e4231264443a6069ccb5aa381","id":"dstb9501b8a1"},"propName":"TM_DateGroup"},{"layoutConfig":{"x":1.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1601733600"]],"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($TM_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":"5ad7a0fe-2","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"23c802dc-3","type":"proxy"}],"displayName":"User Input Control 3","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"ce70b2ef-1","type":"input","dstContext":{"kid":"8761ec0e4231264443a6069ccb5aa381","id":"dstce70b2ef1"},"propName":"TM_DateStart"},{"layoutConfig":{"x":2.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[["1602075600"]],"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($TM_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":"843bfea5-5","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"88b6b416-6","type":"proxy"}],"displayName":"User Input Control 4","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"36818ef2-4","type":"input","dstContext":{"kid":"8761ec0e4231264443a6069ccb5aa381","id":"dst36818ef24"},"propName":"TM_DateEnd"}],"displayName":"Layout Grid","id":"052314ee-5","type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"66e1ebaac6b99eaf96a42767cb31f722","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Filters","usesSampleData":false,"master":"8761ec0e4231264443a6069ccb5aa381"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","773a7b4b52bcff4e6d67acb50b26c8a6"],"dimensions":{"w":1055.0}},"components":[{"size":"xx-small","data":[["The number of quotes submitted and the percentage of quotes that are won. This alows us to keep track of how effective our quoting process is and how much of the quoted 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 quotes submitted and the percentage of quotes that are won. This alows us to keep track of how effective our quoting process is and how much of the quoted work we are losing.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"c39b50b1","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dstc39b50b1"},"wrap":true},{"components":[{"data":[["Overall Quote Win Rate"]],"displayName":"Label 2","formulas":[{"txt":"\"Overall Quote Win Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dste1d034fe55"},"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":"e1d034fe-55","wrap":true},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"showValues":true,"role":"series","data":[["","",""]],"color":"cx-theme_blue_4","displayName":"Quotes Submitted","seriesName":"Quotes Submitted","formulas":[{"txt":"lookup(&'aea8215e',group(&'c28412a2'),groupby(&'c28412a2',&'5cbb1386',\"count(values)\"))","ver":2.0}],"autoFmt":true,"leaveGaps":true,"type":"series_data","fmt":"txt","axis":"74b2c114","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"0ec9d688"},{"renderer":"line","showValues":true,"role":"series","data":[["NaN","NaN","NaN"]],"color":"cx-theme_blue_2","displayName":"% Won","seriesName":"% of Quotes Won","formulas":[{"txt":"lookup(&'aea8215e',group(SELECT(&'c28412a2',&'e6611552-64'=\"Won\")),groupby(SELECT(&'c28412a2',&'e6611552-64'=\"Won\"),SELECT(&'5cbb1386',&'e6611552-64'=\"Won\"),\"count(values)\"))/&'0ec9d688'*100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"482111b0","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":"ad71425a","renamed":true},{"renderer":"line","role":"series","data":[[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(!'aea8215e'))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"482111b0","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":"757a60e4-49"},{"role":"axis_x","data":[["22 Nov 2020","23 Nov 2020","24 Nov 2020"]],"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($TM_DateGroup,\"d\",DATEVALUE(DATERANGE($TM_DateStart,$TM_DateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($TM_DateStart,$TM_DateEnd),\"3\")),\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"id":"aea8215e","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":"482111b0","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Count","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Untitled","type":"chart_axis","fmt":"txt","fmtArgs":{},"id":"74b2c114","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","id":"75d84d69","type":"chart_series","dstContext":{"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dst75d84d69"}},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"current","size":"x-large","data":[["NaN"]],"displayName":"Current Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"precision":"0"},"formulas":[{"txt":"COUNT(select(&'5cbb1386',AND(BETWEEN(&'cee6cd23',$TM_DateStart,$TM_DateEnd),&'e6611552-64'=\"Won\")))/COUNT(select(&'5cbb1386',BETWEEN(&'cee6cd23',$TM_DateStart,$TM_DateEnd)))","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"id":"84c12171-51","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"84c1217151"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dst84c1217151","aggs":{"1a99c2d952":"sum","84c1217151":"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":"1a99c2d9-52","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"1a99c2d952"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dst1a99c2d952","aggs":{"1a99c2d952":"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":"c3f836f953"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dstc3f836f953","aggs":{"1a99c2d952":"sum","84c1217151":"sum","c3f836f953":"sum","a860936854":"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":"c3f836f9-53"},{"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":"a860936854"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dsta860936854","aggs":{"1a99c2d952":"sum","84c1217151":"sum","a860936854":"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":"a8609368-54"},{"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":"77cb8d66-57","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"77cb8d6657"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dst77cb8d6657","aggs":{"77cb8d6657":"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":"ece58c8d-58","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"ece58c8d58"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dstece58c8d58","aggs":{"ece58c8d58":"sum"}}}],"rangeId":1.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_red_3","displayName":"Range 1","formulas":[],"autoFmt":true,"id":"0bfe02db-56","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":"32be7a2c-60","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"32be7a2c60"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dst32be7a2c60","aggs":{"32be7a2c60":"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":"bb97e009-61","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"bb97e00961"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dstbb97e00961","aggs":{"bb97e00961":"sum"}}}],"rangeId":2.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_yellow_3","displayName":"Range 2","formulas":[],"autoFmt":true,"id":"e2257dec-59","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":"991c2cb3-63","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"991c2cb363"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dst991c2cb363","aggs":{"991c2cb363":"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":"361cfdb4-64","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"361cfdb464"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dst361cfdb464","aggs":{"361cfdb464":"sum"}}}],"rangeId":3.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_green_3","displayName":"Range 3","formulas":[],"autoFmt":true,"id":"7eaf3b3d-62","type":"range"}],"size":2.0,"displayName":"Gauge","id":"2cc81689-50","type":"gauge","dstContext":{"id":"dst2cc8168950"},"gaugeStyle":"ag"}],"displayName":"Layout Grid","id":"cf387705-49","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.6467444E9,1.6514136E9,1.6560792E9,1.6419924E9,1.6411284E9,1.64277E9,1.649772E9,1.6296408E9,1.6319736E9,1.6425108E9,1.64493E9,1.6444116E9,1.6504632E9,1.641906E9,1.6328376E9,1.6438068E9,1.6339572E9,1.6442388E9,1.6537464E9,1.630332E9,1.6520184E9,1.6394004E9,1.6389684E9,1.6315416E9,1.6282584E9,1.6370676E9,1.652364E9,1.6340436E9,1.6402644E9,1.6411284E9,1.6344756E9,1.6439796E9,1.6491672E9,1.6368948E9,1.6374996E9,1.6426836E9,1.6412148E9,1.651068E9,1.6415604E9,1.6306776E9,1.6559064E9,1.6451892E9,1.643634E9,1.6299E9,1.6399188E9,1.6411284E9,1.6350804E9,1.6394004E9,1.6417332E9,1.6263576E9,1.6469172E9,1.6452756E9,1.6538328E9,1.6333524E9,1.630332E9,1.6450164E9,1.6528824E9,1.64934E9,1.6295544E9,1.64277E9,1.6544376E9,1.6534872E9,1.6353396E9,1.6387956E9,1.643202E9,1.644498E9,1.6389684E9,1.6513272E9,1.6472628E9,1.6441524E9,1.652364E9,1.6394004E9,1.6376724E9,1.6537464E9,1.6538328E9,1.6392276E9,1.6285176E9,1.6513272E9,1.6379316E9,1.6439796E9,1.6421652E9,1.631628E9,1.641906E9,1.6282584E9,1.6477812E9,1.6287768E9,1.6548696E9,1.6372404E9,1.6279128E9,1.6274808E9,1.6374132E9,1.645794E9,1.6498584E9,1.6321464E9,1.636722E9,1.629036E9,1.6460532E9,1.64277E9,1.6404372E9,1.6451028E9]],"displayName":"Date_Raw","formulas":[{"txt":"DATE_ADD(slice(date(e81016948df440cd06e1fcdc846f01b9@Quotes,A:A;,\"yyyy/MM/dd\")),\"5\",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":"cee6cd23"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["9 Mar 2022","2 May 2022","25 Jun 2022","13 Jan 2022","3 Jan 2022","22 Jan 2022","13 Apr 2022","23 Aug 2021","19 Sep 2021","19 Jan 2022","16 Feb 2022","10 Feb 2022","21 Apr 2022","12 Jan 2022","29 Sep 2021","3 Feb 2022","12 Oct 2021","8 Feb 2022","29 May 2022","31 Aug 2021","9 May 2022","14 Dec 2021","9 Dec 2021","14 Sep 2021","7 Aug 2021","17 Nov 2021","13 May 2022","13 Oct 2021","24 Dec 2021","3 Jan 2022","18 Oct 2021","5 Feb 2022","6 Apr 2022","15 Nov 2021","22 Nov 2021","21 Jan 2022","4 Jan 2022","28 Apr 2022","8 Jan 2022","4 Sep 2021","23 Jun 2022","19 Feb 2022","1 Feb 2022","26 Aug 2021","20 Dec 2021","3 Jan 2022","25 Oct 2021","14 Dec 2021","10 Jan 2022","16 Jul 2021","11 Mar 2022","20 Feb 2022","30 May 2022","5 Oct 2021","31 Aug 2021","17 Feb 2022","19 May 2022","8 Apr 2022","22 Aug 2021","22 Jan 2022","6 Jun 2022","26 May 2022","28 Oct 2021","7 Dec 2021","27 Jan 2022","11 Feb 2022","9 Dec 2021","1 May 2022","15 Mar 2022","7 Feb 2022","13 May 2022","14 Dec 2021","24 Nov 2021","29 May 2022","30 May 2022","12 Dec 2021","10 Aug 2021","1 May 2022","27 Nov 2021","5 Feb 2022","15 Jan 2022","15 Sep 2021","12 Jan 2022","7 Aug 2021","21 Mar 2022","13 Aug 2021","11 Jun 2022","19 Nov 2021","3 Aug 2021","29 Jul 2021","21 Nov 2021","26 Feb 2022","14 Apr 2022","21 Sep 2021","13 Nov 2021","16 Aug 2021","1 Mar 2022","22 Jan 2022","26 Dec 2021","18 Feb 2022"]],"displayName":"Date","formulas":[{"txt":"SWITCH($TM_DateGroup,\"d\",DATEVALUE(&'cee6cd23',\"d MMM yyyy\"),\"m\",DATEVALUE(&'cee6cd23',\"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":"c28412a2"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["John Smith","Jessica Walker","Tim Warner","Tim Warner","Anne Simmons","Anne Simmons","Jessica Walker","Anne Simmons","Anne Simmons","Tim Warner","Tom Jones","Jessica Walker","Anne Simmons","Anne Simmons","Tim Warner","Tim Warner","John Smith","Anne Simmons","Jessica Walker","John Smith","John Smith","John Smith","John Smith","John Smith","Tim Warner","Tom Jones","Tim Warner","Anne Simmons","John Smith","Anne Simmons","Tim Warner","Tim Warner","Anne Simmons","Jessica Walker","Tim Warner","Tom Jones","John Smith","Anne Simmons","John Smith","Anne Simmons","Jessica Walker","John Smith","Anne Simmons","Tom Jones","Tim Warner","Tim Warner","John Smith","Jessica Walker","John Smith","John Smith","Jessica Walker","Jessica Walker","Tim Warner","Anne Simmons","Anne Simmons","Tim Warner","John Smith","John Smith","John Smith","John Smith","Jessica Walker","Tom Jones","Tim Warner","Jessica Walker","John Smith","Anne Simmons","Anne Simmons","Tom Jones","John Smith","John Smith","Anne Simmons","John Smith","John Smith","Tom Jones","Anne Simmons","Anne Simmons","Anne Simmons","Tom Jones","Tim Warner","Tom Jones","Jessica Walker","Tim Warner","Anne Simmons","John Smith","Tim Warner","Tim Warner","Tim Warner","Tom Jones","Anne Simmons","Tom Jones","John Smith","Jessica Walker","Anne Simmons","Anne Simmons","Jessica Walker","Tom Jones","John Smith","Jessica Walker","Jessica Walker","John Smith"]],"displayName":"Employee","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Quotes,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Employee","id":"5cbb1386"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["357","903","643","703","505","187","959","489","772","507","430","829","490","803","518","632","293","239","737","516","777","506","811","886","87","651","751","843","603","623","624","148","646","348","265","954","409","633","966","225","913","419","180","606","584","201","678","428","748","672","902","885","133","505","802","909","433","792","928","544","498","947","172","947","669","741","100","906","987","936","125","449","96","678","799","169","81","450","331","867","921","903","618","975","957","972","299","961","189","673","703","198","783","57","448","242","584","674","934","497"]],"displayName":"Value","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Quotes,C:C;)","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":"a405ad19"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Installation","Warranty","Repair","Installation","Warranty","Installation","Warranty","Installation","Installation","Repair","Installation","Warranty","Repair","Installation","Warranty","Installation","Repair","Repair","Installation","Installation","Call Back","Warranty","Call Back","Installation","Repair","Call Back","Repair","Call Back","Warranty","Installation","Repair","Repair","Repair","Repair","Installation","Call Back","Installation","Installation","Call Back","Installation","Installation","Repair","Installation","Installation","Warranty","Call Back","Warranty","Installation","Warranty","Installation","Repair","Installation","Repair","Call Back","Installation","Warranty","Installation","Installation","Installation","Repair","Repair","Installation","Repair","Repair","Repair","Installation","Call Back","Installation","Installation","Repair","Call Back","Installation","Repair","Repair","Repair","Call Back","Call Back","Repair","Installation","Repair","Installation","Repair","Call Back","Repair","Installation","Repair","Repair","Repair","Installation","Installation","Installation","Call Back","Installation","Call Back","Installation","Installation","Repair","Call Back","Warranty","Installation"]],"displayName":"Type","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Quotes,D:D;)","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":"5b5df579"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Lost","Lost","Won","Won","Won","Lost","Lost","Lost","Lost","Won","Won","Lost","Won","Lost","Lost","Lost","Won","Lost","Lost","Lost","Lost","Won","Lost","Lost","Won","Lost","Lost","Lost","Lost","Lost","Won","Won","Won","Lost","Won","Won","Won","Lost","Lost","Lost","Lost","Lost","Lost","Lost","Lost","Lost","Lost","Won","Lost","Lost","Won","Won","Lost","Lost","Lost","Lost","Lost","Won","Lost","Lost","Won","Won","Won","Lost","Lost","Lost","Lost","Won","Won","Lost","Lost","Won","Lost","Lost","Lost","Lost","Lost","Lost","Won","Lost","Won","Lost","Won","Lost","Won","Lost","Won","Lost","Won","Won","Lost","Lost","Lost","Lost","Lost","Lost","Lost","Won","Won","Lost"]],"displayName":"Status","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Quotes,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":"e6611552-64"}],"displayName":"Table Copy","id":"b38cd557","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"5cbb1386"},{"var":"TM_Employee"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"5cbb1386","variation":"condition"}],"kid":"b2dc36b5357c25a4ab6d64f1f60af504","id":"dstb38cd557"}}],"isForked":false,"id":"3cf21c7902d3dfeefa1f705375323815","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Quotes and Job Win Rate","usesSampleData":false,"master":"b2dc36b5357c25a4ab6d64f1f60af504"},{"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":"de9301e01ffa08ddbb0f7c7f5c5924f6","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 (MAINTENANCE) 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 (MAINTENANCE) DASHBOARD\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"473178b9","type":"label","fmt":"txt","dstContext":{"kid":"cc20e30e299909feb97ec795ec53d8ca","id":"dst473178b9"},"align":"c","wrap":true}],"isForked":false,"id":"1a951aed833fd23c13f25ab86d691470","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"cc20e30e299909feb97ec795ec53d8ca"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9"],"dimensions":{"w":1329.0}},"components":[{"size":"xx-small","data":[["This displays which lead sources are driving the most revenue within the business."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"This displays which lead sources are driving the most revenue within the business.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"65e4e811","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"c4fd510a3ba5c98c88d57bb6f56d1aa4","id":"dst65e4e811"},"wrap":true},{"data":[["Total Job value by Lead Source"]],"displayName":"Label 2","formulas":[{"txt":"\"Total Job value by Lead Source\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"c4fd510a3ba5c98c88d57bb6f56d1aa4","id":"dst9e20af84"},"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":"9e20af84","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"data","data":[[2094.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(select(&'03bb9490-89',BETWEEN(&'2fb90c71',$TM_DateStart,$TM_DateEnd)),select(&'7359a7bf',BETWEEN(&'2fb90c71',$TM_DateStart,$TM_DateEnd)),\"sum(values)\")","ver":2.0}],"autoFmt":false,"id":"42a604b4","type":"series_data","fmt":"cur"},{"role":"labels","data":[["Google"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"GROUP(select(&'03bb9490-89',BETWEEN(&'2fb90c71',$TM_DateStart,$TM_DateEnd)))","ver":2.0}],"autoFmt":false,"id":"567dd843","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["cx-theme_blue_3","cx-theme_green_3","cx-theme_yellow_green_3","cx-theme_blue_1","cx-theme_green_1","cx-theme_violet_1","cx-theme_violet_4","#33867f","#ada434"],"displayName":"Pie Chart","id":"32a07bcc","type":"chart_pie","dstContext":{"kid":"c4fd510a3ba5c98c88d57bb6f56d1aa4","id":"dst32a07bcc"},"overrideColors":true},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5956856E9,1.5945624E9,1.5937848E9,1.5949944E9,1.5959448E9,1.5959448E9,1.5993144E9,1.5955128E9,1.600092E9,1.5961176E9,1.5959448E9,1.598796E9,1.5954264E9,1.600524E9,1.598364E9,1.6017336E9,1.6008696E9,1.5958584E9,1.5984504E9,1.6004376E9,1.6011288E9,1.6006968E9,1.599228E9,1.5995736E9,1.5967224E9,1.5963768E9,1.6018164E9,1.5937848E9,1.597932E9,1.5975864E9,1.6004376E9,1.5954264E9,1.5975E9,1.594044E9,1.5952536E9,1.5972408E9,1.5985368E9,1.5967224E9,1.5954264E9,1.5959448E9,1.600092E9,1.5994008E9,1.5954264E9,1.6013016E9,1.6012152E9,1.6012152E9,1.5995736E9,1.5988824E9,1.59534E9,1.6003512E9,1.596636E9,1.596204E9,1.5997464E9,1.599228E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(e81016948df440cd06e1fcdc846f01b9@Sales,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":"2fb90c71"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["26 Jul 2020","13 Jul 2020","4 Jul 2020","18 Jul 2020","29 Jul 2020","29 Jul 2020","6 Sep 2020","24 Jul 2020","15 Sep 2020","31 Jul 2020","29 Jul 2020","31 Aug 2020","23 Jul 2020","20 Sep 2020","26 Aug 2020","4 Oct 2020","24 Sep 2020","28 Jul 2020","27 Aug 2020","19 Sep 2020","27 Sep 2020","22 Sep 2020","5 Sep 2020","9 Sep 2020","7 Aug 2020","3 Aug 2020","5 Oct 2020","4 Jul 2020","21 Aug 2020","17 Aug 2020","19 Sep 2020","23 Jul 2020","16 Aug 2020","7 Jul 2020","21 Jul 2020","13 Aug 2020","28 Aug 2020","7 Aug 2020","23 Jul 2020","29 Jul 2020","15 Sep 2020","7 Sep 2020","23 Jul 2020","29 Sep 2020","28 Sep 2020","28 Sep 2020","9 Sep 2020","1 Sep 2020","22 Jul 2020","18 Sep 2020","6 Aug 2020","1 Aug 2020","11 Sep 2020","5 Sep 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($TM_DateGroup,\"d\",DATEVALUE(&'2fb90c71',\"d MMM yyyy\"),\"m\",DATEVALUE(&'2fb90c71',\"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":"0ba55a2a"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Tom Jones","John Smith","Anne Simmons","Tim Warner","Jessica Walker","John Smith","Jessica Walker","Tim Warner","John Smith","Tom Jones","Tim Warner","Jessica Walker","Tom Jones","Tom Jones","John Smith","Jessica Walker","Jessica Walker","Tom Jones","Tim Warner","Jessica Walker","Tom Jones","Tom Jones","John Smith","Jessica Walker","Tom Jones","John Smith","Anne Simmons","Tim Warner","Jessica Walker","John Smith","Jessica Walker","Tim Warner","Jessica Walker","Tom Jones","Tom Jones","John Smith","Jessica Walker","Jessica Walker","Tom Jones","Tim Warner","Jessica Walker","Tom Jones","Tom Jones","John Smith","Jessica Walker","Tom Jones","John Smith","Anne Simmons","Tim Warner","Jessica Walker","John Smith","Jessica Walker","Tim Warner","Jessica Walker"]],"displayName":"Employee","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Employee","id":"5552f765"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["998","1563","1759","964","1095","1552","1870","968","187","1803","138","855","434","1181","677","1271","165","147","336","186","542","834","1012","1921","731","903","823","908","814","688","1158","1481","631","468","544","598","1927","1206","1720","1789","1174","978","1399","518","181","1216","600","341","1345","1100","938","1220","1347","1902"]],"displayName":"Value","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,C:C;)","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":"7359a7bf"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Warranty","Call Back","Installation","Repair","Warranty","Call Back","Installation","Repair","Installation","Repair","Warranty","Installation","Repair","Repair","Repair","Repair","Call Back","Installation","Warranty","Call Back","Installation","Repair","Warranty","Call Back","Installation","Repair","Installation","Repair","Warranty","Installation","Repair","Repair","Repair","Repair","Call Back","Installation","Warranty","Call Back","Installation","Repair","Warranty","Call Back","Installation","Repair","Installation","Repair","Warranty","Installation","Repair","Repair","Repair","Repair","Call Back","Installation"]],"displayName":"Type","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,D:D;)","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":"9b2eb53b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Google","Social Media","Word of Mouth","Referral","Google","Google","Referral","Email","Referral","Social Media","Referral","Social Media","Social Media","Google","Email","Google","Word of Mouth","Google","Google","Word of Mouth","Referral","Referral","Word of Mouth","Google","Google","Word of Mouth","Google","Google","Social Media","Word of Mouth","Email","Email","Social Media","Social Media","Word of Mouth","Social Media","Word of Mouth","Email","Social Media","Google","Referral","Email","Referral","Social Media","Social Media","Word of Mouth","Social Media","Email","Google","Email","Referral","Social Media","Social Media","Google"]],"displayName":"Lead Source","formulas":[{"txt":"slice(e81016948df440cd06e1fcdc846f01b9@Sales,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":"Lead Source","id":"03bb9490-89"}],"displayName":"Table","id":"8fa22414","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"5552f765"},{"var":"TM_Employee"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"5552f765","variation":"condition"}],"kid":"c4fd510a3ba5c98c88d57bb6f56d1aa4","id":"dst8fa22414"}}],"isForked":false,"id":"3a1c62e361845440f5fe806a8e9e2ba8","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Jobs by Lead Source","usesSampleData":false,"master":"c4fd510a3ba5c98c88d57bb6f56d1aa4"}]}]