This dashboard uses datasources created with VS Datasource.

Gauges: If you have already connected VS Dash to your Ontraport Account you can begin adding gauges to your dashboard.\nHere's how.\n

\n\n","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"c58282575655d1033445a7facb30095bbbf7cb44","type":"html_data","dstContext":{"id":"dstc58282575655d1033445a7facb30095bbbf7cb44"}}],"overflow":"ns","displayName":"Mobile (Message)","id":"96859c165777f45893988ad119acdd2d6eb11dfe","type":"html_tpl2","dstContext":{"id":"dst96859c165777f45893988ad119acdd2d6eb11dfe"},"renamed":true}],"displayName":"Layout Grid","widths":[{"w":110.0,"x":0.0}],"id":"33e7fc3c05e89ff5c5c435322bb1ae97acd7718a","cellData":[{"x":0.0,"y":0.0}],"type":"panel_grid","rows":1.0,"renamed":true,"cols":2.0},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"layoutConfig":{"x":0.0,"y":0.0},"orientation":"v","displayName":"Separator","id":"2bf33e24878854d128bc9e963c5a674aca1c280c","type":"separator"},{"enableClick":false,"data":[],"horizAlign":1.0,"displayName":"Image","formulas":[{"txt":"\"https://static.klipfolio.com/templates/google-analytics/expected-values.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"https://static.klipfolio.com/templates/google-analytics/expected-values.svg"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ef97803bea044ad05fe29d3500f94584","id":"dstd4be76230cd363248295df25e569034048a40c10"},"layoutConfig":{"x":1.0,"y":0.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"d4be76230cd363248295df25e569034048a40c10","resizeHeight":"70","renamed":true},{"layoutConfig":{"x":2.0,"y":0.0},"tpl":"

Set your targets:\n

\n• Vital Stats can provide you a google sheet to update your personal targets related to these reports. Just email us at support@vitalstats.live and request for your target sheet to be connected.\n

","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"4a8d4880225d3f9b6a5a3c1122420636aa4e22f7","type":"html_data","dstContext":{"id":"dst4a8d4880225d3f9b6a5a3c1122420636aa4e22f7"}}],"overflow":"ns","displayName":"Icons (Message)","id":"b743f7b2994badac266b3697187a6efcd9851e75","type":"html_tpl2","dstContext":{"id":"dstb743f7b2994badac266b3697187a6efcd9851e75"},"renamed":true}],"displayName":"Layout Grid","widths":[{"w":85.0,"x":1.0},{"w":20.0,"x":0.0}],"id":"f74859d30123d32ea500ffbef66a2ed9f675d1be","cellData":[{"x":0.0,"y":0.0},{"x":1.0,"y":0.0},{"x":2.0,"y":0.0}],"type":"panel_grid","rows":1.0,"renamed":true,"cols":3.0},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"layoutConfig":{"x":0.0,"y":0.0},"tpl":"

\n• Discover opportunities to improve your performance\n

\n• Grow your business each an every day by staying on the pulse\n

","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"1693597dfd3cbe81509ab1b3e593656dcffe1a52","type":"html_data","dstContext":{"id":"dst1693597dfd3cbe81509ab1b3e593656dcffe1a52"}}],"overflow":"ns","displayName":"Icons \$Message\$ Copy","id":"d4402d39562f715643e7936493d2ce773b135e08","type":"html_tpl2","dstContext":{"id":"dstd4402d39562f715643e7936493d2ce773b135e08"},"renamed":true}],"displayName":"Layout Grid 2","widths":[{"w":20.0,"x":1.0}],"id":"c7da7c8aabe100e4ba075c05814873ec86b4edfb","cellData":[{"x":1.0,"y":0.0},{"w":2.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":2.0},{"layoutConfig":{"x":3.0,"y":0.0},"components":[{"layoutConfig":{"x":0.0,"y":0.0},"orientation":"v","displayName":"Separator 3","id":"07b07ae353a353e51b0593de21cbc21dffd7bc47","type":"separator"},{"enableClick":false,"data":[],"horizAlign":1.0,"displayName":"Image","formulas":[{"txt":"\"https://static.klipfolio.com/templates/google-analytics/manual.svg\"","ver":2.0,"src":{"c":[{"t":"l","v":"https://static.klipfolio.com/templates/google-analytics/manual.svg"}],"t":"expr","v":false}}],"autoFmt":true,"scale":"resize","type":"image","fmt":"txt","dstContext":{"kid":"ef97803bea044ad05fe29d3500f94584","id":"dst5fb266d3739968cb74392688b11e0f8270d8a59b"},"layoutConfig":{"x":1.0,"y":0.0},"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"5fb266d3739968cb74392688b11e0f8270d8a59b","resizeHeight":"70","renamed":true},{"layoutConfig":{"x":2.0,"y":0.0},"tpl":"

Love details? We’ve developed an in-depth page that covers the methodology behind each metric on this dashboard. Take me there.

