Skip to content

Instantly share code, notes, and snippets.

@declann
Created May 1, 2023 16:51
Show Gist options
  • Save declann/3e973796671f81d332c2ce36e3471e27 to your computer and use it in GitHub Desktop.
Save declann/3e973796671f81d332c2ce36e3471e27 to your computer and use it in GitHub Desktop.
{"datasets":[{"id":"dst-1682959141607","name":"New Dataset","rawFields":[{"fid":"gwc_0","key":"gwc_0","name":"month_in","analyticType":"dimension","semanticType":"nominal"},{"fid":"gwc_1","key":"gwc_1","name":"formula","analyticType":"dimension","semanticType":"nominal"},{"fid":"gwc_2","key":"gwc_2","name":"value","analyticType":"measure","semanticType":"quantitative"}],"dsId":"dse-1682959141607"}],"dataSources":[{"id":"dse-1682959141607","data":[{"gwc_0":-1,"gwc_1":"total_cf","gwc_2":0},{"gwc_0":-1,"gwc_1":"mrr_cf","gwc_2":0},{"gwc_0":-1,"gwc_1":"rent_cf","gwc_2":0},{"gwc_0":-1,"gwc_1":"payroll_cf","gwc_2":0},{"gwc_0":-1,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":-1,"gwc_1":"employees","gwc_2":0},{"gwc_0":-1,"gwc_1":"npv","gwc_2":1083592.141481345},{"gwc_0":0,"gwc_1":"total_cf","gwc_2":-435000},{"gwc_0":0,"gwc_1":"mrr_cf","gwc_2":155000},{"gwc_0":0,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":0,"gwc_1":"payroll_cf","gwc_2":-390000},{"gwc_0":0,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":0,"gwc_1":"employees","gwc_2":26},{"gwc_0":0,"gwc_1":"npv","gwc_2":1518592.141481345},{"gwc_0":1,"gwc_1":"total_cf","gwc_2":-439915.6923771161},{"gwc_0":1,"gwc_1":"mrr_cf","gwc_2":180084.30762288388},{"gwc_0":1,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":1,"gwc_1":"payroll_cf","gwc_2":-420000},{"gwc_0":1,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":1,"gwc_1":"employees","gwc_2":28},{"gwc_0":1,"gwc_1":"npv","gwc_2":1958507.8338584611},{"gwc_0":2,"gwc_1":"total_cf","gwc_2":-440771.8848257195},{"gwc_0":2,"gwc_1":"mrr_cf","gwc_2":209228.11517428048},{"gwc_0":2,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":2,"gwc_1":"payroll_cf","gwc_2":-450000},{"gwc_0":2,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":2,"gwc_1":"employees","gwc_2":30},{"gwc_0":2,"gwc_1":"npv","gwc_2":2399279.7186841806},{"gwc_0":3,"gwc_1":"total_cf","gwc_2":563088.3887509762},{"gwc_0":3,"gwc_1":"mrr_cf","gwc_2":243088.38875097616},{"gwc_0":3,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":3,"gwc_1":"payroll_cf","gwc_2":-480000},{"gwc_0":3,"gwc_1":"vc_cf","gwc_2":1000000},{"gwc_0":3,"gwc_1":"employees","gwc_2":32},{"gwc_0":3,"gwc_1":"npv","gwc_2":1836191.3299332047},{"gwc_0":4,"gwc_1":"total_cf","gwc_2":-427571.58593947114},{"gwc_0":4,"gwc_1":"mrr_cf","gwc_2":282428.41406052886},{"gwc_0":4,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":4,"gwc_1":"payroll_cf","gwc_2":-510000},{"gwc_0":4,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":4,"gwc_1":"employees","gwc_2":34},{"gwc_0":4,"gwc_1":"npv","gwc_2":2263762.915872676},{"gwc_0":5,"gwc_1":"total_cf","gwc_2":-411864.9974250354},{"gwc_0":5,"gwc_1":"mrr_cf","gwc_2":328135.0025749646},{"gwc_0":5,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":5,"gwc_1":"payroll_cf","gwc_2":-540000},{"gwc_0":5,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":5,"gwc_1":"employees","gwc_2":36},{"gwc_0":5,"gwc_1":"npv","gwc_2":2675627.9132977114},{"gwc_0":6,"gwc_1":"total_cf","gwc_2":-388761.51777067286},{"gwc_0":6,"gwc_1":"mrr_cf","gwc_2":381238.48222932714},{"gwc_0":6,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":6,"gwc_1":"payroll_cf","gwc_2":-570000},{"gwc_0":6,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":6,"gwc_1":"employees","gwc_2":38},{"gwc_0":6,"gwc_1":"npv","gwc_2":3064389.431068384},{"gwc_0":7,"gwc_1":"total_cf","gwc_2":-357064.0767002096},{"gwc_0":7,"gwc_1":"mrr_cf","gwc_2":442935.9232997904},{"gwc_0":7,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":7,"gwc_1":"payroll_cf","gwc_2":-600000},{"gwc_0":7,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":7,"gwc_1":"employees","gwc_2":40},{"gwc_0":7,"gwc_1":"npv","gwc_2":3421453.5077685937},{"gwc_0":8,"gwc_1":"total_cf","gwc_2":-315381.8769758352},{"gwc_0":8,"gwc_1":"mrr_cf","gwc_2":514618.1230241648},{"gwc_0":8,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":8,"gwc_1":"payroll_cf","gwc_2":-630000},{"gwc_0":8,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":8,"gwc_1":"employees","gwc_2":42},{"gwc_0":8,"gwc_1":"npv","gwc_2":3736835.384744429},{"gwc_0":9,"gwc_1":"total_cf","gwc_2":-262099.042741969},{"gwc_0":9,"gwc_1":"mrr_cf","gwc_2":597900.957258031},{"gwc_0":9,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":9,"gwc_1":"payroll_cf","gwc_2":-660000},{"gwc_0":9,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":9,"gwc_1":"employees","gwc_2":44},{"gwc_0":9,"gwc_1":"npv","gwc_2":3998934.4274863983},{"gwc_0":10,"gwc_1":"total_cf","gwc_2":-195338.19409759995},{"gwc_0":10,"gwc_1":"mrr_cf","gwc_2":694661.8059024},{"gwc_0":10,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":10,"gwc_1":"payroll_cf","gwc_2":-690000},{"gwc_0":10,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":10,"gwc_1":"employees","gwc_2":46},{"gwc_0":10,"gwc_1":"npv","gwc_2":4194272.621583998},{"gwc_0":11,"gwc_1":"total_cf","gwc_2":1887081.8732128767},{"gwc_0":11,"gwc_1":"mrr_cf","gwc_2":807081.8732128765},{"gwc_0":11,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":11,"gwc_1":"payroll_cf","gwc_2":-720000},{"gwc_0":11,"gwc_1":"vc_cf","gwc_2":2000000},{"gwc_0":11,"gwc_1":"employees","gwc_2":48},{"gwc_0":11,"gwc_1":"npv","gwc_2":2307190.7483711215},{"gwc_0":12,"gwc_1":"total_cf","gwc_2":-12304.643015993526},{"gwc_0":12,"gwc_1":"mrr_cf","gwc_2":937695.3569840065},{"gwc_0":12,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":12,"gwc_1":"payroll_cf","gwc_2":-750000},{"gwc_0":12,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":12,"gwc_1":"employees","gwc_2":50},{"gwc_0":12,"gwc_1":"npv","gwc_2":2319495.391387115},{"gwc_0":13,"gwc_1":"total_cf","gwc_2":109446.57499134028},{"gwc_0":13,"gwc_1":"mrr_cf","gwc_2":1089446.5749913403},{"gwc_0":13,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":13,"gwc_1":"payroll_cf","gwc_2":-780000},{"gwc_0":13,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":13,"gwc_1":"employees","gwc_2":52},{"gwc_0":13,"gwc_1":"npv","gwc_2":2210048.816395775},{"gwc_0":14,"gwc_1":"total_cf","gwc_2":255756.33644798584},{"gwc_0":14,"gwc_1":"mrr_cf","gwc_2":1265756.3364479858},{"gwc_0":14,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":14,"gwc_1":"payroll_cf","gwc_2":-810000},{"gwc_0":14,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":14,"gwc_1":"employees","gwc_2":54},{"gwc_0":14,"gwc_1":"npv","gwc_2":1954292.479947789},{"gwc_0":15,"gwc_1":"total_cf","gwc_2":430599.05463557155},{"gwc_0":15,"gwc_1":"mrr_cf","gwc_2":1470599.0546355715},{"gwc_0":15,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":15,"gwc_1":"payroll_cf","gwc_2":-840000},{"gwc_0":15,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":15,"gwc_1":"employees","gwc_2":56},{"gwc_0":15,"gwc_1":"npv","gwc_2":1523693.4253122176},{"gwc_0":16,"gwc_1":"total_cf","gwc_2":638592.3389994481},{"gwc_0":16,"gwc_1":"mrr_cf","gwc_2":1708592.338999448},{"gwc_0":16,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":16,"gwc_1":"payroll_cf","gwc_2":-870000},{"gwc_0":16,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":16,"gwc_1":"employees","gwc_2":58},{"gwc_0":16,"gwc_1":"npv","gwc_2":885101.0863127694},{"gwc_0":17,"gwc_1":"total_cf","gwc_2":885101.0863127694},{"gwc_0":17,"gwc_1":"mrr_cf","gwc_2":1985101.0863127694},{"gwc_0":17,"gwc_1":"rent_cf","gwc_2":-200000},{"gwc_0":17,"gwc_1":"payroll_cf","gwc_2":-900000},{"gwc_0":17,"gwc_1":"vc_cf","gwc_2":0},{"gwc_0":17,"gwc_1":"employees","gwc_2":60},{"gwc_0":17,"gwc_1":"npv","gwc_2":0}]}],"specList":[{"visId":"gw_y2OM","name":"Chart 1","encodings":{"dimensions":[{"dragId":"gw_iP6p","fid":"gwc_0","name":"month_in","semanticType":"nominal","analyticType":"dimension"},{"dragId":"gw_4jXT","fid":"gwc_1","name":"formula","semanticType":"nominal","analyticType":"dimension"}],"measures":[{"dragId":"gw_W7jr","fid":"gwc_2","name":"value","analyticType":"measure","semanticType":"quantitative","aggName":"sum"},{"dragId":"gw_count_fid","fid":"gw_count_fid","name":"Row count","analyticType":"measure","semanticType":"quantitative","aggName":"sum","computed":true,"expression":{"op":"one","params":[],"as":"gw_count_fid"}}],"rows":[{"dragId":"gw_b612","fid":"gwc_2","name":"value","analyticType":"measure","semanticType":"quantitative","aggName":"sum"}],"columns":[{"dragId":"gw_dOu5","fid":"gwc_0","name":"month_in","semanticType":"nominal","analyticType":"dimension"}],"color":[{"dragId":"gw_gONr","fid":"gwc_1","name":"formula","semanticType":"nominal","analyticType":"dimension"}],"opacity":[],"size":[],"shape":[],"radius":[],"theta":[],"details":[],"filters":[{"dragId":"gw_lhUd","fid":"gwc_1","name":"formula","semanticType":"nominal","analyticType":"dimension","rule":{"type":"one of","value":"Set(\"mrr_cf\",\"rent_cf\",\"payroll_cf\",\"vc_cf\",\"employees\",\"npv\")"}}]},"config":{"defaultAggregated":true,"geoms":["area"],"stack":"stack","showActions":false,"interactiveScale":false,"sorted":"none","size":{"mode":"auto","width":320,"height":200}}},{"visId":"gw_AMpq","name":"Chart 2","encodings":{"dimensions":[{"dragId":"gw_fb_0","fid":"gwc_0","name":"month_in","semanticType":"nominal","analyticType":"dimension"},{"dragId":"gw_tTGW","fid":"gwc_1","name":"formula","semanticType":"nominal","analyticType":"dimension"}],"measures":[{"dragId":"gw_EkEo","fid":"gwc_2","name":"value","analyticType":"measure","semanticType":"quantitative","aggName":"sum"},{"dragId":"gw_count_fid","fid":"gw_count_fid","name":"Row count","analyticType":"measure","semanticType":"quantitative","aggName":"sum","computed":true,"expression":{"op":"one","params":[],"as":"gw_count_fid"}}],"rows":[{"dragId":"gw_r_W2","fid":"gwc_1","name":"formula","semanticType":"nominal","analyticType":"dimension"},{"dragId":"gw_pFql","fid":"gwc_2","name":"value","analyticType":"measure","semanticType":"quantitative","aggName":"sum"}],"columns":[{"dragId":"gw_ngHY","fid":"gwc_0","name":"month_in","semanticType":"nominal","analyticType":"dimension"}],"color":[{"dragId":"gw_Q3bc","fid":"gwc_1","name":"formula","semanticType":"nominal","analyticType":"dimension"}],"opacity":[],"size":[],"shape":[],"radius":[],"theta":[],"details":[],"filters":[]},"config":{"defaultAggregated":true,"geoms":["auto"],"stack":"stack","showActions":false,"interactiveScale":false,"sorted":"none","size":{"mode":"fixed","width":593,"height":102}}}]}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment