[{"tab":{"id":"21438f47d0817136e795c89cb5fe6692","name":"Construction - Sales / Marketing / Estimating","layoutType":"grid","state":{"desktop":{"itemConfigs":[{"minHeight":210,"colSpan":6,"index":[0,0],"id":"gridklip-aba594a055fa59b1f3dc93bf130de080"},{"minHeight":79,"colSpan":6,"index":[0,1],"id":"gridklip-3672fadc04befc39732b0bc8e661aeb0"},{"minHeight":116,"colSpan":6,"index":[0,2],"id":"gridklip-25d274bb923071e6de3edf645b1f116d"},{"minHeight":383,"colSpan":6,"index":[0,3],"id":"gridklip-751673c8cb7979ed2ccc054f3b0f8c64"},{"minHeight":398,"colSpan":6,"index":[0,4],"id":"gridklip-4d973438145ed7715186e268eb80f0f1"},{"minHeight":483,"colSpan":3,"index":[0,5],"id":"gridklip-3e28950102efd2b3575bc78b6b7e6e6c"},{"minHeight":416,"colSpan":6,"index":[0,6],"id":"gridklip-42f151bd88c0a27bc8566a659e4a83ad"},{"minHeight":165,"colSpan":6,"index":[0,7],"id":"gridklip-1b0e9098b907e54acdd78b960eed7fc4"},{"minHeight":490,"colSpan":3,"index":[3,5],"id":"gridklip-8c92bf5bf78823421cf177fd3ee9d30a"}],"colWidths":["auto","auto","auto","auto","auto","auto"],"cols":6}},"master":"21438f47d0817136e795c89cb5fe6692"},"klips":[{"workspace":{"datasources":["773a7b4b52bcff4e6d67acb50b26c8a6","c7111b5ac1f526e9be25f3ed809f7877","05eb33644786b6d75770879750fc0fde"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["Displays the total number and value of projects won by service. This allows us to see which services account for the majority of projects and revenue."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Displays the total number and value of projects won by service. This allows us to see which services account for the majority of projects and revenue.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"1f47adff","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"1b6691802b04cb7375b04e261d7cf562","id":"dst1f47adff"},"wrap":true},{"components":[{"data":[["Total Number of Projects by Service"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Total Number of Projects by Service\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"1b6691802b04cb7375b04e261d7cf562","id":"dst365081ea"},"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":"365081ea","wrap":true},{"data":[["Total Project Value by Service"]],"displayName":"Label 2","formulas":[{"txt":"\"Total Project Value by Service\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"1b6691802b04cb7375b04e261d7cf562","id":"dst76090e83"},"align":"c","layoutConfig":{"x":1.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"76090e83","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"data","data":[[10.0,3.0,2.0,4.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"}},"precision":"0"},"formulas":[{"txt":"LOOKUP(&'1ca719ed',GROUP(SELECT(&'c90770a5',BETWEEN(&'af179082',$dateStart,$dateEnd))),GROUPBY(SELECT(&'c90770a5',BETWEEN(&'af179082',$dateStart,$dateEnd)),SELECT(&'0e3d74ef',BETWEEN(&'af179082',$dateStart,$dateEnd)),\"count(values)\"))","ver":2.0}],"autoFmt":false,"id":"7f253db3","type":"series_data","fmt":"num"},{"role":"labels","data":[["Commercial","Industrial","Renovation","Residential"]],"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(&'c90770a5')","ver":2.0}],"autoFmt":true,"id":"1ca719ed","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["cx-theme_yellow_green_4","cx-theme_yellow_3","cx-theme_orange_3","cx-theme_violet_3","cx-theme_violet_3","cx-theme_brown_3","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart Copy","pie_style":"circle","id":"1ca80f61","type":"chart_pie","dstContext":{"kid":"1b6691802b04cb7375b04e261d7cf562","id":"dst1ca80f61"},"overrideColors":true,"legend_percentages":"0"},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"role":"data","data":[[1555107.0,389130.0,528307.0,421747.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":"LOOKUP(&'bd242a60',GROUP(SELECT(&'c90770a5',BETWEEN(&'af179082',$dateStart,$dateEnd))),GROUPBY(SELECT(&'c90770a5',BETWEEN(&'af179082',$dateStart,$dateEnd)),SELECT(&'0e3d74ef',BETWEEN(&'af179082',$dateStart,$dateEnd)),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"id":"f2b5005d","type":"series_data","fmt":"cur"},{"role":"labels","data":[["Commercial","Industrial","Renovation","Residential"]],"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(&'c90770a5')","ver":2.0}],"autoFmt":true,"id":"bd242a60","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["cx-theme_yellow_green_4","cx-theme_yellow_3","cx-theme_orange_3","cx-theme_violet_4","cx-theme_violet_3","cx-theme_brown_3","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart","id":"fec99182","type":"chart_pie","dstContext":{"kid":"1b6691802b04cb7375b04e261d7cf562","id":"dstfec99182"},"overrideColors":true,"legend_percentages":"0"}],"displayName":"Layout Grid","id":"e8a118cf","cellData":[{"x":1.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":1.0,"alignment":1.0}],"type":"panel_grid","rows":2.0,"cols":2.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["1594130400","1582981200","1603630800","1617804000","1584450000","1597327200","1590501600","1595944800","1613480400","1617282000","1592575200","1591624800","1609851600","1598709600","1587650400","1598018400","1604667600","1594648800","1612011600","1604840400","1612443600","1588687200","1612962000","1590674400","1570366800","1600178400","1606482000","1601128800","1582722000","1586181600","1589205600","1576069200","1587909600","1617195600","1583672400","1589292000","1592402400","1572872400","1576933200","1605704400","1581858000","1585746000","1581339600","1597845600","1595772000","1570971600","1603371600","1599832800","1613653200","1583845200","1605272400","1602248400","1571662800","1611320400","1617282000","1590242400","1607346000","1595685600","1607518800","1573477200","1614949200","1596895200","1595858400","1615813200","1590501600","1609851600","1585746000","1616158800","1598104800","1617976800","1599141600","1584709200","1586959200","1585486800","1604667600","1587650400","1596895200","1578142800","1576587600","1576328400","1583758800","1614690000","1599055200","1606395600","1602594000","1588600800","1575637200","1604149200","1610974800","1599228000","1615986000","1596117600","1593266400","1576674000","1597240800","1580475600","1599228000","1575982800","1598104800"]],"displayName":"Date_Raw_Start","formulas":[{"txt":"date(slice(05eb33644786b6d75770879750fc0fde@Sales,A:A;),\"yyyy/MM/dd\")","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"name":"Date_Raw_Start","id":"af179082"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jul 2020","Mar 2020","Oct 2020","Apr 2021","Mar 2020","Aug 2020","May 2020","Jul 2020","Feb 2021","Apr 2021","Jun 2020","Jun 2020","Jan 2021","Aug 2020","Apr 2020","Aug 2020","Nov 2020","Jul 2020","Jan 2021","Nov 2020","Feb 2021","May 2020","Feb 2021","May 2020","Oct 2019","Sep 2020","Nov 2020","Sep 2020","Feb 2020","Apr 2020","May 2020","Dec 2019","Apr 2020","Apr 2021","Mar 2020","May 2020","Jun 2020","Nov 2019","Dec 2019","Nov 2020","Feb 2020","Apr 2020","Feb 2020","Aug 2020","Jul 2020","Oct 2019","Oct 2020","Sep 2020","Feb 2021","Mar 2020","Nov 2020","Oct 2020","Oct 2019","Jan 2021","Apr 2021","May 2020","Dec 2020","Jul 2020","Dec 2020","Nov 2019","Mar 2021","Aug 2020","Jul 2020","Mar 2021","May 2020","Jan 2021","Apr 2020","Mar 2021","Aug 2020","Apr 2021","Sep 2020","Mar 2020","Apr 2020","Mar 2020","Nov 2020","Apr 2020","Aug 2020","Jan 2020","Dec 2019","Dec 2019","Mar 2020","Mar 2021","Sep 2020","Nov 2020","Oct 2020","May 2020","Dec 2019","Nov 2020","Jan 2021","Sep 2020","Mar 2021","Jul 2020","Jun 2020","Dec 2019","Aug 2020","Feb 2020","Sep 2020","Dec 2019","Aug 2020"]],"displayName":"Date_Start","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(&'af179082',\"d MMM yyyy\"),\"m\",DATEVALUE(&'af179082',\"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_Start","id":"4fe31c15"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Commercial","Commercial","Renovation","Industrial","Commercial","Commercial","Commercial","Renovation","Renovation","Residential","Industrial","Industrial","Commercial","Industrial","Commercial","Industrial","Residential","Industrial","Industrial","Commercial","Commercial","Commercial","Commercial","Commercial","Commercial","Industrial","Commercial","Commercial","Commercial","Commercial","Industrial","Industrial","Renovation","Commercial","Commercial","Commercial","Commercial","Industrial","Commercial","Commercial","Commercial","Commercial","Industrial","Industrial","Residential","Commercial","Renovation","Commercial","Commercial","Commercial","Commercial","Commercial","Commercial","Commercial","Residential","Renovation","Commercial","Commercial","Residential","Industrial","Residential","Renovation","Industrial","Commercial","Commercial","Commercial","Commercial","Commercial","Commercial","Industrial","Commercial","Renovation","Industrial","Commercial","Commercial","Commercial","Commercial","Commercial","Industrial","Commercial","Industrial","Renovation","Industrial","Commercial","Industrial","Renovation","Industrial","Industrial","Residential","Commercial","Commercial","Residential","Residential","Residential","Residential","Industrial","Residential","Commercial","Commercial"]],"displayName":"Type","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Sales,E:E;)","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":"c90770a5"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["177252","189222","178776","114600","54168","168216","187070","170105","276159","133610","156715","75600","112563","158951","214149","103807","67606","143700","114470","188870","129701","64009","132440","177411","218664","207564","211926","172400","65150","203832","177100","165143","147279","163086","182490","249600","96694","88127","96404","192159","117888","168280","165971","64164","192192","93938","131208","90530","138193","137616","159024","116844","121043","228876","76450","126680","97253","182930","135380","104120","127680","138788","201513","166368","45310","148940","125801","138810","71028","160060","130221","71520","131340","207276","87270","181246","62238","122496","108840","56760","182884","252148","73464","61110","199045","91680","160248","215660","84007","208546","196130","72816","73160","201019","162660","142680","184704","118888","198210"]],"displayName":"Value","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Sales,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Value","id":"0e3d74ef"}],"displayName":"Table","id":"29e30159","type":"table","dstContext":{"ops":[],"kid":"1b6691802b04cb7375b04e261d7cf562","id":"dst29e30159"}}],"isForked":false,"id":"8c92bf5bf78823421cf177fd3ee9d30a","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Projects Won by Service","usesSampleData":false,"master":"1b6691802b04cb7375b04e261d7cf562"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","a2d75942456c71f47060d9f50d075fd4","b34d001a86e63a2f279fc461c52cca1f","c7111b5ac1f526e9be25f3ed809f7877","05eb33644786b6d75770879750fc0fde"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["This displays the number and value of sales over the selected period. This is the most important metrics and allows us to gauge overall sucess."]],"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 the number and value of sales over the selected period. This is the most important metrics and allows us to gauge overall sucess.\" ","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"928a4595","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"c29924027ed48455c928a58052194fc2","id":"dst928a4595"},"wrap":true},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"showValues":true,"role":"series","data":[[2.0,5.0,4.0,5.0,5.0]],"color":"cx-theme_blue_2","displayName":"Number of Sales","seriesName":"Number of Sales","formulas":[{"txt":"LOOKUP(&'e53beb8e',GROUP(&'3eccccf4'),GROUPBY(&'3eccccf4',&'e838a6b4',\"count(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"595e0131","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"571510e1"},{"renderer":"line","showValues":true,"role":"series","data":[[232633.0,688856.0,676493.0,881136.0,647806.0]],"color":"cx-theme_yellow_green_4","displayName":"Sales Value","seriesName":"Sales Value","formulas":[{"txt":"LOOKUP(&'e53beb8e',GROUP(&'3eccccf4'),GROUPBY(&'3eccccf4',&'e838a6b4',\"sum(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"0480ee3a","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"1e1730a5-39"},{"role":"axis_x","data":[["Dec 2020","Jan 2021","Feb 2021","Mar 2021","Apr 2021"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(DATERANGE($dateStart,$dateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($dateStart,$dateEnd),\"3\")),\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"id":"e53beb8e","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"id":"595e0131","labelDrop":0.0,"renamed":true},{"customRange":true,"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Perc","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Perc","type":"chart_axis","fmt":"cur","min":"0","fmtArgs":{},"id":"0480ee3a","labelDrop":0.0,"renamed":true}],"stackAreas":"1","displayName":"Bar/Line Chart","id":"36c1d924","type":"chart_series","dstContext":{"kid":"c29924027ed48455c928a58052194fc2","id":"dst36c1d924"},"stackBars":"1","height":"3"},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"primary","data":[["Total Number of Sales"]],"displayName":"Primary Value","formulas":[{"txt":"\"Total Number of Sales\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"c29924027ed48455c928a58052194fc2","id":"dst167eb0dd41"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"167eb0dd-41"},{"role":"secondary","size":"medium","data":[[19.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":"COUNTIF(BETWEEN(&'e5c5e085',$dateStart,$dateEnd))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"a91ff142-42","type":"label","fmt":"num","dstContext":{"kid":"c29924027ed48455c928a58052194fc2","id":"dsta91ff14242"},"align":"c"}],"displayName":"Value Pair","id":"d8c0aa2f-40","type":"simple_value","dstContext":{"id":"dstd8c0aa2f40"}},{"layoutConfig":{"x":2.0,"y":1.0},"components":[{"role":"primary","data":[["Total Value of Sales"]],"displayName":"Primary Value","formulas":[{"txt":"\"Total Value of Sales\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"c29924027ed48455c928a58052194fc2","id":"dste3412f75"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"e3412f75"},{"role":"secondary","size":"medium","data":[[2894291.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":"SUMIF(BETWEEN(&'e5c5e085',$dateStart,$dateEnd),&'e838a6b4')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"75ce275c","type":"label","fmt":"cur","dstContext":{"kid":"c29924027ed48455c928a58052194fc2","id":"dst75ce275c"},"align":"c"}],"displayName":"Value Pair Copy","id":"1159cf89","type":"simple_value","dstContext":{"id":"dst1159cf89"}},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"role":"primary","data":[["Average Sales Value"]],"displayName":"Primary Value","formulas":[{"txt":"\"Average Sales Value\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"c29924027ed48455c928a58052194fc2","id":"dst00e77d51"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"00e77d51"},{"role":"secondary","size":"medium","data":[[152331.1052631579]],"displayName":"Secondary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"formulas":[{"txt":"AVERAGEIF(BETWEEN(&'e5c5e085',$dateStart,$dateEnd),&'e838a6b4')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"6e9ab107","type":"label","fmt":"cur","dstContext":{"kid":"c29924027ed48455c928a58052194fc2","id":"dst6e9ab107"},"align":"c"}],"displayName":"Value Pair Copy 2","id":"2586d727","type":"simple_value","dstContext":{"id":"dst2586d727"}}],"displayName":"Layout Grid 2","id":"c1f6fe8b","cellData":[{"w":2.0,"x":0.0,"h":3.0,"y":0.0},{"x":2.0,"y":2.0,"alignment":1.0},{"x":2.0,"y":1.0,"alignment":1.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"cols":3.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5941304E9,1.5829812E9,1.6036308E9,1.617804E9,1.58445E9,1.5973272E9,1.5905016E9,1.5959448E9,1.6134804E9,1.617282E9,1.5925752E9,1.5916248E9,1.6098516E9,1.5987096E9,1.5876504E9,1.5980184E9,1.6046676E9,1.5946488E9,1.6120116E9,1.6048404E9,1.6124436E9,1.5886872E9,1.612962E9,1.5906744E9,1.5703668E9,1.6001784E9,1.606482E9,1.6011288E9,1.582722E9,1.5861816E9,1.5892056E9,1.5760692E9,1.5879096E9,1.6171956E9,1.5836724E9,1.589292E9,1.5924024E9,1.5728724E9,1.5769332E9,1.6057044E9,1.581858E9,1.585746E9,1.5813396E9,1.5978456E9,1.595772E9,1.5709716E9,1.6033716E9,1.5998328E9,1.6136532E9,1.5838452E9,1.6052724E9,1.6022484E9,1.5716628E9,1.6113204E9,1.617282E9,1.5902424E9,1.607346E9,1.5956856E9,1.6075188E9,1.5734772E9,1.6149492E9,1.5968952E9,1.5958584E9,1.6158132E9,1.5905016E9,1.6098516E9,1.585746E9,1.6161588E9,1.5981048E9,1.6179768E9,1.5991416E9,1.5847092E9,1.5869592E9,1.5854868E9,1.6046676E9,1.5876504E9,1.5968952E9,1.5781428E9,1.5765876E9,1.5763284E9,1.5837588E9,1.61469E9,1.5990552E9,1.6063956E9,1.602594E9,1.5886008E9,1.5756372E9,1.6041492E9,1.6109748E9,1.599228E9,1.615986E9,1.5961176E9,1.5932664E9,1.576674E9,1.5972408E9,1.5804756E9,1.599228E9,1.5759828E9,1.5981048E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(05eb33644786b6d75770879750fc0fde@Sales,A:A;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"e5c5e085"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jul 2020","Mar 2020","Oct 2020","Apr 2021","Mar 2020","Aug 2020","May 2020","Jul 2020","Feb 2021","Apr 2021","Jun 2020","Jun 2020","Jan 2021","Aug 2020","Apr 2020","Aug 2020","Nov 2020","Jul 2020","Jan 2021","Nov 2020","Feb 2021","May 2020","Feb 2021","May 2020","Oct 2019","Sep 2020","Nov 2020","Sep 2020","Feb 2020","Apr 2020","May 2020","Dec 2019","Apr 2020","Apr 2021","Mar 2020","May 2020","Jun 2020","Nov 2019","Dec 2019","Nov 2020","Feb 2020","Apr 2020","Feb 2020","Aug 2020","Jul 2020","Oct 2019","Oct 2020","Sep 2020","Feb 2021","Mar 2020","Nov 2020","Oct 2020","Oct 2019","Jan 2021","Apr 2021","May 2020","Dec 2020","Jul 2020","Dec 2020","Nov 2019","Mar 2021","Aug 2020","Jul 2020","Mar 2021","May 2020","Jan 2021","Apr 2020","Mar 2021","Aug 2020","Apr 2021","Sep 2020","Mar 2020","Apr 2020","Mar 2020","Nov 2020","Apr 2020","Aug 2020","Jan 2020","Dec 2019","Dec 2019","Mar 2020","Mar 2021","Sep 2020","Nov 2020","Oct 2020","May 2020","Dec 2019","Nov 2020","Jan 2021","Sep 2020","Mar 2021","Jul 2020","Jun 2020","Dec 2019","Aug 2020","Feb 2020","Sep 2020","Dec 2019","Aug 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'e5c5e085',\"d MMM yyyy\"),\"m\",DATEVALUE(!'e5c5e085',\"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":{},"defaultAggregate":"COUNT","fmt":"txt"}},"dateInputFormatCustom":"d MMMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMMM yyyy","dateInputFormat":"custom"},"name":"Date","id":"3eccccf4"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["177252","189222","178776","114600","54168","168216","187070","170105","276159","133610","156715","75600","112563","158951","214149","103807","67606","143700","114470","188870","129701","64009","132440","177411","218664","207564","211926","172400","65150","203832","177100","165143","147279","163086","182490","249600","96694","88127","96404","192159","117888","168280","165971","64164","192192","93938","131208","90530","138193","137616","159024","116844","121043","228876","76450","126680","97253","182930","135380","104120","127680","138788","201513","166368","45310","148940","125801","138810","71028","160060","130221","71520","131340","207276","87270","181246","62238","122496","108840","56760","182884","252148","73464","61110","199045","91680","160248","215660","84007","208546","196130","72816","73160","201019","162660","142680","184704","118888","198210"]],"displayName":"Value","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Sales,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Value","id":"e838a6b4"}],"displayName":"Sale","id":"08a3daff","type":"table","dstContext":{"ops":[],"kid":"c29924027ed48455c928a58052194fc2","id":"dst08a3daff"},"renamed":true}],"isForked":false,"id":"42f151bd88c0a27bc8566a659e4a83ad","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Sales","usesSampleData":false,"master":"c29924027ed48455c928a58052194fc2"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9"],"dimensions":{"w":869.0}},"components":[{"components":[{"data":[],"displayName":"Label","formulas":[{"txt":"\"Filter all data on the dashboard based on date\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dst6d510803"},"layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"6d510803","wrap":true},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"array(\"This Week\",\"Last Week\",\"This Month\",\"Last Month\",\"This Quarter\",\"Last Quarter\",\"This Year\",\"Last Year\",\"Last 7 Days\", \"Last 30 Days\", \"Last 365 Days\")","ver":2.0}],"autoFmt":false,"id":"02406d45","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"7ccd5f04","type":"proxy"}],"displayName":"User Input Control 2","scope":2.0,"inputLabel":"Date Range","inputType":1.0,"id":"3d7bfb53","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dst3d7bfb53"},"propName":"dateSelector"},{"layoutConfig":{"x":0.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",\"d\",\"Yesterday\",\"d\",\"This Week\",\"d\",\"Last Week\",\"d\",\"This Month\",\"d\",\"Last Month\",\"d\",\"This Quarter\",\"m\",\"Last Quarter\",\"m\",\"This Year\",\"m\",\"Last Year\",\"m\",\"Last 7 Days\",\"d\", \"Last 30 Days\",\"d\", \"Last 365 Days\",\"m\")","ver":2.0}],"autoFmt":false,"id":"4466fa0f","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"8ac9f164","type":"proxy"}],"displayName":"User Input Control 5","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"a3b0184c","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dsta3b0184c"},"propName":"dateGroup"},{"layoutConfig":{"x":1.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",DATE_STARTOF(today(),\"4\",0),\"Last Week\",DATE_STARTOF(today(),\"4\",-1),\"This Month\",DATE_STARTOF(today(),\"3\",0),\"Last Month\",DATE_STARTOF(today(),\"3\",-1),\"This Quarter\",DATE_STARTOF(today(),\"2\",0),\"Last Quarter\",DATE_STARTOF(today(),\"2\",-1),\"This Year\",DATE_STARTOF(today(),\"1\",0),\"Last Year\",DATE_STARTOF(today(),\"1\",-1),\"Last 7 Days\",DATE_ADD(today(),\"5\",-7), \"Last 30 Days\",DATE_ADD(today(),\"5\",-30), \"Last 365 Days\",DATE_ADD(today(),\"5\",-365))","ver":2.0}],"autoFmt":false,"id":"deea4069","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"f623ad54","type":"proxy"}],"displayName":"User Input Control 3","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"bd2e8f4e","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dstbd2e8f4e"},"propName":"dateStart"},{"layoutConfig":{"x":2.0,"y":1.0},"vis":false,"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"SWITCH($dateSelector,\"Today\",today(),\"Yesterday\",YESTERDAY(),\"This Week\",today(),\"Last Week\",DATE_ENDOF(today(),\"4\",-1),\"This Month\",today(),\"Last Month\",DATE_ENDOF(today(),\"3\",-1),\"This Quarter\",today(),\"Last Quarter\",DATE_ENDOF(today(),\"2\",-1),\"This Year\",today(),\"Last Year\",DATE_ENDOF(today(),\"1\",-1),\"Last 7 Days\",today(), \"Last 30 Days\",today(), \"Last 365 Days\",today())","ver":2.0}],"autoFmt":false,"id":"ab955e69","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"36a873a3","type":"proxy"}],"displayName":"User Input Control 4","scope":2.0,"controlHidden":"hidden","inputType":1.0,"id":"d1ebba48","type":"input","dstContext":{"kid":"bd30b1cb4bb6bb9ab8bef2e16e30adcf","id":"dstd1ebba48"},"propName":"dateEnd"}],"displayName":"Layout Grid","id":"9cf8c221","cellData":[{"w":2.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":3.0}],"isForked":false,"id":"25d274bb923071e6de3edf645b1f116d","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Filters","usesSampleData":false,"master":"eb62776ea1abc46c91e3f6df848ea566"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","a2d75942456c71f47060d9f50d075fd4","b34d001a86e63a2f279fc461c52cca1f","c7111b5ac1f526e9be25f3ed809f7877","05eb33644786b6d75770879750fc0fde"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["This displays the conversion rate from lead to project, both over time and in total."]],"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 the conversion rate from lead to project, both over time and in total.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"d7054196","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"598a59e75455738ab554f593d0ff9ada","id":"dstd7054196"},"wrap":true},{"components":[{"data":[["Conversion Rate Over Time"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Conversion Rate Over Time\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst2439a742"},"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":"2439a742","wrap":true},{"data":[["Average Conversion Rate"]],"displayName":"Label 2","formulas":[{"txt":"\"Average Conversion Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"598a59e75455738ab554f593d0ff9ada","id":"dstf7e644d1"},"align":"c","layoutConfig":{"x":2.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":"f7e644d1","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"renderer":"line","showValues":true,"role":"series","data":[[26.666666666666668,22.58064516129032,37.03703703703704,37.83783783783784,21.428571428571427]],"color":"cx-theme_orange_2","displayName":"Conversion Rate","seriesName":"Conversion Rate","formulas":[{"txt":"LOOKUP(&'112829c1',GROUP(&'082139dc'),GROUPBY(&'082139dc',&'7a38dd7b',\"count(values)\")) / LOOKUP(&'112829c1',GROUP(&'0b831bbb'),GROUPBY(&'0b831bbb',&'5c7d0e8a',\"count(values)\")) * 100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"e3ca42b4","chartStyle":"line_area","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":"1"},"id":"db27fa6d"},{"role":"axis_x","data":[["Dec 2020","Jan 2021","Feb 2021","Mar 2021","Apr 2021"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(DATERANGE($dateStart,$dateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($dateStart,$dateEnd),\"3\")),\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"id":"112829c1","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"pct","grid":true,"fmtArgs":{},"id":"e3ca42b4","labelDrop":0.0,"renamed":true},{"customRange":true,"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Perc","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Perc","type":"chart_axis","fmt":"pct","min":"0","id":"9a55b151","labelDrop":0.0,"renamed":true}],"stackAreas":"1","displayName":"Bar/Line Chart","id":"6b6666cc","type":"chart_series","dstContext":{"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst6b6666cc"},"stackBars":"1"},{"layoutConfig":{"x":2.0,"y":1.0},"components":[{"role":"current","size":"x-large","data":[[0.152]],"displayName":"Current Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"1"},"formulas":[{"txt":"countif(BETWEEN(&'d27ff10c',$dateStart,$dateEnd)) / countif(BETWEEN(&'4ace65c6',$dateStart,$dateEnd))","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"id":"9b5e5f82-45","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"9b5e5f8245"}],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst9b5e5f8245","aggs":{"9b5e5f8245":"sum"}}},{"role":"target","size":"medium","data":[[0.2]],"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":"0.2","ver":2.0,"src":{"c":[{"t":"l","v":"80"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_888","id":"789d45aa-46","type":"label","fmt":"pct","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"789d45aa46"}],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst789d45aa46","aggs":{"789d45aa46":"sum","9b5e5f8245":"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":true,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"853872a947"}],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst853872a947","aggs":{"853872a947":"auto"}},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"853872a9-47"},{"role":"max","size":"xx-small","data":[],"displayName":"Max Value","formulas":[],"autoFmt":true,"font_colour":"cx-color_888","id":"1e684b50-48","font_style":"","type":"label","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"1e684b5048"}],"id":"dst1e684b5048","aggs":{}}},{"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":"75875cc3-50","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"75875cc350"}],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst75875cc350","aggs":{"75875cc350":"sum"}}},{"role":"end","data":[[0.1]],"displayName":"End 1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.1","ver":2.0}],"autoFmt":false,"id":"128988e0-51","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"128988e051"}],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst128988e051","aggs":{"128988e051":"sum"}}}],"rangeId":1.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_red_2","displayName":"Range 1","formulas":[],"autoFmt":true,"id":"c0941c77-49","type":"range"},{"components":[{"role":"start","data":[[0.1]],"displayName":"Start 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true}},"formulas":[{"txt":"0.1","ver":2.0}],"autoFmt":false,"id":"479701c6-53","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"479701c653"}],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst479701c653","aggs":{"479701c653":"sum"}}},{"role":"end","data":[[0.2]],"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.2","ver":2.0}],"autoFmt":false,"id":"7cbf6559-54","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"7cbf655954"}],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst7cbf655954","aggs":{"7cbf655954":"sum"}}}],"rangeId":2.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_orange_2","displayName":"Range 2","formulas":[],"autoFmt":true,"id":"10782ba2-52","type":"range"},{"components":[{"role":"start","data":[[0.2]],"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.2","ver":2.0}],"autoFmt":false,"id":"8222a043-56","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"8222a04356"}],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst8222a04356","aggs":{"8222a04356":"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":"05290287-57","type":"proxy","fmt":"num","dstContext":{"ops":[{"type":"aggregate","aggregateBy":"0529028757"}],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst0529028757","aggs":{"0529028757":"sum"}}}],"rangeId":3.0,"role":"range","data":[],"dataDisabled":true,"color":"cx-theme_green_3","displayName":"Range 3","formulas":[],"autoFmt":true,"id":"5f180836-55","type":"range"}],"size":2.0,"displayName":"Gauge","id":"b829f0a8-44","type":"gauge","dstContext":{"id":"dstb829f0a844"},"gaugeStyle":"ag"}],"displayName":"Layout Grid 2","id":"1c8d8dde","cellData":[{"w":2.0,"x":0.0,"y":0.0},{"w":2.0,"x":0.0,"y":1.0}],"type":"panel_grid","rows":2.0,"cols":3.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.6028532E9,1.6008696E9,1.6122708E9,1.5948216E9,1.6024212E9,1.6122708E9,1.6163316E9,1.5989688E9,1.6180632E9,1.608642E9,1.6070868E9,1.5964632E9,1.6154676E9,1.588428E9,1.5971544E9,1.59102E9,1.6027668E9,1.5873912E9,1.6143444E9,1.6065684E9,1.6040628E9,1.6029396E9,1.6128756E9,1.61253E9,1.5960312E9,1.615122E9,1.5887736E9,1.6001784E9,1.6078644E9,1.590588E9,1.6106292E9,1.6087284E9,1.5974136E9,1.6139988E9,1.6127028E9,1.587132E9,1.609938E9,1.6113204E9,1.5985368E9,1.6149492E9,1.5892056E9,1.5921432E9,1.6102836E9,1.6153812E9,1.5986232E9,1.5893784E9,1.611234E9,1.59966E9,1.5935256E9,1.6000056E9,1.6050996E9,1.5907608E9,1.6076052E9,1.5994008E9,1.5894648E9,1.595772E9,1.5908472E9,1.6019892E9,1.6076052E9,1.5905016E9,1.5976728E9,1.6133076E9,1.6173684E9,1.6037172E9,1.6076916E9,1.6008696E9,1.6162452E9,1.5908472E9,1.6174548E9,1.6152948E9,1.5895512E9,1.6076916E9,1.596636E9,1.6016472E9,1.5934392E9,1.6158132E9,1.6160724E9,1.6131348E9,1.5885144E9,1.6147764E9,1.5879096E9,1.61037E9,1.5981912E9,1.5900696E9,1.6158996E9,1.5874776E9,1.6161588E9,1.6011288E9,1.594908E9,1.6165908E9,1.606482E9,1.6044084E9,1.6004376E9,1.6161588E9,1.59966E9,1.6061364E9,1.6108884E9,1.6134804E9,1.5965496E9,1.6079508E9]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(05eb33644786b6d75770879750fc0fde@Leads,A:A;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"4ace65c6"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Oct 2020","Sep 2020","Feb 2021","Jul 2020","Oct 2020","Feb 2021","Mar 2021","Sep 2020","Apr 2021","Dec 2020","Dec 2020","Aug 2020","Mar 2021","May 2020","Aug 2020","Jun 2020","Oct 2020","Apr 2020","Feb 2021","Nov 2020","Oct 2020","Oct 2020","Feb 2021","Feb 2021","Jul 2020","Mar 2021","May 2020","Sep 2020","Dec 2020","May 2020","Jan 2021","Dec 2020","Aug 2020","Feb 2021","Feb 2021","Apr 2020","Jan 2021","Jan 2021","Aug 2020","Mar 2021","May 2020","Jun 2020","Jan 2021","Mar 2021","Aug 2020","May 2020","Jan 2021","Sep 2020","Jul 2020","Sep 2020","Nov 2020","May 2020","Dec 2020","Sep 2020","May 2020","Jul 2020","May 2020","Oct 2020","Dec 2020","May 2020","Aug 2020","Feb 2021","Apr 2021","Oct 2020","Dec 2020","Sep 2020","Mar 2021","May 2020","Apr 2021","Mar 2021","May 2020","Dec 2020","Aug 2020","Oct 2020","Jun 2020","Mar 2021","Mar 2021","Feb 2021","May 2020","Mar 2021","Apr 2020","Jan 2021","Aug 2020","May 2020","Mar 2021","Apr 2020","Mar 2021","Sep 2020","Jul 2020","Mar 2021","Nov 2020","Nov 2020","Sep 2020","Mar 2021","Sep 2020","Nov 2020","Jan 2021","Feb 2021","Aug 2020","Dec 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'4ace65c6',\"d MMM yyyy\"),\"m\",DATEVALUE(!'4ace65c6',\"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":{},"defaultAggregate":"COUNT","fmt":"txt"}},"dateInputFormatCustom":"d MMMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMMM yyyy","dateInputFormat":"custom"},"name":"Date","id":"0b831bbb"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Property Developer","Website","Agent","Property Developer","Property Developer","Website","Property Developer","Website","Word of Mouth","Property Developer","Agent","Property Developer","Property Developer","Website","Agent","Agent","Agent","Property Developer","Property Developer","Website","Agent","Website","Word of Mouth","Word of Mouth","Property Developer","Website","Property Developer","Word of Mouth","Website","Website","Agent","Agent","Agent","Website","Word of Mouth","Website","Website","Agent","Agent","Website","Website","Word of Mouth","Property Developer","Property Developer","Property Developer","Agent","Word of Mouth","Property Developer","Property Developer","Word of Mouth","Property Developer","Website","Property Developer","Website","Property Developer","Property Developer","Website","Word of Mouth","Property Developer","Property Developer","Property Developer","Property Developer","Website","Property Developer","Website","Agent","Website","Property Developer","Agent","Website","Word of Mouth","Website","Property Developer","Word of Mouth","Word of Mouth","Website","Property Developer","Agent","Website","Agent","Property Developer","Property Developer","Property Developer","Property Developer","Website","Agent","Property Developer","Website","Website","Website","Property Developer","Website","Property Developer","Agent","Property Developer","Website","Website","Agent","Word of Mouth","Property Developer"]],"displayName":"Channel","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Leads,B:B;)","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":"Channel","id":"5c7d0e8a"}],"displayName":"Lead","id":"71d1a962","type":"table","dstContext":{"ops":[],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst71d1a962"},"renamed":true},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[[1.5941304E9,1.5829812E9,1.6036308E9,1.617804E9,1.58445E9,1.5973272E9,1.5905016E9,1.5959448E9,1.6134804E9,1.617282E9,1.5925752E9,1.5916248E9,1.6098516E9,1.5987096E9,1.5876504E9,1.5980184E9,1.6046676E9,1.5946488E9,1.6120116E9,1.6048404E9,1.6124436E9,1.5886872E9,1.612962E9,1.5906744E9,1.5703668E9,1.6001784E9,1.606482E9,1.6011288E9,1.582722E9,1.5861816E9,1.5892056E9,1.5760692E9,1.5879096E9,1.6171956E9,1.5836724E9,1.589292E9,1.5924024E9,1.5728724E9,1.5769332E9,1.6057044E9,1.581858E9,1.585746E9,1.5813396E9,1.5978456E9,1.595772E9,1.5709716E9,1.6033716E9,1.5998328E9,1.6136532E9,1.5838452E9,1.6052724E9,1.6022484E9,1.5716628E9,1.6113204E9,1.617282E9,1.5902424E9,1.607346E9,1.5956856E9,1.6075188E9,1.5734772E9,1.6149492E9,1.5968952E9,1.5958584E9,1.6158132E9,1.5905016E9,1.6098516E9,1.585746E9,1.6161588E9,1.5981048E9,1.6179768E9,1.5991416E9,1.5847092E9,1.5869592E9,1.5854868E9,1.6046676E9,1.5876504E9,1.5968952E9,1.5781428E9,1.5765876E9,1.5763284E9,1.5837588E9,1.61469E9,1.5990552E9,1.6063956E9,1.602594E9,1.5886008E9,1.5756372E9,1.6041492E9,1.6109748E9,1.599228E9,1.615986E9,1.5961176E9,1.5932664E9,1.576674E9,1.5972408E9,1.5804756E9,1.599228E9,1.5759828E9,1.5981048E9,""]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(05eb33644786b6d75770879750fc0fde@Sales,A:A;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"d27ff10c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Oct 2020","Sep 2020","Feb 2021","Jul 2020","Oct 2020","Feb 2021","Mar 2021","Sep 2020","Apr 2021","Dec 2020","Dec 2020","Aug 2020","Mar 2021","May 2020","Aug 2020","Jun 2020","Oct 2020","Apr 2020","Feb 2021","Nov 2020","Oct 2020","Oct 2020","Feb 2021","Feb 2021","Jul 2020","Mar 2021","May 2020","Sep 2020","Dec 2020","May 2020","Jan 2021","Dec 2020","Aug 2020","Feb 2021","Feb 2021","Apr 2020","Jan 2021","Jan 2021","Aug 2020","Mar 2021","May 2020","Jun 2020","Jan 2021","Mar 2021","Aug 2020","May 2020","Jan 2021","Sep 2020","Jul 2020","Sep 2020","Nov 2020","May 2020","Dec 2020","Sep 2020","May 2020","Jul 2020","May 2020","Oct 2020","Dec 2020","May 2020","Aug 2020","Feb 2021","Apr 2021","Oct 2020","Dec 2020","Sep 2020","Mar 2021","May 2020","Apr 2021","Mar 2021","May 2020","Dec 2020","Aug 2020","Oct 2020","Jun 2020","Mar 2021","Mar 2021","Feb 2021","May 2020","Mar 2021","Apr 2020","Jan 2021","Aug 2020","May 2020","Mar 2021","Apr 2020","Mar 2021","Sep 2020","Jul 2020","Mar 2021","Nov 2020","Nov 2020","Sep 2020","Mar 2021","Sep 2020","Nov 2020","Jan 2021","Feb 2021","Aug 2020","Dec 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'4ace65c6',\"d MMM yyyy\"),\"m\",DATEVALUE(!'4ace65c6',\"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":{},"defaultAggregate":"COUNT","fmt":"txt"}},"dateInputFormatCustom":"d MMMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMMM yyyy","dateInputFormat":"custom"},"name":"Date","id":"082139dc"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Agent","Property Developer","Property Developer","Agent","Property Developer","Property Developer","Agent","Property Developer","Agent","Agent","Website","Agent","Website","Property Developer","Website","Website","Agent","Word of Mouth","Word of Mouth","Word of Mouth","Word of Mouth","Agent","Word of Mouth","Website","Website","Agent","Word of Mouth","Agent","Website","Agent","Website","Property Developer","Website","Agent","Website","Website","Website","Agent","Property Developer","Property Developer","Property Developer","Website","Agent","Word of Mouth","Website","Website","Agent","Word of Mouth","Website","Website","Agent","Word of Mouth","Website","Agent","Property Developer","Agent","Property Developer","Property Developer","Property Developer","Word of Mouth","Property Developer","Property Developer","Word of Mouth","Website","Agent","Agent","Word of Mouth","Property Developer","Word of Mouth","Website","Agent","Word of Mouth","Agent","Property Developer","Word of Mouth","Website","Property Developer","Word of Mouth","Agent","Website","Website","Website","Website","Property Developer","Word of Mouth","Property Developer","Website","Property Developer","Website","Website","Property Developer","Website","Agent","Property Developer","Website","Word of Mouth","Agent","Agent","Property Developer",""]],"displayName":"Channel","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Sales,D:D;)","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":"Channel","id":"7a38dd7b"}],"displayName":"Sale","id":"0e3c8a2b","type":"table","dstContext":{"ops":[],"kid":"598a59e75455738ab554f593d0ff9ada","id":"dst0e3c8a2b"},"renamed":true}],"isForked":false,"id":"4d973438145ed7715186e268eb80f0f1","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Conversion Rate","usesSampleData":false,"master":"598a59e75455738ab554f593d0ff9ada"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":1104.0}},"components":[{"size":"large","data":[["CONSTRUCTION - SALES / MARKETING / ESTIMATING"]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"CONSTRUCTION - SALES / MARKETING / ESTIMATING\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"2f3cb5bf","type":"label","fmt":"txt","dstContext":{"kid":"16aecfb186fe176d95dcd72b651d08e2","id":"dst2f3cb5bf"},"align":"c","wrap":true}],"isForked":false,"id":"3672fadc04befc39732b0bc8e661aeb0","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"16aecfb186fe176d95dcd72b651d08e2"},{"workspace":{"datasources":["773a7b4b52bcff4e6d67acb50b26c8a6","c7111b5ac1f526e9be25f3ed809f7877","05eb33644786b6d75770879750fc0fde"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["Displays the total number and value of projects won by lead source. This allows us to see which lead sources account for the majority of projects and revenue."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Displays the total number and value of projects won by lead source. This allows us to see which lead sources account for the majority of projects and revenue.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"1f47adff","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"f8c0e451d66d37c7a8f30b6e0479a6a5","id":"dst1f47adff"},"wrap":true},{"components":[{"data":[["Total Number of Projects by Source"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Total Number of Projects by Source\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"f8c0e451d66d37c7a8f30b6e0479a6a5","id":"dst365081ea"},"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":"365081ea","wrap":true},{"data":[["Total Project Value by Source"]],"displayName":"Label 2","formulas":[{"txt":"\"Total Project Value by Source\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"f8c0e451d66d37c7a8f30b6e0479a6a5","id":"dst76090e83"},"align":"c","layoutConfig":{"x":1.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"76090e83","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"data","data":[[6.0,4.0,6.0,3.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"}},"precision":"0"},"formulas":[{"txt":"LOOKUP(&'1ca719ed',GROUP(SELECT(&'c90770a5',BETWEEN(&'af179082',$dateStart,$dateEnd))),GROUPBY(SELECT(&'c90770a5',BETWEEN(&'af179082',$dateStart,$dateEnd)),SELECT(&'0e3d74ef',BETWEEN(&'af179082',$dateStart,$dateEnd)),\"count(values)\"))","ver":2.0}],"autoFmt":false,"id":"7f253db3","type":"series_data","fmt":"num"},{"role":"labels","data":[["Agent","Property Developer","Website","Word of Mouth"]],"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(&'c90770a5')","ver":2.0}],"autoFmt":true,"id":"1ca719ed","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["cx-theme_orange_2","cx-theme_green_2","cx-theme_blue_2","cx-theme_violet_1","cx-theme_violet_3","cx-theme_brown_3","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart Copy","pie_style":"circle","id":"1ca80f61","type":"chart_pie","dstContext":{"kid":"f8c0e451d66d37c7a8f30b6e0479a6a5","id":"dst1ca80f61"},"overrideColors":true,"legend_percentages":"0"},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"role":"data","data":[[1065271.0,539070.0,913339.0,376611.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":"LOOKUP(&'bd242a60',GROUP(SELECT(&'c90770a5',BETWEEN(&'af179082',$dateStart,$dateEnd))),GROUPBY(SELECT(&'c90770a5',BETWEEN(&'af179082',$dateStart,$dateEnd)),SELECT(&'0e3d74ef',BETWEEN(&'af179082',$dateStart,$dateEnd)),\"sum(values)\"))","ver":2.0}],"autoFmt":false,"id":"f2b5005d","type":"series_data","fmt":"cur"},{"role":"labels","data":[["Agent","Property Developer","Website","Word of Mouth"]],"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(&'c90770a5')","ver":2.0}],"autoFmt":true,"id":"bd242a60","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["cx-theme_orange_2","cx-theme_green_2","cx-theme_blue_2","cx-theme_violet_1","cx-theme_violet_3","cx-theme_brown_3","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart","id":"fec99182","type":"chart_pie","dstContext":{"kid":"f8c0e451d66d37c7a8f30b6e0479a6a5","id":"dstfec99182"},"overrideColors":true,"legend_percentages":"0"}],"displayName":"Layout Grid","id":"e8a118cf","cellData":[{"x":1.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":1.0,"alignment":1.0}],"type":"panel_grid","rows":2.0,"cols":2.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["1594130400","1582981200","1603630800","1617804000","1584450000","1597327200","1590501600","1595944800","1613480400","1617282000","1592575200","1591624800","1609851600","1598709600","1587650400","1598018400","1604667600","1594648800","1612011600","1604840400","1612443600","1588687200","1612962000","1590674400","1570366800","1600178400","1606482000","1601128800","1582722000","1586181600","1589205600","1576069200","1587909600","1617195600","1583672400","1589292000","1592402400","1572872400","1576933200","1605704400","1581858000","1585746000","1581339600","1597845600","1595772000","1570971600","1603371600","1599832800","1613653200","1583845200","1605272400","1602248400","1571662800","1611320400","1617282000","1590242400","1607346000","1595685600","1607518800","1573477200","1614949200","1596895200","1595858400","1615813200","1590501600","1609851600","1585746000","1616158800","1598104800","1617976800","1599141600","1584709200","1586959200","1585486800","1604667600","1587650400","1596895200","1578142800","1576587600","1576328400","1583758800","1614690000","1599055200","1606395600","1602594000","1588600800","1575637200","1604149200","1610974800","1599228000","1615986000","1596117600","1593266400","1576674000","1597240800","1580475600","1599228000","1575982800","1598104800"]],"displayName":"Date_Raw_Start","formulas":[{"txt":"date(slice(05eb33644786b6d75770879750fc0fde@Sales,A:A;),\"yyyy/MM/dd\")","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"name":"Date_Raw_Start","id":"af179082"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jul 2020","Mar 2020","Oct 2020","Apr 2021","Mar 2020","Aug 2020","May 2020","Jul 2020","Feb 2021","Apr 2021","Jun 2020","Jun 2020","Jan 2021","Aug 2020","Apr 2020","Aug 2020","Nov 2020","Jul 2020","Jan 2021","Nov 2020","Feb 2021","May 2020","Feb 2021","May 2020","Oct 2019","Sep 2020","Nov 2020","Sep 2020","Feb 2020","Apr 2020","May 2020","Dec 2019","Apr 2020","Apr 2021","Mar 2020","May 2020","Jun 2020","Nov 2019","Dec 2019","Nov 2020","Feb 2020","Apr 2020","Feb 2020","Aug 2020","Jul 2020","Oct 2019","Oct 2020","Sep 2020","Feb 2021","Mar 2020","Nov 2020","Oct 2020","Oct 2019","Jan 2021","Apr 2021","May 2020","Dec 2020","Jul 2020","Dec 2020","Nov 2019","Mar 2021","Aug 2020","Jul 2020","Mar 2021","May 2020","Jan 2021","Apr 2020","Mar 2021","Aug 2020","Apr 2021","Sep 2020","Mar 2020","Apr 2020","Mar 2020","Nov 2020","Apr 2020","Aug 2020","Jan 2020","Dec 2019","Dec 2019","Mar 2020","Mar 2021","Sep 2020","Nov 2020","Oct 2020","May 2020","Dec 2019","Nov 2020","Jan 2021","Sep 2020","Mar 2021","Jul 2020","Jun 2020","Dec 2019","Aug 2020","Feb 2020","Sep 2020","Dec 2019","Aug 2020"]],"displayName":"Date_Start","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(&'af179082',\"d MMM yyyy\"),\"m\",DATEVALUE(&'af179082',\"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_Start","id":"4fe31c15"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Agent","Property Developer","Property Developer","Agent","Property Developer","Property Developer","Agent","Property Developer","Agent","Agent","Website","Agent","Website","Property Developer","Website","Website","Agent","Word of Mouth","Word of Mouth","Word of Mouth","Word of Mouth","Agent","Word of Mouth","Website","Website","Agent","Word of Mouth","Agent","Website","Agent","Website","Property Developer","Website","Agent","Website","Website","Website","Agent","Property Developer","Property Developer","Property Developer","Website","Agent","Word of Mouth","Website","Website","Agent","Word of Mouth","Website","Website","Agent","Word of Mouth","Website","Agent","Property Developer","Agent","Property Developer","Property Developer","Property Developer","Word of Mouth","Property Developer","Property Developer","Word of Mouth","Website","Agent","Agent","Word of Mouth","Property Developer","Word of Mouth","Website","Agent","Word of Mouth","Agent","Property Developer","Word of Mouth","Website","Property Developer","Word of Mouth","Agent","Website","Website","Website","Website","Property Developer","Word of Mouth","Property Developer","Website","Property Developer","Website","Website","Property Developer","Website","Agent","Property Developer","Website","Word of Mouth","Agent","Agent","Property Developer"]],"displayName":"Type","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Sales,D:D;)","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":"c90770a5"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["177252","189222","178776","114600","54168","168216","187070","170105","276159","133610","156715","75600","112563","158951","214149","103807","67606","143700","114470","188870","129701","64009","132440","177411","218664","207564","211926","172400","65150","203832","177100","165143","147279","163086","182490","249600","96694","88127","96404","192159","117888","168280","165971","64164","192192","93938","131208","90530","138193","137616","159024","116844","121043","228876","76450","126680","97253","182930","135380","104120","127680","138788","201513","166368","45310","148940","125801","138810","71028","160060","130221","71520","131340","207276","87270","181246","62238","122496","108840","56760","182884","252148","73464","61110","199045","91680","160248","215660","84007","208546","196130","72816","73160","201019","162660","142680","184704","118888","198210"]],"displayName":"Value","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Sales,C:C;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Value","id":"0e3d74ef"}],"displayName":"Table","id":"29e30159","type":"table","dstContext":{"ops":[],"kid":"f8c0e451d66d37c7a8f30b6e0479a6a5","id":"dst29e30159"}}],"isForked":false,"id":"3e28950102efd2b3575bc78b6b7e6e6c","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Projects Won by Source","usesSampleData":false,"master":"f8c0e451d66d37c7a8f30b6e0479a6a5"},{"workspace":{"datasources":["e81016948df440cd06e1fcdc846f01b9","d98626e5c469c95e0374d45ff0b5da2a","773a7b4b52bcff4e6d67acb50b26c8a6","a2d75942456c71f47060d9f50d075fd4","b34d001a86e63a2f279fc461c52cca1f","c7111b5ac1f526e9be25f3ed809f7877","05eb33644786b6d75770879750fc0fde"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["This displays the number of leads added by source, both over time and in total."]],"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 the number of leads added by source, both over time and in total.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"433988e9","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"71b49163b2c145463c8caf6d840182dd","id":"dst433988e9"},"wrap":true},{"components":[{"data":[["Leads by Source Over Time"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Leads by Source Over Time\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"71b49163b2c145463c8caf6d840182dd","id":"dstb229938a"},"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":"b229938a","wrap":true},{"data":[["Total Leads by Source"]],"displayName":"Label 2","formulas":[{"txt":"\"Total Leads by Source\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"71b49163b2c145463c8caf6d840182dd","id":"dst2d47dfd6"},"align":"c","layoutConfig":{"x":2.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":"2d47dfd6","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"series","data":[[7.0,5.0,5.0,8.0,3.0]],"color":"cx-theme_orange_2","displayName":"Agent","seriesName":"Agent","formulas":[{"txt":"lookup(&'18b9381e',group(SELECT(&'713effeb',&'317419d2'=\"Agent\")),groupby(SELECT(&'713effeb',&'317419d2'=\"Agent\"),SELECT(&'317419d2',&'317419d2'=\"Agent\"),\"count(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"c5340c9e","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"6cd79e66"},{"role":"series","data":[[12.0,9.0,9.0,14.0,3.0]],"color":"cx-theme_green_2","displayName":"Property Developer","seriesName":"Property Developer","formulas":[{"txt":"lookup(&'18b9381e',group(SELECT(&'713effeb',&'317419d2'=\"Property Developer\")),groupby(SELECT(&'713effeb',&'317419d2'=\"Property Developer\"),SELECT(&'317419d2',&'317419d2'=\"Property Developer\"),\"count(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"c5340c9e","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"ae1ab0e3"},{"role":"series","data":[["",4.0,5.0,1.0,2.0]],"color":"cx-theme_violet_1","displayName":"Word of Mouth","seriesName":"Word of Mouth","formulas":[{"txt":"lookup(&'18b9381e',group(SELECT(&'713effeb',&'317419d2'=\"Word of Mouth\")),groupby(SELECT(&'713effeb',&'317419d2'=\"Word of Mouth\"),SELECT(&'317419d2',&'317419d2'=\"Word of Mouth\"),\"count(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"c5340c9e","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"e799cc2d"},{"role":"series","data":[[11.0,13.0,8.0,14.0,6.0]],"color":"cx-theme_blue_2","displayName":"Website","seriesName":"Website","formulas":[{"txt":"lookup(&'18b9381e',group(SELECT(&'713effeb',&'317419d2'=\"Website\")),groupby(SELECT(&'713effeb',&'317419d2'=\"Website\"),SELECT(&'317419d2',&'317419d2'=\"Website\"),\"count(values)\"))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"c5340c9e","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"28c7ef39"},{"renderer":"line","showValues":true,"role":"series","data":[[30.0,31.0,27.0,37.0,14.0]],"color":"cx-theme_warm_gray_3","displayName":"Total","seriesName":"Total","formulas":[{"txt":"&'6cd79e66'+&'ae1ab0e3'+&'e799cc2d'+&'28c7ef39'","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"c5340c9e","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"1d6046fd"},{"role":"axis_x","data":[["Dec 2020","Jan 2021","Feb 2021","Mar 2021","Apr 2021"]],"displayName":"Untitled","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(DATERANGE($dateStart,$dateEnd),\"d MMM yyyy\"),\"m\",DATEVALUE(GROUP(DATE_STARTOF(DATERANGE($dateStart,$dateEnd),\"3\")),\"MMM yyyy\"))","ver":2.0}],"autoFmt":true,"id":"18b9381e","label":"Untitled","type":"chart_axis","fmt":"txt","labelDrop":0.0,"showLabelTicks":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"id":"c5340c9e","labelDrop":0.0,"renamed":true},{"customRange":true,"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Perc","formulas":[],"autoFmt":true,"axisPosition":"right","label":"Perc","type":"chart_axis","fmt":"pct","min":"0","id":"6b235c41","labelDrop":0.0,"renamed":true}],"stackAreas":"1","displayName":"Bar/Line Chart","id":"6727f449","type":"chart_series","dstContext":{"kid":"71b49163b2c145463c8caf6d840182dd","id":"dst6727f449"},"stackBars":"1"},{"layoutConfig":{"x":2.0,"y":1.0},"components":[{"role":"data","data":[[28.0,47.0,12.0,52.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"}},"precision":"0"},"formulas":[{"txt":"ARRAY(sum(&'6cd79e66'),sum(&'ae1ab0e3'),sum(&'e799cc2d'),sum(&'28c7ef39'))","ver":2.0}],"autoFmt":false,"id":"8c070f86","type":"series_data","fmt":"num"},{"role":"labels","data":[["Agent","Property Developer","Word of Mouth","Website"]],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"ARRAY(\"Agent\",\"Property Developer\",\"Word of Mouth\",\"Website\")","ver":2.0}],"autoFmt":true,"id":"69eeced4","type":"series_labels","fmt":"txt"}],"size":2.0,"sliceColors":["cx-theme_orange_2","cx-theme_green_2","cx-theme_violet_1","cx-theme_blue_2","cx-theme_red_1","cx-theme_brown_3","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart","pie_style":"circle","id":"52a31682","type":"chart_pie","dstContext":{"kid":"71b49163b2c145463c8caf6d840182dd","id":"dst52a31682"},"overrideColors":true}],"displayName":"Layout Grid 2","id":"46250177","cellData":[{"w":2.0,"x":0.0,"y":0.0},{"w":2.0,"x":0.0,"y":1.0}],"type":"panel_grid","rows":2.0,"cols":3.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Oct 17, 2020","Sep 24, 2020","Feb 3, 2021","Jul 16, 2020","Oct 12, 2020","Feb 3, 2021","Mar 22, 2021","Sep 2, 2020","Apr 11, 2021","Dec 23, 2020","Dec 5, 2020","Aug 4, 2020","Mar 12, 2021","May 3, 2020","Aug 12, 2020","Jun 2, 2020","Oct 16, 2020","Apr 21, 2020","Feb 27, 2021","Nov 29, 2020","Oct 31, 2020","Oct 18, 2020","Feb 10, 2021","Feb 6, 2021","Jul 30, 2020","Mar 8, 2021","May 7, 2020","Sep 16, 2020","Dec 14, 2020","May 28, 2020","Jan 15, 2021","Dec 24, 2020","Aug 15, 2020","Feb 23, 2021","Feb 8, 2021","Apr 18, 2020","Jan 7, 2021","Jan 23, 2021","Aug 28, 2020","Mar 6, 2021","May 12, 2020","Jun 15, 2020","Jan 11, 2021","Mar 11, 2021","Aug 29, 2020","May 14, 2020","Jan 22, 2021","Sep 10, 2020","Jul 1, 2020","Sep 14, 2020","Nov 12, 2020","May 30, 2020","Dec 11, 2020","Sep 7, 2020","May 15, 2020","Jul 27, 2020","May 31, 2020","Oct 7, 2020","Dec 11, 2020","May 27, 2020","Aug 18, 2020","Feb 15, 2021","Apr 3, 2021","Oct 27, 2020","Dec 12, 2020","Sep 24, 2020","Mar 21, 2021","May 31, 2020","Apr 4, 2021","Mar 10, 2021","May 16, 2020","Dec 12, 2020","Aug 6, 2020","Oct 3, 2020","Jun 30, 2020","Mar 16, 2021","Mar 19, 2021","Feb 13, 2021","May 4, 2020","Mar 4, 2021","Apr 27, 2020","Jan 12, 2021","Aug 24, 2020","May 22, 2020","Mar 17, 2021","Apr 22, 2020","Mar 20, 2021","Sep 27, 2020","Jul 17, 2020","Mar 25, 2021","Nov 28, 2020","Nov 4, 2020","Sep 19, 2020","Mar 20, 2021","Sep 10, 2020","Nov 24, 2020","Jan 18, 2021","Feb 17, 2021","Aug 5, 2020","Dec 15, 2020"]],"displayName":"Date_Raw","formulas":[{"txt":"slice(date(05eb33644786b6d75770879750fc0fde@Leads,A:A;,\"yyyy/MM/dd\"))","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Raw","id":"cea330d0"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Oct 2020","Sep 2020","Feb 2021","Jul 2020","Oct 2020","Feb 2021","Mar 2021","Sep 2020","Apr 2021","Dec 2020","Dec 2020","Aug 2020","Mar 2021","May 2020","Aug 2020","Jun 2020","Oct 2020","Apr 2020","Feb 2021","Nov 2020","Oct 2020","Oct 2020","Feb 2021","Feb 2021","Jul 2020","Mar 2021","May 2020","Sep 2020","Dec 2020","May 2020","Jan 2021","Dec 2020","Aug 2020","Feb 2021","Feb 2021","Apr 2020","Jan 2021","Jan 2021","Aug 2020","Mar 2021","May 2020","Jun 2020","Jan 2021","Mar 2021","Aug 2020","May 2020","Jan 2021","Sep 2020","Jul 2020","Sep 2020","Nov 2020","May 2020","Dec 2020","Sep 2020","May 2020","Jul 2020","May 2020","Oct 2020","Dec 2020","May 2020","Aug 2020","Feb 2021","Apr 2021","Oct 2020","Dec 2020","Sep 2020","Mar 2021","May 2020","Apr 2021","Mar 2021","May 2020","Dec 2020","Aug 2020","Oct 2020","Jun 2020","Mar 2021","Mar 2021","Feb 2021","May 2020","Mar 2021","Apr 2020","Jan 2021","Aug 2020","May 2020","Mar 2021","Apr 2020","Mar 2021","Sep 2020","Jul 2020","Mar 2021","Nov 2020","Nov 2020","Sep 2020","Mar 2021","Sep 2020","Nov 2020","Jan 2021","Feb 2021","Aug 2020","Dec 2020"]],"displayName":"Date","formulas":[{"txt":"SWITCH($dateGroup,\"d\",DATEVALUE(!'cea330d0',\"d MMM yyyy\"),\"m\",DATEVALUE(!'cea330d0',\"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":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateInputFormatCustom":"d MMMM yyyy","dateFormat":"custom","dateFormatCustom":"d MMMM yyyy","dateInputFormat":"custom"},"name":"Date","id":"713effeb"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Property Developer","Website","Agent","Property Developer","Property Developer","Website","Property Developer","Website","Word of Mouth","Property Developer","Agent","Property Developer","Property Developer","Website","Agent","Agent","Agent","Property Developer","Property Developer","Website","Agent","Website","Word of Mouth","Word of Mouth","Property Developer","Website","Property Developer","Word of Mouth","Website","Website","Agent","Agent","Agent","Website","Word of Mouth","Website","Website","Agent","Agent","Website","Website","Word of Mouth","Property Developer","Property Developer","Property Developer","Agent","Word of Mouth","Property Developer","Property Developer","Word of Mouth","Property Developer","Website","Property Developer","Website","Property Developer","Property Developer","Website","Word of Mouth","Property Developer","Property Developer","Property Developer","Property Developer","Website","Property Developer","Website","Agent","Website","Property Developer","Agent","Website","Word of Mouth","Website","Property Developer","Word of Mouth","Word of Mouth","Website","Property Developer","Agent","Website","Agent","Property Developer","Property Developer","Property Developer","Property Developer","Website","Agent","Property Developer","Website","Website","Website","Property Developer","Website","Property Developer","Agent","Property Developer","Website","Website","Agent","Word of Mouth","Property Developer"]],"displayName":"Channel","formulas":[{"txt":"slice(05eb33644786b6d75770879750fc0fde@Leads,B:B;)","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Channel","id":"317419d2"}],"displayName":"Table","id":"cd27301d","type":"table","dstContext":{"ops":[],"kid":"71b49163b2c145463c8caf6d840182dd","id":"dstcd27301d"}}],"isForked":false,"id":"751673c8cb7979ed2ccc054f3b0f8c64","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Leads by Source","usesSampleData":false,"master":"71b49163b2c145463c8caf6d840182dd"},{"workspace":{"datasources":["773a7b4b52bcff4e6d67acb50b26c8a6","05eb33644786b6d75770879750fc0fde"],"dimensions":{"w":1540.0}},"components":[{"size":"xx-small","data":[["A list displayimg all projects won in that selected period. This gives an overview of which projects have recently been won."]],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"A list displayimg all projects won in that selected period. This gives an overview of which projects have recently been won.\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"afd4980a","font_style":"italic","type":"label","fmt":"txt","dstContext":{"kid":"035baac70639d50afabad0b8ed108180","id":"dstafd4980a"},"wrap":true},{"components":[{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[["Jan 6, 2021","Jan 6, 2021","Jan 19, 2021","Jan 23, 2021","Jan 31, 2021","Feb 5, 2021","Feb 11, 2021","Feb 17, 2021","Feb 19, 2021","Mar 3, 2021","Mar 6, 2021","Mar 16, 2021","Mar 18, 2021","Mar 20, 2021","Apr 1, 2021","Apr 2, 2021","Apr 2, 2021","Apr 8, 2021","Apr 10, 2021"]],"displayName":"Date_Won","formulas":[{"txt":"date(slice(05eb33644786b6d75770879750fc0fde@Projects,A:A;),\"yyyy/MM/dd\")","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"name":"Date_Won","id":"b7da83ce-34"},{"components":[{"role":"customHeader","data":[["Project"]],"displayName":"Project","formulas":[{"txt":"\"Project\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"035baac70639d50afabad0b8ed108180","id":"dst76cbc8d938"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"76cbc8d9-38","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_666"}]}]}],"customHeader":true,"role":"tcol","data":[["Project 13","Project 66","Project 89","Project 54","Project 19","Project 21","Project 23","Project 9","Project 49","Project 82","Project 61","Project 64","Project 91","Project 68","Project 34","Project 10","Project 55","Project 4","Project 70"]],"displayName":"Project","formulas":[{"txt":"SLICE(05eb33644786b6d75770879750fc0fde@Projects,B:B;)","ver":2.0}],"autoFmt":true,"index":1.0,"type":"table_col","fmt":"txt","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Project","id":"1d8a5c5b-37"},{"components":[{"role":"customHeader","data":[["Won Date"]],"displayName":"Start Date","formulas":[{"txt":"\"Won Date\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"035baac70639d50afabad0b8ed108180","id":"dstd8d627bc41"},"align":"c","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"d8d627bc-41","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_666"}]}]}],"customHeader":true,"role":"tcol","data":[["6 Jan 2021","6 Jan 2021","19 Jan 2021","23 Jan 2021","31 Jan 2021","5 Feb 2021","11 Feb 2021","17 Feb 2021","19 Feb 2021","3 Mar 2021","6 Mar 2021","16 Mar 2021","18 Mar 2021","20 Mar 2021","1 Apr 2021","2 Apr 2021","2 Apr 2021","8 Apr 2021","10 Apr 2021"]],"displayName":"Start Date","formulas":[{"txt":"SLICE(05eb33644786b6d75770879750fc0fde@Projects,A:A;)","ver":2.0}],"autoFmt":true,"index":2.0,"type":"table_col","fmt":"dat2","align":"c","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"d MMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Start Date","id":"1e6423dd-40"},{"components":[{"role":"customHeader","data":[["Estimated Cost"]],"displayName":"Estimated Cost","formulas":[{"txt":"\"Estimated Cost\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"035baac70639d50afabad0b8ed108180","id":"dst2e9eefe147"},"align":"c","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"2e9eefe1-47","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_666"}]}]}],"customHeader":true,"role":"tcol","data":[[102330.0,148940.0,76370.0,190730.0,114470.0,99770.0,120400.0,212430.0,125630.0,193960.0,106400.0,138640.0,178300.0,138810.0,148260.0,133610.0,76450.0,114600.0,160060.0]],"displayName":"Estimated Cost","formulas":[{"txt":"SLICE(05eb33644786b6d75770879750fc0fde@Projects,F:F;)+SLICE(05eb33644786b6d75770879750fc0fde@Projects,J:J;)+SLICE(05eb33644786b6d75770879750fc0fde@Projects,N:N;)+SLICE(05eb33644786b6d75770879750fc0fde@Projects,R:R;)","ver":2.0}],"autoFmt":false,"index":3.0,"type":"table_col","fmt":"cur","align":"c","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"precision":"0"},"name":"Estimated Cost","id":"8977212c-46"},{"components":[{"role":"customHeader","data":[["End Date"]],"displayName":"End Date","formulas":[{"txt":"\"End Date\"","ver":2.0}],"font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"035baac70639d50afabad0b8ed108180","id":"dst9bab3a0844"},"align":"c","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"9bab3a08-44","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"color","value":"cx-theme_fff","isScalar":true},{"type":"background-color","isScalar":true,"value":"cx-bgcolor_666"}]}]}],"customHeader":true,"role":"tcol","data":[["4 May 2021","24 Apr 2021","11 May 2021","4 Jun 2021","12 Jun 2021","1 Jul 2021","25 May 2021","14 Jun 2021","17 Jun 2021","3 Jul 2021","11 Jul 2021","21 Jun 2021","12 Jun 2021","19 Aug 2021","22 Jul 2021","20 Jul 2021","5 Aug 2021","24 Aug 2021","17 Aug 2021"]],"displayName":"End Date","formulas":[{"txt":"SLICE(05eb33644786b6d75770879750fc0fde@Projects,S:S;)","ver":2.0}],"autoFmt":true,"index":4.0,"type":"table_col","fmt":"dat2","align":"c","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateFormatCustom":"d MMM yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy/M/d","dateFormat":"custom","dateFormatCustom":"d MMM yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"End Date","id":"2648b3d1-43"}],"maxRows":"10","displayName":"Table 2","id":"70d9baa4-33","type":"table","dstContext":{"ops":[{"p":{"args":[{"op":">=","dim":"b7da83ce34","type":"op","value":{"var":"dateStart"},"valueFmt":{"type":"EPOCH"}},{"op":"<=","dim":"b7da83ce34","type":"op","value":{"var":"dateEnd"},"valueFmt":{"type":"EPOCH"}}],"f":"and","type":"f"},"displayName":"Multiple Conditions","type":"filter","filterBy":"b7da83ce34","variation":"condition"},{"sortBy":[{"dim":"1e6423dd40","dir":1.0}],"type":"sort"}],"kid":"035baac70639d50afabad0b8ed108180","id":"dst70d9baa433"}}],"displayName":"Layout Grid","widths":[{"w":"10%","x":0.0},{"w":"10%","x":2.0}],"id":"1e427cad-25","cellData":[{"x":0.0,"y":0.0},{"x":2.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":3.0}],"isForked":false,"id":"1b0e9098b907e54acdd78b960eed7fc4","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Projects Win List","usesSampleData":false,"master":"035baac70639d50afabad0b8ed108180"},{"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":"aba594a055fa59b1f3dc93bf130de080","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Logo","usesSampleData":false,"master":"685ef16df9cbec639ecf20b110cf9882"}]}]