\n\n","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"309ad6ebdf1a61715db61624cee0f62211e25719","type":"html_data","dstContext":{"id":"dst309ad6ebdf1a61715db61624cee0f62211e25719"}}],"overflow":"ns","displayName":"Slack (Message)","id":"6d7eaf1b549a36602a1d4481bb700a5633f27df2","type":"html_tpl2","dstContext":{"id":"dst6d7eaf1b549a36602a1d4481bb700a5633f27df2"},"renamed":true}],"displayName":"Layout Grid","widths":[{"w":20.0,"x":0.0},{"w":85.0,"x":1.0}],"id":"72671b49699a4946d2ff32de27b0ae701944b904","cellData":[{"x":0.0,"y":0.0},{"x":1.0,"y":0.0}],"type":"panel_grid","rows":1.0,"renamed":true,"cols":3.0},{"vis":false,"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"$imp_secret_key","ver":2.0}],"autoFmt":false,"id":"818f80f5e7911d6d5f57e0fd43fdbf96040fa4d4","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"491f3dbef6888a86acf979f509aee3ce6b8c5816","type":"proxy"}],"displayName":"User Input Control Copy","defaultValue":"b9d1fcd1-cdbb-11e9-b8d6-524ed9740323","controlHidden":"hidden","type":"input","dstContext":{"kid":"ef97803bea044ad05fe29d3500f94584","id":"dst3638d486f5d525aef566251b0168f73c6c8ef945"},"propName":"vs_secret_key","layoutConfig":{"x":0.0,"y":1.0},"useButton":"4a24d3ea-5****","scope":3.0,"inputType":1.0,"id":"3638d486f5d525aef566251b0168f73c6c8ef945","submitAsGroup":"0"}],"displayName":"Layout Grid","widths":[{"w":"30%","x":1.0}],"id":"14394569ebdbee79af2c0a81cee81ac68d0e5c17","cellData":[{"x":0.0,"y":0.0,"cellPadding":[20.0,5.0,20.0,5.0]},{"x":1.0,"y":0.0,"cellPadding":[20.0,10.0,20.0,5.0]},{"x":2.0,"y":0.0,"cellPadding":[20.0,5.0,20.0,10.0]},{"x":3.0,"y":0.0,"cellPadding":[20.0,5.0,5.0,5.0]},{"w":4.0,"x":0.0,"y":1.0}],"type":"panel_grid","rows":2.0,"renamed":true,"cols":4.0},{"layoutConfig":{"x":0.0,"y":3.0},"tpl":"\n\n

Need any additional reports? Submit your requests to us at support@vitalstats.live

","components":[{"mixin":"label","role":"data","data":[],"dataId":"Series1","displayName":"Series1","formulas":[],"autoFmt":true,"isDstRoot":true,"id":"62e2be7994000ac0fa8d33a5896413d4d9e546ca","type":"html_data","dstContext":{"kid":"ef97803bea044ad05fe29d3500f94584","id":"dst62e2be7994000ac0fa8d33a5896413d4d9e546ca"}}],"overflow":"ns","displayName":"Info","id":"6304298dbe1b3692268053099fcd433032684589","type":"html_tpl2","dstContext":{"id":"dst6304298dbe1b3692268053099fcd433032684589"},"renamed":true}],"containerClassName":"responsive","innerPadding":"0","templateName":"Header","isForked":true,"id":"eb9186205e79776a2752c90f4d56ed4c","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Congrats! You're now the proud owner of the Ultimate Ontraport Dashboard.","templateId":"72e5a3ed4e896cbb52a83f2ecbeb2568","usesSampleData":false,"master":"c4e98e897b4fdea7e2f6b4874158fae6"},{"workspace":{"datasources":["81202847048ab773daeebcec6fe0c74c"],"dataSets":[],"dimensions":{"w":1483.0}},"components":[{"components":[{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"PeriodValues","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"ARRAY(\"4w\",\"1y\")","ver":2.0}],"autoFmt":false,"id":"65090f2cf765dcaa8cfd802ca8c3f688ff49d605","type":"proxy","renamed":true},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"fb72d9a33efe29ebb9b7266ccbc3000cb15b1d27","type":"proxy"},{"role":"data","data":[],"displayName":"Period_Start","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", DATE_STARTOF(TODAY(), \"4\", -3 ) , \"1y\", DATE_ADD(TODAY(), \"3\", -12))","ver":2.0}],"autoFmt":true,"name":"Period_Start","isDstRoot":true,"id":"5da92359c92b6b1e1de0e8eca19be605a304637f","type":"data_slot","fmt":"txt","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst5da92359c92b6b1e1de0e8eca19be605a304637f"}},{"role":"data","data":[],"displayName":"Period_END","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", YESTERDAY() , \"1y\", YESTERDAY() )","ver":2.0}],"autoFmt":true,"name":"Period_END","isDstRoot":true,"id":"ec7112110c86eef9f6f8a13544579ef4529f6114","type":"data_slot","fmt":"txt","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dstec7112110c86eef9f6f8a13544579ef4529f6114"}},{"role":"data","data":[],"displayName":"DateComponent","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"0"},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", \"4\" , \"1y\", \"4\")","ver":2.0}],"autoFmt":false,"name":"DateComponent","isDstRoot":true,"id":"2403a70f59597e9d9334d3f0aa1459d677e38bd7","type":"data_slot","fmt":"txt","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst2403a70f59597e9d9334d3f0aa1459d677e38bd7"}},{"role":"data","data":[],"displayName":"DatePrevIncrement","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"0"},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", -4 , \"1y\", -52)","ver":2.0}],"autoFmt":false,"name":"DatePrevIncrement","isDstRoot":true,"id":"fb4ef128ef2ba8546a372705c7ea46ef722a46d1","type":"data_slot","fmt":"num","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dstfb4ef128ef2ba8546a372705c7ea46ef722a46d1"}}],"displayName":"Last Period","scope":1.0,"inputType":1.0,"id":"6ced7a3414ac2aa18b1582bdad370310f9099aa0","type":"input","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst6ced7a3414ac2aa18b1582bdad370310f9099aa0"},"renamed":true,"propName":"stripe_mrr_period"},{"layoutConfig":{"x":3.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", ARRAY(\"Daily\",\"Weekly\"), \"1y\", ARRAY(\"Weekly\",\"Monthly\"), \"_default_\", ARRAY(\"Weekly\",\"Monthly\") )","ver":2.0}],"autoFmt":false,"id":"2f1e5d047ec244cb01c7c54a9a131c4aa2ed53f1","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"df0da47cba0847cc03984916bb3ecfb670bf07af","type":"proxy"},{"role":"data","data":[],"displayName":"Unit","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"30.4167","ver":2.0}],"autoFmt":true,"name":"Untitled","isDstRoot":false,"id":"27f6904a7cc5057bfcfa0e4971b18d699897b978","type":"data_slot","fmt":"num","renamed":true},{"role":"data","data":[],"displayName":"dateUnit","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"SWITCH($stripe_mrr_unit, \"Weekly\", \"4\", \"Monthly\", \"3\" )","ver":2.0}],"autoFmt":true,"name":"dateUnit","isDstRoot":true,"id":"8aa3ffd5d2adeefdd58da40d13785d52c8d0c31b","type":"data_slot","fmt":"num","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst8aa3ffd5d2adeefdd58da40d13785d52c8d0c31b"}},{"role":"data","data":[],"displayName":"dateFormat","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($stripe_mrr_unit,\"Daily\", \"MMM d\", \"Weekly\", \"MMM d yyyy ('w')\", \"Monthly\", \"MMM yy\" )","ver":2.0}],"autoFmt":true,"name":"dateFormat","isDstRoot":true,"id":"85d55617202435d5f5aeb505b7f5f4015d0d6cd1","type":"data_slot","fmt":"txt","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst85d55617202435d5f5aeb505b7f5f4015d0d6cd1"}}],"displayName":"Unit","scope":1.0,"inputType":1.0,"id":"3a2ad794444760a87f1abc88a54f04036a9bfcea","type":"input","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst3a2ad794444760a87f1abc88a54f04036a9bfcea"},"renamed":true,"propName":"stripe_mrr_unit"}],"displayName":"Layout Grid","widths":[{"w":"10%","x":2.0},{"w":"10%","x":3.0}],"id":"db26c3bca61323ff7d6134f08e866e9fb68a8fca","cellData":[{"x":2.0,"y":0.0},{"x":3.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":4.0},{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[],"displayName":"MRR Label","formulas":[{"txt":"\"MRR\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst811169af679421fdd06e2c614a0bd44a5744ff9a"},"layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"811169af679421fdd06e2c614a0bd44a5744ff9a","renamed":true,"wrap":true},{"data":[],"displayName":"MRR Label","formulas":[{"txt":"\"Net Revenue\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst0f1be80f312c9ac13927c2c785da9f425c1b3d25"},"layoutConfig":{"x":1.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"0f1be80f312c9ac13927c2c785da9f425c1b3d25","renamed":true,"wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[],"displayName":"MRR Value","formulas":[{"txt":"LAST(&'5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3')+0","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dste5c902eb0799812d76b1e7f3483bc1ee908aca05"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"id":"e5c902eb0799812d76b1e7f3483bc1ee908aca05","renamed":true,"wrap":true},{"data":[],"displayName":"MRR Comparison %","formulas":[{"txt":"LAST(&'bd5a33473e3ee45c445cdd29dd3395ddd6085a9e')","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_style":"","type":"label","fmt":"num","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dstee629247b0e9f82c91f1921d406265eb4ca07228"},"layoutConfig":{"x":1.0,"y":0.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"1","suffix":"%"},"id":"ee629247b0e9f82c91f1921d406265eb4ca07228","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_green_3","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"#d9251c","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-green","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"icon","value":"ind-triangle-down-red","isScalar":true}]}],"renamed":true,"wrap":true}],"displayName":"MRR Stats","id":"6749fdcb7b014b21516ea665ea495501ac8a4f6a","type":"panel_grid","rows":1.0,"renamed":true,"cols":2.0},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"data":[],"displayName":"MRR Value","formulas":[{"txt":"SUM(&'44ff58f9777134443d9463eeeabc66ae4afdb387')+0","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst582eb28067db5923fc376c038448073d2dac8143"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"0"},"id":"582eb28067db5923fc376c038448073d2dac8143","renamed":true,"wrap":true},{"data":[],"displayName":"MRR Comparison %","formulas":[{"txt":" (SUM(&'44ff58f9777134443d9463eeeabc66ae4afdb387')-SUM(&'0150f88643b78c648fa9deaa3df483b89724ea60'))/SUM(&'0150f88643b78c648fa9deaa3df483b89724ea60')","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_style":"","type":"label","fmt":"pct","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dstfa4f2435b9ae3a4ac4b47dabda98418554292e94"},"layoutConfig":{"x":1.0,"y":0.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"1","suffix":""},"id":"fa4f2435b9ae3a4ac4b47dabda98418554292e94","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_green_3","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"#d9251c","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"left","type":"icon","value":"ind-triangle-up-green","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"icon","value":"ind-triangle-down-red","isScalar":true}]}],"renamed":true,"wrap":true}],"displayName":"Revenue Stats","id":"01d8f4d32e1856dac156037a13a425096265753b","type":"panel_grid","rows":1.0,"renamed":true,"cols":2.0},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"renderer":"line","role":"series","data":[],"color":"#07bdff","displayName":"MRR Current","seriesName":"Current","formulas":[{"txt":"&'254a1915d8733584fa8f2d0b8a2ac661e37ee0a9'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"3e1e1021c54613a66d62d6b21a2cca6025bb89fc","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3","renamed":true},{"renderer":"line","role":"series","data":[],"color":"cx-theme_888","displayName":"MRR Previous","seriesName":"Previous","formulas":[{"txt":"&'1456d65d473fd0b65c92564fd540e85a95aa0d9f'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"3e1e1021c54613a66d62d6b21a2cca6025bb89fc","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"9d4c6ab577c99b334615a24285062f3b3c5e78c5","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ffd014","displayName":"MRR Comparison","seriesName":"Prev. Period Comparison","formulas":[{"txt":"((&'5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3'/&'9d4c6ab577c99b334615a24285062f3b3c5e78c5')-1)*100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"2d1f4c96ecab5c5b7ccb77ad6f7303be2afc2ac1","chartStyle":"line","overrideColor":true,"lineWeight":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","precision":"1","dateInputFormat":"epoch"},"id":"bd5a33473e3ee45c445cdd29dd3395ddd6085a9e","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ab00ee","displayName":"MRR Trend","seriesName":"Trend","formulas":[{"txt":"( MAP( CUMULATIVE( REPEAT( 1 , COUNT( &'5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3') ) ) , \"x\" , ( ( SLOPE( &'5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3') ) ) ) ) * $x ) + ( FIRST( &'5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3') - ( SLOPE( &'5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3') ) ) ) ) ) ) ) ) + 1 )","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"3e1e1021c54613a66d62d6b21a2cca6025bb89fc","lineDashes":"ShortDot","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"be526699e5c2e1b22ed933025d3150ea2f820eba","renamed":true},{"role":"axis_x","data":[],"displayName":"MRR Time","formulas":[{"txt":"SWITCH($stripe_mrr_unit, \n\"Daily\", &'705a442063559261f8efef678381051c6e12dd3a',\n\"Weekly\", &'06d232de1acce80556755959ba0fdc1b558130e0',\n\"Monthly\", &'8d1af01c27adccd0ae90be16826a82ef59cc9635'\n)","ver":2.0}],"autoFmt":false,"label":"Untitled","type":"chart_axis","fmt":"txt","labelStagger":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d","dateFormatCustom":"MMM d","dateInputFormat":"epoch"},"labelAngle":"-45","id":"94608a7d56d455a1f7f0646b04399b6b1394c671","showAxis":false,"labelDrop":"0","renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"MRR Value","formulas":[],"autoFmt":true,"label":"MRR Value","type":"chart_axis","fmt":"cur","grid":true,"fmtArgs":{},"originLine":false,"id":"3e1e1021c54613a66d62d6b21a2cca6025bb89fc","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"%","formulas":[],"autoFmt":true,"axisPosition":"right","label":"%","type":"chart_axis","fmt":"pct","showLabelTicks":true,"fmtArgs":{"precision":"2"},"originLine":false,"id":"2d1f4c96ecab5c5b7ccb77ad6f7303be2afc2ac1","labelDrop":0.0},{"role":"data","data":[],"displayName":"sort","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"d/M/yyyy","dateInputFormat":"d/M/yyyy"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"&'705a442063559261f8efef678381051c6e12dd3a'","ver":2.0}],"autoFmt":true,"name":"sort","isDstRoot":false,"id":"394d4cb2c33712b347594a7faf812caa1a2415a5","type":"data_slot","fmt":"dat2"}],"displayName":"MRR value","showLegend":1.0,"id":"45a2cdb7ec77be3c24b7b67e8a20edaac1d92f2b","type":"chart_series","dstContext":{"ops":[{"groupBy":"94608a7d56d455a1f7f0646b04399b6b1394c671","type":"group"},{"sortBy":[{"dim":"394d4cb2c33712b347594a7faf812caa1a2415a5","dir":1.0}],"type":"sort"}],"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst45a2cdb7ec77be3c24b7b67e8a20edaac1d92f2b","aggs":{"394d4cb2c33712b347594a7faf812caa1a2415a5":"first","bd5a33473e3ee45c445cdd29dd3395ddd6085a9e":"average","5c175500752ec90aebf0e8d3bb416ab2cc1bf0e3":"sum","e57bd61aa3f02610ef46a6e166c98b5a3b21fec2":"auto","be526699e5c2e1b22ed933025d3150ea2f820eba":"sum","9d4c6ab577c99b334615a24285062f3b3c5e78c5":"sum"}},"renamed":true,"height":"2"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"renderer":"line","role":"series","data":[],"color":"#07bdff","displayName":"NR Current","seriesName":"Current","formulas":[{"txt":"&'7c83ac2327a8c80cdf30be116fc8f4b9ae4e551c'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"01b279d2e42010aa5a4fdcbb49fb78a62ae54cda","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"44ff58f9777134443d9463eeeabc66ae4afdb387","renamed":true},{"renderer":"line","role":"series","data":[],"color":"cx-theme_888","displayName":"NR Previous","seriesName":"Previous","formulas":[{"txt":"&'9c312f508c08ef2b024e9f52255c0ec08d585516'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"01b279d2e42010aa5a4fdcbb49fb78a62ae54cda","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"0150f88643b78c648fa9deaa3df483b89724ea60","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ab00ee","displayName":"NR Trend","seriesName":"Trend","formulas":[{"txt":"( MAP( CUMULATIVE( REPEAT( 1 , COUNT( &'44ff58f9777134443d9463eeeabc66ae4afdb387') ) ) , \"x\" , ( ( SLOPE( &'44ff58f9777134443d9463eeeabc66ae4afdb387', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'44ff58f9777134443d9463eeeabc66ae4afdb387') ) ) ) ) * $x ) + ( FIRST( &'44ff58f9777134443d9463eeeabc66ae4afdb387') - ( SLOPE( &'44ff58f9777134443d9463eeeabc66ae4afdb387', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'44ff58f9777134443d9463eeeabc66ae4afdb387') ) ) ) ) ) ) ) ) + 1 )","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"01b279d2e42010aa5a4fdcbb49fb78a62ae54cda","lineDashes":"ShortDot","lineStyle":"curve","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"ea80f2a9d2bb1f4f7ab036d5bab43d47383fb2d6","renamed":true},{"role":"axis_x","data":[],"displayName":"NR Time","formulas":[{"txt":"SWITCH($stripe_mrr_unit, \n\"Daily\", &'705a442063559261f8efef678381051c6e12dd3a',\n\"Weekly\", &'06d232de1acce80556755959ba0fdc1b558130e0',\n\"Monthly\", &'8d1af01c27adccd0ae90be16826a82ef59cc9635'\n)","ver":2.0}],"autoFmt":false,"label":"Untitled","type":"chart_axis","fmt":"txt","labelStagger":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d","dateFormatCustom":"MMM d","dateInputFormat":"epoch"},"labelAngle":"-45","id":"6453a64ef7b894fa7ca0537801687bec9a93af76","showAxis":false,"labelDrop":"0","renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"MRR Value","formulas":[],"autoFmt":true,"label":"MRR Value","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"originLine":false,"id":"01b279d2e42010aa5a4fdcbb49fb78a62ae54cda","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"%","formulas":[],"autoFmt":true,"axisPosition":"right","label":"%","type":"chart_axis","fmt":"pct","showLabelTicks":true,"fmtArgs":{"precision":"2"},"originLine":false,"id":"fccedbead56177d84fea4f4934e78e5dcb5a9424","labelDrop":0.0},{"role":"data","data":[],"displayName":"sort","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"d/M/yyyy","dateInputFormat":"d/M/yyyy"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"&'705a442063559261f8efef678381051c6e12dd3a'","ver":2.0}],"autoFmt":true,"name":"sort","isDstRoot":false,"id":"473edd525ec8567f79d935bd53fbca1c2a3828d8","type":"data_slot","fmt":"dat2"}],"displayName":"Net Revenue","showLegend":1.0,"id":"120d7f051c60e9e335d222a89db947aae09e54dd","type":"chart_series","dstContext":{"ops":[{"groupBy":"6453a64ef7b894fa7ca0537801687bec9a93af76","type":"group"},{"sortBy":[{"dim":"473edd525ec8567f79d935bd53fbca1c2a3828d8","dir":1.0}],"type":"sort"}],"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst120d7f051c60e9e335d222a89db947aae09e54dd","aggs":{"ea80f2a9d2bb1f4f7ab036d5bab43d47383fb2d6":"auto","394d4cb2c33712b347594a7faf812caa1a2415a5":"first","473edd525ec8567f79d935bd53fbca1c2a3828d8":"first","8a9bdc905d3fb18a6cd26ae4f386042a2436e498":"auto","0150f88643b78c648fa9deaa3df483b89724ea60":"sum","44ff58f9777134443d9463eeeabc66ae4afdb387":"sum"}},"renamed":true,"height":"2"},{"layoutConfig":{"x":0.0,"y":3.0},"size":"xx-small","data":[],"displayName":"Label Copy","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"MRR growth\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"ab40f28d5c5e52f08f0818e7e7cf55dd7c78b835","type":"label","fmt":"txt","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dstab40f28d5c5e52f08f0818e7e7cf55dd7c78b835"},"wrap":true},{"data":[],"displayName":"MRR Label Copy","formulas":[{"txt":"\"New Subscribers\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dstf7dfaef2c788b8357fcc0126193a0e67b7204080"},"layoutConfig":{"x":1.0,"y":3.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"f7dfaef2c788b8357fcc0126193a0e67b7204080","renamed":true,"wrap":true},{"layoutConfig":{"x":0.0,"y":4.0},"components":[{"data":[],"displayName":"Label","formulas":[{"txt":"SUM(&'1ed77682cca0e4f3da071da24a35f45eeaadd9dd')+0","ver":2.0}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst8b7bb361940540a7f01a0c745067cc905d2829ab"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"id":"8b7bb361940540a7f01a0c745067cc905d2829ab","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-up-green","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"pos":"right","type":"icon","value":"ind-triangle-down-red","isScalar":true}]}],"wrap":true},{"data":[],"displayName":"Label","formulas":[],"autoFmt":false,"font_style":"","type":"label","fmt":"pct","dstContext":{"kid":"bd554c616f7adf56efb8bb40e97dec6d","id":"dst0ab9c44593353917c6e30ab6599c61d82700f887"},"layoutConfig":{"x":1.0,"y":0.0},"size":"x-small","fmtArgs":{"precision":"1"},"id":"0ab9c44593353917c6e30ab6599c61d82700f887","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_green_3","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"#d9251c","isScalar":true}]}],"wrap":true}],"displayName":"Layout Grid 3","id":"97b513e7c08d5cb4099531bd5b4842b7eb408352","type":"panel_grid","rows":1.0,"cols":2.0},{"layoutConfig":{"x":1.0,"y":4.0},"components":[{"data":[],"displayName":"MRR Value ","formulas":[{"txt":"SUM(&'250966712ea97ad2b0d88ef397a728370cb0913c'+0)","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"num","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dstdc2f3425404df6e6861e1686ab31de75d905ad61"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"0"},"id":"dc2f3425404df6e6861e1686ab31de75d905ad61","renamed":true,"wrap":true},{"data":[],"displayName":"MRR Comparison %","formulas":[{"txt":"((SUM(&'250966712ea97ad2b0d88ef397a728370cb0913c')/SUM(&'9f5c913382befa9940d57d84adef7be322e5b619') )-1)*100","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_style":"","type":"label","fmt":"num","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dstd5314feb805c45c64059813aaca1f4812ad10f2f"},"layoutConfig":{"x":1.0,"y":0.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"1","suffix":"%"},"id":"d5314feb805c45c64059813aaca1f4812ad10f2f","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_green_3","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"#d9251c","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-green","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"icon","value":"ind-triangle-down-red","isScalar":true}]}],"renamed":true,"wrap":true}],"displayName":"Revenue Stats","id":"64e1f5b4dc49e08a0f9a97e0e579763d996837e1","type":"panel_grid","rows":1.0,"renamed":true,"cols":2.0},{"layoutConfig":{"x":0.0,"y":5.0},"components":[{"role":"series","data":[],"color":"#07bdff","displayName":"New","seriesName":"New $","formulas":[{"txt":"&'0f8367185d03dcc6eda75808133f51fb6449d035'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"0d478e986334708ab5b9d3e37d41423eb728e018","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"51c9b5a290560a19764cc388e9ca6f8eea2b89ee","renamed":true},{"role":"series","data":[],"color":"#ff5456","displayName":"Churn","seriesName":"Churn $","formulas":[{"txt":"&'09bae6767a047f72bf8410f4c501e39346be7116'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"0d478e986334708ab5b9d3e37d41423eb728e018","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"002a291f14eb71fc0877995463fd22b66b8f0329","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ffd014","displayName":"Net Growth","seriesName":"Net Growth","formulas":[{"txt":"&'51c9b5a290560a19764cc388e9ca6f8eea2b89ee'+&'002a291f14eb71fc0877995463fd22b66b8f0329'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"0d478e986334708ab5b9d3e37d41423eb728e018","lineStyle":"curve","overrideColor":true,"lineWeight":"3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","precision":"0","dateInputFormat":"epoch"},"id":"1ed77682cca0e4f3da071da24a35f45eeaadd9dd","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"#36d190"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"#ff5456"}]}],"renamed":true},{"role":"axis_x","data":[],"displayName":"Time","formulas":[{"txt":"SWITCH($stripe_mrr_unit, \n\"Daily\", &'705a442063559261f8efef678381051c6e12dd3a',\n\"Weekly\", &'06d232de1acce80556755959ba0fdc1b558130e0',\n\"Monthly\", &'8d1af01c27adccd0ae90be16826a82ef59cc9635'\n)","ver":2.0}],"autoFmt":false,"label":"Untitled","type":"chart_axis","fmt":"txt","labelStagger":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d","dateFormatCustom":"MMM d","dateInputFormat":"epoch"},"labelAngle":"-45","id":"ffad7ff9a526bd92cbe4b6063e50360e25b0c543","showAxis":false,"labelDrop":"0","renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Value","formulas":[],"autoFmt":true,"label":"Value","type":"chart_axis","fmt":"cur","grid":true,"fmtArgs":{"precision":"2"},"originLine":false,"id":"0d478e986334708ab5b9d3e37d41423eb728e018","labelDrop":0.0},{"role":"data","data":[],"displayName":"sort","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"d/M/yyyy","dateInputFormat":"d/M/yyyy"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"&'705a442063559261f8efef678381051c6e12dd3a'","ver":2.0}],"autoFmt":true,"name":"sort","isDstRoot":false,"id":"da6ebf34c578cd440ddd21b77da6e0884273cd39","type":"data_slot","fmt":"dat2"}],"displayName":"MRR Growth","showLegend":1.0,"id":"872a771ee02bcc717e87f49de49f60e623be95ef","type":"chart_series","dstContext":{"ops":[{"groupBy":"ffad7ff9a526bd92cbe4b6063e50360e25b0c543","type":"group"},{"sortBy":[{"dim":"da6ebf34c578cd440ddd21b77da6e0884273cd39","dir":1.0}],"type":"sort"}],"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst872a771ee02bcc717e87f49de49f60e623be95ef","aggs":{"da6ebf34c578cd440ddd21b77da6e0884273cd39":"first","394d4cb2c33712b347594a7faf812caa1a2415a5":"first","51c9b5a290560a19764cc388e9ca6f8eea2b89ee":"sum","473edd525ec8567f79d935bd53fbca1c2a3828d8":"first","1ed77682cca0e4f3da071da24a35f45eeaadd9dd":"sum","002a291f14eb71fc0877995463fd22b66b8f0329":"sum"}},"renamed":true,"stackBars":"1","height":"2"},{"layoutConfig":{"x":1.0,"y":5.0},"components":[{"renderer":"line","role":"series","data":[],"color":"#07bdff","displayName":"New Current","seriesName":"# New","formulas":[{"txt":"&'6734cb44cf74fdd54c5ad21467051a5fd8eac148'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"8689baf03f34630f22e2f7179f56d674e2b75810","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"250966712ea97ad2b0d88ef397a728370cb0913c","renamed":true},{"renderer":"line","role":"series","data":[],"color":"cx-theme_888","displayName":"New Previous","seriesName":"# New Previous","formulas":[{"txt":"&'9f8d553d831a8ef8b921f89affc2b23dd9951ace'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"8689baf03f34630f22e2f7179f56d674e2b75810","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"9f5c913382befa9940d57d84adef7be322e5b619","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ffd014","displayName":"New Comparison","seriesName":"% Comparison","formulas":[{"txt":"((&'250966712ea97ad2b0d88ef397a728370cb0913c'/&'9f5c913382befa9940d57d84adef7be322e5b619')-1)*100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"1aaa0f9862606ebc43a6921861b18ca249ce8223","chartStyle":"line","overrideColor":true,"lineWeight":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","precision":"1","dateInputFormat":"epoch"},"id":"84e655dfffbca726aeabb52f527631eef545c215","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ab00ee","displayName":"New Trend","seriesName":"Trend","formulas":[{"txt":"( MAP( CUMULATIVE( REPEAT( 1 , COUNT( &'250966712ea97ad2b0d88ef397a728370cb0913c') ) ) , \"x\" , ( ( SLOPE( &'250966712ea97ad2b0d88ef397a728370cb0913c', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'250966712ea97ad2b0d88ef397a728370cb0913c') ) ) ) ) * $x ) + ( FIRST( &'250966712ea97ad2b0d88ef397a728370cb0913c') - ( SLOPE( &'250966712ea97ad2b0d88ef397a728370cb0913c', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'250966712ea97ad2b0d88ef397a728370cb0913c') ) ) ) ) ) ) ) ) + 1 )","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"8689baf03f34630f22e2f7179f56d674e2b75810","lineDashes":"ShortDot","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"8d885fff561ed68182b54ecebd207ebe2029d594","renamed":true},{"role":"axis_x","data":[],"displayName":"New Time","formulas":[{"txt":"SWITCH($stripe_mrr_unit, \n\"Daily\", &'705a442063559261f8efef678381051c6e12dd3a',\n\"Weekly\", &'06d232de1acce80556755959ba0fdc1b558130e0',\n\"Monthly\", &'8d1af01c27adccd0ae90be16826a82ef59cc9635'\n)","ver":2.0}],"autoFmt":false,"label":"Untitled","type":"chart_axis","fmt":"txt","labelStagger":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d","dateFormatCustom":"MMM d","dateInputFormat":"epoch"},"labelAngle":"-45","id":"c689a1b98f2e7fea039211b12c16b3275b3a6735","showAxis":false,"labelDrop":"0","renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"MRR Value","formulas":[],"autoFmt":true,"label":"MRR Value","type":"chart_axis","fmt":"num","grid":true,"fmtArgs":{},"originLine":false,"id":"8689baf03f34630f22e2f7179f56d674e2b75810","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"%","formulas":[],"autoFmt":true,"axisPosition":"right","label":"%","type":"chart_axis","fmt":"pct","showLabelTicks":true,"fmtArgs":{"precision":"2"},"originLine":false,"id":"1aaa0f9862606ebc43a6921861b18ca249ce8223","labelDrop":0.0},{"role":"data","data":[],"displayName":"sort","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"d/M/yyyy","dateInputFormat":"d/M/yyyy"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"&'705a442063559261f8efef678381051c6e12dd3a'","ver":2.0}],"autoFmt":true,"name":"sort","isDstRoot":false,"id":"d16b7841b725d28768f425d48dcf5fd5e9e9fd64","type":"data_slot","fmt":"dat2"}],"displayName":"New Subscribers","showLegend":1.0,"id":"6ed3c82923af42692af4e8c93f3d430c2729fe98","type":"chart_series","dstContext":{"ops":[{"groupBy":"c689a1b98f2e7fea039211b12c16b3275b3a6735","type":"group"},{"sortBy":[{"dim":"d16b7841b725d28768f425d48dcf5fd5e9e9fd64","dir":1.0}],"type":"sort"}],"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst6ed3c82923af42692af4e8c93f3d430c2729fe98","aggs":{"8d885fff561ed68182b54ecebd207ebe2029d594":"sum","da6ebf34c578cd440ddd21b77da6e0884273cd39":"first","250966712ea97ad2b0d88ef397a728370cb0913c":"sum","394d4cb2c33712b347594a7faf812caa1a2415a5":"first","9f5c913382befa9940d57d84adef7be322e5b619":"sum","473edd525ec8567f79d935bd53fbca1c2a3828d8":"first","84e655dfffbca726aeabb52f527631eef545c215":"average","d16b7841b725d28768f425d48dcf5fd5e9e9fd64":"first"}},"renamed":true,"height":"2"}],"displayName":"Growth","id":"aa961ba8260895b28073d384953c0c4b1931c181","cellData":[{"x":0.0,"y":2.0,"cellPadding":10.0}],"type":"panel_grid","rows":6.0,"renamed":true,"cols":2.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Day","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"d/M/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Day","id":"705a442063559261f8efef678381051c6e12dd3a"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Week","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,B:B;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Week","id":"06d232de1acce80556755959ba0fdc1b558130e0"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Month","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,C:C;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Month","id":"8d1af01c27adccd0ae90be16826a82ef59cc9635"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"MRR","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,K:K;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"MRR","id":"254a1915d8733584fa8f2d0b8a2ac661e37ee0a9"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"MRR Previous","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,Q:Q;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"MRR Previous","id":"1456d65d473fd0b65c92564fd540e85a95aa0d9f"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Net Revenue","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,G:G;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":5.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Net Revenue","id":"7c83ac2327a8c80cdf30be116fc8f4b9ae4e551c"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"New Subscribers","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,H:H;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":6.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"New Subscribers","id":"35bd43bc9cfae646913d6d3b04083b8336ef17c8"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"New $","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,J:J;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":7.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"New $","id":"0f8367185d03dcc6eda75808133f51fb6449d035"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Churn $","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,I:I;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":8.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Churn $","id":"09bae6767a047f72bf8410f4c501e39346be7116"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"# New","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,R:R;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":9.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"# New","id":"6734cb44cf74fdd54c5ad21467051a5fd8eac148"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"# New Previous","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,S:S;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":10.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"# New Previous","id":"9f8d553d831a8ef8b921f89affc2b23dd9951ace"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Previous Net Revenue","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,T:T;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'5da92359c92b6b1e1de0e8eca19be605a304637f', &'ec7112110c86eef9f6f8a13544579ef4529f6114'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":11.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Previous Net Revenue","id":"9c312f508c08ef2b024e9f52255c0ec08d585516"}],"displayName":"Table","id":"85a0ac985dff055a65243cf6dcee9d49da9c19a3","type":"table","dstContext":{"kid":"fc38452a30a1113726d5f344a4a1410a","id":"dst85a0ac985dff055a65243cf6dcee9d49da9c19a3"}}],"datasourceProps":["vs_secret_key"],"isForked":false,"id":"423e057515a9501dfbd5d3bfba9a58e0","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Subscription Stats Over Time","usesSampleData":false,"master":"71b11606be0959d58add205482950e6e"},{"workspace":{"datasources":["81202847048ab773daeebcec6fe0c74c"],"dataSets":[],"dimensions":{"w":1559.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true}},"formulas":[{"txt":"ARRAY(\"Next 4 Weeks\",\"Next 6 Months\" ,\"Next Year\")","ver":2.0}],"autoFmt":false,"id":"20c7ec05ebc679b2c1dc4dff508d62075863582e","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"473aa2307d91593c65651b91ad76b706149bbcc8","type":"proxy"},{"role":"data","data":[],"displayName":"from","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($var_er_period, \"Next 4 Weeks\", TODAY(),\"Next 6 Months\", TODAY() ,\"Next Year\", TODAY())","ver":2.0}],"autoFmt":true,"name":"from","isDstRoot":true,"id":"fb868ab0997241fe9860d7c0a798f0676a86d113","type":"data_slot","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dstfb868ab0997241fe9860d7c0a798f0676a86d113"}},{"role":"data","data":[],"displayName":"to","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($var_er_period, \"Next 4 Weeks\", DATE_ENDOF(TODAY(), \"4\", 4),\"Next 6 Months\", DATE_ENDOF(TODAY(), \"3\", 6) ,\"Next Year\", DATE_ADD(TODAY(), \"1\", 1))","ver":2.0}],"autoFmt":true,"name":"to","isDstRoot":true,"id":"f27a4b6c599633e02d624c5d918a07314292f5de","type":"data_slot","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dstf27a4b6c599633e02d624c5d918a07314292f5de"}}],"displayName":"User Input Control","defaultValue":"Next 4 Weeks","scope":2.0,"inputLabel":"Period","inputType":1.0,"id":"3b729266b868f9d2e5315210ee482bae80ba8802","type":"input","dstContext":{"ops":[{"p":{"args":[{"dim":"20c7ec05ebc679b2c1dc4dff508d62075863582e"},{"args":[{"value":"\"Next 4 Weeks\""},{"value":"\"Next 6 Months\""}],"f":"dst_array","type":"f"}],"f":"in","type":"f"},"filterBy":"20c7ec05ebc679b2c1dc4dff508d62075863582e","type":"filter","variation":"member"}],"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst3b729266b868f9d2e5315210ee482bae80ba8802"},"propName":"var_er_period"},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"SWITCH($var_er_period, \"Next 4 Weeks\", ARRAY(\"Daily\", \"Weekly\"), \"Next 6 Months\", ARRAY(\"Weekly\", \"Monthly\"),\"Next Year\", ARRAY(\"Weekly\", \"Monthly\"), \"_default_\", \"Weekly\")","ver":2.0}],"autoFmt":false,"id":"04e9226220c417774c0adde23282c6c4e7102752","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"5f495cf5699d57a05833f3a2ce550a6e3d3c101b","type":"proxy"}],"displayName":"User Input Control 2","defaultValue":"Weekly","scope":2.0,"inputLabel":"Group by","inputType":1.0,"id":"dc8094e13ccf9e1541ea54948ee4960affbb4f7c","type":"input","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dstdc8094e13ccf9e1541ea54948ee4960affbb4f7c"},"propName":"var_er_groupby"}],"displayName":"Layout Grid","id":"8cf4279d13f226ed4464bf22126878a52c6e3e96","type":"panel_grid","rows":1.0,"cols":4.0},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","data":[],"displayName":"PP","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscription KPIs,J2;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst7bbcacc8279f2d103fc303876f24448023f7d562"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"7bbcacc8279f2d103fc303876f24448023f7d562","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}],"renamed":true},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"\"Current Payment Plans\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst4c5b1ad443a6beb1da9bacc390e15a61f001af86"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"4c5b1ad443a6beb1da9bacc390e15a61f001af86","conditions":[{"predicates":[{"left":{"cx":"7bbcacc8279f2d103fc303876f24448023f7d562"},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Active Plans","id":"f19918c93db83ece2200f377aa0a93b8e01a6422","type":"simple_value","dstContext":{"id":"dstf19918c93db83ece2200f377aa0a93b8e01a6422"},"renamed":true},{"layoutConfig":{"x":1.0,"y":0.0},"components":[{"role":"primary","data":[],"displayName":"Primary Value","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscription KPIs,K2;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"num","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst23871fbcdb5bf25bd660c73dddc620dd277ad009"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1"},"precision":"0"},"id":"23871fbcdb5bf25bd660c73dddc620dd277ad009","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"\"Overdue Orders\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst5ee4bf6cfc856f29418e6dd0dd40ae600feaf378"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"5ee4bf6cfc856f29418e6dd0dd40ae600feaf378","conditions":[{"predicates":[{"left":{"cx":"23871fbcdb5bf25bd660c73dddc620dd277ad009"},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Payment Sum","id":"e2cc19e8c912f7d87226419fb69b8d4a93fa42c2","type":"simple_value","dstContext":{"id":"dste2cc19e8c912f7d87226419fb69b8d4a93fa42c2"},"renamed":true},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"primary","data":[],"displayName":"Primary Value","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscription KPIs,L2;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst4a3f87b0f396c544e8e5e158f9ae88cbd5509385"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1"},"precision":"0"},"id":"4a3f87b0f396c544e8e5e158f9ae88cbd5509385","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"\"Overdue Total\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst0c35e833298c4cc633f092097222173f6a01b28b"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"0c35e833298c4cc633f092097222173f6a01b28b","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Payment Sum Copy","id":"c9002e7144e86aeec67d13cc422b4a0d4843c9be","type":"simple_value","dstContext":{"id":"dstc9002e7144e86aeec67d13cc422b4a0d4843c9be"},"renamed":true},{"layoutConfig":{"x":3.0,"y":0.0},"components":[{"role":"primary","data":[],"displayName":"Active Subs","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscription KPIs,I2;","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"num","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dsteb094847fbc26f002f07c2f7f65cd9d5f864eb85"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"id":"eb094847fbc26f002f07c2f7f65cd9d5f864eb85","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}],"renamed":true},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"\"Active Subscriptions\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dstedfad5cbdf7f70282217f8c1842ef378c3ac506e"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"edfad5cbdf7f70282217f8c1842ef378c3ac506e","conditions":[{"predicates":[{"left":{"cx":"eb094847fbc26f002f07c2f7f65cd9d5f864eb85"},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Subscriptions","id":"0303e063521a494ee2018a0822fc9dc81ef52ede","type":"simple_value","dstContext":{"id":"dst0303e063521a494ee2018a0822fc9dc81ef52ede"},"renamed":true},{"layoutConfig":{"x":4.0,"y":0.0},"components":[{"role":"primary","data":[],"displayName":"RR","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscription KPIs,M2;*SWITCH($var_er_period, \"Next Year\", 12, \"_default_\", 1)","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst48a2f1b646ecd2ab9bf602e82917225bb40705d3"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"0"},"id":"48a2f1b646ecd2ab9bf602e82917225bb40705d3","conditions":[{"predicates":[{"left":{"cx":"eb094847fbc26f002f07c2f7f65cd9d5f864eb85"},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}],"renamed":true},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"SWITCH($var_er_period, \"Next Year\", \"Avg ARR from Active Subscriptions\", \"_default_\", \"Avg MRR from Active Subscriptions\")","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dstf53859adc9d1ae26a669891dc0e18cf39cbc58fc"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"f53859adc9d1ae26a669891dc0e18cf39cbc58fc","conditions":[{"predicates":[{"left":{"cx":"eb094847fbc26f002f07c2f7f65cd9d5f864eb85"},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Subs RR","id":"a8bf4b4822d719b8f90c48206a253cc0815d5fc9","type":"simple_value","dstContext":{"id":"dsta8bf4b4822d719b8f90c48206a253cc0815d5fc9"},"renamed":true}],"displayName":"Metrics","id":"67f8a32fdb6364b301afcc0511f857729703f4ae","type":"panel_grid","rows":1.0,"renamed":true,"cols":5.0},{"displayName":"Separator","id":"6d7d8fd0b9a5712816908ecc87d7d48340dcd170","type":"separator"},{"components":[{"data":[],"displayName":"Graph Title","formulas":[{"txt":"CONCAT(DATEVALUE(&'fb868ab0997241fe9860d7c0a798f0676a86d113', \"yyyy MMM dd\"), \" to \", DATEVALUE(&'f27a4b6c599633e02d624c5d918a07314292f5de', \"yyyy MMM dd\"))","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst41f7fd22c89fdafd0e700d456684b23013a72ccf"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"prefix":"Expected Revenue from Open Orders: ","prefixFontStyle":"bold","autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"},"prefixFontColour":"cx-color_444"},"id":"41f7fd22c89fdafd0e700d456684b23013a72ccf","renamed":true,"wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"primary","data":[],"displayName":"Active Subscriptions Revenue","formulas":[{"txt":"SUM(&'ffb1d45faf3be7d65bac2d4551f018cb95d40a68')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst9532f233b8e51de87715fd1528e8f5eb3c24fbfc"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"0"},"id":"9532f233b8e51de87715fd1528e8f5eb3c24fbfc","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}],"renamed":true},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"\"Active Subscriptions Revenue\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dsteae4c7bf68e9ecf4f6cb2dfb96c13485a32e1068"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"eae4c7bf68e9ecf4f6cb2dfb96c13485a32e1068","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Active Subscriptions Revenue","id":"c5022464063bccb920604985f9d0836718f70b7f","type":"simple_value","dstContext":{"id":"dstc5022464063bccb920604985f9d0836718f70b7f"},"renamed":true},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"role":"primary","data":[],"displayName":"Active Payment Plan Revenue","formulas":[{"txt":"SUM(&'3b2f01dbf9b90c0ec26858e90d943f86908ce141')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dstf849714e552f174523d884208373d7f4800c6839"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"0"},"id":"f849714e552f174523d884208373d7f4800c6839","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}],"renamed":true},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"\"Active Payment Plan Revenue\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst407fc48c74ff0ed727b54100439fef6f44fdbda8"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"407fc48c74ff0ed727b54100439fef6f44fdbda8","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Active Payment Plan Revenue","id":"2b289dc96d08d5f05b48e67b3a7c0093c358078a","type":"simple_value","dstContext":{"id":"dst2b289dc96d08d5f05b48e67b3a7c0093c358078a"},"renamed":true},{"layoutConfig":{"x":2.0,"y":1.0},"components":[{"role":"primary","data":[],"displayName":"Active One-time Payment Revenue","formulas":[{"txt":"SUM(&'cbb827a0f0859bbec1a61d7f4d720f4cb1b1b449')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst26722894bf4a0347cce4554b6575104b6ece59ba"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"0"},"id":"26722894bf4a0347cce4554b6575104b6ece59ba","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}],"renamed":true},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"\"Active One-time Payment Revenue\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dste517aa55c5dbad0aa52a721ce9f263f6ffb6e4ef"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"e517aa55c5dbad0aa52a721ce9f263f6ffb6e4ef","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Active One-time Payment Revenue","id":"a38eb0d95cde82f6d9bafc048fb420b286b36689","type":"simple_value","dstContext":{"id":"dsta38eb0d95cde82f6d9bafc048fb420b286b36689"},"renamed":true},{"layoutConfig":{"x":3.0,"y":1.0},"components":[{"role":"primary","data":[],"displayName":"Projected Loss from Collections","formulas":[{"txt":"SUM(&'c573be3a1e6f9c7632e0cbb614aeac973d0c5c10')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"font_colour":"cx-color_red_3","type":"label","fmt":"cur","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dsta24a13f45aa57e2a752b5a3a0e6105e15b02061c"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"0"},"id":"a24a13f45aa57e2a752b5a3a0e6105e15b02061c","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}],"renamed":true},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"\"Projected Loss from Collections\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst21aa2652578412c7e637e33973a2c47ed9a0705d"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"21aa2652578412c7e637e33973a2c47ed9a0705d","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Projected Loss from Collections","id":"54f49104ea8c71b776539a3f54a430bde5618121","type":"simple_value","dstContext":{"id":"dst54f49104ea8c71b776539a3f54a430bde5618121"},"renamed":true},{"layoutConfig":{"x":4.0,"y":1.0},"components":[{"role":"primary","data":[],"displayName":"Total","formulas":[{"txt":"SUM(&'3b2f01dbf9b90c0ec26858e90d943f86908ce141'+&'ffb1d45faf3be7d65bac2d4551f018cb95d40a68'+&'cbb827a0f0859bbec1a61d7f4d720f4cb1b1b449')","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst31ed5b5d1004849460eb690b2cb2a305d3c9629b"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"0"},"id":"31ed5b5d1004849460eb690b2cb2a305d3c9629b","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}],"renamed":true},{"role":"secondary","data":[],"displayName":"Secondary Value","formulas":[{"txt":"\"Total Revenue\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":true,"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dstde4c8108f1a0365f52fc74f29d361c567cd0bc0d"},"align":"c","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"de4c8108f1a0365f52fc74f29d361c567cd0bc0d","conditions":[{"predicates":[{"left":{},"right":{"raw":"0"},"type":"eq"}],"reactions":[{"type":"text","value":" ","isScalar":true}]}]}],"displayName":"Total","id":"4affd7c34092433090a1f5adb503e765484f6a22","type":"simple_value","dstContext":{"id":"dst4affd7c34092433090a1f5adb503e765484f6a22"},"renamed":true},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"showValues":true,"role":"series","data":[],"color":"#07bdff","displayName":"Payment Plan Payments","seriesName":"Payment Plan Payments","formulas":[{"txt":"&'de878e65d9aef687e699ff80f65f631138e7bce8'","ver":2.0}],"autoFmt":false,"leaveGaps":true,"type":"series_data","fmt":"cur","axis":"c1208b9313e10c16d7a6e45021cd07b818497e95","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"3b2f01dbf9b90c0ec26858e90d943f86908ce141"},{"showValues":true,"role":"series","data":[],"color":"#36d190","displayName":"Active Subscription Revenue","seriesName":"Active Subscription Revenue","formulas":[{"txt":"&'f6219f17fc20dd59f6fc001b20747a288d02a2c9'","ver":2.0}],"autoFmt":false,"leaveGaps":true,"type":"series_data","fmt":"cur","axis":"c1208b9313e10c16d7a6e45021cd07b818497e95","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"ffb1d45faf3be7d65bac2d4551f018cb95d40a68"},{"showValues":true,"role":"series","data":[],"displayName":"One Time Payments","seriesName":"One Time Payments","formulas":[{"txt":"&'21fa3624ea554e462de7d0c2f1ad9b04b730a364'","ver":2.0}],"autoFmt":true,"leaveGaps":true,"type":"series_data","fmt":"txt","axis":"c1208b9313e10c16d7a6e45021cd07b818497e95","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"cbb827a0f0859bbec1a61d7f4d720f4cb1b1b449"},{"showValues":true,"role":"series","data":[],"color":"#ff5456","displayName":"Projected Loss from Collections","seriesName":"Projected Loss from Collections","formulas":[{"txt":"&'35a0d057b222481a3d86e09547267ac02c4976ae'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"num","axis":"c1208b9313e10c16d7a6e45021cd07b818497e95","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"c573be3a1e6f9c7632e0cbb614aeac973d0c5c10"},{"renderer":"line","role":"series","data":[],"color":"#ab00ee","seriesHidden":true,"displayName":"Trend","seriesName":"Trend","formulas":[{"txt":"( MAP( CUMULATIVE( REPEAT( 1 , COUNT( &'f2e42597d8ca21cc08b7b068188d68a7be5b6ac7') ) ) , \"x\" , ( ( SLOPE( &'f2e42597d8ca21cc08b7b068188d68a7be5b6ac7', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'f2e42597d8ca21cc08b7b068188d68a7be5b6ac7') ) ) ) ) * $x ) + ( FIRST( &'f2e42597d8ca21cc08b7b068188d68a7be5b6ac7') - ( SLOPE( &'f2e42597d8ca21cc08b7b068188d68a7be5b6ac7', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'f2e42597d8ca21cc08b7b068188d68a7be5b6ac7') ) ) ) ) ) ) ) ) + 1 )","ver":2.0}],"autoFmt":true,"type":"series_data","fmt":"num","axis":"c1208b9313e10c16d7a6e45021cd07b818497e95","lineDashes":"ShortDot","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"},"precision":"0"},"id":"6ff76e6b67187f09dac5315c31673928402a7920","renamed":true},{"role":"axis_x","data":[],"displayName":"Date","formulas":[{"txt":"SWITCH($var_er_groupby, \n\"Daily\", &'9e0d5efe713796af24f7b41321ce9f2f4cf81acf',\n\"Weekly\", &'0e1ac1d419b2ffd217084fcb76fded0e69d100f0',\n\"Monthly\", &'43c6d8dca96990490a3bcc270ea3bfca78bc1f8b'\n)","ver":2.0}],"autoFmt":true,"label":"Untitled","type":"chart_axis","fmt":"txt","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"labelAngle":"-45","id":"13df094c4b6dfd6dbac0fb4416c3a01fc97784d4","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Total","formulas":[],"autoFmt":true,"label":"Total","type":"chart_axis","fmt":"txt","grid":true,"fmtArgs":{},"id":"c1208b9313e10c16d7a6e45021cd07b818497e95","labelDrop":0.0,"renamed":true},{"role":"data","data":[],"displayName":"sort","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"epoch"},"formulas":[{"txt":"SWITCH($var_er_groupby, \"Daily\", date(&'13df094c4b6dfd6dbac0fb4416c3a01fc97784d4'), \"Weekly\", date(&'13df094c4b6dfd6dbac0fb4416c3a01fc97784d4', \"YYYY 'w:' w\"), \"Monthly\", date(&'13df094c4b6dfd6dbac0fb4416c3a01fc97784d4', \"yyyy-MM\"), \"_default_\", date(&'13df094c4b6dfd6dbac0fb4416c3a01fc97784d4', \"YYYY 'w:' w\"))","ver":2.0}],"autoFmt":false,"name":"sort","isDstRoot":false,"id":"3089b13e56f4e69d00ee9f549117732b6cfcbbfe","type":"data_slot","fmt":"dat2"},{"role":"data","data":[],"displayName":"total","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":true,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"&'3b2f01dbf9b90c0ec26858e90d943f86908ce141'+&'ffb1d45faf3be7d65bac2d4551f018cb95d40a68'+&'cbb827a0f0859bbec1a61d7f4d720f4cb1b1b449'","ver":2.0}],"autoFmt":true,"name":"total","isDstRoot":false,"id":"f2e42597d8ca21cc08b7b068188d68a7be5b6ac7","type":"data_slot","fmt":"num"}],"hideNullSeries":1.0,"displayName":"Bar/Line for Payments and Subscriptions","id":"1f136bb5414956016796d877fe1303eee488edc4","type":"chart_series","dstContext":{"ops":[{"groupBy":"13df094c4b6dfd6dbac0fb4416c3a01fc97784d4","type":"group"},{"sortBy":[{"dim":"3089b13e56f4e69d00ee9f549117732b6cfcbbfe","dir":1.0}],"type":"sort"}],"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst1f136bb5414956016796d877fe1303eee488edc4","aggs":{"6ff76e6b67187f09dac5315c31673928402a7920":"auto","3b2f01dbf9b90c0ec26858e90d943f86908ce141":"sum","f2e42597d8ca21cc08b7b068188d68a7be5b6ac7":"auto","ffb1d45faf3be7d65bac2d4551f018cb95d40a68":"sum","c573be3a1e6f9c7632e0cbb614aeac973d0c5c10":"auto","cbb827a0f0859bbec1a61d7f4d720f4cb1b1b449":"auto"}},"renamed":true,"stackBars":"1"}],"displayName":"Visuals","id":"c4f8fee63259afc8acf63d8b6f58a1e2cabbc125","cellData":[{"w":5.0,"x":0.0,"y":0.0},{"w":5.0,"x":0.0,"y":2.0,"alignment":1.0}],"type":"panel_grid","rows":3.0,"renamed":true,"cols":5.0},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","data":[],"displayName":"Label","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"New Signups\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"8a2d174036962c501bd36a531fd2a9eddfd67c9d","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst8a2d174036962c501bd36a531fd2a9eddfd67c9d"},"wrap":true},{"layoutConfig":{"x":1.0,"y":0.0},"size":"xx-small","data":[],"displayName":"Label Copy","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"\"Collections List\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"id":"495e2cce5027271ca8174689384149e1424a17bd","type":"label","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst495e2cce5027271ca8174689384149e1424a17bd"},"wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"components":[{"role":"customHeader","data":[],"displayName":"Sign up Date","formulas":[{"txt":"\"Sign up Date\"","ver":2.0}],"font_colour":"#ffffff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst5b1d147c759d61f21a965862a99699345eaadf7f"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"5b1d147c759d61f21a965862a99699345eaadf7f","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#07bdff","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Sign up Date","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,F:F;)","ver":2.0}],"autoFmt":false,"index":0.0,"type":"table_col","fmt":"dat2","borderLeft":"0","size":"x-small","namerenamed":true,"borderRight":"0","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"dateInputFormatCustom":"M/d/yyyy","dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"custom"},"name":"Sign up Date","id":"29dd7b31e93880bd650614579f31c6bb85b8f0d3"},{"components":[{"role":"customHeader","data":[],"displayName":"Contact","formulas":[{"txt":"\"Contact\"","ver":2.0}],"font_colour":"#ffffff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dstd5a4fc69debca6e3c46e88be54057ffa13a2e879"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"d5a4fc69debca6e3c46e88be54057ffa13a2e879","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#07bdff","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Contact","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,A:A;)","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"hyp","borderLeft":"0","size":"x-small","namerenamed":true,"borderRight":"0","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true}},"name":"Contact","id":"be009c423ee290c06f580cff1be407eed0e77175"},{"components":[{"role":"customHeader","data":[],"displayName":"Amount","formulas":[{"txt":"\"Amount\"","ver":2.0}],"font_colour":"cx-color_fff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst2c59f5559648d431ada0c77e007b3a7f664be134"},"align":"r","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"2c59f5559648d431ada0c77e007b3a7f664be134","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#07bdff","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Amount","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,G:G;)","ver":2.0}],"autoFmt":false,"index":2.0,"type":"table_col","fmt":"cur","align":"left","borderLeft":"0","size":"x-small","namerenamed":true,"borderRight":"0","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"precision":"0"},"name":"Amount","id":"02653b574be562f35fc34cc2b419262a7b71b767"}],"displayName":"Last Signups","id":"75118c5a780a28df25e080ea3aebc8aa1fd33a11","type":"table","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst75118c5a780a28df25e080ea3aebc8aa1fd33a11"},"renamed":true,"showBorder":false},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"components":[{"role":"customHeader","data":[],"displayName":"Next Payment Date","formulas":[{"txt":"\"Next Payment Date\"","ver":2.0}],"font_colour":"#ffffff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dstb8dba28a3b35a2d29747d36b8235bdb70388c5d7"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"b8dba28a3b35a2d29747d36b8235bdb70388c5d7","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ff5456","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Next Payment Date","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,H:H;)","ver":2.0}],"autoFmt":false,"index":0.0,"type":"table_col","fmt":"dat2","borderLeft":"0","size":"x-small","namerenamed":true,"borderRight":"0","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"dateInputFormatCustom":"M/d/yyyy","dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"custom"},"name":"Sign up Date","id":"9de359bcaa791f1aa99d365356bd31f5d1f535d5","renamed":true},{"components":[{"role":"customHeader","data":[],"displayName":"Contact","formulas":[{"txt":"\"Contact\"","ver":2.0}],"font_colour":"#ffffff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst87fca4acf8e20c45451cc032ab60a63484cb360d"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"87fca4acf8e20c45451cc032ab60a63484cb360d","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ff5456","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Contact","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,A:A;)","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"hyp","borderLeft":"0","size":"x-small","namerenamed":true,"borderRight":"0","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true}},"name":"Contact","id":"5730f48eba58485804de6c45810cad34b272d1f0"},{"components":[{"role":"customHeader","data":[],"displayName":"Overdue Amount","formulas":[{"txt":"\"Overdue Amount\"","ver":2.0}],"font_colour":"#ffffff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst483f51d734db7b65fb5b274b5658e66d544922c9"},"align":"r","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"483f51d734db7b65fb5b274b5658e66d544922c9","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ff5456","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Overdue Amount","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,I:I;)","ver":2.0}],"autoFmt":false,"index":2.0,"type":"table_col","fmt":"cur","align":"left","borderLeft":"0","size":"x-small","namerenamed":true,"borderRight":"0","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"precision":"0"},"name":"Overdue Amount","id":"93ce24c78a05134f740fd54f1464ba58345e1170"}],"displayName":"Collections","id":"646aa5962d8e56ae6e8c14f04acf525d98e22188","type":"table","dstContext":{"ops":[{"sortBy":[{"dim":"9de359bcaa791f1aa99d365356bd31f5d1f535d5","dir":2.0}],"type":"sort"}],"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst646aa5962d8e56ae6e8c14f04acf525d98e22188"},"renamed":true,"showBorder":false}],"displayName":"Layout Grid 3","id":"68173769207b191a60a096cdb6ac860cfe874f8d","cellData":[{"x":0.0,"y":0.0}],"type":"panel_grid","rows":2.0,"cols":2.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Day","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'fb868ab0997241fe9860d7c0a798f0676a86d113', &'f27a4b6c599633e02d624c5d918a07314292f5de'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"d/M/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Day","id":"9e0d5efe713796af24f7b41321ce9f2f4cf81acf"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Week","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,B:B;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'fb868ab0997241fe9860d7c0a798f0676a86d113', &'f27a4b6c599633e02d624c5d918a07314292f5de'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Week","id":"0e1ac1d419b2ffd217084fcb76fded0e69d100f0"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Month","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,C:C;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'fb868ab0997241fe9860d7c0a798f0676a86d113', &'f27a4b6c599633e02d624c5d918a07314292f5de'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Month","id":"43c6d8dca96990490a3bcc270ea3bfca78bc1f8b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Payment Plan Payments","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,N:N;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'fb868ab0997241fe9860d7c0a798f0676a86d113', &'f27a4b6c599633e02d624c5d918a07314292f5de'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Payment Plan Payments","id":"de878e65d9aef687e699ff80f65f631138e7bce8"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Active Subscription Revenue","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,O:O;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'fb868ab0997241fe9860d7c0a798f0676a86d113', &'f27a4b6c599633e02d624c5d918a07314292f5de'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Active Subscription Revenue","id":"f6219f17fc20dd59f6fc001b20747a288d02a2c9"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Projected Loss from Collections","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,P:P;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'fb868ab0997241fe9860d7c0a798f0676a86d113', &'f27a4b6c599633e02d624c5d918a07314292f5de'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":5.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Projected Loss from Collections","id":"35a0d057b222481a3d86e09547267ac02c4976ae"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"One Time Payments","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,X:X;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'fb868ab0997241fe9860d7c0a798f0676a86d113', &'f27a4b6c599633e02d624c5d918a07314292f5de'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":6.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"One Time Payments","id":"21fa3624ea554e462de7d0c2f1ad9b04b730a364"}],"displayName":"Table Copy","id":"883ef56df45aa04e17b2495067e766d02f5ec108","type":"table","dstContext":{"kid":"af138d34fda2d1ff2673b832db08b30b","id":"dst883ef56df45aa04e17b2495067e766d02f5ec108"}}],"datasourceProps":["vs_secret_key"],"isForked":false,"id":"a9b858bd546ab78f7f138b2a127d17fe","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Expected Revenue from All Open Orders","usesSampleData":false,"master":"c30ae92d4562ebcaa06ecff25ae570b6"},{"workspace":{"datasources":["81202847048ab773daeebcec6fe0c74c"],"dataSets":[],"dimensions":{"w":1271.0}},"components":[{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"ARRAY(\"Last Year\", \"Last 2 Years\", \"All Time\")","ver":2.0}],"autoFmt":false,"id":"0b357a7c99f4c0368c4fb101135df6e7ad39e212","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"2e1da3ba149944663eca445630229701d06e0ff3","type":"proxy"},{"role":"data","data":[],"displayName":"from","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($RR_Date_Prest, \n\"Last Year\",\nDATE_ADD(TODAY() , \"5\", -365 ),\n\"Last 2 Years\",\nDATE_ADD(TODAY() , \"5\", -730 ),\n\"All Time\", \n0,\n\"_default_\",\nDATE_ADD(TODAY() , \"5\", -365 )\n)","ver":2.0}],"autoFmt":true,"name":"from","isDstRoot":true,"id":"e52b3eaaeaeb85e3fdb55732b17690fa58468fad","type":"data_slot","fmt":"txt","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dste52b3eaaeaeb85e3fdb55732b17690fa58468fad"}},{"role":"data","data":[],"displayName":"to","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($RR_Date_Prest, \n\"Last Year\",\nTODAY(),\n\"Last 2 Years\",\nTODAY(),\n\"All Time\", \nTODAY(),\n\"_default_\",\nDATE_ADD(TODAY() , \"5\", -365 )\n)","ver":2.0}],"autoFmt":true,"name":"to","isDstRoot":true,"id":"43a83826ea20d33634c8ea531164c06708a7079a","type":"data_slot","fmt":"txt","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dst43a83826ea20d33634c8ea531164c06708a7079a"}}],"displayName":"User Input Control 2","scope":2.0,"inputLabel":"Date","inputType":1.0,"id":"bc41d73bf4bd9a82e8556f2ca91a4ada5529cf58","type":"input","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dstbc41d73bf4bd9a82e8556f2ca91a4ada5529cf58"},"propName":"RR_Date_Prest"},{"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true}},"formulas":[{"txt":"GROUP(SLICE(81202847048ab773daeebcec6fe0c74c@Subscriber Retention Rate by Pr,D:D;))","ver":2.0}],"autoFmt":false,"id":"df72c2b72aeb5129ad2fae9dfb4ef6dd1d625ba1","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"6d90a9292125d31420c98dfd9b75f5a31fc7e877","type":"proxy"}],"displayName":"User Input Control","defaultValue":"_all_","includeAllData":true,"type":"input","dstContext":{"ops":[{"groupBy":"011e56cc154","type":"group"},{"p":{"args":[{"args":[{"dim":"6d90a9292125d31420c98dfd9b75f5a31fc7e877"},{"var":"Subscription_Product_text"}],"f":"contains_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","filterBy":"6d90a9292125d31420c98dfd9b75f5a31fc7e877","type":"filter","variation":"condition"},{"sortBy":[{"dim":"6d90a9292125d31420c98dfd9b75f5a31fc7e877","dir":1.0}],"type":"sort"}],"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dstdea4cf0e893e92d59fd667077afccf83fcdb78a4","aggs":{}},"propName":"Subscription_Product","layoutConfig":{"x":2.0,"y":0.0},"allDataLabel":"All Products","scope":1.0,"inputLabel":"Product","inputType":1.0,"id":"dea4cf0e893e92d59fd667077afccf83fcdb78a4"},{"layoutConfig":{"x":3.0,"y":0.0},"components":[],"allDataLabel":"All Products","displayName":"User Input Control Copy","scope":1.0,"inputType":2.0,"id":"7a88bc918adedff489022686a01da0169a6de7cc","includeAllData":true,"type":"input","dstContext":{"ops":[{"groupBy":"011e56cc154","type":"group"},{"sortBy":[{"dim":"4e1bd8df","dir":1.0}],"type":"sort"}],"kid":"b1d713e9ba10b525e5894c179ddbd0ca","id":"dst7a88bc918adedff489022686a01da0169a6de7cc","aggs":{}},"propName":"Subscription_Product_text"}],"displayName":"Date Entry","widths":[{"w":"5%","x":1.0},{"w":"25%","x":0.0}],"id":"c57f1dd44529d41209655d4a32c6bc3554d84c0f","cellData":[{"x":1.0,"y":0.0},{"x":0.0,"y":0.0}],"type":"panel_grid","rows":1.0,"renamed":true,"cols":4.0},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"renderer":"line","role":"series","data":[],"color":"#36d190","displayName":"Retention Rate","seriesName":"Retention Rate","formulas":[{"txt":"&'7d70850e4a54c03df10bd6efb3574e545cb712d5'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"c8306156a766b49d26c52a1970965b0b11849443","lineStyle":"curve","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"name":"RR","suggestedName":"RR","isGrouped":true,"isDSTApplied":true},"precision":"1","suffix":" Customers"},"id":"98390f1ef0dcdeb6ef90877d7758962d6dbe2767","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#07bdff","displayName":"MRR Retention Rate","seriesName":"MRR Retention Rate","formulas":[{"txt":"&'09e5e4f11a6ae7a8ae235b32d7ea631eb2175066'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"c8306156a766b49d26c52a1970965b0b11849443","lineStyle":"curve","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"name":"MRR RR","suggestedName":"MRR RR","isGrouped":true,"isDSTApplied":true},"precision":"1","suffix":" Revenue"},"id":"c3ca156748eea8072e00b1449bf8c9bd7b3d7c7c","renamed":true},{"role":"axis_x","data":[],"displayName":"Months","formulas":[{"txt":"&'faa76b5008603b268b6f650ae309ad2f55e58593'","ver":2.0}],"autoFmt":true,"label":"Months","type":"chart_axis","fmt":"txt","showLabelTicks":true,"showLabel":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"name":"Month","suggestedName":"Month","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"ce13857d732288a8c6107eb2f9b1d3fc76e15c30","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Retention Rate","formulas":[],"autoFmt":true,"label":"% Active Customers","type":"chart_axis","fmt":"pct","showLabel":true,"grid":true,"fmtArgs":{},"id":"c8306156a766b49d26c52a1970965b0b11849443","labelDrop":0.0,"renamed":true}],"displayName":"Bar/Line Chart","id":"e69491acd7223bb108bda5470c19cc1aad7be9d8","type":"chart_series","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dste69491acd7223bb108bda5470c19cc1aad7be9d8"}},{"data":[],"displayName":"Label 2","formulas":[{"txt":"\"Early Churn Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dsta0696ccc37d72c40f877679adadbac395786f295"},"align":"c","layoutConfig":{"x":0.0,"y":1.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"a0696ccc37d72c40f877679adadbac395786f295","wrap":true},{"data":[],"displayName":"Label 3","formulas":[{"txt":"\"Mid-Stage Churn Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dst3fb8d0793a8ff58848a3f0561e17e0682f8ac28d"},"align":"c","layoutConfig":{"x":1.0,"y":1.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"3fb8d0793a8ff58848a3f0561e17e0682f8ac28d","wrap":true},{"data":[],"displayName":"Label 4","formulas":[{"txt":"\"Late Churn Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dst532ffaa254fe7018c96c64a92326e702846c1342"},"align":"c","layoutConfig":{"x":2.0,"y":1.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"532ffaa254fe7018c96c64a92326e702846c1342","wrap":true},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"role":"primary","size":"small","data":[],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"formulas":[{"txt":"(lookup(\"1\",&'faa76b5008603b268b6f650ae309ad2f55e58593',&'4a6dd1e9c99202cebd059d4ae430dadfa71577dc')+lookup(\"2\",&'faa76b5008603b268b6f650ae309ad2f55e58593',&'4a6dd1e9c99202cebd059d4ae430dadfa71577dc')+lookup(\"3\",&'faa76b5008603b268b6f650ae309ad2f55e58593',&'4a6dd1e9c99202cebd059d4ae430dadfa71577dc'))/3","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"cd8d7a39064a8a8443e42fd89f06767197561845","type":"label","fmt":"pct","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dstcd8d7a39064a8a8443e42fd89f06767197561845"},"align":"c"},{"role":"secondary","size":"xx-small","data":[],"displayName":"Secondary Value","fmtArgs":{"prefix":"Previous Period: ","autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[],"autoFmt":true,"id":"dd1504bef7b7e643c8e1f31a54f9a07077ef846c","type":"label","fmt":"txt","dstContext":{"kid":"b1d713e9ba10b525e5894c179ddbd0ca","id":"dstdd1504bef7b7e643c8e1f31a54f9a07077ef846c"},"align":"c"}],"displayName":"Early Churn","id":"5a8e77f433a0228a6a5da1079326b66dc18bf7b5","type":"simple_value","dstContext":{"id":"dst5a8e77f433a0228a6a5da1079326b66dc18bf7b5"},"renamed":true},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"role":"primary","size":"small","data":[],"displayName":"Primary Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"formulas":[{"txt":"(lookup(\"5\",&'faa76b5008603b268b6f650ae309ad2f55e58593',&'4a6dd1e9c99202cebd059d4ae430dadfa71577dc')+lookup(\"6\",&'faa76b5008603b268b6f650ae309ad2f55e58593',&'4a6dd1e9c99202cebd059d4ae430dadfa71577dc')+lookup(\"7\",&'faa76b5008603b268b6f650ae309ad2f55e58593',&'4a6dd1e9c99202cebd059d4ae430dadfa71577dc'))/3","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"id":"a04ae4abbe1a6946ffef903e4f117d681d3799a4","type":"label","fmt":"pct","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dsta04ae4abbe1a6946ffef903e4f117d681d3799a4"},"align":"c"},{"role":"secondary","size":"xx-small","data":[],"displayName":"Secondary Value","fmtArgs":{"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[],"autoFmt":true,"id":"0a0ec2c256ed251e7dc9f70a54f9ceca17a1974b","type":"label","fmt":"txt","dstContext":{"kid":"b1d713e9ba10b525e5894c179ddbd0ca","id":"dst0a0ec2c256ed251e7dc9f70a54f9ceca17a1974b"},"align":"c"}],"displayName":"Mid Churn","id":"7515a355139eaaea5e97d0f2da9ea282e5830f6d","type":"simple_value","dstContext":{"id":"dst7515a355139eaaea5e97d0f2da9ea282e5830f6d"},"renamed":true},{"layoutConfig":{"x":2.0,"y":2.0},"components":[{"role":"primary","data":[],"displayName":"Primary Value","formulas":[{"txt":"(lookup(\"10\",&'faa76b5008603b268b6f650ae309ad2f55e58593',&'4a6dd1e9c99202cebd059d4ae430dadfa71577dc')+lookup(\"11\",&'faa76b5008603b268b6f650ae309ad2f55e58593',&'4a6dd1e9c99202cebd059d4ae430dadfa71577dc')+lookup(\"12\",&'faa76b5008603b268b6f650ae309ad2f55e58593',&'4a6dd1e9c99202cebd059d4ae430dadfa71577dc'))/3","ver":2.0,"src":{"c":[{"t":"l","v":"My Value"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"pct","dstContext":{"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dstd18b686c12e2097fe1d5b79518487a845710bf1d"},"align":"c","size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"id":"d18b686c12e2097fe1d5b79518487a845710bf1d","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"NaN"},"type":"contain"}],"reactions":[{"type":"text","value":"-","isScalar":true}]}]},{"role":"secondary","size":"xx-small","data":[],"displayName":"Secondary Value","fmtArgs":{"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[],"autoFmt":true,"id":"2c90aa17396d2270dfda002d0601bfc48682997b","type":"label","fmt":"txt","dstContext":{"kid":"b1d713e9ba10b525e5894c179ddbd0ca","id":"dst2c90aa17396d2270dfda002d0601bfc48682997b"},"align":"c"}],"displayName":"Late Churn","id":"687c879be0d3060866b232f72c44dc37aea5a9c9","type":"simple_value","dstContext":{"id":"dst687c879be0d3060866b232f72c44dc37aea5a9c9"},"renamed":true}],"displayName":"Product Filter","id":"b9745d23cdee2291f5237b8b4f2cfbb393bbdb39","cellData":[{"w":3.0,"x":0.0,"y":0.0}],"type":"panel_grid","rows":3.0,"renamed":true,"cols":3.0},{"firstRowIsHeader":true,"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Month","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscriber Retention Rate by Pr,A:A;","ver":2.0}],"autoFmt":false,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"txt","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"name":"Month","suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"name":"Month","id":"faa76b5008603b268b6f650ae309ad2f55e58593"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"RR","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscriber Retention Rate by Pr,B:B;","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"num","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"name":"RR","suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"RR","id":"7d70850e4a54c03df10bd6efb3574e545cb712d5"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"MRR RR","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscriber Retention Rate by Pr,C:C;","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"num","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"name":"MRR RR","suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"MRR RR","id":"09e5e4f11a6ae7a8ae235b32d7ea631eb2175066"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Product","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscriber Retention Rate by Pr,D:D;","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"name":"Product","suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Product","id":"24e1f47298ba3e8af9996b575a04f3afb6f2fe57"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Churn Rate","formulas":[{"txt":"81202847048ab773daeebcec6fe0c74c@Subscriber Retention Rate by Pr,E:E;","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":true,"name":"Churn Rate","suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Churn Rate","id":"4a6dd1e9c99202cebd059d4ae430dadfa71577dc"}],"displayName":"Table","id":"18174164bb1ed4143913efa1a065934f7c8512fd","type":"table","dstContext":{"ops":[{"p":{"args":[{"args":[{"dim":"24e1f47298ba3e8af9996b575a04f3afb6f2fe57"},{"var":"Subscription_Product"}],"f":"matches_insensitive","type":"f"}],"f":"and","type":"f"},"displayName":"Multiple Conditions","filterBy":"24e1f47298ba3e8af9996b575a04f3afb6f2fe57","type":"filter","variation":"condition"},{"groupBy":"faa76b5008603b268b6f650ae309ad2f55e58593","type":"group"}],"kid":"5cae083f13cd1cb25bdc9542c8cfe033","id":"dst18174164bb1ed4143913efa1a065934f7c8512fd","aggs":{"09e5e4f11a6ae7a8ae235b32d7ea631eb2175066":"average","7d70850e4a54c03df10bd6efb3574e545cb712d5":"average","4a6dd1e9c99202cebd059d4ae430dadfa71577dc":"average","24e1f47298ba3e8af9996b575a04f3afb6f2fe57":"first"}}}],"datasourceProps":["vs_secret_key"],"isForked":false,"id":"b2098fe95a7e90362caddb6b6aa2d831","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Subscriber Retention Rate by Product","usesSampleData":false,"master":"0cd56cc21a705259bc7f36bf94a4b760"},{"workspace":{"datasources":["81202847048ab773daeebcec6fe0c74c"],"dataSets":[],"dimensions":{"w":1312.0}},"components":[{"components":[{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"PeriodValues","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"ARRAY(\"4w\",\"1y\")","ver":2.0}],"autoFmt":false,"id":"5c6a61aed4fb984440a33e0805463090719d60e5","type":"proxy","renamed":true},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"dfc672c5be1485a8f2933b7b1834746e1726d411","type":"proxy"},{"role":"data","data":[],"displayName":"Period_Start","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", DATE_STARTOF(TODAY(), \"4\", -3 ) , \"1y\", DATE_ADD(TODAY(), \"3\", -12))","ver":2.0}],"autoFmt":true,"name":"Period_Start","isDstRoot":true,"id":"def4c3a89b93553b1ce867b610c94faff15632ff","type":"data_slot","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstdef4c3a89b93553b1ce867b610c94faff15632ff"}},{"role":"data","data":[],"displayName":"Period_END","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", YESTERDAY() , \"1y\", YESTERDAY() )","ver":2.0}],"autoFmt":true,"name":"Period_END","isDstRoot":true,"id":"0b72fc9cf471ff923ff2a64d199abefb19cdbcdb","type":"data_slot","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst0b72fc9cf471ff923ff2a64d199abefb19cdbcdb"}},{"role":"data","data":[],"displayName":"DateComponent","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"0"},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", \"4\" , \"1y\", \"4\")","ver":2.0}],"autoFmt":false,"name":"DateComponent","isDstRoot":true,"id":"25e2328fea213b7b9d82bac7c3c55c99583df50a","type":"data_slot","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst25e2328fea213b7b9d82bac7c3c55c99583df50a"}},{"role":"data","data":[],"displayName":"DatePrevIncrement","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"0"},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", -4 , \"1y\", -52)","ver":2.0}],"autoFmt":false,"name":"DatePrevIncrement","isDstRoot":true,"id":"3609eec34f250a8ffbbf349e5997c51bb6d61736","type":"data_slot","fmt":"num","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst3609eec34f250a8ffbbf349e5997c51bb6d61736"}}],"displayName":"Last Period","scope":1.0,"inputType":1.0,"id":"c7d260592a5dc704c74c859d0bef34fd03565811","type":"input","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstc7d260592a5dc704c74c859d0bef34fd03565811"},"renamed":true,"propName":"stripe_mrr_period"},{"layoutConfig":{"x":3.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", ARRAY(\"Daily\",\"Weekly\"), \"1y\", ARRAY(\"Weekly\",\"Monthly\"), \"_default_\", ARRAY(\"Weekly\",\"Monthly\") )","ver":2.0}],"autoFmt":false,"id":"2814764d219c76470a44266741a5207bdb99675c","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"15d20439f53ed6de6262f4bff15239d0f19edbe8","type":"proxy"},{"role":"data","data":[],"displayName":"Unit","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"30.4167","ver":2.0}],"autoFmt":true,"name":"Untitled","isDstRoot":false,"id":"41c49794f4c39f8c717d6d5857d70be5d30e77c7","type":"data_slot","fmt":"num","renamed":true},{"role":"data","data":[],"displayName":"dateUnit","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"SWITCH($stripe_mrr_unit, \"Weekly\", \"4\", \"Monthly\", \"3\" )","ver":2.0}],"autoFmt":true,"name":"dateUnit","isDstRoot":true,"id":"6163818e89ee46466b7dd2f4bd7455186fc891af","type":"data_slot","fmt":"num","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst6163818e89ee46466b7dd2f4bd7455186fc891af"}},{"role":"data","data":[],"displayName":"dateFormat","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($stripe_mrr_unit,\"Daily\", \"MMM d\", \"Weekly\", \"MMM d YYYY ('w')\", \"Monthly\", \"MMM yy\" )","ver":2.0}],"autoFmt":true,"name":"dateFormat","isDstRoot":true,"id":"be661f277a9b3e4532ce720b9591ab76a44b351c","type":"data_slot","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstbe661f277a9b3e4532ce720b9591ab76a44b351c"}}],"displayName":"Unit","scope":1.0,"inputType":1.0,"id":"00c4c6eefb5929f3683ec551c190fdbf8ef81528","type":"input","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst00c4c6eefb5929f3683ec551c190fdbf8ef81528"},"renamed":true,"propName":"stripe_mrr_unit"}],"displayName":"Layout Grid","widths":[{"w":"10%","x":2.0},{"w":"10%","x":3.0}],"id":"42f61fa7210b103231be2165a2eb4dd2fabf46fd","cellData":[{"x":2.0,"y":0.0},{"x":3.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":4.0},{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"data":[],"displayName":"AR Label","formulas":[{"txt":"\"Average Monthly Revenue per Subscriber\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst382f277b12f20985b43dfd2521ef09e4ac2290fb"},"layoutConfig":{"x":0.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"382f277b12f20985b43dfd2521ef09e4ac2290fb","renamed":true,"wrap":true},{"data":[],"displayName":"MRR Label","formulas":[{"txt":"\"Customer Life Time Value\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst5e17b6eb06366ee9366d1f50e36cbd1d8d7abaf0"},"layoutConfig":{"x":1.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"5e17b6eb06366ee9366d1f50e36cbd1d8d7abaf0","renamed":true,"wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"data":[],"displayName":"AR - val","formulas":[{"txt":"LAST(&'6452e286de68cd1c377a3a5f07077da91265ff72')","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dsta8e5156db0905b2764489744a579f8ec329e4d74"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"id":"a8e5156db0905b2764489744a579f8ec329e4d74","renamed":true,"wrap":true},{"data":[],"displayName":"AR - change","formulas":[{"txt":"LAST(&'4eff05cd377f73c515967496a52ffa8734e69f60')/100","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_style":"","type":"label","fmt":"pct","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst94df22d3efabed179ec4258ca29fc510ebffb184"},"layoutConfig":{"x":1.0,"y":0.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"id":"94df22d3efabed179ec4258ca29fc510ebffb184","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_green_3","isScalar":true},{"type":"icon","isScalar":true,"value":"ind-triangle-up-green"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"cx-theme_red_3","isScalar":true},{"type":"icon","value":"ind-triangle-down-red","isScalar":true}]}],"renamed":true,"wrap":true}],"displayName":"AR labels","id":"8ec0c28440fd95ae6f76f84948742abc3c9e0cec","cellData":[{"x":1.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":1.0,"renamed":true,"cols":2.0},{"layoutConfig":{"x":1.0,"y":1.0},"components":[{"data":[],"displayName":"CLTV - val","formulas":[{"txt":"Last(&'f69df0124d1feeb06b67cb5f1c56badf9dd3413f')","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"type":"label","fmt":"cur","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstfb25d2ad392e2de7df7b21eb7b5c4b4d3c522d6b"},"layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"id":"fb25d2ad392e2de7df7b21eb7b5c4b4d3c522d6b","renamed":true,"wrap":true},{"data":[],"displayName":"CLTV - change","formulas":[{"txt":"last(&'d0a7189b0126b4af952e0b6c69a2218b48cd2387')/100","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":false,"font_style":"","type":"label","fmt":"pct","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstd999333bc6c4ea77b6392debf8fb30b8d56e7040"},"layoutConfig":{"x":1.0,"y":0.0},"size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"id":"d999333bc6c4ea77b6392debf8fb30b8d56e7040","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"gt"}],"reactions":[{"type":"color","value":"cx-theme_green_3","isScalar":true},{"type":"icon","isScalar":true,"value":"ind-triangle-up-green"}]},{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"lt"}],"reactions":[{"type":"color","value":"cx-theme_red_3","isScalar":true},{"type":"icon","value":"ind-triangle-down-red","isScalar":true}]}],"renamed":true,"wrap":true}],"displayName":"CLTV labels","id":"609f846737151e2f490c7ca94d223e7603f8d1eb","cellData":[{"x":1.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":1.0,"renamed":true,"cols":2.0},{"layoutConfig":{"x":0.0,"y":2.0},"components":[{"renderer":"line","role":"series","data":[],"color":"#07bdff","displayName":"AR Current","seriesName":"Current","formulas":[{"txt":"&'cd359f9a1063938f4e60af6ccf0ab7bc8df18154'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"19f9189be0cccb7601e66851a63b2782501d5940","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"6452e286de68cd1c377a3a5f07077da91265ff72","renamed":true},{"renderer":"line","role":"series","data":[],"color":"cx-theme_888","displayName":"AR Previous","seriesName":"Previous","formulas":[{"txt":"&'378e12a83c1ece1a5559ee455085e11e9b55dae1'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"19f9189be0cccb7601e66851a63b2782501d5940","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"845e6855b155d2fe595e686c7c5f9102a26807a9","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ffd014","displayName":"AR Comparison","seriesName":"Prev. Period Comparison","formulas":[{"txt":"((&'6452e286de68cd1c377a3a5f07077da91265ff72'/&'845e6855b155d2fe595e686c7c5f9102a26807a9')-1)*100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"d5aeec54cddc657fd78aa59f672bfb18a11cc5df","chartStyle":"line","overrideColor":true,"lineWeight":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","precision":"1","dateInputFormat":"epoch"},"id":"4eff05cd377f73c515967496a52ffa8734e69f60","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ab00ee","displayName":"AR Trend","seriesName":"Trend","formulas":[{"txt":"( MAP( CUMULATIVE( REPEAT( 1 , COUNT( &'6452e286de68cd1c377a3a5f07077da91265ff72') ) ) , \"x\" , ( ( SLOPE( &'6452e286de68cd1c377a3a5f07077da91265ff72', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'6452e286de68cd1c377a3a5f07077da91265ff72') ) ) ) ) * $x ) + ( FIRST( &'6452e286de68cd1c377a3a5f07077da91265ff72') - ( SLOPE( &'6452e286de68cd1c377a3a5f07077da91265ff72', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'6452e286de68cd1c377a3a5f07077da91265ff72') ) ) ) ) ) ) ) ) + 1 )","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"19f9189be0cccb7601e66851a63b2782501d5940","lineDashes":"ShortDot","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"d638aaadcd7eede2e481bf2dd678457618d62f4c","renamed":true},{"role":"axis_x","data":[],"displayName":"AR Time","formulas":[{"txt":"SWITCH($stripe_mrr_unit, \n\"Daily\", &'d39c25736098b68b7203d936fa06b1ca84912f02',\n\"Weekly\", &'a6539ff0f983132fafa4eb4545590048b29caca6',\n\"Monthly\", &'c353966ab53d299ab14c829b6312082fb521bad7'\n)","ver":2.0}],"autoFmt":false,"label":"Untitled","type":"chart_axis","fmt":"txt","labelStagger":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d","dateFormatCustom":"MMM d","dateInputFormat":"epoch"},"labelAngle":"-45","id":"46c0ddfc3dfbbd87cd8f31787d5ed15fe0bb83ed","showAxis":false,"labelDrop":"0","renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"AR Value","formulas":[],"autoFmt":true,"label":"MRR Value","type":"chart_axis","fmt":"cur","grid":true,"fmtArgs":{},"originLine":false,"id":"19f9189be0cccb7601e66851a63b2782501d5940","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"%","formulas":[],"autoFmt":true,"axisPosition":"right","label":"%","type":"chart_axis","fmt":"pct","showLabelTicks":true,"fmtArgs":{"precision":"2"},"originLine":false,"id":"d5aeec54cddc657fd78aa59f672bfb18a11cc5df","labelDrop":0.0},{"role":"data","data":[],"displayName":"sort","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"d/M/yyyy","dateInputFormat":"d/M/yyyy"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"&'d39c25736098b68b7203d936fa06b1ca84912f02'","ver":2.0}],"autoFmt":true,"name":"sort","isDstRoot":false,"id":"eb580510d7c014cb1770e0fd70cbbf545f67b25e","type":"data_slot","fmt":"dat2"}],"displayName":"AR value","showLegend":1.0,"id":"15b5f7b140fbed4ed8eff12c5f8fcbd3c6e975cb","type":"chart_series","dstContext":{"ops":[{"groupBy":"46c0ddfc3dfbbd87cd8f31787d5ed15fe0bb83ed","type":"group"},{"sortBy":[{"dim":"eb580510d7c014cb1770e0fd70cbbf545f67b25e","dir":1.0}],"type":"sort"}],"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst15b5f7b140fbed4ed8eff12c5f8fcbd3c6e975cb","aggs":{"845e6855b155d2fe595e686c7c5f9102a26807a9":"sum","d638aaadcd7eede2e481bf2dd678457618d62f4c":"sum","eb580510d7c014cb1770e0fd70cbbf545f67b25e":"first","6452e286de68cd1c377a3a5f07077da91265ff72":"sum","4eff05cd377f73c515967496a52ffa8734e69f60":"average"}},"renamed":true,"height":"2"},{"layoutConfig":{"x":1.0,"y":2.0},"components":[{"renderer":"line","role":"series","data":[],"color":"#07bdff","displayName":"CLTV Current","seriesName":"Current","formulas":[{"txt":"&'c3ee5615d8753a66524b578d9feb7c234457d27b'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"06914e5e48b1e6ff461a49a2c8d828b5b53b4e50","chartStyle":"line","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"f69df0124d1feeb06b67cb5f1c56badf9dd3413f","renamed":true},{"renderer":"line","role":"series","data":[],"color":"cx-theme_888","displayName":"CLTV Previous","seriesName":"Previous","formulas":[{"txt":"&'2182ae97712fcc19cf2667fe55070f72a3429a95'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"06914e5e48b1e6ff461a49a2c8d828b5b53b4e50","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"7a40359273b681ce0de379ef5724ddde9f62a2ce","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ffd014","displayName":"CLTV Comparison","seriesName":"Prev. Period Comparison","formulas":[{"txt":"((&'f69df0124d1feeb06b67cb5f1c56badf9dd3413f'/&'7a40359273b681ce0de379ef5724ddde9f62a2ce')-1)*100","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"d878b3fa2e86d28e31ee9f86988acbebdb7fd5cd","chartStyle":"line","overrideColor":true,"lineWeight":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","precision":"1","dateInputFormat":"epoch"},"id":"d0a7189b0126b4af952e0b6c69a2218b48cd2387","renamed":true},{"renderer":"line","role":"series","data":[],"color":"#ab00ee","displayName":"CLTV Trend","seriesName":"Trend","formulas":[{"txt":"( MAP( CUMULATIVE( REPEAT( 1 , COUNT( &'f69df0124d1feeb06b67cb5f1c56badf9dd3413f') ) ) , \"x\" , ( ( SLOPE( &'f69df0124d1feeb06b67cb5f1c56badf9dd3413f', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'f69df0124d1feeb06b67cb5f1c56badf9dd3413f') ) ) ) ) * $x ) + ( FIRST( &'f69df0124d1feeb06b67cb5f1c56badf9dd3413f') - ( SLOPE( &'f69df0124d1feeb06b67cb5f1c56badf9dd3413f', ARRAY( CUMULATIVE( REPEAT( 1 , COUNT( &'f69df0124d1feeb06b67cb5f1c56badf9dd3413f') ) ) ) ) ) ) ) ) + 1 )","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"cur","axis":"06914e5e48b1e6ff461a49a2c8d828b5b53b4e50","lineDashes":"ShortDot","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"0"},"id":"c6b9cb268e666c60b74bc66ecea5bc5646bc979c","renamed":true},{"role":"axis_x","data":[],"displayName":"CLTV Time","formulas":[{"txt":"SWITCH($stripe_mrr_unit, \n\"Daily\", &'d39c25736098b68b7203d936fa06b1ca84912f02',\n\"Weekly\", &'a6539ff0f983132fafa4eb4545590048b29caca6',\n\"Monthly\", &'c353966ab53d299ab14c829b6312082fb521bad7'\n)","ver":2.0}],"autoFmt":false,"label":"Untitled","type":"chart_axis","fmt":"txt","labelStagger":"1","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"dateFormat":"MMM d","dateFormatCustom":"MMM d","dateInputFormat":"epoch"},"labelAngle":"-45","id":"7dbacfbc190e6411e089b5a95d901081678fd993","showAxis":false,"labelDrop":"0","renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"CLTV Value","formulas":[],"autoFmt":true,"label":"MRR Value","type":"chart_axis","fmt":"cur","grid":true,"fmtArgs":{},"originLine":false,"id":"06914e5e48b1e6ff461a49a2c8d828b5b53b4e50","labelDrop":0.0,"renamed":true},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"%","formulas":[],"autoFmt":true,"axisPosition":"right","label":"%","type":"chart_axis","fmt":"pct","showLabelTicks":true,"fmtArgs":{"precision":"2"},"originLine":false,"id":"d878b3fa2e86d28e31ee9f86988acbebdb7fd5cd","labelDrop":0.0},{"role":"data","data":[],"displayName":"sort","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"d/M/yyyy","dateInputFormat":"d/M/yyyy"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"&'d39c25736098b68b7203d936fa06b1ca84912f02'","ver":2.0}],"autoFmt":true,"name":"sort","isDstRoot":false,"id":"de2b457d1515a6f1ab9960d088759a969db48bd1","type":"data_slot","fmt":"dat2"}],"displayName":"CLTV Chart","showLegend":1.0,"id":"a25c8a5c65b1d58c7f3fa91f900c33b531a5e591","type":"chart_series","dstContext":{"ops":[{"groupBy":"7dbacfbc190e6411e089b5a95d901081678fd993","type":"group"},{"sortBy":[{"dim":"de2b457d1515a6f1ab9960d088759a969db48bd1","dir":1.0}],"type":"sort"}],"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dsta25c8a5c65b1d58c7f3fa91f900c33b531a5e591","aggs":{"f69df0124d1feeb06b67cb5f1c56badf9dd3413f":"sum","de2b457d1515a6f1ab9960d088759a969db48bd1":"first","eb580510d7c014cb1770e0fd70cbbf545f67b25e":"first","7a40359273b681ce0de379ef5724ddde9f62a2ce":"sum","d0a7189b0126b4af952e0b6c69a2218b48cd2387":"average","c6b9cb268e666c60b74bc66ecea5bc5646bc979c":"sum"}},"renamed":true,"height":"2"},{"data":[],"displayName":"Top Subscribers","formulas":[{"txt":"\"Top Subscribers\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstea7558ebc15b943c4afe7d658a0ceec64194d9d2"},"layoutConfig":{"x":0.0,"y":3.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"ea7558ebc15b943c4afe7d658a0ceec64194d9d2","renamed":true,"wrap":true},{"data":[],"displayName":"Recently Churned","formulas":[{"txt":"\"Recently Churned\"","ver":2.0,"src":{"c":[{"t":"l","v":"My Label"}],"t":"expr","v":false}}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstc5f27031cf0c703fa74760fba6e7bf17ab25246e"},"layoutConfig":{"x":1.0,"y":3.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"c5f27031cf0c703fa74760fba6e7bf17ab25246e","renamed":true,"wrap":true},{"layoutConfig":{"x":0.0,"y":4.0},"components":[{"components":[{"role":"customHeader","data":[],"displayName":"Subscriber Name","formulas":[{"txt":"\"Subscriber Name\"","ver":2.0}],"font_colour":"cx-color_fff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dste16c683fb3bc85a2bf504b2ec87d5bec7df75cf3"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"e16c683fb3bc85a2bf504b2ec87d5bec7df75cf3","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#07bdff","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Subscriber Name","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,A:A;)","ver":2.0}],"autoFmt":false,"index":0.0,"type":"table_col","fmt":"hyp","fw":"fixed","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"w":"25%","name":"Subscriber Name","id":"9291fd5599ea250009f57a12fdf9a33855d7ab66"},{"components":[{"role":"customHeader","data":[],"displayName":"Total Paid","formulas":[{"txt":"\"Total Paid\"","ver":2.0}],"font_colour":"cx-color_fff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst3a96e5670f15c34b3fb723fa3e2dd16c9890ec5a"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"3a96e5670f15c34b3fb723fa3e2dd16c9890ec5a","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#07bdff","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Total Paid","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,B:B;)","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"cur","fw":"fixed","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"0"},"w":"15%","name":"Total Paid","id":"5278a8bd89c65da2571e63ba17b4188fca11c020"},{"components":[{"role":"customHeader","data":[],"displayName":"Product Name","formulas":[{"txt":"\"Product Name\"","ver":2.0}],"font_colour":"cx-color_fff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst86af05b19796989bf4900d2cdcbdac6d99d61f0d"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"86af05b19796989bf4900d2cdcbdac6d99d61f0d","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#07bdff","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Product Name","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,C:C;)","ver":2.0}],"autoFmt":true,"index":2.0,"type":"table_col","fmt":"txt","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Product Name","id":"1999bff7c84c25c310149a7c6f73b15848bb5d1f"}],"maxRows":"8","displayName":"Top Subscribers","id":"2f982c7bf11c541e6c9bf0930f27421e87d122d8","type":"table","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst2f982c7bf11c541e6c9bf0930f27421e87d122d8"},"renamed":true,"showBorder":false},{"layoutConfig":{"x":1.0,"y":4.0},"components":[{"components":[{"role":"customHeader","data":[],"displayName":"Subscriber Name","formulas":[{"txt":"\"Subscriber Name\"","ver":2.0}],"font_colour":"cx-color_fff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstd4c53495e8f6bf20fac6c41793e2629c5f44d6a3"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"d4c53495e8f6bf20fac6c41793e2629c5f44d6a3","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ff5456","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Subscriber Name","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,A:A;)","ver":2.0}],"autoFmt":false,"index":0.0,"type":"table_col","fmt":"hyp","fw":"fixed","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"w":"35%","name":"Subscriber Name","id":"2bc4f0f0f4797e12b1d6f365f1b0a7853fdfd9dd"},{"components":[{"role":"customHeader","data":[],"displayName":"Churned Amount","formulas":[{"txt":"\"Churned Amount\"","ver":2.0}],"font_colour":"cx-color_fff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst1b24cf6765ba7263bcd5d308c6bf82c15c908096"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"1b24cf6765ba7263bcd5d308c6bf82c15c908096","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ff5456","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Churned Amount","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,D:D;)","ver":2.0}],"autoFmt":false,"index":1.0,"type":"table_col","fmt":"cur","fw":"fixed","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"0"},"w":"25%","name":"Churned Amount","id":"4b0902bed8e089c99f4d3004d61956ee5c55b5da"},{"components":[{"role":"customHeader","data":[],"displayName":"Cancellation Date","formulas":[{"txt":"\"Cancellation Date\"","ver":2.0}],"font_colour":"cx-color_fff","font_style":"bold","type":"table_headers","fmt":"txt","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dst56313af6dbc07a0dffaf8a67b2265be5384fc037"},"align":"l","mixin":"label","size":"x-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"56313af6dbc07a0dffaf8a67b2265be5384fc037","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"raw":"0"},"type":"ne"}],"reactions":[{"type":"background-color","value":"#ff5456","isScalar":true}]}]}],"customHeader":true,"role":"tcol","data":[],"displayName":"Cancellation Date","formulas":[{"txt":"SLICE(81202847048ab773daeebcec6fe0c74c@Subscribers,E:E;)","ver":2.0}],"autoFmt":true,"index":2.0,"type":"table_col","fmt":"dat2","size":"x-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"dateFormat":"MMM d, yyyy","dateFormatCustom":"MMM d, yyyy","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"MMM d, yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Cancellation Date","id":"ad27e666e05769519c4050ca2e67bb0817112458"}],"maxRows":"8","displayName":"Recently Churned","id":"b7b359814ac8682e1797bce6c4b2aa1ff9df8306","type":"table","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstb7b359814ac8682e1797bce6c4b2aa1ff9df8306"},"renamed":true,"showBorder":false}],"displayName":"Growth","id":"fed1de969eb25c6246c85b9e5c9df5ac461062de","cellData":[{"x":0.0,"y":2.0,"cellPadding":10.0}],"type":"panel_grid","rows":5.0,"renamed":true,"cols":2.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Day","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'def4c3a89b93553b1ce867b610c94faff15632ff', &'0b72fc9cf471ff923ff2a64d199abefb19cdbcdb'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"d/M/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Day","id":"d39c25736098b68b7203d936fa06b1ca84912f02"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Week","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,B:B;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"),&'def4c3a89b93553b1ce867b610c94faff15632ff', &'0b72fc9cf471ff923ff2a64d199abefb19cdbcdb'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Week","id":"a6539ff0f983132fafa4eb4545590048b29caca6"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Month","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,C:C;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"),&'def4c3a89b93553b1ce867b610c94faff15632ff', &'0b72fc9cf471ff923ff2a64d199abefb19cdbcdb'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Month","id":"c353966ab53d299ab14c829b6312082fb521bad7"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"AMR","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,L:L;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'def4c3a89b93553b1ce867b610c94faff15632ff', &'0b72fc9cf471ff923ff2a64d199abefb19cdbcdb'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"AMR","id":"cd359f9a1063938f4e60af6ccf0ab7bc8df18154"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"AMR Previous","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,U:U;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'def4c3a89b93553b1ce867b610c94faff15632ff', &'0b72fc9cf471ff923ff2a64d199abefb19cdbcdb'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"AMR Previous","id":"378e12a83c1ece1a5559ee455085e11e9b55dae1"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"CLTV","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,M:M;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"),&'def4c3a89b93553b1ce867b610c94faff15632ff', &'0b72fc9cf471ff923ff2a64d199abefb19cdbcdb'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":5.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"CLTV","id":"c3ee5615d8753a66524b578d9feb7c234457d27b"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"CLTV Previous","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,V:V;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"),&'def4c3a89b93553b1ce867b610c94faff15632ff', &'0b72fc9cf471ff923ff2a64d199abefb19cdbcdb'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":6.0,"type":"table_col","fmt":"txt","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"CLTV Previous","id":"2182ae97712fcc19cf2667fe55070f72a3429a95"}],"displayName":"Table Copy","id":"b60a6ae562af6c3128c6d51b61225922263883ad","type":"table","dstContext":{"kid":"b4e1c7cdfad5b38517f2617c7a01463b","id":"dstb60a6ae562af6c3128c6d51b61225922263883ad"}}],"datasourceProps":["vs_secret_key"],"isForked":false,"id":"e538c60bfbe7d06003ab3462bf179880","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Subscribers","usesSampleData":false,"master":"a4e302d1d0944d6b3aa278efdf9f9206"},{"workspace":{"datasources":["81202847048ab773daeebcec6fe0c74c"],"dataSets":[],"dimensions":{"w":1312.0}},"components":[{"components":[{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"PeriodValues","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"ARRAY(\"1y\",\"2y\")","ver":2.0}],"autoFmt":false,"id":"5c346f7fd5c5bd81fdc157177656435dca47c193","type":"proxy","renamed":true},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"749c5b7cac51d33dd6ece4daa3cb6a824b2ad616","type":"proxy"},{"role":"data","data":[],"displayName":"Period_Start","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \n\"4w\", DATE_STARTOF(TODAY(), \"4\", -3 ) , \n\"1y\", DATE_ADD(TODAY(), \"3\", -12),\n\"2y\", DATE_ADD(TODAY(), \"3\", -24)\n)","ver":2.0}],"autoFmt":true,"name":"Period_Start","isDstRoot":true,"id":"7cc6a3d9b4bf0d68eba93caf058ef932a5eec2a0","type":"data_slot","fmt":"txt","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst7cc6a3d9b4bf0d68eba93caf058ef932a5eec2a0"}},{"role":"data","data":[],"displayName":"Period_END","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", YESTERDAY() , \"1y\", YESTERDAY(),\"2y\", YESTERDAY() )","ver":2.0}],"autoFmt":true,"name":"Period_END","isDstRoot":true,"id":"ebe48cad250069a9932979b49095e386a2a2b7d4","type":"data_slot","fmt":"txt","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dstebe48cad250069a9932979b49095e386a2a2b7d4"}},{"role":"data","data":[],"displayName":"DateComponent","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"0"},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", \"4\" , \"1y\", \"4\", \"2y\", \"4\")","ver":2.0}],"autoFmt":false,"name":"DateComponent","isDstRoot":true,"id":"0ce3a1793aefa515c549b990c6d030e3ed5b9c8f","type":"data_slot","fmt":"txt","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst0ce3a1793aefa515c549b990c6d030e3ed5b9c8f"}},{"role":"data","data":[],"displayName":"DatePrevIncrement","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"0"},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", -4 , \"1y\", -52, \"2y\", 104)","ver":2.0}],"autoFmt":false,"name":"DatePrevIncrement","isDstRoot":true,"id":"9d5598a5d929f8344866ea5334c530e734535831","type":"data_slot","fmt":"num","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst9d5598a5d929f8344866ea5334c530e734535831"}}],"displayName":"Last Period","scope":1.0,"inputType":1.0,"id":"b50ac54738433918892e42b4bedb8e009fa62c0e","type":"input","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dstb50ac54738433918892e42b4bedb8e009fa62c0e"},"renamed":true,"propName":"stripe_mrr_period"},{"layoutConfig":{"x":3.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"SWITCH($stripe_mrr_period, \"4w\", ARRAY(\"Daily\",\"Weekly\"), \"1y\", ARRAY(\"Weekly\",\"Monthly\"), \"2y\", ARRAY(\"Weekly\",\"Monthly\"), \"_default_\", ARRAY(\"Weekly\",\"Monthly\") )","ver":2.0}],"autoFmt":false,"id":"4cb156916bd8e8b3fdb4c5575579cef488666d38","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","formulas":[],"autoFmt":false,"id":"b63d5bc444ddd33ff9250ed804f82efdaeac4d7a","type":"proxy"},{"role":"data","data":[],"displayName":"Unit","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{"precision":"4"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"30.4167","ver":2.0}],"autoFmt":true,"name":"Untitled","isDstRoot":false,"id":"c4ef6a2245ce0c22c76b08a76a33d3fe346d6920","type":"data_slot","fmt":"num","renamed":true},{"role":"data","data":[],"displayName":"dateUnit","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{"precision":"0"},"defaultAggregate":"SUM","fmt":"num"}},"formulas":[{"txt":"SWITCH($stripe_mrr_unit, \"Weekly\", \"4\", \"Monthly\", \"3\" )","ver":2.0}],"autoFmt":true,"name":"dateUnit","isDstRoot":true,"id":"b48859fb7cd719449c7fc59f8785e45c3d4ee8cf","type":"data_slot","fmt":"num","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dstb48859fb7cd719449c7fc59f8785e45c3d4ee8cf"}},{"role":"data","data":[],"displayName":"dateFormat","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"formulas":[{"txt":"SWITCH($stripe_mrr_unit,\"Daily\", \"MMM d\", \"Weekly\", \"MMM d yyyy ('w')\", \"Monthly\", \"MMM yy\" )","ver":2.0}],"autoFmt":true,"name":"dateFormat","isDstRoot":true,"id":"4bf103915cf82741af686c790baf407f9b4c4487","type":"data_slot","fmt":"txt","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst4bf103915cf82741af686c790baf407f9b4c4487"}}],"displayName":"Unit","scope":1.0,"inputType":1.0,"id":"ad842d951a529cfb0ec5ee530bec08d0c97ce126","type":"input","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dstad842d951a529cfb0ec5ee530bec08d0c97ce126"},"renamed":true,"propName":"stripe_mrr_unit"}],"displayName":"Layout Grid","widths":[{"w":"10%","x":2.0},{"w":"10%","x":3.0}],"id":"10473b429f182923f66c17e029c7a3468667a5c9","cellData":[{"x":2.0,"y":0.0},{"x":3.0,"y":0.0}],"type":"panel_grid","rows":1.0,"cols":4.0},{"components":[{"data":[],"displayName":"Label Copy 2","formulas":[{"txt":"\"MRR Retention Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"MRR Retention"}],"t":"expr","v":false}}],"font_colour":"cx-color_000","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst4bcda86352f3f585518389a2ddbc6f3ad6327c26"},"align":"c","layoutConfig":{"x":0.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"4bcda86352f3f585518389a2ddbc6f3ad6327c26","wrap":true},{"data":[],"displayName":"Label Copy 3","formulas":[{"txt":"\"MRR Expansion Rate\"","ver":2.0,"src":{"c":[{"t":"l","v":"MRR Expansion"}],"t":"expr","v":false}}],"font_colour":"cx-color_000","font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst5701b7e4c1c7743d11c242817869b20cca30effd"},"align":"c","layoutConfig":{"x":2.0,"y":0.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"5701b7e4c1c7743d11c242817869b20cca30effd","wrap":true},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"role":"current","size":"medium","data":[],"show_value":false,"displayName":"Current Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"prefix":"Actual: ","precision":"2","suffix":""},"formulas":[{"txt":"LAST(&'3f3ed08b8cf7d46fd91d637c0d35488312a1fce0')/100","ver":2.0,"src":{"c":[{"t":"l","v":"1"},{"t":"o","v":"-"},{"c":[{"c":[{"t":"d","v":{"a":"retention and expansion,8:8","id":"ca67f1b384c78915a82e49e424f64c5a"}},{"t":"l","v":"-1"},{"arg_obj":{"optional":true,"placeholder":"end"},"t":"a"}],"t":"f","v":"slice"},{"t":"o","v":"/"},{"c":[{"t":"d","v":{"a":"retention and expansion,9:9","id":"ca67f1b384c78915a82e49e424f64c5a"}},{"t":"l","v":"-1"},{"arg_obj":{"optional":true,"placeholder":"end"},"t":"a"}],"t":"f","v":"slice"}],"t":"expr","v":false}],"t":"expr","v":false}}],"id":"ab6280ec96deb38756e76f8f52135d3e2c3ed8b3","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dstab6280ec96deb38756e76f8f52135d3e2c3ed8b3"}},{"role":"target","size":"xx-small","data":[],"displayName":"Target Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"prefix":"Target: ","precision":"1"},"formulas":[{"txt":"\"0.99\"","ver":2.0,"src":{"c":[{"t":"l","v":"0.99"}],"t":"expr","v":false}}],"font_colour":"cx-color_888","id":"4121a60ce3fa1f4799f0904bdf40109e77e93fc1","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst4121a60ce3fa1f4799f0904bdf40109e77e93fc1"}},{"role":"min","size":"xx-small","data":[],"displayName":"Min Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"\"0.90\"","ver":2.0,"src":{"c":[{"t":"l","v":"0.97"}],"t":"expr","v":false}}],"font_colour":"cx-color_888","id":"51ff5a897c3b9f5613386c47ee20ee4ad8cae7e1","font_style":"","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst51ff5a897c3b9f5613386c47ee20ee4ad8cae7e1"}},{"role":"max","size":"xx-small","data":[],"displayName":"Max Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"\"1\"","ver":2.0,"src":{"c":[{"t":"l","v":"1"}],"t":"expr","v":false}}],"font_colour":"cx-color_888","id":"df943fb789f82f24ccbd862bcb262c19437d93ae","font_style":"","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dstdf943fb789f82f24ccbd862bcb262c19437d93ae"}}],"size":2.0,"displayName":"Gauge Copy","id":"a063c5fdf8a81a0c04840ffefd6a06cdef265ffd","type":"gauge","dstContext":{"id":"dsta063c5fdf8a81a0c04840ffefd6a06cdef265ffd"},"conditions":[{"predicates":[{"left":{"cx":"ab6280ec96deb38756e76f8f52135d3e2c3ed8b3"},"right":{"cx":"4121a60ce3fa1f4799f0904bdf40109e77e93fc1"},"type":"lt"}],"reactions":[{"type":"color","value":"#ff5456","isScalar":true}]},{"predicates":[{"left":{"cx":"ab6280ec96deb38756e76f8f52135d3e2c3ed8b3"},"right":{"cx":"4121a60ce3fa1f4799f0904bdf40109e77e93fc1"},"type":"gt"}],"reactions":[{"type":"color","value":"#36d190","isScalar":true}]}],"gaugeStyle":"ag"},{"layoutConfig":{"x":2.0,"y":1.0},"components":[{"role":"current","size":"medium","data":[],"show_value":false,"displayName":"Current Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"prefix":"Actual: ","precision":"2","suffix":""},"formulas":[{"txt":"Last(&'623be558ee3928bf4044a35caced378d3959f749')/100","ver":2.0,"src":{"c":[{"c":[{"c":[{"t":"d","v":{"a":"retention and expansion,7:7","id":"ca67f1b384c78915a82e49e424f64c5a"}},{"t":"l","v":"-1"},{"arg_obj":{"optional":true,"placeholder":"end"},"t":"a"}],"t":"f","v":"slice"},{"t":"o","v":"/"},{"c":[{"t":"d","v":{"a":"retention and expansion,9:9","id":"ca67f1b384c78915a82e49e424f64c5a"}},{"t":"l","v":"-1"},{"arg_obj":{"optional":true,"placeholder":"end"},"t":"a"}],"t":"f","v":"slice"}],"t":"expr","v":false}],"t":"expr","v":false}}],"id":"0746d2b77e8a5259805a3acc91877aa0e8263ace","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst0746d2b77e8a5259805a3acc91877aa0e8263ace"}},{"role":"target","size":"xx-small","data":[],"displayName":"Target Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"prefix":"Target: ","precision":"1"},"formulas":[{"txt":"\"0.06\"","ver":2.0,"src":{"c":[{"t":"l","v":"0.035"}],"t":"expr","v":false}}],"font_colour":"cx-color_888","id":"b2690077bee5ce2617ddbeb3129ded95336baef3","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dstb2690077bee5ce2617ddbeb3129ded95336baef3"}},{"role":"min","size":"xx-small","data":[],"displayName":"Min Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"\"0\"","ver":2.0,"src":{"c":[{"t":"l","v":"0"}],"t":"expr","v":false}}],"font_colour":"cx-color_888","id":"dfa9cb84178f088553c3c62909a49a8de9d77e4e","font_style":"","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dstdfa9cb84178f088553c3c62909a49a8de9d77e4e"}},{"role":"max","size":"xx-small","data":[],"displayName":"Max Value","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"&'b2690077bee5ce2617ddbeb3129ded95336baef3'*1.5","ver":2.0,"src":{"c":[{"t":"l","v":"0.05"}],"t":"expr","v":false}}],"font_colour":"cx-color_888","id":"29cf89793f0e09269e77d8f03803a78c02429d4e","font_style":"","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst29cf89793f0e09269e77d8f03803a78c02429d4e"}}],"size":2.0,"displayName":"Gauge Copy 2","id":"0c910405a02a2db3581a1439b4bae1397f1a22f4","type":"gauge","dstContext":{"id":"dst0c910405a02a2db3581a1439b4bae1397f1a22f4"},"conditions":[{"predicates":[{"left":{"cx":"0746d2b77e8a5259805a3acc91877aa0e8263ace"},"right":{"cx":"b2690077bee5ce2617ddbeb3129ded95336baef3"},"type":"lt"}],"reactions":[{"type":"color","value":"#ff5456","isScalar":true}]},{"predicates":[{"left":{"cx":"0746d2b77e8a5259805a3acc91877aa0e8263ace"},"right":{"cx":"b2690077bee5ce2617ddbeb3129ded95336baef3"},"type":"gt"}],"reactions":[{"type":"color","value":"#36d190","isScalar":true}]}],"gaugeStyle":"ag"},{"data":[],"displayName":"Label Copy 4","formulas":[{"txt":"\"Actual:\"","ver":2.0,"src":{"c":[{"t":"l","v":"Actual:"}],"t":"expr","v":false}}],"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst7d4e5ec862d860023e71cbfa5a688794b4d09e83"},"align":"r","layoutConfig":{"x":0.0,"y":2.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"7d4e5ec862d860023e71cbfa5a688794b4d09e83","wrap":true},{"layoutConfig":{"x":1.0,"y":2.0},"size":"small","data":[],"displayName":"Label Copy 5","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"formulas":[{"txt":"&'ab6280ec96deb38756e76f8f52135d3e2c3ed8b3'","ver":2.0,"src":{"c":[{"t":"ref","v":{"r":"cx","cx":"ab6280ec96deb38756e76f8f52135d3e2c3ed8b3"}}],"t":"expr","v":false}}],"id":"60547331ae7de7651270e97ab2b7fce6e04c4db3","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst60547331ae7de7651270e97ab2b7fce6e04c4db3"},"wrap":true},{"data":[],"displayName":"Label Copy 6","formulas":[{"txt":"\"Actual:\"","ver":2.0,"src":{"c":[{"t":"l","v":"Actual:"}],"t":"expr","v":false}}],"font_style":"","type":"label","fmt":"txt","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dsta204f09af489d4ffe96ef22cf823f2ab15e10bbe"},"align":"r","layoutConfig":{"x":2.0,"y":2.0},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"id":"a204f09af489d4ffe96ef22cf823f2ab15e10bbe","wrap":true},{"layoutConfig":{"x":3.0,"y":2.0},"size":"small","data":[],"displayName":"Label Copy 7","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true},"precision":"2"},"formulas":[{"txt":"&'0746d2b77e8a5259805a3acc91877aa0e8263ace'","ver":2.0,"src":{"c":[{"t":"ref","v":{"r":"cx","cx":"0746d2b77e8a5259805a3acc91877aa0e8263ace"}}],"t":"expr","v":false}}],"id":"12de9fabeae1158bfb0f9bdd1869a7fd82c132ec","type":"label","fmt":"pct","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst12de9fabeae1158bfb0f9bdd1869a7fd82c132ec"},"wrap":true},{"layoutConfig":{"x":0.0,"y":3.0},"components":[{"role":"series","data":[],"color":"#07bdff","displayName":"MRR Retention Rate","seriesName":"MRR Retention Rate","formulas":[{"txt":"&'9f6fc69c55d72a538d4d0a36fa43b06d3bb17455'","ver":2.0,"src":{"c":[{"c":[{"t":"l","v":"1"},{"t":"o","v":"-"},{"c":[{"c":[{"t":"d","v":{"a":"retention and expansion,8:8","id":"ca67f1b384c78915a82e49e424f64c5a"}},{"arg_obj":{"optional":true,"placeholder":"start"},"t":"a"},{"arg_obj":{"optional":true,"placeholder":"end"},"t":"a"}],"t":"f","v":"slice"},{"t":"o","v":"/"},{"c":[{"t":"d","v":{"a":"retention and expansion,9:9","id":"ca67f1b384c78915a82e49e424f64c5a"}},{"arg_obj":{"optional":true,"placeholder":"start"},"t":"a"},{"arg_obj":{"optional":true,"placeholder":"end"},"t":"a"}],"t":"f","v":"slice"}],"t":"expr","v":false}],"t":"expr","v":false},{"t":"o","v":"*"},{"t":"l","v":"100"}],"t":"expr","v":false}}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"22cf4072a62f0e43e8d85a32c069e78e783a3972","lineStyle":"curve","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"1"},"id":"3f3ed08b8cf7d46fd91d637c0d35488312a1fce0"},{"role":"series","data":[],"color":"#36d190","displayName":"MRR Expansion Rate","seriesName":"MRR Expansion Rate","formulas":[{"txt":"&'c897a0bd943d34d832bb6904bac8fa16d4aef4ab'","ver":2.0,"src":{"c":[{"c":[{"c":[{"t":"d","v":{"a":"retention and expansion,7:7","id":"ca67f1b384c78915a82e49e424f64c5a"}},{"arg_obj":{"optional":true,"placeholder":"start"},"t":"a"},{"arg_obj":{"optional":true,"placeholder":"end"},"t":"a"}],"t":"f","v":"slice"},{"t":"o","v":"/"},{"c":[{"t":"d","v":{"a":"retention and expansion,9:9","id":"ca67f1b384c78915a82e49e424f64c5a"}},{"arg_obj":{"optional":true,"placeholder":"start"},"t":"a"},{"arg_obj":{"optional":true,"placeholder":"end"},"t":"a"}],"t":"f","v":"slice"}],"t":"expr","v":false},{"t":"o","v":"*"},{"t":"l","v":"100"}],"t":"expr","v":false}}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"22cf4072a62f0e43e8d85a32c069e78e783a3972","lineStyle":"curve","chartStyle":"line_area","overrideColor":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"precision":"1"},"id":"623be558ee3928bf4044a35caced378d3959f749"},{"role":"axis_x","data":[],"displayName":"Month","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true}},"formulas":[{"txt":"SWITCH($stripe_mrr_unit, \n\"Daily\", &'ea43cdc92dc708b0022da27672b844086e31d4b9',\n\"Weekly\", &'e0c459a1af40238accdcddcc44e4a09edc295ff1',\n\"Monthly\", &'e57fa124c5652fca3f7a0d7dbd78bfc0103802d1'\n)","ver":2.0,"src":{"c":[{"c":[{"t":"d","v":{"a":"retention and expansion,1:1","id":"ca67f1b384c78915a82e49e424f64c5a"}},{"arg_obj":{"optional":true,"placeholder":"start"},"t":"a"},{"arg_obj":{"optional":true,"placeholder":"end"},"t":"a"}],"t":"f","v":"slice"}],"t":"expr","v":false}}],"labelAngle":"-45","id":"7533752d8ed946bfb7adea2a5de30382e973f4c1","label":"Month","type":"chart_axis","fmt":"txt","labelDrop":0.0},{"customRange":true,"role":"axis_y","data":[],"dataDisabled":true,"tickInterval":"2","displayName":"Retention Rate Percentage","formulas":[],"autoFmt":true,"label":"Retention Rate Percentage","type":"chart_axis","fmt":"pct","min":"90","fmtArgs":{"precision":"0"},"id":"22cf4072a62f0e43e8d85a32c069e78e783a3972","showAxis":false,"customInterval":true,"labelDrop":0.0},{"role":"data","data":[],"displayName":"sort","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":true,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isGrouped":true,"isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"M/d/yyyy"},"defaultAggregate":"COUNT","fmt":"dat2"}},"formulas":[{"txt":"&'ea43cdc92dc708b0022da27672b844086e31d4b9'","ver":2.0}],"autoFmt":true,"name":"sort","isDstRoot":false,"id":"d0030dc2dc2129a7d751f864f986c1a038d19e46","type":"data_slot","fmt":"dat2"}],"stackAreas":"1","displayName":"Series Chart Copy","customHeight":"120","showLegend":1.0,"id":"0afccbdcc5be4b38dc974cb58c27d5aa6e38dcc6","type":"chart_series","dstContext":{"ops":[{"groupBy":"7533752d8ed946bfb7adea2a5de30382e973f4c1","type":"group"},{"sortBy":[{"dim":"d0030dc2dc2129a7d751f864f986c1a038d19e46","dir":1.0}],"type":"sort"}],"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst0afccbdcc5be4b38dc974cb58c27d5aa6e38dcc6","aggs":{"3f3ed08b8cf7d46fd91d637c0d35488312a1fce0":"average","d0030dc2dc2129a7d751f864f986c1a038d19e46":"first","623be558ee3928bf4044a35caced378d3959f749":"average"}},"stackBars":"1","height":"2"}],"displayName":"Layout Grid Copy","id":"e622fd7894f1f703d721fbc064c92a5a27d4f3b8","cellData":[{"w":2.0,"x":0.0,"y":0.0},{"w":2.0,"x":0.0,"y":1.0},{"w":2.0,"x":2.0,"y":0.0},{"w":2.0,"x":2.0,"y":1.0},{"w":4.0,"x":0.0,"y":3.0,"cellPadding":[15.0,5.0,5.0,5.0]}],"type":"panel_grid","rows":4.0,"cols":4.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Day","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'7cc6a3d9b4bf0d68eba93caf058ef932a5eec2a0', &'ebe48cad250069a9932979b49095e386a2a2b7d4'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"dateInputFormatCustom":"M/d/yyyy","dateFormat":"custom","dateFormatCustom":"M/d/yyyy","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Day","id":"ea43cdc92dc708b0022da27672b844086e31d4b9"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Week","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,B:B;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'7cc6a3d9b4bf0d68eba93caf058ef932a5eec2a0', &'ebe48cad250069a9932979b49095e386a2a2b7d4'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Week","id":"e0c459a1af40238accdcddcc44e4a09edc295ff1"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Month","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,C:C;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'7cc6a3d9b4bf0d68eba93caf058ef932a5eec2a0', &'ebe48cad250069a9932979b49095e386a2a2b7d4'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"txt","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"name":"Month","id":"e57fa124c5652fca3f7a0d7dbd78bfc0103802d1"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"MRR Retention Rate","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,D:D;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'7cc6a3d9b4bf0d68eba93caf058ef932a5eec2a0', &'ebe48cad250069a9932979b49095e386a2a2b7d4'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":3.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"MRR Retention Rate","id":"9f6fc69c55d72a538d4d0a36fa43b06d3bb17455"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"MRR Expansion Rate","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,E:E;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), &'7cc6a3d9b4bf0d68eba93caf058ef932a5eec2a0', &'ebe48cad250069a9932979b49095e386a2a2b7d4'))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":4.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"MRR Expansion Rate","id":"c897a0bd943d34d832bb6904bac8fa16d4aef4ab"}],"displayName":"Table Copy","id":"6450f8605da5d233495b14352718ee3aee4295e0","type":"table","dstContext":{"kid":"2bbb7cceb7500ad264d3fe31594b7886","id":"dst6450f8605da5d233495b14352718ee3aee4295e0"}}],"datasourceProps":["vs_secret_key"],"isForked":false,"id":"72384a03f281d2b5fcb0ce405543a26d","appliedMigrations":{"result_rows2":true,"post_dst":true,"textOnlyFormulas":true,"separate_root_dsts":true},"title":"Subscription MRR Retention & Expansion Rates","usesSampleData":false,"master":"40ef4a0a8dae72fc8d6c450378b44b96"},{"workspace":{"datasources":["81202847048ab773daeebcec6fe0c74c"],"dataSets":[],"dimensions":{"w":1277.0}},"components":[{"displayName":"Separator","id":"43eee858e8a02a4805c7c775dc43ed6b648cad5c","type":"separator"},{"components":[{"layoutConfig":{"x":0.0,"y":0.0},"components":[{"role":"primary","data":[],"displayName":"Churn: Current","formulas":[{"txt":"AVERAGE(&'00719b66cde1a64437d37d517c8e96893a544387')/100","ver":2.0}],"autoFmt":false,"type":"label","fmt":"pct","dstContext":{"kid":"640099e58806ffeb390c6196a895d524","id":"dstbbb19d77376c8c7b3e0c26116a4cb07f28bd3ed8"},"size":"small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"2","suffix":""},"id":"bbb19d77376c8c7b3e0c26116a4cb07f28bd3ed8","conditions":[{"predicates":[{"left":{"self":1.0},"right":{"cx":"c034a166c951495d10564c22b4a4aeaa21395929"},"type":"lt"}],"reactions":[{"type":"icon","value":"ind-triangle-down-green","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"cx":"c034a166c951495d10564c22b4a4aeaa21395929"},"type":"eq"}],"reactions":[{"type":"icon","value":"ind-even-yellow","isScalar":true}]},{"predicates":[{"left":{"self":1.0},"right":{"cx":"c034a166c951495d10564c22b4a4aeaa21395929"},"type":"gt"}],"reactions":[{"type":"icon","value":"ind-triangle-up-red","isScalar":true}]}],"renamed":true},{"role":"secondary","data":[],"displayName":"Churn: Previous","formulas":[{"txt":"AVERAGE(&'6c40a6cfebcbe73016af9846342b55a506e462ce')/100","ver":2.0}],"autoFmt":false,"font_style":"","type":"label","fmt":"pct","dstContext":{"kid":"640099e58806ffeb390c6196a895d524","id":"dstc034a166c951495d10564c22b4a4aeaa21395929"},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"precision":"2","suffix":" Previous Period"},"id":"c034a166c951495d10564c22b4a4aeaa21395929","renamed":true}],"displayName":"Value Pair Copy","id":"8f35095089945a632f24d21dda23421d6e8f48a1","type":"simple_value","dstContext":{"id":"dst8f35095089945a632f24d21dda23421d6e8f48a1"}},{"data":[],"displayName":"Title","formulas":[{"txt":"LOOKUP($ChurnOverTime_PeriodSelector,&'e4174f81d4c3c32eb915f90e1a6d2eb8959c76ee',&'b1d7095019cbee3e8998cdbe38574099404eb829')","ver":2.0}],"autoFmt":true,"type":"label","fmt":"txt","dstContext":{"kid":"640099e58806ffeb390c6196a895d524","id":"dst2b25a3ec21a3c7f14d256a20a972e9770abfb1fb"},"align":"c","layoutConfig":{"x":1.0,"y":0.0},"size":"xx-small","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"},"prefix":"Churn Rate ","autoFmt":{"fmtArgs":{},"defaultAggregate":"COUNT","fmt":"txt"}},"id":"2b25a3ec21a3c7f14d256a20a972e9770abfb1fb","renamed":true,"wrap":true},{"layoutConfig":{"x":2.0,"y":0.0},"components":[{"role":"values","data":[],"displayName":"Values","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"ARRAY(-7,-30,-90)","ver":2.0}],"autoFmt":false,"id":"e4174f81d4c3c32eb915f90e1a6d2eb8959c76ee","type":"proxy"},{"role":"labels","data":[],"displayName":"Labels","fmtArgs":{"resultMetadata":{"resultCount":1.0,"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1"}},"formulas":[{"txt":"ARRAY(\"Last 7 days\",\"Last 30 days\",\"Last 90 days\")","ver":2.0}],"autoFmt":false,"id":"b1d7095019cbee3e8998cdbe38574099404eb829","type":"proxy"}],"displayName":"User Input Control","scope":2.0,"inputType":1.0,"id":"1af23ea96a0eef68020f0c8bf036487cde96d7d9","type":"input","dstContext":{"kid":"640099e58806ffeb390c6196a895d524","id":"dst1af23ea96a0eef68020f0c8bf036487cde96d7d9"},"propName":"ChurnOverTime_PeriodSelector"},{"layoutConfig":{"x":0.0,"y":1.0},"components":[{"renderer":"line","role":"series","data":[],"color":"#07bdff","displayName":"Churn % Over Time","seriesName":"Churn % Over Time","formulas":[{"txt":"&'de1d134c4993e60fdc9f18a99496b817b1b3b5e2'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"3dc4109a1a05890f9a39ee60c15047d4226f0d86","lineStyle":"curve","chartStyle":"line","overrideColor":true,"lineWeight":"3","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"precision":"1"},"id":"00719b66cde1a64437d37d517c8e96893a544387","renamed":true},{"renderer":"line","role":"series","data":[],"color":"cx-theme_888","displayName":"Churn % Over Prev","seriesName":"Churn % Prev Period","formulas":[{"txt":"&'ca713d98c3b630521fbfd259518064083235bacc'","ver":2.0}],"autoFmt":false,"type":"series_data","fmt":"pct","axis":"3dc4109a1a05890f9a39ee60c15047d4226f0d86","lineStyle":"curve","chartStyle":"line","overrideColor":true,"lineWeight":"2","fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"precision":"1"},"id":"6c40a6cfebcbe73016af9846342b55a506e462ce","renamed":true},{"role":"axis_x","data":[],"displayName":"Date Range","formulas":[{"txt":"&'efd567f3fe42261fdfcaa40b770ddc906f458b29'","ver":2.0}],"autoFmt":false,"label":"Date Range","type":"chart_axis","fmt":"dat2","showLabelTicks":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"dateInputFormatCustom":"MMM d","dateFormat":"custom","dateFormatCustom":"MMM d","dateInputFormat":"MMM d"},"labelAngle":"-45","id":"aac7744cc865c838a5d4dcf4f81deeab6187ba12","labelDrop":0.0},{"role":"axis_y","data":[],"dataDisabled":true,"displayName":"Percentage","formulas":[],"autoFmt":true,"label":"Percentage","type":"chart_axis","fmt":"pct","grid":true,"fmtArgs":{"precision":"1"},"id":"3dc4109a1a05890f9a39ee60c15047d4226f0d86","labelDrop":0.0}],"displayName":"Bar/Line Chart Copy","id":"50c97110583a03a92edb76529c62be675348a233","type":"chart_series","dstContext":{"ops":[{"sortBy":[{"dim":"aac7744cc865c838a5d4dcf4f81deeab6187ba12","dir":1.0}],"type":"sort"}],"kid":"640099e58806ffeb390c6196a895d524","id":"dst50c97110583a03a92edb76529c62be675348a233"},"height":"2"}],"displayName":"Churn Rate Over Time","id":"c75688967d601eddaf06e7ec00ae48d2a2cfb551","cellData":[{"x":0.0,"y":0.0},{"w":3.0,"x":0.0,"y":1.0},{"x":1.0,"y":0.0,"alignment":1.0},{"x":2.0,"y":0.0,"alignment":1.0}],"type":"panel_grid","rows":2.0,"renamed":true,"cols":3.0},{"components":[{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Day","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), DATE_ADD(TODAY(), \"5\", $ChurnOverTime_PeriodSelector),TODAY()))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":0.0,"type":"table_col","fmt":"dat2","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"dateFormat":"MMM d","dateFormatCustom":"MMM d","autoFmt":{"fmtArgs":{"dateInputFormatCustom":"d/M/yyyy","dateFormat":"custom","dateFormatCustom":"MMM d","dateInputFormat":"custom"},"defaultAggregate":"COUNT","fmt":"dat2"}},"name":"Day","id":"efd567f3fe42261fdfcaa40b770ddc906f458b29"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Churn Rate Over Time","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,F:F;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), DATE_ADD(TODAY(), \"5\", $ChurnOverTime_PeriodSelector),TODAY()))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":1.0,"type":"table_col","fmt":"num","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Churn Rate Over Time","id":"de1d134c4993e60fdc9f18a99496b817b1b3b5e2"},{"vis":false,"components":[],"customHeader":false,"role":"tcol","data":[],"displayName":"Churn Rate Previous","formulas":[{"txt":"SELECT(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,W:W;),BETWEEN(DATE(SLICE(81202847048ab773daeebcec6fe0c74c@Timed Data,A:A;),\"d/M/yyyy\"), DATE_ADD(TODAY(), \"5\", $ChurnOverTime_PeriodSelector),TODAY()))","ver":2.0}],"autoFmt":true,"colHidden":"hidden","index":2.0,"type":"table_col","fmt":"num","align":"left","size":"xx-small","namerenamed":true,"fmtArgs":{"resultMetadata":{"resultCount":1.0,"expiryScheme":[{"expiryType":"EOD"}],"ignoreDateFormat":false,"isAggregated":false,"formulaIsDataPointer":false,"suggestedName":"Unnamed 1","isDSTApplied":true},"autoFmt":{"fmtArgs":{"precision":"2"},"defaultAggregate":"SUM","fmt":"num"}},"name":"Churn Rate Previous","id":"ca713d98c3b630521fbfd259518064083235bacc"}],"displayName":"Table Copy","id":"738f21e3e4591e191371215f5ea53ba60fbd184f","type":"table","dstContext":{"kid":"640099e58806ffeb390c6196a895d524","id":"dst738f21e3e4591e191371215f5ea53ba60fbd184f"}}],"datasourceProps":["vs_secret_key"],"isForked":false,"id":"68a4e23d023f2a952e4fba961067710e","appliedMigrations":{"result_rows2":true,"post_dst":true,"separate_root_dsts":true},"title":"Churn Rate Over Time","usesSampleData":false,"master":"3a74b568fc9d9eb72c840d6ca171ce3d"}]}]