","components":[{"role":"data","data":[["2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020","2020"]],"displayName":"year","formulas":[{"txt":"SLICE(0142c8f6f3b226ef0670d311c2a8e386@Blad1,A:A;)","ver":2.0}],"autoFmt":false,"type":"html_data","fmt":"txt","dstContext":{"kid":"f5f5facbda8a722acdde725dbbafad47","id":"dstd264074f"},"mixin":"label","dataId":"year","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"isDstRoot":true,"id":"d264074f","renamed":true},{"role":"data","data":[["5","5","10","10","15","15","20","20","25","25","30","30","35","35","40","40","45","45","50","50","55","55","60","60","65","65","70","70","75","75","80","80"]],"displayName":"age","formulas":[{"txt":"SLICE(0142c8f6f3b226ef0670d311c2a8e386@Blad1,B:B;)","ver":2.0}],"autoFmt":false,"type":"html_data","fmt":"txt","dstContext":{"kid":"f5f5facbda8a722acdde725dbbafad47","id":"dst94e3043c"},"mixin":"label","dataId":"age","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"isDstRoot":true,"id":"94e3043c","renamed":true},{"role":"data","data":[["1","2","1","2","1","2","1","2","1","2","1","2","1","2","1","2","1","2","1","2","1","2","1","2","1","2","1","2","1","2","1","2"]],"displayName":"sex","formulas":[{"txt":"SLICE(0142c8f6f3b226ef0670d311c2a8e386@Blad1,C:C;)","ver":2.0}],"autoFmt":false,"type":"html_data","fmt":"txt","dstContext":{"kid":"f5f5facbda8a722acdde725dbbafad47","id":"dst8399c83b"},"mixin":"label","dataId":"sex","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"isDstRoot":true,"id":"8399c83b","renamed":true},{"role":"data","data":[["1388","1807","7025","6371","6699","4757","10856","10794","11483","11143","10436","9096","9968","8894","7957","7983","7367","6693","3315","3470","2292","2314","1128","1153","936","828","550","597","332","266","227","138"]],"displayName":"people","formulas":[{"txt":"SLICE(0142c8f6f3b226ef0670d311c2a8e386@Blad1,D:D;)","ver":2.0}],"autoFmt":false,"type":"html_data","fmt":"txt","dstContext":{"kid":"f5f5facbda8a722acdde725dbbafad47","id":"dstbcdad08b"},"mixin":"label","dataId":"people","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"isDstRoot":true,"id":"bcdad08b","renamed":true}],"displayName":"HTML Template","id":"ad9a4cce","script_tpl":"//Define%20the%20path%20configurations%20to%20the%20JS%20modules%20that%20you%20want%20to%20load%0A//In%20this%20example%20we%20are%20loading%20D3,%20topojson%20(used%20by%20Vega)%20and%20Vega%20%20%0A//Note:%20URLs%20have%20to%20be%20HTTPS%20due%20to%20browser%20security%20restrictions%20%0A%0Avar%20vizmodules%20=%20%7B%0A%20%20%20%20d3%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20:%20'https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min.js?noext',%0A%20%20%20%20topojson%20%20%20%20%20%20%20%20%20:%20'https://cdnjs.cloudflare.com/ajax/libs/topojson/1.6.19/topojson.min.js?noext',%0A%20%20%20%20vega%20%20%20%20%20%20%20%20%20%20%20%20%20:%20'https://cdnjs.cloudflare.com/ajax/libs/vega/1.5.0/vega.min.js?noext'%0A%7D;%0A%0A//Pass%20in%20the%20configurations%20to%20requirejs%20%20%0Arequirejs.config(%7B%0A%20%20%20%20paths:%20vizmodules%0A%7D);%0A%0A//Create%20a%20reference%20to%20the%20component%20%0Avar%20_component%20=%20this;%0A%0A//Create%20a%20reference%20to%20the%20data%20model%20%0Avar%20_dataModel%20=%20this.dataModel;%0A%0A%0A//Load%20the%20libraries%20%0Arequire(%5Bvizmodules.vega%5D,%20%0Afunction(vg)%20%7B%20//%20the%20callback%20function%20that%20is%20called%20after%20the%20libraries%20are%20loaded%0Aconsole.log('hoi');%0A%0Avar%20_data%20=%20%5B%5D;%20%20%0A%0A//%20use%20the%20dataModel%20and%20convert%20the%20string%20to%20numbers%20%0A_.each(_dataModel.data,%20function(element)%7B%0A%20%20_data.push(%7Byear:%20Number(element.year),%20age:%20Number(element.age),%20sex:%20Number(element.sex),%20people:%20Number(element.people)%7D);%20%0A%7D);%0Aconsole.log(JSON.stringify(_data));%0A%0A//Get%20the%20component%20width%0Avar%20_width%20=%20_component.dimensions.w;%0A%0A//Set%20the%20properties%20that%20needs%20to%20be%20updated%20as%20the%20width%20is%20updated%0Avar%20_scales_range1%20=%20_width%20/%202%20-%2010;%0Avar%20_marks_properties_x%20=%20%20_width%20/%202%20-%2020;%0Avar%20_marks_properties_width%20=%20_width%20/%202%20-%2040;%0A%0Avar%20spec%20=%20%7B%0A%20%20%22description%22:%20%22Dit%20is%20een%20test.%22,%0A%20%20%22width%22:%20_width,%20//reference%20the%20component%20width%20in%20the%20spec%20%0A%20%20%22height%22:%20400,%0A%20%20%22data%22:%20%5B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%22name%22:%20%22pop%22,%0A%20%20%20%20%20%20%22values%22:%20_data%20//%20add%20the%20data%20to%20the%20spec%0A%20%20%20%20%7D,%20%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%22name%22:%20%22popYear%22,%0A%20%20%20%20%20%20%22source%22:%20%22pop%22,%20//%20add%20the%20data%20to%20the%20spec%0A%20%20%20%20%20%20%22transform%22:%20%5B%0A%20%20%20%20%20%20%20%20%7B%22type%22:%20%22filter%22,%20%22test%22:%20%22d.data.year%20==%202020%22%7D%0A%20%20%20%20%20%20%5D%0A%20%20%20%20%7D,%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%22name%22:%20%22males%22,%0A%20%20%20%20%20%20%22source%22:%20%22popYear%22,%0A%20%20%20%20%20%20%22transform%22:%20%5B%0A%20%20%20%20%20%20%20%20%7B%22type%22:%20%22filter%22,%20%22test%22:%20%22d.data.sex%20==%201%22%7D%0A%20%20%20%20%20%20%5D%0A%20%20%20%20%7D,%20%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%22name%22:%20%22females%22,%0A%20%20%20%20%20%20%22source%22:%20%22popYear%22,%0A%20%20%20%20%20%20%22transform%22:%20%5B%0A%20%20%20%20%20%20%20%20%7B%22type%22:%20%22filter%22,%20%22test%22:%20%22d.data.sex%20==%202%22%7D%0A%20%20%20%20%20%20%5D%0A%20%20%20%20%7D%0A%20%20%5D,%0A%20%20%22scales%22:%20%5B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%22name%22:%20%22g%22,%0A%20%20%20%20%20%20%22domain%22:%20%5B0,%201%5D,%0A%20%20%20%20%20%20%22range%22:%20%5B_scales_range1,%2010%5D%0A%20%20%20%20%7D,%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%22name%22:%20%22y%22,%0A%20%20%20%20%20%20%22type%22:%20%22ordinal%22,%0A%20%20%20%20%20%20%22range%22:%20%22height%22,%0A%20%20%20%20%20%20%22reverse%22:%20true,%0A%20%20%20%20%20%20%22domain%22:%20%7B%22data%22:%20%22popYear%22,%20%22field%22:%20%22data.age%22%7D%0A%20%20%20%20%7D,%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%22name%22:%20%22c%22,%0A%20%20%20%20%20%20%22type%22:%20%22ordinal%22,%0A%20%20%20%20%20%20%22domain%22:%20%5B1,%202%5D,%0A%20%20%20%20%20%20%22range%22:%20%5B%22#20214E%22,%20%22#EC650C%22%5D%0A%20%20%20%20%7D%0A%20%20%5D,%0A%20%20%22marks%22:%20%5B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%22type%22:%20%22text%22,%0A%20%20%20%20%20%20%22interactive%22:%20false,%0A%20%20%20%20%20%20%22from%22:%20%7B%0A%20%20%20%20%20%20%20%20%22data%22:%20%22popYear%22,%0A%20%20%20%20%20%20%20%20%22transform%22:%20%5B%7B%22type%22:%22unique%22,%20%22field%22:%22data.age%22,%20%22as%22:%22age%22%7D%5D%0A%20%20%20%20%20%20%7D,%0A%20%20%20%20%20%20%22properties%22:%20%7B%0A%20%20%20%20%20%20%20%20%22enter%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%22x%22:%20%7B%22value%22:%20_marks_properties_x%7D,%0A%20%20%20%20%20%20%20%20%20%20%22y%22:%20%7B%22scale%22:%20%22y%22,%20%22field%22:%20%22age%22,%20%22offset%22:%2011%7D,%0A%20%20%20%20%20%20%20%20%20%20%22text%22:%20%7B%22field%22:%20%22age%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%22baseline%22:%20%7B%22value%22:%20%22middle%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%22align%22:%20%7B%22value%22:%20%22center%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%22fill%22:%20%7B%22value%22:%20%22#000%22%7D%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D,%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%22type%22:%20%22group%22,%0A%20%20%20%20%20%20%22from%22:%20%7B%0A%20%20%20%20%20%20%20%20%22data%22:%20%22popYear%22,%0A%20%20%20%20%20%20%20%20%22transform%22:%20%5B%0A%20%20%20%20%20%20%20%20%20%20%7B%22type%22:%22facet%22,%20%22keys%22:%5B%22data.sex%22%5D%7D%0A%20%20%20%20%20%20%20%20%5D%0A%20%20%20%20%20%20%7D,%0A%20%20%20%20%20%20%22properties%22:%20%7B%0A%20%20%20%20%20%20%20%20%22update%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%22x%22:%20%7B%22scale%22:%20%22g%22,%20%22field%22:%20%22index%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%22y%22:%20%7B%22value%22:%200%7D,%0A%20%20%20%20%20%20%20%20%20%20%22width%22:%20%7B%22value%22:%20_marks_properties_width%7D,%0A%20%20%20%20%20%20%20%20%20%20%22height%22:%20%7B%22group%22:%20%22height%22%7D%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%7D,%0A%20%20%20%20%20%20%22scales%22:%20%5B%0A%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%22name%22:%20%22x%22,%0A%20%20%20%20%20%20%20%20%20%20%22type%22:%20%22linear%22,%0A%20%20%20%20%20%20%20%20%20%20%22range%22:%20%22width%22,%0A%20%20%20%20%20%20%20%20%20%20%22reverse%22:%20%7B%22field%22:%20%22index%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%22nice%22:%20true,%0A%20%20%20%20%20%20%20%20%20%20%22domain%22:%20%7B%22data%22:%20%22popYear%22,%20%22field%22:%20%22data.people%22%7D%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%5D,%0A%20%20%20%20%20%20%22axes%22:%20%5B%0A%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%22type%22:%20%22x%22,%0A%20%20%20%20%20%20%20%20%20%20%20%22scale%22:%20%22x%22,%0A%20%20%20%20%20%20%20%20%20%20%20%22format%22:%20%22s%22,%0A%20%20%20%20%20%20%20%20%20%20%20%22properties%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%22ticks%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22stroke%22:%20%7B%22value%22:%20%22#000%22%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%22majorTicks%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22strokeWidth%22:%20%7B%22value%22:%202%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%22labels%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22fill%22:%20%7B%22value%22:%20%22#000%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22angle%22:%20%7B%22value%22:%2050%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22align%22:%20%7B%22value%22:%20%22left%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22baseline%22:%20%7B%22value%22:%20%22middle%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%22title%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22fontSize%22:%20%7B%22value%22:%2016%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%22axis%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22stroke%22:%20%7B%22value%22:%20%22#000%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22strokeWidth%22:%20%7B%22value%22:%201.5%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%5D,%0A%20%20%20%20%20%20%22marks%22:%20%5B%0A%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%22type%22:%20%22rect%22,%0A%20%20%20%20%20%20%20%20%20%20%22properties%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22enter%22:%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22x%22:%20%7B%22scale%22:%20%22x%22,%20%22field%22:%20%22data.people%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22x2%22:%20%7B%22scale%22:%20%22x%22,%20%22value%22:%200%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22y%22:%20%7B%22scale%22:%20%22y%22,%20%22field%22:%20%22data.age%22%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22height%22:%20%7B%22scale%22:%20%22y%22,%20%22band%22:%20true,%20%22offset%22:%20-1%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22fillOpacity%22:%20%7B%22value%22:%201%7D,%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22fill%22:%20%7B%22scale%22:%20%22c%22,%20%22field%22:%20%22data.sex%22%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%5D%0A%20%20%20%20%7D%0A%20%20%5D%0A%7D;%0A%0A//%20pass%20in%20the%20spec%20to%20vega%20to%20render%0A%20vg.parse.spec(spec,%20function(chart)%20%7B%20chart(%7Bel:%22#vis%22%7D).update();%20%7D);%0A%7D);","type":"html_tpl2","dstContext":{"kid":"2ae64418221a8360e47182a4f0c866b7","id":"dstad9a4cce"}}],"isForked":false,"id":"1d31921ed4326884778a22bf55e3136a","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Age Distribution","usesSampleData":false,"master":"f5f5facbda8a722acdde725dbbafad47"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":1055.0}},"components":[{"components":[{"role":"series","data":[[69201.0,70575.0,71654.0,74126.0,76987.0,86355.0,87128.0,86696.0,89040.0,88583.0,89390.0,89512.0,89952.0,87037.0,85846.0,84828.0,84384.0,83611.0,81784.0,82497.0,83123.0,83572.0,84012.0,84123.0]],"color":"#26214F","displayName":"Male","seriesName":"Male","formulas":[{"txt":"lookup(&'a60ca999-3',date_convert(slice(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,A:A;),\"dd/MM/yyyy\",\"yyyy\"),slice(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,F:F;))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"c29478c5-4","overrideColor":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},"separator":".,"},"id":"149ac599-2"},{"role":"series","data":[[40957.0,43456.0,45856.0,49262.0,53086.0,61734.0,64528.0,66471.0,70628.0,72648.0,75751.0,78335.0,81250.0,81102.0,82479.0,82757.0,80528.0,78275.0,75871.0,76457.0,75349.0,78532.0,79231.0,74832.0]],"color":"#CA320A","displayName":"Female","seriesName":"Female","formulas":[{"txt":"lookup(&'a60ca999-3',date_convert(slice(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,A:A;),\"dd/MM/yyyy\",\"yyyy\"),slice(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,G:G;))","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"c29478c5-4","overrideColor":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},"separator":".,"},"id":"3651bb15-1"},{"renderer":"line","role":"series","data":[[110158.0,114031.0,117510.0,123388.0,130073.0,148089.0,151656.0,153167.0,159668.0,161231.0,165141.0,167847.0,171202.0,168139.0,168325.0,167585.0,164912.0,161886.0,157655.0,158954.0,158472.0,162104.0,163243.0,158955.0]],"color":"#ED6614","displayName":"Total Base","seriesName":"Total Base","formulas":[{"txt":"SUM(&'149ac599-2',&'3651bb15-1')","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"c29478c5-4","pointSize":"4","overrideColor":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},"separator":".,"},"id":"410c0dd6-2"},{"role":"axis_x","data":[["2001","2002","2003","2004","2005","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019","2020","2021","2022","2023","2024"]],"displayName":"Untitled","formulas":[{"txt":"date_convert(slice(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,A:A;),\"dd/MM/yyyy\",\"yyyy\")","ver":2.0}],"autoFmt":false,"label":"Untitled","type":"chart_axis","fmt":"txt","showLabelTicks":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"},"labelAngle":"-45","id":"a60ca999-3","labelDrop":"2"},{"role":"axis_y","data":[],"dataDisabled":true,"max":"200000","tickInterval":"25000","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{"separator":",."},"id":"c29478c5-4","customInterval":true,"labelDrop":0.0}],"displayName":"Bar/Line Chart","id":"210e1572-1","type":"chart_series","dstContext":{"ops":[{"sortBy":[{"dim":"a60ca9993","dir":1.0}],"type":"sort"}],"kid":"9c2d3d980c6bc13c8d354ae0bbf768c2","id":"dst210e15721"},"stackBars":"1","height":"2"}],"isForked":false,"id":"6ecf82ed4144ff49ef91d3ffbbbe47ac","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Total Member Base ","usesSampleData":false,"master":"9c2d3d980c6bc13c8d354ae0bbf768c2"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":550.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","data":[["Category:"]],"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":"\"Category:\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"52b130eb-24","type":"label","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst52b130eb24"},"wrap":true},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"values","data":[["All","Running","High Jump","Steeple Chase","Heptathlon","Long Jump","Javelin Throw"]],"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(\"All\",\"Running\",\"High Jump\",\"Steeple Chase\",\"Heptathlon\",\"Long Jump\",\"Javelin Throw\")","ver":2.0}],"autoFmt":false,"id":"55c252ed-22","type":"proxy"},{"role":"labels","data":[[]],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"828a108e-23","type":"proxy"}],"displayName":"User Input Control","scope":2.0,"inputType":1.0,"id":"a1121308-21","type":"input","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dsta112130821"},"propName":""},{"layoutConfig":{"x":0.0,"y":1.0},"size":"xx-small","data":[["Game type:"]],"displayName":"Label 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Game type:\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"42ae5c4b-25","type":"label","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst42ae5c4b25"},"wrap":true},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"role":"values","data":[["All","Amateur","Professional"]],"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(\"All\",\"Amateur\",\"Professional\")","ver":2.0}],"autoFmt":false,"id":"968f4daf-27","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"5441bb57-28","type":"proxy"}],"displayName":"User Input Control 2","scope":2.0,"inputType":1.0,"id":"466aba99-26","type":"input","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst466aba9926"},"propName":""},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"components":[{"role":"customHeader","data":[["Date"]],"displayName":"Datum","formulas":[{"txt":"\"Date\"","ver":2.0}],"font_colour":"#26214F","font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dste05dc0fb11"},"align":"l","mixin":"label","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"e05dc0fb-11","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"Datum"},"type":"eq"}],"reactions":[{"type":"background-color","value":"#E8F2FA","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[["2020-12-28","2020-12-19","2020-11-20","2020-10-27","2020-10-15","2020-10-07","2020-09-10","2020-08-28","2020-08-27","2020-07-20","2020-06-19","2020-05-07","2020-04-15","2020-04-10"]],"displayName":"Datum","formulas":[{"txt":"SLICE(&'d7cab6ca-29')","ver":2.0}],"autoFmt":true,"index":0.0,"type":"table_col","fmt":"dat2","align":"left","size":"xx-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":"yyyy-MM-dd","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"yyyy-MM-dd","dateFormatCustom":"yyyy-MM-dd","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy-M-d","dateFormat":"custom","dateFormatCustom":"yyyy-MM-dd","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Datum","id":"01590e5e-15"},{"components":[{"role":"customHeader","data":[["Event"]],"displayName":"Evenement","formulas":[{"txt":"\"Event\"","ver":2.0}],"font_colour":"#26214F","font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst87d4505713"},"align":"l","mixin":"label","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"87d45057-13","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"self":1.0},"type":"eq"}],"reactions":[{"type":"background-color","value":"#E8F2FA","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[["Oliebollentoernooi","Sport Champs","Sport Champs","Club kampioen","Club kampioen","Club kampioen","Club kampioen","Alles uit de blokken","Douwe Smit Trofee","Pupillen indoor wedstrijd","Baan circuit 3000m","Baan competitie","Club kampioen","Club kampioen"]],"displayName":"Evenement","formulas":[{"txt":"LOOKUP(&'01590e5e-15',&'d7cab6ca-29',&'81255c32-31')","ver":2.0}],"autoFmt":true,"index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Evenement","id":"c207e8dc-3","wrap":"active"},{"components":[{"role":"customHeader","data":[["City"]],"displayName":"Plaats","formulas":[{"txt":"\"City\"","ver":2.0}],"font_colour":"#26214F","font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dstb80aee0015"},"align":"l","mixin":"label","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"b80aee00-15","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"cx":"cae3612f-6"},"type":"eq"}],"reactions":[{"type":"background-color","value":"#E8F2FA"}]}]}],"customHeader":true,"role":"tcol","data":[["Assen","Utrecht","Eindhoven","Maastricht","Rotterdam","Amsterdam","Groningen","Heerenveen","Beek","Soest","Doetinchem","Kampen","Hardewijk","Hilversum"]],"displayName":"Plaats","formulas":[{"txt":"LOOKUP(&'01590e5e-15',&'d7cab6ca-29',&'abc1c3c2-30')","ver":2.0}],"autoFmt":true,"index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Plaats","id":"cae3612f-6"},{"components":[{"role":"customHeader","data":[["Total participants"]],"displayName":"Totaal deelnemers","formulas":[{"txt":"\"Total participants\"","ver":2.0}],"font_colour":"#26214F","font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dstd40b1c7f10"},"align":"l","mixin":"label","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"d40b1c7f-10","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"self":1.0},"type":"eq"}],"reactions":[{"type":"background-color","value":"#E8F2FA","isScalar":true}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[["90","35","75","175","100","30","80","90","175","75","35","30","100","80"]],"displayName":"Totaal deelnemers","formulas":[{"txt":"LOOKUP(&'01590e5e-15',&'d7cab6ca-29',&'82c6462e-34')","ver":2.0}],"autoFmt":true,"index":3.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Totaal deelnemers","id":"b226908f-9"},{"components":[{"role":"customHeader","data":[["Professionals"]],"displayName":"Professionele Deelnemers","formulas":[{"txt":"\"Professionals\"","ver":2.0}],"font_colour":"#26214F","font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dstd3f105d413"},"align":"l","mixin":"label","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"d3f105d4-13","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"self":1.0},"type":"eq"}],"reactions":[{"type":"background-color","value":"#E8F2FA","isScalar":true}]}],"wrap":"active"}],"customHeader":true,"role":"tcol","data":[["0","35","0","50","0","30","0","0","50","0","35","30","0","0"]],"displayName":"Professionele Deelnemers","formulas":[{"txt":"LOOKUP(&'01590e5e-15',&'d7cab6ca-29',&'2df92981-35')","ver":2.0}],"autoFmt":true,"index":4.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Professionele Deelnemers","id":"3e3cb479-12"},{"components":[{"role":"customHeader","data":[["Spectators"]],"displayName":"Toeschouwers","formulas":[{"txt":"\"Spectators\"","ver":2.0}],"font_colour":"#26214F","font_style":"","type":"table_headers","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dstf16f5f6719"},"align":"l","mixin":"label","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"f16f5f67-19","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"self":1.0},"type":"eq"}],"reactions":[{"type":"background-color","value":"#E8F2FA","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[["0","675","0","885","0","500","0","0","885","0","675","500","0","0"]],"displayName":"Toeschouwers","formulas":[{"txt":"LOOKUP(&'01590e5e-15',&'d7cab6ca-29',&'19ff87a8-39')","ver":2.0}],"autoFmt":true,"index":5.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Toeschouwers","id":"afb4ee6f-18"},{"role":"data","data":[["","2020-04-10","2020-05-07","2020-04-15","2020-08-27","2020-07-20","2020-06-19","2020-08-28","2020-09-10","2020-10-07","2020-10-15","2020-10-27","2020-11-20","2020-12-19","2020-12-28"]],"displayName":"data","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy-M-d","dateFormat":"custom","dateFormatCustom":"yyyy-MM-dd","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"dateInputFormatCustom":"yyyy-MM-dd","dateFormatCustom":"yyyy-MM-dd","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"yyyy-M-d","dateFormat":"custom","dateFormatCustom":"yyyy-MM-dd","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"ccb79639ab9b5acfada501ddb9d91ee4@Event data,A:A;","ver":2.0}],"autoFmt":true,"name":"data","isDstRoot":true,"id":"d7cab6ca-29","type":"data_slot","fmt":"dat2","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dstd7cab6ca29"}},{"role":"data","data":[["Plaats","Hilversum","Kampen","Hardewijk","Beek","Soest","Doetinchem","Heerenveen","Groningen","Amsterdam","Rotterdam","Maastricht","Eindhoven","Utrecht","Assen"]],"displayName":"plaats","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"ccb79639ab9b5acfada501ddb9d91ee4@Event data,B:B;","ver":2.0}],"autoFmt":true,"name":"plaats","isDstRoot":true,"id":"abc1c3c2-30","type":"data_slot","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dstabc1c3c230"}},{"role":"data","data":[["Evenement","Club kampioen","Baan competitie","Club kampioen","Douwe Smit Trofee","Pupillen indoor wedstrijd","Baan circuit 3000m","Alles uit de blokken","Club kampioen","Club kampioen","Club kampioen","Club kampioen","Sport Champs","Sport Champs","Oliebollentoernooi"]],"displayName":"evenement","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"ccb79639ab9b5acfada501ddb9d91ee4@Event data,C:C;","ver":2.0}],"autoFmt":true,"name":"evenement","isDstRoot":true,"id":"81255c32-31","type":"data_slot","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst81255c3231"}},{"role":"data","data":[["Type Evenement","Recreatief","Professioneel","Recreatief","Gemixt","Recreatief","Professioneel","Recreatief","Recreatief","Professioneel","Recreatief","Gemixt","Recreatief","Professioneel","Recreatief"]],"displayName":"evenement type","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"ccb79639ab9b5acfada501ddb9d91ee4@Event data,D:D;","ver":2.0}],"autoFmt":true,"name":"evenement type","isDstRoot":true,"id":"24a328eb-32","type":"data_slot","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst24a328eb32"}},{"role":"data","data":[["categorie","Hardlopen","Speerwerpen","Verspringen","Hardlopen","Hardlopen","Hordelopen","Meerkamp","Hardlopen","Hordelopen","Meerkamp","Hardlopen","Hardlopen","Verspringen","Meerkamp"]],"displayName":"categorie","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"ccb79639ab9b5acfada501ddb9d91ee4@Event data,E:E;","ver":2.0}],"autoFmt":true,"name":"categorie","isDstRoot":true,"id":"e5b2b306-33","type":"data_slot","fmt":"txt","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dste5b2b30633"}},{"role":"data","data":[["Totaal deelnemers","80","30","100","175","75","35","90","80","30","100","175","75","35","90"]],"displayName":"deelnemers","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"ccb79639ab9b5acfada501ddb9d91ee4@Event data,F:F;","ver":2.0}],"autoFmt":true,"name":"deelnemers","isDstRoot":true,"id":"82c6462e-34","type":"data_slot","fmt":"num","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst82c6462e34"}},{"role":"data","data":[["Professioneel Deelnemers","0","30","0","50","0","35","0","0","30","0","50","0","35","0"]],"displayName":"professioneel","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"ccb79639ab9b5acfada501ddb9d91ee4@Event data,G:G;","ver":2.0}],"autoFmt":true,"name":"professioneel","isDstRoot":true,"id":"2df92981-35","type":"data_slot","fmt":"num","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst2df9298135"}},{"role":"data","data":[["Toeschouwers","0","500","0","885","0","675","0","0","500","0","885","0","675","0"]],"displayName":"toeschouwers","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"ccb79639ab9b5acfada501ddb9d91ee4@Event data,H:H;","ver":2.0}],"autoFmt":true,"name":"toeschouwers","isDstRoot":true,"id":"19ff87a8-39","type":"data_slot","fmt":"num","dstContext":{"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst19ff87a839"}}],"maxRows":"14","displayName":"Table","id":"04e4a782-2","type":"table","dstContext":{"ops":[{"sortBy":[{"dim":"01590e5e15","dir":2.0}],"type":"sort"}],"kid":"4c25bf442efdf911c0e54f431a071982","id":"dst04e4a7822"}}],"displayName":"Layout Grid","widths":[{"w":107.0,"x":0.0}],"id":"442dad5c-1","cellData":[{"x":0.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":1.0,"alignment":1.0},{"w":4.0,"x":0.0,"h":2.0,"y":2.0}],"type":"panel_grid","rows":4.0,"cols":4.0}],"isForked":false,"id":"0c54ee534f6f6608b7a0c3bdbedb0a55","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Events Overview","usesSampleData":false,"master":"4c25bf442efdf911c0e54f431a071982"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":550.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"components":[],"role":"current","data":[[1299.0]],"displayName":"Current Value","formulas":[{"txt":"1299","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"num","dstContext":{"ops":[],"kid":"8b9c1b50117f5456e6340da6e34da8a1","id":"dst54a4807d","aggs":{"f2b1713a":"auto","54a4807d":"count","8c8c4625":"auto"}},"size":"x-large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0","suffix":"","separator":",."},"id":"54a4807d","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"cx":"7d5e40d8"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-grey","isScalar":true}]}]},{"role":"target","size":"medium","data":[[1000.0]],"displayName":"Target Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"prefix":"Target: ","precision":"0","suffix":"","separator":".,"},"formulas":[{"txt":"1000","ver":2.0,"src":{"c":[{"t":"l","v":"80"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_888","id":"7d5e40d8","type":"label","fmt":"num","dstContext":{"ops":[],"kid":"8b9c1b50117f5456e6340da6e34da8a1","id":"dst7d5e40d8","aggs":{"7d5e40d8":"count","54a4807d":"count"}}},{"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":[],"kid":"8b9c1b50117f5456e6340da6e34da8a1","id":"dst8ea6a667","aggs":{"8ea6a667":"auto"}},"size":"small","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"}},"id":"8ea6a667"},{"role":"max","data":[[2000.0]],"displayName":"Max Value","formulas":[{"txt":"2*&'7d5e40d8'","ver":2.0}],"autoFmt":true,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"num","dstContext":{"ops":[],"kid":"8b9c1b50117f5456e6340da6e34da8a1","id":"dst90298ee2","aggs":{"90298ee2":"auto"}},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":".,"},"id":"90298ee2"}],"size":"3","displayName":"Gauge","id":"fc5adc60","type":"gauge","dstContext":{"id":"dstfc5adc60"},"conditions":[{"predicates":[{"left":{"cx":"54a4807d"},"right":{"cx":"7d5e40d8"},"type":"lt"}],"reactions":[{"type":"color","value":"#26214F","isScalar":true}]},{"predicates":[{"left":{"cx":"54a4807d"},"right":{"cx":"7d5e40d8"},"type":"gteq"}],"reactions":[{"type":"color","value":"#00821F","isScalar":true}]}],"gaugeStyle":"ag"}],"displayName":"Layout Grid","id":"500807f9-1","cellData":[{"x":0.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":1.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"rowHeights":[{"h":90.0,"y":0.0}],"cols":1.0}],"isForked":false,"id":"e66a1a7af9602fa2ac59f4e5e52772b6","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Net Growth Year-to-Date","usesSampleData":false,"master":"8b9c1b50117f5456e6340da6e34da8a1"},{"workspace":{"datasources":[],"dimensions":{"w":550.0}},"components":[{"components":[{"components":[{"role":"region_id","data":[["FY","GR","DR","OV","FL","UT","NH","ZH","GE","NB","ZE","LI"]],"displayName":"ID","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"ARRAY(\"FY\",\"GR\",\"DR\",\"OV\",\"FL\",\"UT\",\"NH\",\"ZH\",\"GE\",\"NB\",\"ZE\",\"LI\")\n","ver":2.0}],"autoFmt":true,"id":"6275151a-3","type":"proxy","fmt":"txt"},{"role":"region_color","data":[[17.0,11.0,11.0,20.0,13.0,16.0,57.0,35.0,30.0,54.0,9.0,23.0]],"endColor":"#26214F","displayName":"Color","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"LOOKUP(&'6275151a-3',&'e274d067-5',ARRAY(17,11,11,20,13,16,57,35,30,54,9,23))\n\n","ver":2.0}],"autoFmt":true,"valueType":"color","id":"90843839-4","type":"map_tooltip_prop","fmt":"num","startColor":"#E8F2FA"},{"role":"region_desc","data":[],"displayName":"Description","formulas":[],"autoFmt":true,"valueType":"description","id":"6e6cea74-5","type":"map_tooltip_prop"},{"role":"region_xref","data":[],"displayName":"Link","formulas":[],"autoFmt":true,"id":"f9d454fa-6","type":"map_link"},{"role":"data","data":[["FY","GR","DR","OV","FL","UT","NH","ZH","GE","NB","ZE","LI"]],"displayName":"country code","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(\"FY\",\"GR\",\"DR\",\"OV\",\"FL\",\"UT\",\"NH\",\"ZH\",\"GE\",\"NB\",\"ZE\",\"LI\")\n\n","ver":2.0}],"autoFmt":true,"name":"country code","isDstRoot":false,"id":"e274d067-5","type":"data_slot","fmt":"txt"}],"role":"tile_regions","displayName":"Regions","id":"a242c4fb-2","type":"map_region","dstContext":{"kid":"6e4a58e4c02dd1399b75f0f5c96fcfa4","id":"dsta242c4fb2"}},{"components":[{"role":"marker_lat","data":[],"displayName":"Latitude","formulas":[],"autoFmt":true,"id":"7ddc28b0-8","type":"proxy"},{"role":"marker_lng","data":[],"displayName":"Longitude","formulas":[],"autoFmt":true,"id":"eeb6d5e6-9","type":"proxy"},{"role":"marker_name","data":[],"displayName":"Name","formulas":[],"autoFmt":true,"valueType":"name","id":"2484f670-10","type":"map_tooltip_prop"},{"role":"marker_color","data":[],"displayName":"Color","formulas":[],"autoFmt":true,"valueType":"color","id":"d7e141ef-11","type":"map_tooltip_prop","fmt":"num"},{"role":"marker_size","data":[],"displayName":"Size","formulas":[],"autoFmt":true,"valueType":"size","id":"c0bfa498-12","type":"map_tooltip_prop","fmt":"num"},{"role":"marker_desc","data":[],"displayName":"Description","fmtArgs":{"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[],"autoFmt":true,"valueType":"description","id":"24d91f8c-13","type":"map_tooltip_prop","fmt":"num"},{"role":"marker_xref","data":[],"displayName":"Link","formulas":[],"autoFmt":true,"id":"900b4e8f-14","type":"map_link"}],"role":"tile_markers","displayName":"Markers","id":"e4da8768-7","type":"map_marker","dstContext":{"kid":"6e4a58e4c02dd1399b75f0f5c96fcfa4","id":"dste4da87687"}}],"size":"3","displayName":"Map","mapId":"netherlands_nl","id":"faded33b-1","type":"tile_map","dstContext":{"id":"dstfaded33b1"}}],"isForked":false,"id":"04d8136c04de5240870f70122242001d","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"# Clubs and Associations per province","usesSampleData":false,"master":"6e4a58e4c02dd1399b75f0f5c96fcfa4"},{"workspace":{"datasources":[],"dimensions":{"w":1081.0}},"components":[{"components":[{"role":"values","data":[["Satisfaction Survey June 2023"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"formulas":[{"txt":"\"Satisfaction Survey June 2023\"","ver":2.0}],"autoFmt":false,"id":"8b3b2ae5-2","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"53adc94d-3","type":"proxy"}],"displayName":"User Input Control","scope":2.0,"inputLabel":"Questionnaire","inputType":1.0,"id":"b9c9f9bc-1","type":"input","dstContext":{"kid":"53fb17fd5f0e19fc27186dc7251fff7f","id":"dstb9c9f9bc1"},"propName":""},{"components":[{"showValues":true,"role":"series","data":[[8.5,5.0,7.0,3.0,2.0,7.5,5.5]],"displayName":"vragen","seriesName":"","formulas":[{"txt":"ARRAY(8.5,5,7,3,2,7.5,5.5)","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"d223604a","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"1"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"1"},"id":"dd1d3165","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"8"},"type":"gt"}],"reactions":[{"type":"color","value":"#00821F"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"2"},"type":"lteq"}],"reactions":[{"type":"color","value":"#CA320A"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"2"},"type":"gt"},{"left":{"self":1.0},"right":{"raw":"4"},"type":"lteq"}],"reactions":[{"type":"color","value":"#E8F2FA"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"4"},"type":"gteq"},{"left":{"self":1.0},"right":{"raw":"6"},"type":"lt"}],"reactions":[{"type":"color","value":"#ED6614"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"6"},"type":"gteq"},{"left":{"self":1.0},"right":{"raw":"8"},"type":"lt"}],"reactions":[{"type":"color","value":"#26214F"}]}],"renamed":true},{"role":"axis_x","data":[["Clubliefde","Financiële gezondheid","Meelevendheid","Saamhorigheid","Competitiviteit","Algemene trevredenheid","Passie"]],"displayName":"Untitled","formulas":[{"txt":"ARRAY(\"Clubliefde\",\"Financiële gezondheid\",\"Meelevendheid\",\"Saamhorigheid\",\"Competitiviteit\",\"Algemene trevredenheid\",\"Passie\")\n/*ARRAY(\"De opkomst bij trainingen is hoog\", \"Met de huidige accommodatie kunnen we nog jaren vooruit\", \"De accommodatie is in goede staat\",\"De vereniging weet specifieke groepen goed te bereiken\",\"Sportverenigingen zijn er om hun leden leuk te laten sporten en niet meer dan dat\", \"Dit is een vereniging van vrijwilligers en dat moet zo blijven\", \"De vereniging heeft jaarlijks een positief financieel resultaat\") */","ver":2.0}],"autoFmt":false,"label":"Untitled","type":"chart_axis","fmt":"txt","labelStagger":"1","showLabelTicks":true,"grid":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"dee5aef9","labelDrop":"1"},{"customRange":true,"role":"axis_y","data":[],"dataDisabled":true,"max":"10","displayName":"Untitled","formulas":[],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"num","min":"0","grid":true,"fmtArgs":{"precision":"1"},"id":"d223604a","labelDrop":0.0}],"hideNullSeries":1.0,"displayName":"Bar/Line Chart 2","showLegend":false,"invertAxes":1.0,"id":"18420a19","type":"chart_series","dstContext":{"ops":[],"kid":"53fb17fd5f0e19fc27186dc7251fff7f","id":"dst18420a19","aggs":{"dd1d3165":"sum"}},"height":"2"}],"datasourceProps":["company_id"],"isForked":false,"id":"266d34f8bd3d56719ab4f815f31c8754","appliedMigrations":{"hideNullSeries":true,"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Member Questionnaires","usesSampleData":false,"master":"53fb17fd5f0e19fc27186dc7251fff7f"},{"padding":[15.0,15.0,"50",15.0],"workspace":{"datasources":[],"dimensions":{"w":550.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","18.575","Pupil",""]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"18.575\",\"Pupil\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Unnamed 1","id":"b3b34f8c","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ec650c"}]}],"wrap":false}],"displayName":"Table Copy 3","showHeader":false,"id":"4ddb5817","type":"table","dstContext":{"kid":"b0c59c0e1f1de4b281404f20195db18b","id":"dst4ddb5817"}},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","36.923","Junior",""]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"36.923\",\"Junior\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Unnamed 1","id":"5b85a7c2","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ec650c"}]}],"wrap":false}],"displayName":"Table Copy 2","showHeader":false,"id":"e70afd21","type":"table","dstContext":{"kid":"b0c59c0e1f1de4b281404f20195db18b","id":"dste70afd21"}},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","85.321","Senior",""]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"85.321\",\"Senior\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Unnamed 1","id":"8286235c","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ec650c"}]}],"wrap":false}],"displayName":"Table Copy","showHeader":false,"id":"5f83e7c5","type":"table","dstContext":{"kid":"b0c59c0e1f1de4b281404f20195db18b","id":"dst5f83e7c5"}},{"layoutConfig":{"x":0.0,"y":3.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","16.836","Master",""]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"16.836\",\"Master\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Unnamed 1","id":"14a6f82c-2","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ec650c"}]}],"wrap":false}],"displayName":"Table","showHeader":false,"id":"4288dfc7-1","type":"table","dstContext":{"kid":"b0c59c0e1f1de4b281404f20195db18b","id":"dst4288dfc71"}},{"layoutConfig":{"x":0.0,"y":4.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","157.655","Total members",""]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"157.655\",\"\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Unnamed 1","id":"10c33730","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#26214F"}]}],"wrap":false}],"displayName":"Table Copy 4","showHeader":false,"id":"2253c743","type":"table","dstContext":{"kid":"b0c59c0e1f1de4b281404f20195db18b","id":"dst2253c743"}}],"displayName":"Layout Grid","id":"7b247c20-1","cellData":[{"x":0.0,"y":0.0,"cellPadding":[75.0,5.0,47.0,5.0]},{"x":0.0,"y":1.0,"cellPadding":[5.0,5.0,47.0,5.0]},{"x":0.0,"y":2.0,"cellPadding":[5.0,5.0,47.0,5.0]},{"x":0.0,"y":3.0,"alignment":1.0,"cellPadding":[5.0,5.0,47.0,5.0]}],"type":"panel_grid","rows":5.0,"cols":1.0}],"innerPadding":"50","isForked":false,"titleSize":"medium","id":"b40cde569840b9afcbdf4a949765e0d4","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Members per age category last period","usesSampleData":false,"useSamePadding":false,"master":"b0c59c0e1f1de4b281404f20195db18b"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":791.0}},"components":[{"components":[{"data":[[0.5189992073178403]],"displayName":"Label 2","formulas":[{"txt":"FIRST(&'b14b798a-1')/(FIRST(&'ee4bb6d6-2')+first(&'b14b798a-1'))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#26214F","type":"label","fmt":"pct","dstContext":{"kid":"73db3690ccbd5327e5f0fe2eb337874e","id":"dsta39a93d7"},"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":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"1","separator":".,"},"id":"a39a93d7","wrap":true},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"padding":[2.0,4.0,2.0,2.0],"valueId":1.0,"role":"value","data":[[51.899920731784036]],"colorFilter":"color","displayName":"Image Set","stepValue":10.0,"formulas":[{"txt":"FIRST(&'b14b798a-1')/(FIRST(&'ee4bb6d6-2')+first(&'b14b798a-1'))*100","ver":2.0,"src":{"c":[{"t":"l","v":"5"}],"t":"expr","v":false}}],"type":"picto_data","fmt":"num","dstContext":{"kid":"73db3690ccbd5327e5f0fe2eb337874e","id":"dst4186db8e"},"useSamePadding":false,"valueColor":"#26214F","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}}},"id":"4186db8e","imageType":"man"}],"size":"large","displayName":"Pictograph Copy","id":"0e25ebeb","type":"pictograph","dstContext":{"id":"dst0e25ebeb"}},{"components":[{"role":"data","data":[["82497","81784","83611","84384","84828","85846","87037","89952","89512","89390","88583","89040","86696","87128","86355","76987","74126","71654","70575","69201"]],"displayName":"Man","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"},"separator":".,"},"formulas":[{"txt":"SLICE(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,F:F;)","ver":2.0}],"autoFmt":true,"name":"Man","isDstRoot":true,"id":"b14b798a-1","type":"data_slot","fmt":"txt","dstContext":{"kid":"73db3690ccbd5327e5f0fe2eb337874e","id":"dstb14b798a1"}},{"role":"data","data":[["76457","75871","78275","80528","82757","82479","81102","81250","78335","75751","72648","70628","66471","64528","61734","53086","49262","45856","43456","40957"]],"displayName":"Vrouw","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"},"separator":".,"},"formulas":[{"txt":"SLICE(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,G:G;)","ver":2.0}],"autoFmt":true,"name":"Vrouw","isDstRoot":true,"id":"ee4bb6d6-2","type":"data_slot","fmt":"txt","dstContext":{"kid":"73db3690ccbd5327e5f0fe2eb337874e","id":"dstee4bb6d62"}}],"data":[[0.4810007926821596]],"displayName":"Label 3","formulas":[{"txt":"FIRST(&'ee4bb6d6-2')/(FIRST(&'b14b798a-1')+first(&'ee4bb6d6-2'))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#CA320A","type":"label","fmt":"pct","dstContext":{"kid":"73db3690ccbd5327e5f0fe2eb337874e","id":"dstd1b20d91"},"layoutConfig":{"x":0.0,"y":1.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"1","separator":".,"},"id":"d1b20d91","wrap":true},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"padding":[2.0,1.0,2.0,2.0],"valueId":1.0,"role":"value","data":[[48.100079268215964]],"colorFilter":"color","displayName":"Image Set","stepValue":10.0,"formulas":[{"txt":"FIRST(&'ee4bb6d6-2')/(FIRST(&'b14b798a-1')+first(&'ee4bb6d6-2'))*100","ver":2.0,"src":{"c":[{"t":"l","v":"5"}],"t":"expr","v":false}}],"type":"picto_data","fmt":"num","dstContext":{"kid":"73db3690ccbd5327e5f0fe2eb337874e","id":"dst2c8b4a9f"},"useSamePadding":false,"valueColor":"#CA320A","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}}},"id":"2c8b4a9f","imageType":"woman"}],"size":"large","displayName":"Pictograph","id":"5ac73d47","type":"pictograph","dstContext":{"id":"dst5ac73d47"}},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"data","data":[["42","56","4"]],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"array(\"42\",\"56\",\"4\")","ver":2.0}],"autoFmt":true,"id":"29bd6df2","type":"series_data","fmt":"num"},{"role":"labels","data":[["Recreanten","Amateurs","Professionals"]],"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(\"Amateurs\",\"Semi Prof\",\"Professionals\")","ver":2.0}],"autoFmt":true,"id":"6d821605","type":"series_labels","fmt":"txt"}],"size":"1","sliceColors":["#26214F","#ED6614","#00821F","#00821F","#E8F2FA","cx-theme_brown_3","#cc527b","#33867f","#ada434"],"displayName":"Pie Chart Copy","pie_style":"circle","legend_values":false,"id":"853f69ef","type":"chart_pie","dstContext":{"kid":"73db3690ccbd5327e5f0fe2eb337874e","id":"dst853f69ef"},"overrideColors":true,"legend_percentages":"0"}],"displayName":"Layout Grid","widths":[{"w":100.0,"x":0.0}],"id":"6d8b8198","cellData":[{"x":1.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":1.0,"alignment":1.0},{"x":0.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":1.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":2.0}],"type":"panel_grid","rows":3.0,"cols":2.0}],"isForked":false,"id":"deb8a74272e1a4c5daf5247c616ea00a","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Gender & Type","usesSampleData":false,"master":"73db3690ccbd5327e5f0fe2eb337874e"},{"workspace":{"datasources":["9d531052ea340f50ee103aa201adb513"],"dimensions":{"w":550.0}},"components":[{"tpl":"\n\n\n\n\n\n\n\n\n\n

","components":[{"role":"data","data":[["6.4954819","5.7482927","6.0552034","5.6369654","5.8570584","6.4787378","6.8351322","6.4345382","6.1287758","5.966571","6.7983363","5.9051854","4.7635336","5.7629199","5.7561718","5.180002","4.4206166","5.01228","4.2396569","5.3812989","5.6306922","4.9684778","5.2479669","4.6839655","6.0789936","4.5726672","4.4465645","4.6239145","3.582594","5.3076116"]],"displayName":"Longitude","formulas":[{"txt":"slice(9d531052ea340f50ee103aa201adb513@Sheet1,D:D;)","ver":2.0}],"autoFmt":true,"type":"html_data","fmt":"num","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dst514d9172"},"mixin":"label","dataId":"Longitude","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"isDstRoot":true,"id":"514d9172"},{"role":"data","data":[["53.2217872","53.2003959","53.1055525","53.028084","52.956065","52.9837359","52.7804755","52.7194493","52.7116375","52.5143565","52.2233632","52.211509","52.3547921","51.8429523","52.0057437","52.3696449","51.9280711","52.0842714","52.0717389","51.4485716","50.8578841","51.5737216","51.7149041","52.6337029","51.3775265","52.3838758","52.1517843","51.5600592","51.5051517","52.1590354"]],"displayName":"Latitude","formulas":[{"txt":"slice(9d531052ea340f50ee103aa201adb513@Sheet1,C:C;)","ver":2.0}],"autoFmt":true,"type":"html_data","fmt":"num","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dst9d2434f8"},"mixin":"label","dataId":"Latitude","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"isDstRoot":true,"id":"9d2434f8"},{"role":"data","data":[["Tom Dumoulin","Primoz Roglic","Primoz Roglic","Dylan Groenewegen","Primoz Roglic","Primoz Roglic","Tom Dumoulin","Primoz Roglic","Primoz Roglic","Tom Dumoulin","Primoz Roglic","Tom Dumoulin","Primoz Roglic","Tom Dumoulin","Tom Dumoulin","Dylan Groenewegen","Wout van Aert","Dylan Groenewegen","Dylan Groenewegen","Wout van Aert","Tom Dumoulin","Wout van Aert","Wout van Aert","Dylan Groenewegen","Tom Dumoulin","Dylan Groenewegen","Dylan Groenewegen","Wout van Aert","Wout van Aert","Dylan Groenewegen"]],"displayName":"Renners","formulas":[{"txt":"slice(9d531052ea340f50ee103aa201adb513@Sheet1,E:E;)","ver":2.0}],"autoFmt":true,"type":"html_data","fmt":"txt","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dst3ecea759"},"mixin":"label","dataId":"Renners","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":"3ecea759"},{"role":"data","data":[["Groningen","Leeuwarden","Drachten","Sneek","Heerenveen","Assen","Emmen","Hoogeveen","Meppel","Zwolle","Enschede","Apeldoorn","Amsterdam","Nijmegen","Arnhem","Almere","Rotterdam","Utrecht","Den Haag","Eindhoven","Maastricht","Tilburg","Den Bosch","Alkmaar","Venlo","Haarlem","Leiden","Breda","Middelburg","Amersfoort"]],"displayName":"City","formulas":[{"txt":"slice(9d531052ea340f50ee103aa201adb513@Sheet1,A:A;)","ver":2.0}],"autoFmt":true,"type":"html_data","fmt":"txt","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dstf8c99ceb"},"mixin":"label","dataId":"City","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":"f8c99ceb"}],"displayName":"HTML Template","id":"77fbcc83","script_tpl":"require.config(%7B%0Apaths:%7B%0A%20%20%20%20%22async%22%20:%20%22https://static.klipfolio.com/static/js/require_async%22%0A%7D%0A%7D);%0A%0Arequire(%20%5B%22async!https://maps.google.com/maps/api/js?key=AIzaSyByFM6xh56-vGKIHfOSpp8L8QnaeefC4TI%22%5D%20,%20function(ok)%20%7B%0A%0Avar%20latitudes%20=%20$(%22#map-latitudes%20li%22);%0Avar%20longitudes%20=%20$(%22#map-longitudes%20li%22);%0Avar%20city%20=%20$(%22#map-city%20li%22);%20%0Avar%20renners%20=%20$(%22#map-renners%20li%22);%0A%0A/*%0Avar%20centerLatLng;%0Aif%20(latitudes.length%20%3E%200%20&&%20longitudes.length%20%3E%200)%20%7B%0A%20%20%20%20centerLatLng%20=%20new%20google.maps.LatLng(parseInt($(latitudes%5B0%5D).text()),%20parseInt($(longitudes%5B0%5D).text())+1)%0A%7D%0A*/%0A%0Avar%20myOptions%20=%20%7B%0A%20%20%20%20zoom:%208,%0A%20%20%20%20center:%20new%20google.maps.LatLng(52.156,5.387),%0A%20%20%20%20mapTypeId:%20google.maps.MapTypeId.ROADMAP%0A%7D;%0A%0Avar%20map%20=%20new%20google.maps.Map(document.getElementById(%22map_canvas%22),%20myOptions);%0A%0Avar%20infoWindow%20=%20new%20google.maps.InfoWindow();%0Avar%20marker;%0A%0A%20%20%20%20for%20(var%20i%20=%200;%20i%20%3C%20latitudes.length;%20i++)%20%7B%0A%0A%20%20%20%20%20%20marker%20=%20new%20google.maps.Marker(%7B%0A%20%20%20%20%20%20%20%20position:%20new%20google.maps.LatLng($(latitudes%5Bi%5D).text(),%20$(longitudes%5Bi%5D).text()),%0A%20%20%20%20%20%20%20%20map:%20map,%0A%20%20%20%20%20%20%20%20title:%20$(city%5Bi%5D).text()%0A%20%20%20%20%20%20%7D);%0A%20%20%0A%20%20%20%20%20%20google.maps.event.addListener(marker,%20%22click%22,%20(function(marker,%20i)%20%7B%0A%20%20%20%20%20%20%20%20return%20function()%20%7B%0A%20%20%20%20%20%20%20%20%20%20infoWindow.setContent(%0A%20%20%20%20%20%20%20%20%20%20%20%20%22%3Cdiv%3E%22%20+%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22%3Ch1%3E%22%20+%20$(city%5Bi%5D).text()%20+%20%22%3C/h1%3E%22%20+%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20/*%20%22%3Cp%3E%3Cspan%20style='font-weight:bold;'%3EMeest%20populair:%20%3C/span%3E%22%20+%20$(renners%5Bi%5D).text()%20+%20%22%3C/p%3E%22%20+%20*/%0A%09%09%22%3Cp%3E%3Cspan%20style='font-weight:bold;'%3EMemberships:%20%3C/span%3E%22%20+%20Math.floor(Math.random()%20*%202000)%20+%20%22%3C/p%3E%22%20+%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%22%3C/div%3E%22%0A%20%20%20%20%20%20%20%20%20%20);%0A%20%20%20%20%20%20%20%20%20%20infoWindow.open(map,%20marker);%0A%20%20%20%20%20%20%20%20%7D%20%20%20%0A%20%20%20%20%20%20%7D)(marker,%20i));%0A%20%20%20%20%0A%20%20%20%20%20%20if%20($(renners%5Bi%5D).text()%20==%20%22Tom%20Dumoulin%22)%20%7B%0A%09%09marker.setIcon(%22http://maps.google.com/mapfiles/kml/pushpin/wht-pushpin.png%22);%0A%09%7D%20else%20if%20($(renners%5Bi%5D).text()%20==%20%22Wout%20van%20Aert%22)%20%7B%0A%09%09marker.setIcon(%22http://maps.google.com/mapfiles/kml/pushpin/grn-pushpin.png%22);%0A%09%7D%20else%20if%20($(renners%5Bi%5D).text()%20==%20%22Dylan%20Groenewegen%22)%20%7B%0A%09%09marker.setIcon(%22http://maps.google.com/mapfiles/kml/pushpin/purple-pushpin.png%22);%0A%09%7D%20else%20if%20($(renners%5Bi%5D).text()%20==%20%22Primoz%20Roglic%22)%20%7B%0A%09%09marker.setIcon(%22http://maps.google.com/mapfiles/kml/pushpin/grn-pushpin.png%22);%0A%09%7D%0A%0A%20%20%20%20%7D%0A%20%20%0A%20%20%20%20%7D);%20","type":"html_tpl2","dstContext":{"id":"dst77fbcc83"}},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"data":[["https://maps.google.com/mapfiles/kml/pushpin/wht-pushpin.png"]],"horizAlign":1.0,"displayName":"Image","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"https://maps.google.com/mapfiles/kml/pushpin/wht-pushpin.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"id":"727717c7-2","type":"image","fmt":"txt","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dst727717c72"}},{"layoutConfig":{"x":1.0,"y":0.0},"size":"small","data":[["Pupils to Profs"]],"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":"\"Pupils to Profs\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"b78caed1-7","type":"label","fmt":"txt","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dstb78caed17"},"wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"data":[["https://maps.google.com/mapfiles/kml/pushpin/grn-pushpin.png"]],"horizAlign":1.0,"displayName":"Image Copy","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"https://maps.google.com/mapfiles/kml/pushpin/grn-pushpin.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"id":"af4a7fdc","type":"image","fmt":"txt","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dstaf4a7fdc"}},{"layoutConfig":{"x":1.0,"y":1.0},"size":"small","data":[["Seniors + Profs"]],"displayName":"Label Copy","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":"\"Seniors + Profs\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"08e3e7bf","type":"label","fmt":"txt","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dst08e3e7bf"},"wrap":true},{"layoutConfig":{"x":0.0,"y":2.0},"data":[["https://maps.google.com/mapfiles/kml/pushpin/purple-pushpin.png"]],"horizAlign":1.0,"displayName":"Image Copy 3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"https://maps.google.com/mapfiles/kml/pushpin/purple-pushpin.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"id":"48990808","type":"image","fmt":"txt","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dst48990808"}},{"layoutConfig":{"x":1.0,"y":2.0},"size":"small","data":[["Juniors + Seniors"]],"displayName":"Label Copy 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Juniors + Seniors\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"937e5bf9","type":"label","fmt":"txt","dstContext":{"kid":"f9d6c9321f9eafe6d9046bc70b9ced40","id":"dst937e5bf9"},"wrap":true}],"displayName":"Layout Grid","id":"c902e6c3-1","cellData":[{"x":1.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":1.0,"alignment":1.0},{"x":1.0,"y":2.0,"alignment":1.0}],"type":"panel_grid","rows":4.0,"cols":2.0}],"isForked":false,"id":"b85a34ca1d556d30e8c4bf9db0aa2d7c","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Associated Club Locations","usesSampleData":false,"master":"f9d6c9321f9eafe6d9046bc70b9ced40"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":1012.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"line_colour":"#ED6614","displayName":"Separator","id":"fd6aa16d","type":"separator"},{"data":[["Actual membership base"]],"displayName":"Label","formulas":[{"txt":"\"Actual Membership Base\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#ED6614","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"dd8ff95fb25dda377564ddd08e5a9338","id":"dstddd44bb8"},"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":"ddd44bb8","wrap":true},{"layoutConfig":{"x":2.0,"y":0.0},"line_colour":"#ED6614","displayName":"Separator Copy","id":"4caad945","type":"separator"}],"displayName":"Layout Grid","id":"b0bcd20a","cellData":[{"x":2.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":1.0,"cols":3.0}],"isForked":false,"id":"8e137a9b18bf052bea265ddaaf302623","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Header Atletiekunie","usesSampleData":false,"master":"dd8ff95fb25dda377564ddd08e5a9338"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":550.0}},"components":[{"tpl":"

Disclaimer: This dashboard contains fictional data for demostration purposes only. Any similarities to real data are purely coincidental.

","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"7e6a261d-3","type":"html_data","dstContext":{"id":"dst7e6a261d3"}}],"displayName":"HTML Template","id":"7f7cb2c6-2","script_tpl":"%3C!--%20Google%20Tag%20Manager%20--%3E%0A(function(w,d,s,l,i)%7Bw%5Bl%5D=w%5Bl%5D%7C%7C%5B%5D;w%5Bl%5D.push(%7B'gtm.start':%0Anew%20Date().getTime(),event:'gtm.js'%7D);var%20f=d.getElementsByTagName(s)%5B0%5D,%0Aj=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=%0A'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);%0A%7D)(window,document,'script','dataLayer','GTM-PLRHXX6');%0A%3C!--%20End%20Google%20Tag%20Manager%20--%3E","type":"html_tpl2","dstContext":{"id":"dst7f7cb2c62"}}],"isForked":false,"id":"5020fe19eb5fc29cc417db4f4ee9f7b6","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Header Atletiekunie","usesSampleData":false,"master":"5f8b6acd23768bf273d3c3db69509bb7"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":550.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"components":[],"role":"current","data":[[22.0]],"displayName":"Current Value","formulas":[{"txt":"22","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"num","dstContext":{"ops":[],"kid":"633b26db38fba6f9e46a1c81ff6722fd","id":"dst65e8f100","aggs":{"f2b1713a":"auto","65e8f100":"count","8c8c4625":"auto"}},"size":"x-large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0","suffix":""},"id":"65e8f100","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-grey","isScalar":true}]}]},{"role":"target","size":"medium","data":[[25.0]],"displayName":"Target Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"prefix":"Target: ","precision":"0","suffix":"","separator":".,"},"formulas":[{"txt":"25","ver":2.0,"src":{"c":[{"t":"l","v":"80"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_aaa","id":"0cc5c317","type":"label","fmt":"num","dstContext":{"ops":[],"kid":"633b26db38fba6f9e46a1c81ff6722fd","id":"dst0cc5c317","aggs":{"0cc5c317":"count","65e8f100":"count"}}},{"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":[],"kid":"633b26db38fba6f9e46a1c81ff6722fd","id":"dst446d0598","aggs":{"446d0598":"auto"}},"size":"small","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"}},"id":"446d0598"},{"role":"max","data":[[50.0]],"displayName":"Max Value","formulas":[{"txt":"50","ver":2.0}],"autoFmt":true,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"num","dstContext":{"ops":[],"kid":"633b26db38fba6f9e46a1c81ff6722fd","id":"dstb2146b88","aggs":{"b2146b88":"auto"}},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":""},"id":"b2146b88"}],"size":"3","displayName":"Gauge","id":"2789c365","type":"gauge","dstContext":{"id":"dst2789c365"},"conditions":[{"predicates":[{"left":{"cx":"65e8f100"},"right":{"cx":"0cc5c317"},"type":"lt"}],"reactions":[{"type":"color","value":"#CA320A","isScalar":true}]},{"predicates":[{"left":{"cx":"65e8f100"},"right":{"cx":"0cc5c317"},"type":"gteq"}],"reactions":[{"type":"color","value":"#ED6614","isScalar":true}]}],"gaugeStyle":"ag"}],"displayName":"Layout Grid","id":"88866a3a-1","cellData":[{"x":0.0,"y":0.0},{"x":0.0,"y":1.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"rowHeights":[{"h":90.0,"y":0.0}],"cols":1.0}],"isForked":false,"id":"81684ac80e1f0cb92f17c6a9acf46ab4","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Net Growth Last 7 Days","usesSampleData":false,"master":"633b26db38fba6f9e46a1c81ff6722fd"},{"workspace":{"datasources":[],"dimensions":{"w":763.0}},"components":[{"size":"xx-small","data":[["Members with an ending membership and inactive members are important since reactivating these members takes less effort than gaining new members"]],"displayName":"Label 6","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":"\"Members with an ending membership and inactive members are important since reactivating these members takes less effort than gaining new members\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"cx-color_888","id":"15d7353d-1","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst15d7353d1"},"wrap":true},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"size":"x-small","data":[["Status"]],"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":"\"Status\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"9615472b","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst9615472b"},"wrap":true},{"layoutConfig":{"x":1.0,"y":0.0},"orientation":"v","displayName":"Separator 2","id":"fb0fabbd","type":"separator"},{"data":[["Q1"]],"displayName":"Label 3","formulas":[{"txt":"\"Q1\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst6ef22b08"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"x-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":"6ef22b08","wrap":true},{"data":[["Q2"]],"displayName":"Label 3 Copy","formulas":[{"txt":"\"Q2\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#ED6614","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstfe3c2e2e"},"align":"c","layoutConfig":{"x":3.0,"y":0.0},"size":"x-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":"fe3c2e2e","wrap":true},{"data":[["Q3"]],"displayName":"Label 3 Copy 2","formulas":[{"txt":"\"Q3\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#CA320A","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstd325c42d"},"align":"c","layoutConfig":{"x":4.0,"y":0.0},"size":"x-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":"d325c42d","wrap":true},{"data":[["Q4"]],"displayName":"Label 3 Copy 3","formulas":[{"txt":"\"Q4\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#00821F","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstf453f127"},"align":"c","layoutConfig":{"x":5.0,"y":0.0},"size":"x-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":"f453f127","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"displayName":"Separator","id":"da6a4e60","type":"separator"},{"layoutConfig":{"x":2.0,"y":1.0},"displayName":"Separator Copy","id":"5c2b26a1","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"size":"x-small","data":[["Ending memberships"]],"displayName":"Label 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Ending memberships\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"c69c6d68","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstc69c6d68"},"wrap":true},{"data":[["5000"]],"displayName":"Label 4","formulas":[{"txt":"\"5000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst5d22910e"},"align":"c","layoutConfig":{"x":2.0,"y":2.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"5d22910e","wrap":true},{"data":[["2400"]],"displayName":"Label 4 Copy 11","formulas":[{"txt":"\"2400\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#ED6614","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dsteb47a38c"},"align":"c","layoutConfig":{"x":3.0,"y":2.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"eb47a38c","wrap":true},{"data":[["3500"]],"displayName":"Label 4 Copy 5","formulas":[{"txt":"\"3500\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#CA320A","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst3b5c9d6a"},"align":"c","layoutConfig":{"x":4.0,"y":2.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"3b5c9d6a","wrap":true},{"data":[["8000"]],"displayName":"Label 5 Copy 2","formulas":[{"txt":"\"8000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#00821F","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstec4afef0"},"align":"c","layoutConfig":{"x":5.0,"y":2.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"ec4afef0","wrap":true},{"layoutConfig":{"x":0.0,"y":3.0},"size":"x-small","data":[["Inactive/Suspended"]],"displayName":"Label 2 Copy","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":"\"Inactive/Suspended\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"928c411d","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst928c411d"},"wrap":true},{"data":[["8000"]],"displayName":"Label 4 Copy","formulas":[{"txt":"\"8000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstf6f5b7b9"},"align":"c","layoutConfig":{"x":2.0,"y":3.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"f6f5b7b9","wrap":true},{"data":[["9000"]],"displayName":"Label 4 Copy 4","formulas":[{"txt":"\"9000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#ED6614","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstf944fc6b"},"align":"c","layoutConfig":{"x":3.0,"y":3.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"f944fc6b","wrap":true},{"data":[["3500"]],"displayName":"Label 4 Copy 13","formulas":[{"txt":"\"10000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#CA320A","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst755562a1"},"align":"c","layoutConfig":{"x":4.0,"y":3.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"755562a1","wrap":true},{"data":[],"displayName":"Label 4 Copy 7","formulas":[],"autoFmt":true,"font_colour":"#00821F","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst4f27433f"},"layoutConfig":{"x":5.0,"y":3.0},"size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":""},"id":"4f27433f","wrap":true},{"layoutConfig":{"x":0.0,"y":4.0},"size":"x-small","data":[["Active"]],"displayName":"Label 2 Copy 2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Active\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"f46e912b","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstf46e912b"},"wrap":true},{"data":[["80000"]],"displayName":"Label 4 Copy 2","formulas":[{"txt":"\"80000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dsted7984c6"},"align":"c","layoutConfig":{"x":2.0,"y":4.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"ed7984c6","wrap":true},{"data":[["85000"]],"displayName":"Label 5 Copy","formulas":[{"txt":"\"85000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#ED6614","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst838a7cff"},"align":"c","layoutConfig":{"x":3.0,"y":4.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"838a7cff","wrap":true},{"data":[["82500"]],"displayName":"Label 4 Copy 9","formulas":[{"txt":"\"82500\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#CA320A","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstd7742437"},"align":"c","layoutConfig":{"x":4.0,"y":4.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"d7742437","wrap":true},{"data":[],"displayName":"Label 4 Copy 10","formulas":[],"autoFmt":true,"font_colour":"#00821F","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst1a3c70e6"},"layoutConfig":{"x":5.0,"y":4.0},"size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":""},"id":"1a3c70e6","wrap":true},{"layoutConfig":{"x":0.0,"y":5.0},"size":"x-small","data":[["Participating in competitions"]],"displayName":"Label 2 Copy 3","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":"\"Participating in competitions\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"afabdca0","type":"label","fmt":"txt","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dstafabdca0"},"wrap":true},{"data":[["10000"]],"displayName":"Label 4 Copy 3","formulas":[{"txt":"\"10000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst1a64a38f"},"align":"c","layoutConfig":{"x":2.0,"y":5.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"1a64a38f","wrap":true},{"data":[["11000"]],"displayName":"Label 5","formulas":[{"txt":"\"11000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#ED6614","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst7f91d266"},"align":"c","layoutConfig":{"x":3.0,"y":5.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"7f91d266","wrap":true},{"data":[["12000"]],"displayName":"Label 4 Copy 8","formulas":[{"txt":"\"12000\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#CA320A","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst0d421bf8"},"align":"c","layoutConfig":{"x":4.0,"y":5.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":"","separator":",."},"id":"0d421bf8","wrap":true},{"data":[],"displayName":"Label 4 Copy 6","formulas":[],"autoFmt":true,"font_colour":"#00821F","type":"label","fmt":"num","dstContext":{"kid":"adae159ca270dc5c3f5d0054e4b91ca0","id":"dst18766271"},"layoutConfig":{"x":5.0,"y":5.0},"size":"xx-small","fmtArgs":{"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":""},"id":"18766271","wrap":true}],"displayName":"Layout Grid","widths":[{"w":20.0,"x":1.0},{"w":210.0,"x":0.0}],"id":"d7583296","cellData":[{"x":1.0,"h":6.0,"y":0.0},{"w":4.0,"x":2.0,"y":1.0},{"x":0.0,"y":1.0},{"x":0.0,"y":0.0},{"x":0.0,"y":2.0}],"type":"panel_grid","rows":6.0,"rowHeights":[{"h":25.0,"y":1.0}],"cols":6.0}],"isForked":false,"id":"db357ad945a0cf1437d912950ce9d7f7","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Quarterly Membership Status Overview","usesSampleData":false,"master":"adae159ca270dc5c3f5d0054e4b91ca0"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":1012.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"line_colour":"#ED6614","displayName":"Separator","id":"fba46612","type":"separator"},{"data":[["Inzicht in leden"]],"displayName":"Label","formulas":[{"txt":"\"Member Insights\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#ED6614","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"5859f6b4a732e06382a1fe02dc0a9583","id":"dst7d01fe40"},"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":"7d01fe40","wrap":true},{"layoutConfig":{"x":2.0,"y":0.0},"line_colour":"#ED6614","displayName":"Separator Copy","id":"5719749a","type":"separator"}],"displayName":"Layout Grid","id":"634b3063","cellData":[{"x":2.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":1.0,"cols":3.0}],"isForked":false,"id":"0a703ecc700bd3aada557ae8d392ecc6","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Insights header","usesSampleData":false,"master":"5859f6b4a732e06382a1fe02dc0a9583"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":550.0}},"components":[{"components":[{"components":[],"role":"current","data":[[4.0]],"displayName":"Current Value","formulas":[{"txt":"4","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"num","dstContext":{"ops":[],"kid":"07fa40878b5fd6c9310d26d3a2f70dbd","id":"dstb50bc488","aggs":{"f2b1713a":"auto","8c8c4625":"auto","b50bc488":"count"}},"size":"x-large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0","suffix":""},"id":"b50bc488","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-grey","isScalar":true}]}]},{"role":"target","size":"medium","data":[[10.0]],"displayName":"Target Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"prefix":"Target: ","precision":"0","suffix":""},"formulas":[{"txt":"10","ver":2.0,"src":{"c":[{"t":"l","v":"80"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_888","id":"16a5a806","type":"label","fmt":"num","dstContext":{"ops":[],"kid":"07fa40878b5fd6c9310d26d3a2f70dbd","id":"dst16a5a806","aggs":{"16a5a806":"count","b50bc488":"count"}}},{"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":[],"kid":"07fa40878b5fd6c9310d26d3a2f70dbd","id":"dst010fc19b","aggs":{"010fc19b":"auto"}},"size":"medium","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"}},"id":"010fc19b"},{"role":"max","data":[[12.0]],"displayName":"Max Value","formulas":[{"txt":"1.2*&'16a5a806'","ver":2.0}],"autoFmt":true,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"num","dstContext":{"ops":[],"kid":"07fa40878b5fd6c9310d26d3a2f70dbd","id":"dst528a2a01","aggs":{"528a2a01":"auto"}},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":""},"id":"528a2a01"}],"size":"4","displayName":"Gauge","id":"896a1ed2","type":"gauge","dstContext":{"id":"dst896a1ed2"},"conditions":[{"predicates":[{"left":{"cx":"b50bc488"},"right":{"cx":"16a5a806"},"type":"lt"}],"reactions":[{"type":"color","value":"#CA320A","isScalar":true}]},{"predicates":[{"left":{"cx":"b50bc488"},"right":{"cx":"16a5a806"},"type":"gteq"}],"reactions":[{"type":"color","value":"#ED6614","isScalar":true}]}],"gaugeStyle":"vg"}],"isForked":false,"id":"9779b441a493dec24a4d5d42472832d7","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Net Growth Year-to-Date","usesSampleData":false,"master":"07fa40878b5fd6c9310d26d3a2f70dbd"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":1012.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"line_colour":"#ED6614","displayName":"Separator","id":"f9451ee3","type":"separator"},{"data":[["Year-on-Year Membership Base Development"]],"displayName":"Label","formulas":[{"txt":"\"Year-on-Year Membership Base Development\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#ED6614","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"1bf255f2c7eb714d1a2e9956937b2efe","id":"dst683b7c94"},"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":"683b7c94","wrap":true},{"layoutConfig":{"x":2.0,"y":0.0},"line_colour":"#ED6614","displayName":"Separator Copy","id":"84ee1f7c","type":"separator"}],"displayName":"Layout Grid","id":"2abde659","cellData":[{"x":2.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":1.0,"cols":3.0}],"isForked":false,"id":"9c86465b18a3ae3a02700ba13c72bb9a","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Header YoY Development","usesSampleData":false,"master":"1bf255f2c7eb714d1a2e9956937b2efe"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":1012.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"line_colour":"#ED6614","displayName":"Separator","id":"de59daad","type":"separator"},{"data":[["Instroom en uitstroom"]],"displayName":"Label","formulas":[{"txt":"\"Instroom en uitstroom\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#ED6614","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"1bf255f2c7eb714d1a2e9956937b2efe","id":"dst58990fa6"},"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":"58990fa6","wrap":true},{"layoutConfig":{"x":2.0,"y":0.0},"line_colour":"#ED6614","displayName":"Separator Copy","id":"007651c7","type":"separator"}],"displayName":"Layout Grid","id":"c409c77c","cellData":[{"x":2.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":1.0,"cols":3.0}],"isForked":false,"id":"016b4100d6bd31c5bffd11efec126bd4","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Header Atletiekunie","usesSampleData":false,"master":"910521a66769266f3acd064b7489d4b3"},{"workspace":{"datasources":[],"dimensions":{"w":1251.0}},"components":[{"components":[{"data":[["Join"]],"displayName":"Label 2 Copy","formulas":[{"txt":"\"Join\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst0715fca6"},"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":"0715fca6","wrap":true},{"data":[["Flow"]],"displayName":"Label Copy 4","formulas":[{"txt":"\"Flow\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst0a440cbd"},"align":"c","layoutConfig":{"x":3.0,"y":0.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"0a440cbd","wrap":true},{"data":[["Leave"]],"displayName":"Label 2 Copy 3","formulas":[{"txt":"\"Leave\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst68c6a3a5"},"align":"c","layoutConfig":{"x":6.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":"68c6a3a5","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"line_colour":"#ec650c","displayName":"Separator 2 Copy 2","line_weight":"5","id":"6d92c4fa","type":"separator"},{"layoutConfig":{"x":0.0,"y":3.0},"components":[{"role":"primary","size":"medium","data":[[3076.0]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"3076","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"989a28f9","type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst989a28f9"},"align":"c"},{"role":"secondary","data":[[123.0]],"displayName":"Secondary Value","formulas":[{"txt":"123","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst80528212"},"align":"c","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"}},"prefix":"delta last year ","autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"80528212","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}]}],"displayName":"Value Pair","id":"f0e115ce","type":"simple_value","dstContext":{"id":"dstf0e115ce"}},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg"]],"resizeWidth":"75","horizAlign":2.0,"displayName":"Image 2 Copy","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst055b4d61"},"layoutConfig":{"x":2.0,"y":3.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"055b4d61"},{"data":[["Pupil"]],"displayName":"Label","formulas":[{"txt":"\"Pupil\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstc0b64a11"},"align":"c","layoutConfig":{"x":3.0,"y":3.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"c0b64a11","wrap":true},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg"]],"resizeWidth":"75","horizAlign":1.0,"displayName":"Image 2 Copy 9","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstdf13d482"},"layoutConfig":{"x":5.0,"y":3.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"df13d482"},{"layoutConfig":{"x":6.0,"y":3.0},"components":[{"role":"primary","data":[[30.0]],"displayName":"Primary Value","formulas":[{"txt":"30","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst8186096f"},"align":"c","size":"medium","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"}},"id":"8186096f","conditions":[{"predicates":[{"left":{"self":1.0}}],"reactions":[{"type":"color","value":"cx-theme_green_3"}]}]},{"role":"secondary","data":[[-50.0]],"displayName":"Secondary Value","formulas":[{"txt":"-50","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst23ca4914"},"align":"c","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"}},"prefix":"delta last year ","autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"23ca4914","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-up-red"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-down-green","isScalar":true}]}]}],"displayName":"Value Pair Copy 8","id":"c9a30f49","type":"simple_value","dstContext":{"id":"dstc9a30f49"}},{"layoutConfig":{"x":0.0,"y":4.0},"line_colour":"#26214F","displayName":"Separator 2","id":"84db688f","type":"separator"},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/oranje_omlaag.svg"]],"resizeWidth":"75","horizAlign":2.0,"displayName":"Image 2 Copy 5","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/oranje_omlaag.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstcc60716d"},"layoutConfig":{"x":3.0,"y":5.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"cc60716d"},{"data":[[2498.0]],"displayName":"Label 6","formulas":[{"txt":"2498","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#ec650c","type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst0a806b96"},"layoutConfig":{"x":4.0,"y":5.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"0a806b96","wrap":true},{"layoutConfig":{"x":0.0,"y":6.0},"components":[{"role":"primary","size":"medium","data":[[695.0]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"695","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"20538e9d","type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst20538e9d"},"align":"c"},{"role":"secondary","data":[[-65.0]],"displayName":"Secondary Value","formulas":[{"txt":"-65","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst399ed12d"},"align":"c","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"}},"prefix":"delta last year ","autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"399ed12d","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-down-red","isScalar":true}]}]}],"displayName":"Value Pair Copy","id":"267b4b8f","type":"simple_value","dstContext":{"id":"dst267b4b8f"}},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg"]],"resizeWidth":"75","horizAlign":2.0,"displayName":"Image 2 Copy 2","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst1f84654d"},"layoutConfig":{"x":2.0,"y":6.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"1f84654d"},{"data":[["Junior"]],"displayName":"Label Copy","formulas":[{"txt":"\"Junior\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst911651db"},"align":"c","layoutConfig":{"x":3.0,"y":6.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":"911651db","wrap":true},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg"]],"resizeWidth":"75","horizAlign":1.0,"displayName":"Image 2 Copy 13","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstb407880b"},"layoutConfig":{"x":5.0,"y":6.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"b407880b"},{"layoutConfig":{"x":6.0,"y":6.0},"components":[{"role":"primary","data":[[844.0]],"displayName":"Primary Value","formulas":[{"txt":"844","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst8e50dd50"},"align":"c","size":"medium","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"}},"id":"8e50dd50","conditions":[{"predicates":[{"left":{"self":1.0}}],"reactions":[{"type":"color","value":"cx-theme_green_3"}]}]},{"role":"secondary","data":[[123.0]],"displayName":"Secondary Value","formulas":[{"txt":"123","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst9a4f645d"},"align":"c","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"}},"prefix":"delta last year ","autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"9a4f645d","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-up-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-down-green","isScalar":true}]}]}],"displayName":"Value Pair Copy 9","id":"3924e0a0","type":"simple_value","dstContext":{"id":"dst3924e0a0"}},{"layoutConfig":{"x":0.0,"y":7.0},"line_colour":"#26214F","displayName":"Separator 2 Copy","id":"97229eab","type":"separator"},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/oranje_omlaag.svg"]],"resizeWidth":"75","horizAlign":2.0,"displayName":"Image 2 Copy 6","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/oranje_omlaag.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstcbfeae88"},"layoutConfig":{"x":3.0,"y":8.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"cbfeae88"},{"data":[[3396.0]],"displayName":"Label 6 Copy 2","formulas":[{"txt":"3396","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#ec650c","type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst7d93da02"},"layoutConfig":{"x":4.0,"y":8.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"7d93da02","wrap":true},{"layoutConfig":{"x":0.0,"y":9.0},"components":[{"role":"primary","size":"medium","data":[[1091.0]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"prefix":"","autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"1091","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"ac30593b","type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstac30593b"},"align":"c"},{"role":"secondary","data":[[75.0]],"displayName":"Secondary Value","formulas":[{"txt":"75","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dsted2a60d5"},"align":"c","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"}},"prefix":"delta last year ","autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"ed2a60d5","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gteq"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}]}],"displayName":"Value Pair Copy 2","id":"c6007b0e","type":"simple_value","dstContext":{"id":"dstc6007b0e"}},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg"]],"resizeWidth":"75","horizAlign":2.0,"displayName":"Image 2 Copy 3","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstec13ec73"},"layoutConfig":{"x":2.0,"y":9.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"ec13ec73"},{"data":[["Senior"]],"displayName":"Label Copy 2","formulas":[{"txt":"\"Senior\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst6b8b4c72"},"align":"c","layoutConfig":{"x":3.0,"y":9.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":"6b8b4c72","wrap":true},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg"]],"resizeWidth":"75","horizAlign":1.0,"displayName":"Image 2 Copy 14","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstb7d96e39"},"layoutConfig":{"x":5.0,"y":9.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"b7d96e39"},{"layoutConfig":{"x":6.0,"y":9.0},"components":[{"role":"primary","data":[[2485.0]],"displayName":"Primary Value","formulas":[{"txt":"2485","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst31d46273"},"align":"c","size":"medium","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"}},"id":"31d46273","conditions":[{"predicates":[{"left":{"self":1.0}}],"reactions":[{"type":"color","value":"cx-theme_green_3"}]}]},{"role":"secondary","data":[[-13.0]],"displayName":"Secondary Value","formulas":[{"txt":"-13","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst6627a9b0"},"align":"c","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"}},"prefix":"delta last year ","autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"6627a9b0","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-up-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-down-green","isScalar":true}]}]}],"displayName":"Value Pair Copy 10","id":"63541b9f","type":"simple_value","dstContext":{"id":"dst63541b9f"}},{"layoutConfig":{"x":0.0,"y":10.0},"line_colour":"#26214F","displayName":"Separator","id":"c0e0a60d","type":"separator"},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/oranje_omlaag.svg"]],"resizeWidth":"75","horizAlign":2.0,"displayName":"Image 2 Copy 7","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/oranje_omlaag.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst5d935785"},"layoutConfig":{"x":3.0,"y":11.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"5d935785"},{"data":[[3309.0]],"displayName":"Label 6 Copy 3","formulas":[{"txt":"3309","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#ec650c","type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst6c93c4e8"},"layoutConfig":{"x":4.0,"y":11.0},"size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"id":"6c93c4e8","wrap":true},{"layoutConfig":{"x":0.0,"y":12.0},"components":[{"role":"primary","size":"medium","data":[[882.0]],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"882","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"id":"3b8de8e4","type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst3b8de8e4"},"align":"c"},{"role":"secondary","data":[[20.0]],"displayName":"Secondary Value","formulas":[{"txt":"20","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst704b8b96"},"align":"c","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"}},"prefix":"delta last year ","autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"704b8b96","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gteq"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-up-green","isScalar":true}]}]}],"displayName":"Value Pair Copy 3","id":"cbf704b7","type":"simple_value","dstContext":{"id":"dstcbf704b7"}},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg"]],"resizeWidth":"75","horizAlign":2.0,"displayName":"Image 2 Copy 4","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstab142b4a"},"layoutConfig":{"x":2.0,"y":12.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"ab142b4a"},{"data":[["Masters"]],"displayName":"Label Copy 3","formulas":[{"txt":"\"Master\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst342a901a"},"align":"c","layoutConfig":{"x":3.0,"y":12.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":"342a901a","wrap":true},{"data":[["https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg"]],"resizeWidth":"75","horizAlign":1.0,"displayName":"Image 2 Copy 15","formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/09/blauw_rechts.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dstc29a0b7f"},"layoutConfig":{"x":5.0,"y":12.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"c29a0b7f"},{"layoutConfig":{"x":6.0,"y":12.0},"components":[{"role":"primary","data":[[726.0]],"displayName":"Primary Value","formulas":[{"txt":"726","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dste2814b1b"},"align":"c","size":"medium","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"}},"id":"e2814b1b","conditions":[{"predicates":[{"left":{"self":1.0}}],"reactions":[{"type":"color","value":"cx-theme_green_3"}]}]},{"role":"secondary","data":[[45.0]],"displayName":"Secondary Value","formulas":[{"txt":"45","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"0101ab8a4d6354432fe62bde354c0fd6","id":"dst9bbd5e52"},"align":"c","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"}},"prefix":"delta last year ","autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"9bbd5e52","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-up-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-down-green","isScalar":true}]}]}],"displayName":"Value Pair Copy 11","id":"56447504","type":"simple_value","dstContext":{"id":"dst56447504"}},{"layoutConfig":{"x":0.0,"y":13.0},"line_colour":"#ec650c","displayName":"Separator 2 Copy 3","line_weight":"5","id":"0fe9ab61","type":"separator"}],"displayName":"Layout Grid","id":"835d7499","cellData":[{"w":2.0,"x":3.0,"y":3.0,"alignment":1.0},{"w":2.0,"x":3.0,"y":0.0,"alignment":1.0},{"x":3.0,"y":4.0},{"x":3.0,"y":5.0,"alignment":2.0},{"w":2.0,"x":3.0,"y":6.0,"alignment":1.0},{"x":3.0,"y":7.0,"alignment":1.0},{"x":3.0,"y":8.0,"alignment":2.0},{"w":2.0,"x":3.0,"y":9.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":3.0,"alignment":1.0},{"x":0.0,"y":5.0,"alignment":1.0},{"w":8.0,"x":0.0,"y":7.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":9.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":0.0,"alignment":1.0},{"w":2.0,"x":3.0,"y":12.0,"alignment":1.0},{"x":3.0,"y":11.0,"alignment":2.0},{"w":2.0,"x":0.0,"y":6.0,"alignment":1.0},{"w":2.0,"x":0.0,"y":12.0,"alignment":1.0},{"w":2.0,"x":6.0,"y":3.0},{"w":2.0,"x":6.0,"y":6.0},{"w":2.0,"x":6.0,"y":9.0},{"w":2.0,"x":6.0,"y":12.0},{"w":2.0,"x":4.0,"y":11.0,"alignment":1.0},{"w":2.0,"x":4.0,"y":8.0,"alignment":1.0},{"w":2.0,"x":4.0,"y":5.0,"alignment":1.0},{"w":2.0,"x":6.0,"y":0.0},{"w":8.0,"x":0.0,"y":1.0},{"w":8.0,"x":0.0,"y":4.0},{"w":8.0,"x":0.0,"y":10.0},{"w":8.0,"x":0.0,"y":13.0}],"type":"panel_grid","rows":14.0,"cols":8.0}],"isForked":false,"titleSize":"medium","id":"bea3733bb3466d2881b42952b5ba9cec","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Join + Flow + Leave","usesSampleData":false,"master":"0101ab8a4d6354432fe62bde354c0fd6"},{"showToolbar":false,"workspace":{"datasources":[],"dimensions":{"w":550.0}},"components":[{"components":[{"layoutConfig":{"x":2.0,"y":0.0},"line_colour":"#26214f","displayName":"Separator","line_weight":"5","id":"08242d68-2","type":"separator"},{"data":[["Sportbond"]],"displayName":"Label","formulas":[{"txt":"\"Sports Association\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214f","type":"label","fmt":"txt","dstContext":{"kid":"0ca86fc670f42293c77e6dd43668d33e","id":"dst239a42163"},"align":"c","layoutConfig":{"x":5.0,"y":0.0},"size":"large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"239a4216-3","wrap":true},{"layoutConfig":{"x":8.0,"y":0.0},"line_colour":"#26214f","displayName":"Separator Copy 2","line_weight":"5","id":"9b5e35a4","type":"separator"},{"layoutConfig":{"x":9.0,"y":0.0},"line_colour":"#26214f","displayName":"Separator Copy","line_weight":"5","id":"700871a5","type":"separator"},{"layoutConfig":{"x":10.0,"y":0.0},"data":[["https://i-spark.nl/wp-content/uploads/2020/10/I-Spark_logo.png"]],"horizAlign":1.0,"displayName":"Image","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"https://i-spark.nl/wp-content/uploads/2020/10/I-Spark_logo.png\"","ver":2.0,"src":{"c":[{"t":"l","v":"/images/components/image-placeholder.png"}],"t":"expr","v":false}}],"autoFmt":true,"id":"87a549ac-1","type":"image","fmt":"txt","dstContext":{"kid":"0ca86fc670f42293c77e6dd43668d33e","id":"dst87a549ac1"},"height":"2"}],"displayName":"Layout Grid","id":"a53da512-1","cellData":[{"x":3.0,"y":0.0,"alignment":1.0},{"x":1.0,"y":0.0,"alignment":1.0},{"w":2.0,"x":2.0,"y":0.0,"alignment":1.0},{"w":2.0,"x":5.0,"y":0.0,"alignment":1.0},{"x":4.0,"y":0.0,"alignment":1.0},{"x":7.0,"y":0.0,"alignment":1.0},{"w":2.0,"x":8.0,"y":0.0,"alignment":1.0},{"x":11.0,"y":0.0,"alignment":1.0},{"w":2.0,"x":10.0,"y":0.0,"cellPadding":[5.0,5.0,5.0,15.0]}],"type":"panel_grid","rows":1.0,"cols":12.0}],"isForked":false,"id":"609b279c23907fd25949207d5978a412","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Header Atletiekunie","usesSampleData":false,"master":"0ca86fc670f42293c77e6dd43668d33e"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":550.0}},"components":[{"components":[{"components":[{"role":"data_x","data":[["1434","1120","1918","1136","524","612","832","1656","1394","1488","1070","1290","1086","1132","578","624","902","1314","1126","1234","1012","688","1280","1962","1058","716","1610","1234","980","1286","1074","1262","772","780","670","1098","618","1084","958","1004","486","826","526","1018","596","920","872","1024","622","692","1014","552","1026","936","1064","838","366","268","686","958","678","850","964","338","504","810","928","728","906","392","236","888","894","1100","524","322","1008","314","1082","894","358","960","442","544","710","384","844","390","148","124","142","102","112","110","146","116","124","194","114","174"]],"displayName":"X","seriesName":"X","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"select(ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,B:B;,ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,D:D;=\"V\")","ver":2.0}],"autoFmt":true,"id":"6eeefafd-3","type":"series_data","fmt":"num","axis":"97f4daa5-7"},{"role":"data_y","data":[[21770.0,26406.0,49654.0,16023.0,10859.0,4337.0,18114.0,17844.0,11739.0,8627.0,10743.0,8992.0,3823.0,5100.0,15893.0,9194.0,42.0,13.0,18.0,270.0,182.0,270.0,222.0,26.0,63.0,73.0,188.0,147.0,274.0,28.0,174.0,156.0,82.0,193.0,102.0,337.0,9.0,193.0,183.0,97.0,191.0,45.0,197.0,136.0,372.0,183.0,9.0,235.0,312.0,140.0,44.0,122.0,142.0,93.0,102.0,194.0,132.0,324.0,41.0,161.0,82.0,338.0,241.0,287.0,353.0,9.0,315.0,69.0,309.0,230.0,326.0,297.0,247.0,181.0,257.0,89.0,385.0,187.0,111.0,220.0,77.0,309.0,341.0,23.0,174.0,242.0,287.0,68.0,50.0,358.0,2.0,114.0,231.0,113.0,39.0,336.0,336.0,226.0,148.0,334.0]],"displayName":"Y","seriesName":"Y","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0","currency":"eur","separator":",."},"formulas":[{"txt":"select(ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,C:C;,ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,D:D;=\"V\")","ver":2.0}],"autoFmt":false,"id":"658f0de8-4","type":"series_data","fmt":"cur","axis":"24d5a16a-8"},{"role":"data_z","data":[],"displayName":"Z","seriesName":"Z","formulas":[],"autoFmt":true,"id":"d04ee020-5","type":"series_data","fmt":"num","axis":"fab4f948-9"},{"role":"data_labels","data":[],"displayName":"Labels","fmtArgs":{"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[],"autoFmt":true,"id":"64b7c541-6","type":"series_labels","fmt":"txt"}],"role":"scatter_data","data":[],"dataDisabled":true,"color":"#26214F","displayName":"Club","formulas":[],"autoFmt":true,"type":"scatter_data","dstContext":{"kid":"423d7d4ce9db036b2aed74fe5687ed2c","id":"dst68827b122"},"overrideColor":true,"scatterName":"Club","id":"68827b12-2"},{"components":[{"role":"data_x","data":[["800","1664","842","792","930","1666","636","1304","1250","1622","1242","1826","728","1246","1408","1966","376","1088","740","1054","332","564","968","1016","1056","312","314","1090","1010","854","924","858","232","336","388","746","1104","512","436","742","834","676","192","112","128","118","166","118","138","148","112","198","118","166","142","122","104","162","194","116","168","142","192","162","138","130","160","106","160","174","176","154","128","200","198","160","136","130","104","188","170","104","188","196","180"]],"displayName":"X","seriesName":"X","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"select(ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,B:B;,and(ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,D:D;=\"S\",ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,A:A;!=\"nr 246\"))","ver":2.0}],"autoFmt":true,"id":"9e1769cc-2","type":"series_data","fmt":"num","axis":"97f4daa5-7"},{"role":"data_y","data":[[3339.0,16409.0,12433.0,11237.0,7774.0,18362.0,13618.0,10.0,393.0,262.0,176.0,307.0,118.0,354.0,113.0,224.0,285.0,181.0,324.0,73.0,49.0,120.0,309.0,63.0,389.0,275.0,50.0,134.0,352.0,335.0,244.0,251.0,277.0,104.0,275.0,219.0,44.0,399.0,358.0,266.0,316.0,28.0,212.0,362.0,350.0,127.0,332.0,310.0,352.0,168.0,344.0,28.0,7.0,219.0,351.0,215.0,101.0,171.0,5.0,28.0,295.0,322.0,386.0,237.0,258.0,192.0,243.0,270.0,398.0,350.0,201.0,33.0,228.0,388.0,267.0,56.0,325.0,4.0,73.0,202.0,130.0,361.0,183.0,207.0,363.0]],"displayName":"Y","seriesName":"Y","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0","currency":"eur","separator":",."},"formulas":[{"txt":"select(ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,C:C;,and(ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,D:D;=\"S\",ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,A:A;!=\"nr 246\")) ","ver":2.0}],"autoFmt":false,"id":"826f92c5-3","type":"series_data","fmt":"cur","axis":"24d5a16a-8"},{"role":"data_z","data":[],"displayName":"Z","seriesName":"Z","formulas":[],"autoFmt":true,"id":"eacdcf9f-4","type":"series_data","fmt":"num","axis":"fab4f948-9"},{"role":"data_labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":true,"id":"b6aefd90-5","type":"series_labels","fmt":"txt"}],"role":"scatter_data","data":[],"dataDisabled":true,"color":"#ed6614","displayName":"Association","formulas":[],"autoFmt":true,"type":"scatter_data","dstContext":{"kid":"423d7d4ce9db036b2aed74fe5687ed2c","id":"dst236f3dbb1"},"overrideColor":true,"scatterName":"Association","id":"236f3dbb-1"},{"role":"axis_x","data":[],"dataDisabled":true,"displayName":"Number of members","formulas":[],"autoFmt":true,"label":"Number of members","type":"chart_axis","fmt":"num","showLabelTicks":true,"showLabel":true,"fmtArgs":{"separator":",."},"id":"97f4daa5-7","labelDrop":0.0},{"customRange":true,"role":"axis_y","data":[],"dataDisabled":true,"max":"1250","displayName":"Revenue per clubmember","formulas":[],"autoFmt":true,"label":"Revenue per clubmember","type":"chart_axis","fmt":"cur","showLabel":true,"min":"0","grid":true,"fmtArgs":{"currency":"eur","separator":",."},"id":"24d5a16a-8","labelDrop":0.0},{"role":"axis_z","data":[],"dataDisabled":true,"displayName":"Untitled","formulas":[],"autoFmt":true,"id":"fab4f948-9","label":"Untitled","type":"chart_axis","fmt":"num","labelDrop":0.0}],"displayName":"Scatter/Bubble Chart","id":"1e79cba1-1","type":"chart_scatter","dstContext":{"id":"dst1e79cba11"},"height":"3"}],"isForked":false,"id":"c0461ba6b9a9fd9b32b52c68ecf2bfc7","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Revenue and Members last year","usesSampleData":false,"master":"423d7d4ce9db036b2aed74fe5687ed2c"},{"padding":[15.0,15.0,"50",15.0],"workspace":{"datasources":[],"dimensions":{"w":550.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","19.123","Pupil",""]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"19.123\",\"Pupil\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Unnamed 1","id":"f42791e2","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ec650c"}]}],"wrap":false}],"displayName":"Table Copy 3","showHeader":false,"id":"fc7b30c8","type":"table","dstContext":{"kid":"f814c4e5ec729b52c0a258435cbf0aa4","id":"dstfc7b30c8"}},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","35.876","Junior",""]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"35.876\",\"Junior\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Unnamed 1","id":"397bbe3c","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ec650c"}]}],"wrap":false}],"displayName":"Table Copy 2","showHeader":false,"id":"773f52c6","type":"table","dstContext":{"kid":"f814c4e5ec729b52c0a258435cbf0aa4","id":"dst773f52c6"}},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","83.654","Senior",""]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"83.654\",\"Senior\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Unnamed 1","id":"4a67b7e8","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ec650c"}]}],"wrap":false}],"displayName":"Table Copy","showHeader":false,"id":"fce8f768","type":"table","dstContext":{"kid":"f814c4e5ec729b52c0a258435cbf0aa4","id":"dstfce8f768"}},{"layoutConfig":{"x":0.0,"y":3.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","20.301","Master",""]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"20.301\",\"Master\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"3"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0"},"name":"Unnamed 1","id":"19831938","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ec650c"}]}],"wrap":false}],"displayName":"Table","showHeader":false,"id":"d4ede9dd","type":"table","dstContext":{"kid":"f814c4e5ec729b52c0a258435cbf0aa4","id":"dstd4ede9dd"}},{"layoutConfig":{"x":0.0,"y":4.0},"components":[{"components":[],"customHeader":false,"role":"tcol","data":[["","158.954","Total Members","+xxx"]],"displayName":"Unnamed 1","formulas":[{"txt":"array(\"\",\"158.954\",\"Total Members\",\"\")","ver":2.0}],"autoFmt":false,"index":0.0,"font_colour":"cx-color_fff","font_style":"bold","type":"table_col","fmt":"txt","align":"c","size":"medium","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"precision":"0"},"name":"Unnamed 1","id":"8a741a20","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#26214F"}]}],"wrap":false}],"displayName":"Table Copy 4","showHeader":false,"id":"0bf865b8","type":"table","dstContext":{"kid":"f814c4e5ec729b52c0a258435cbf0aa4","id":"dst0bf865b8"}}],"displayName":"Layout Grid","id":"f94ca8dd","cellData":[{"x":0.0,"y":0.0,"cellPadding":[75.0,5.0,47.0,5.0]},{"x":0.0,"y":1.0,"cellPadding":[5.0,5.0,47.0,5.0]},{"x":0.0,"y":2.0,"cellPadding":[5.0,5.0,47.0,5.0]},{"x":0.0,"y":3.0,"alignment":1.0,"cellPadding":[5.0,5.0,47.0,5.0]}],"type":"panel_grid","rows":5.0,"cols":1.0}],"innerPadding":"50","isForked":false,"titleSize":"medium","id":"467812c126208d98a5d0d711602319bb","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Members per age category this period","usesSampleData":false,"useSamePadding":false,"master":"f814c4e5ec729b52c0a258435cbf0aa4"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":550.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"components":[],"role":"current","data":[[125.0]],"displayName":"Current Value","formulas":[{"txt":"125","ver":2.0,"src":{"c":[{"t":"l","v":"50"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"num","dstContext":{"ops":[],"kid":"6699c4631a5c28c47c8d3ee3066ca482","id":"dstbe042eac","aggs":{"f2b1713a":"auto","be042eac":"count","8c8c4625":"auto"}},"size":"x-large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"precision":"0","suffix":""},"id":"be042eac","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"cx":"3a03d2b1"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-grey","isScalar":true}]}]},{"role":"target","size":"medium","data":[[100.0]],"displayName":"Target Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"prefix":"Target: ","precision":"0","suffix":""},"formulas":[{"txt":"100","ver":2.0,"src":{"c":[{"t":"l","v":"80"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_888","id":"3a03d2b1","type":"label","fmt":"num","dstContext":{"ops":[],"kid":"6699c4631a5c28c47c8d3ee3066ca482","id":"dst3a03d2b1","aggs":{"3a03d2b1":"count","be042eac":"count"}}},{"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":[],"kid":"6699c4631a5c28c47c8d3ee3066ca482","id":"dst85656558","aggs":{"85656558":"auto"}},"size":"small","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"}},"id":"85656558"},{"role":"max","data":[[200.0]],"displayName":"Max Value","formulas":[{"txt":"&'3a03d2b1'*2","ver":2.0}],"autoFmt":true,"font_colour":"cx-color_888","font_style":"","type":"label","fmt":"num","dstContext":{"ops":[],"kid":"6699c4631a5c28c47c8d3ee3066ca482","id":"dstbc72276b","aggs":{"bc72276b":"auto"}},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"suffix":""},"id":"bc72276b"}],"size":"3","displayName":"Gauge","id":"ab922a9f","type":"gauge","dstContext":{"id":"dstab922a9f"},"conditions":[{"predicates":[{"left":{"cx":"be042eac"},"right":{"cx":"3a03d2b1"},"type":"lt"}],"reactions":[{"type":"color","value":"#26214F","isScalar":true}]},{"predicates":[{"left":{"cx":"be042eac"},"right":{"cx":"3a03d2b1"},"type":"gteq"}],"reactions":[{"type":"color","value":"#00821F","isScalar":true}]}],"gaugeStyle":"ag"}],"displayName":"Layout Grid","id":"b48e5898-1","cellData":[{"x":0.0,"y":0.0},{"x":0.0,"y":1.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"rowHeights":[{"h":90.0,"y":0.0}],"cols":1.0}],"isForked":false,"id":"4a1c78114e8ed06447d9c6975d5e5093","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Net Growth Month-to-Date","usesSampleData":false,"master":"6699c4631a5c28c47c8d3ee3066ca482"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":550.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"components":[{"role":"data","data":[["353"]],"displayName":"stand vorig jaar","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"FIRST(SLICE(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,C:C;,2))","ver":2.0}],"autoFmt":true,"name":"stand vorig jaar","isDstRoot":true,"id":"0be6d236","type":"data_slot","fmt":"num","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dst0be6d236"}}],"role":"primary","data":[["357"]],"displayName":"Primary Value","formulas":[{"txt":"FIRST(SLICE(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,C:C;))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"num","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dst7e6c7ce6"},"align":"c","size":"large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"7e6c7ce6","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"cx":"0be6d236"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-green","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"cx":"0be6d236"},"type":"lt"}],"reactions":[{"type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"cx":"0be6d236"},"type":"eq"}],"reactions":[{"type":"icon","value":"ind-even-yellow","isScalar":true}]}]},{"components":[],"role":"secondary","data":[["(+4 since January 1)"]],"displayName":"Secondary Value","formulas":[{"txt":"CONCAT(\"(+\", NUMBERFORMAT(&'7e6c7ce6'-&'0be6d236'), \" since January 1)\")","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#26214F","type":"label","fmt":"txt","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dstdb028ead"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"db028ead","wrap":"active"}],"displayName":"Value Pair Copy 3","id":"710d8db1","type":"simple_value","dstContext":{"id":"dst710d8db1"}},{"layoutConfig":{"x":0.0,"y":1.0},"displayName":"Separator","id":"ee51d0a5-1","type":"separator"},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"components":[],"role":"primary","data":[["GVSV"]],"displayName":"Primary Value","formulas":[{"txt":"\"GVSV\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"txt","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dst11744eb7"},"align":"c","size":"large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"11744eb7"},{"components":[],"role":"secondary","data":[["Largest club"]],"displayName":"Secondary Value","formulas":[{"txt":"\"Largest club\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#26214F","type":"label","fmt":"txt","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dst2e4429c3"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"2e4429c3","wrap":"active"}],"displayName":"Value Pair","id":"3270424f","type":"simple_value","dstContext":{"id":"dst3270424f"}},{"layoutConfig":{"x":0.0,"y":3.0},"displayName":"Separator 4","id":"be3b00cc-3","type":"separator"},{"layoutConfig":{"x":0.0,"y":4.0},"components":[{"components":[{"role":"data","data":[["353"]],"displayName":"stand vorig jaar","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"FIRST(SLICE(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,C:C;,2))","ver":2.0}],"autoFmt":true,"name":"stand vorig jaar","isDstRoot":true,"id":"c1fbc059","type":"data_slot","fmt":"num","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dstc1fbc059"}}],"role":"primary","data":[[1966.0]],"displayName":"Primary Value","formulas":[{"txt":"max(ccb79639ab9b5acfada501ddb9d91ee4@Verenigingen euro,B:B;)","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"num","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dst89a3e5f2"},"align":"c","size":"large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"89a3e5f2"},{"components":[],"role":"secondary","data":[["# Memberships at largest club"]],"displayName":"Secondary Value","formulas":[{"txt":"\"# Memberships at largest club\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#26214F","type":"label","fmt":"txt","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dstfca5cf07"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"fca5cf07","wrap":"active"}],"displayName":"Value Pair Copy 2","id":"1b1785f9","type":"simple_value","dstContext":{"id":"dst1b1785f9"}},{"layoutConfig":{"x":0.0,"y":5.0},"displayName":"Separator 2","id":"d5fd004f-2","type":"separator"},{"layoutConfig":{"x":0.0,"y":6.0},"components":[{"components":[{"role":"data","data":[["353"]],"displayName":"stand vorig jaar","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"FIRST(SLICE(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,C:C;,2))","ver":2.0}],"autoFmt":true,"name":"stand vorig jaar","isDstRoot":true,"id":"2dd83b61","type":"data_slot","fmt":"num","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dst2dd83b61"}}],"role":"primary","data":[["1-9-2020"]],"displayName":"Primary Value","formulas":[{"txt":"\"01-09-2020\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"dat2","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dst7815b547"},"align":"c","size":"large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"dateInputFormatCustom":"M-d-yyyy","dateFormat":"custom","dateFormatCustom":"M-d-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"},"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M-d-yyyy","dateFormat":"custom","dateFormatCustom":"M-d-yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"id":"7815b547"},{"components":[],"role":"secondary","data":[["Join date last associated club"]],"displayName":"Secondary Value","formulas":[{"txt":"\"Join date last associated club\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#26214F","type":"label","fmt":"txt","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dsta374eb65"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"a374eb65","wrap":"active"}],"displayName":"Value Pair Copy","id":"c4e0635c","type":"simple_value","dstContext":{"id":"dstc4e0635c"}},{"layoutConfig":{"x":0.0,"y":7.0},"displayName":"Separator 3","id":"6c245834-3","type":"separator"},{"layoutConfig":{"x":0.0,"y":8.0},"components":[{"components":[{"role":"data","data":[[448.0]],"displayName":"stand vorig jaar","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"448","ver":2.0}],"autoFmt":true,"name":"stand vorig jaar","isDstRoot":true,"id":"d98a8046","type":"data_slot","fmt":"num","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dstd98a8046"}}],"role":"primary","data":[[445.0]],"displayName":"Primary Value","formulas":[{"txt":"445","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"num","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dst6b9c8448"},"align":"c","size":"large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"precision":"0"},"id":"6b9c8448"},{"components":[],"role":"secondary","data":[["Average number of memberships per club"]],"displayName":"Secondary Value","formulas":[{"txt":"\"Average number of memberships per club\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#26214F","type":"label","fmt":"txt","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dste2060ad8"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"e2060ad8","wrap":"active"}],"displayName":"Value Pair Copy 5","id":"aa310948","type":"simple_value","dstContext":{"id":"dstaa310948"}},{"layoutConfig":{"x":0.0,"y":9.0},"displayName":"Separator 5","id":"beb3e575-7","type":"separator"},{"layoutConfig":{"x":0.0,"y":10.0},"components":[{"components":[{"role":"data","data":[["353"]],"displayName":"stand vorig jaar","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"FIRST(SLICE(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,C:C;,2))","ver":2.0}],"autoFmt":true,"name":"stand vorig jaar","isDstRoot":true,"id":"e225525a","type":"data_slot","fmt":"num","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dste225525a"}}],"role":"primary","data":[[16.0]],"displayName":"Primary Value","formulas":[{"txt":"16","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"num","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dsta05e660b"},"align":"c","size":"large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"a05e660b","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"cx":"e225525a"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-green","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"cx":"e225525a"},"type":"lt"}],"reactions":[{"type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"cx":"e225525a"},"type":"eq"}],"reactions":[{"type":"icon","value":"ind-even-yellow","isScalar":true}]}]},{"components":[],"role":"secondary","data":[["Clubs with > 1 prof, -1 since last year"]],"displayName":"Secondary Value","formulas":[{"txt":"CONCAT(\"Clubs with => 1 prof, -\", NUMBERFORMAT(1), \" since last year\")","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#26214F","type":"label","fmt":"txt","dstContext":{"kid":"6fc462eb77fbbea6f0ee54219c46c916","id":"dstfcb92175"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"fcb92175","wrap":"active"}],"displayName":"Value Pair Copy 4","id":"c8aa06e3","type":"simple_value","dstContext":{"id":"dstc8aa06e3"}}],"displayName":"Layout Grid","id":"383fa02b-1","cellData":[{"x":0.0,"y":1.0,"alignment":1.0},{"x":0.0,"y":3.0,"alignment":1.0},{"x":0.0,"y":5.0,"alignment":1.0},{"x":0.0,"y":7.0,"alignment":1.0},{"x":0.0,"y":9.0,"alignment":1.0},{"x":0.0,"y":0.0,"alignment":1.0},{"x":0.0,"y":2.0,"alignment":1.0},{"x":0.0,"y":4.0,"alignment":1.0},{"x":0.0,"y":6.0,"alignment":1.0},{"x":0.0,"y":8.0,"alignment":1.0},{"x":0.0,"y":10.0,"alignment":1.0}],"type":"panel_grid","rows":11.0,"rowHeights":[{"h":50.0,"y":1.0},{"h":50.0,"y":3.0},{"h":50.0,"y":5.0},{"h":50.0,"y":7.0},{"h":50.0,"y":9.0}],"cols":1.0}],"isForked":false,"titleSize":"medium","id":"ddf45b2cf3442909f2a7982177a8fb3b","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Clubs Summary","usesSampleData":false,"master":"6fc462eb77fbbea6f0ee54219c46c916"},{"workspace":{"datasources":["ccb79639ab9b5acfada501ddb9d91ee4"],"dimensions":{"w":550.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"components":[{"role":"data","data":[["157655"]],"displayName":"stand vorig jaar","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"FIRST(SLICE(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,B:B;,2))","ver":2.0}],"autoFmt":true,"name":"stand vorig jaar","isDstRoot":true,"id":"5ca747ab-1","type":"data_slot","fmt":"num","dstContext":{"kid":"e19fe3b09ef6c44582b61bc3335a1481","id":"dst5ca747ab1"}}],"role":"primary","data":[["158954"]],"displayName":"Primary Value","formulas":[{"txt":"FIRST(SLICE(ccb79639ab9b5acfada501ddb9d91ee4@Sheet1,B:B;))","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_colour":"#26214F","type":"label","fmt":"num","dstContext":{"kid":"e19fe3b09ef6c44582b61bc3335a1481","id":"dst2d54910e3"},"align":"c","size":"x-large","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"separator":",."},"id":"2d54910e-3","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"cx":"5ca747ab-1"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-green","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"cx":"5ca747ab-1"},"type":"lt"}],"reactions":[{"type":"icon","value":"ind-triangle-down-red","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"cx":"5ca747ab-1"},"type":"eq"}],"reactions":[{"type":"icon","value":"ind-even-yellow"}]}]},{"components":[{"role":"data","data":[[1299.0]],"displayName":"verandering","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"&'2d54910e-3'-&'5ca747ab-1'","ver":2.0}],"autoFmt":true,"name":"verandering","isDstRoot":false,"id":"b445b45f-12","type":"data_slot","fmt":"num"}],"role":"secondary","data":[["(+1299 Since January 1)"]],"displayName":"Secondary Value","formulas":[{"txt":"CONCAT(\"(+\", NUMBERFORMAT(&'b445b45f-12'), \" Since January 1)\")","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"#26214F","font_style":"bold,italic","type":"label","fmt":"txt","dstContext":{"kid":"e19fe3b09ef6c44582b61bc3335a1481","id":"dstb40ad60c4"},"align":"c","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","resultAutoDetectedFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}}},"id":"b40ad60c-4","wrap":"active"}],"displayName":"Value Pair","id":"d629a4d9-2","type":"simple_value","dstContext":{"id":"dstd629a4d92"}}],"displayName":"Layout Grid","id":"6eaed9ea-1","cellData":[{"x":0.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":1.0,"cols":1.0}],"isForked":false,"id":"53c1d37c5ae82cdb04701a73b1f60884","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Actual Base","usesSampleData":false,"master":"e19fe3b09ef6c44582b61bc3335a1481"}]}]