CREATE DATABASE apple_basketImport the sample data line protocol inlcuded in this gist. I just used the "Write Data" functionality in Chronograf's Data Explorer (here if you're running Chronograf on localhost).
SELECT (mean("apple_weight")/cumulative_sum(mean("apple_weight")))*100 AS "apple_pct_weight" FROM "apple_basket"."autogen"."weight" WHERE time >= '2018-06-04T12:00:00Z' AND time <= '2018-06-04T15:20:00Z' GROUP BY time(1m)| weight apple_weight=0.11 1528113660000000000 | |
| weight apple_weight=0.42 1528113720000000000 | |
| weight apple_weight=0.83 1528113780000000000 | |
| weight apple_weight=0.07 1528113840000000000 | |
| weight apple_weight=0.19 1528113900000000000 | |
| weight apple_weight=0.43 1528113960000000000 | |
| weight apple_weight=0.67 1528114020000000000 | |
| weight apple_weight=0.24 1528114080000000000 | |
| weight apple_weight=0.74 1528114140000000000 | |
| weight apple_weight=0.03 1528114200000000000 | |
| weight apple_weight=0.45 1528114260000000000 | |
| weight apple_weight=0.38 1528114320000000000 | |
| weight apple_weight=0.75 1528114380000000000 | |
| weight apple_weight=0.82 1528114440000000000 | |
| weight apple_weight=0.25 1528114500000000000 | |
| weight apple_weight=0.09 1528114560000000000 | |
| weight apple_weight=0.38 1528114620000000000 | |
| weight apple_weight=0.85 1528114680000000000 | |
| weight apple_weight=0.83 1528114740000000000 | |
| weight apple_weight=0.02 1528114800000000000 | |
| weight apple_weight=0.92 1528114860000000000 | |
| weight apple_weight=0.44 1528114920000000000 | |
| weight apple_weight=0.03 1528114980000000000 | |
| weight apple_weight=0.11 1528115040000000000 | |
| weight apple_weight=0.08 1528115100000000000 | |
| weight apple_weight=0.63 1528115160000000000 | |
| weight apple_weight=0.4 1528115220000000000 | |
| weight apple_weight=0.91 1528115280000000000 | |
| weight apple_weight=0.06 1528115340000000000 | |
| weight apple_weight=0.53 1528115400000000000 | |
| weight apple_weight=0.44 1528115460000000000 | |
| weight apple_weight=0.21 1528115520000000000 | |
| weight apple_weight=0.89 1528115580000000000 | |
| weight apple_weight=0.8 1528115640000000000 | |
| weight apple_weight=0.39 1528115700000000000 | |
| weight apple_weight=0.32 1528115760000000000 | |
| weight apple_weight=0.03 1528115820000000000 | |
| weight apple_weight=0.39 1528115880000000000 | |
| weight apple_weight=0.13 1528115940000000000 | |
| weight apple_weight=0.49 1528116000000000000 | |
| weight apple_weight=0.8 1528116060000000000 | |
| weight apple_weight=0.32 1528116120000000000 | |
| weight apple_weight=0.28 1528116180000000000 | |
| weight apple_weight=0.6 1528116240000000000 | |
| weight apple_weight=0.95 1528116300000000000 | |
| weight apple_weight=0.38 1528116360000000000 | |
| weight apple_weight=0.12 1528116420000000000 | |
| weight apple_weight=0.25 1528116480000000000 | |
| weight apple_weight=0.58 1528116540000000000 | |
| weight apple_weight=0.66 1528116600000000000 | |
| weight apple_weight=0.65 1528116660000000000 | |
| weight apple_weight=0.08 1528116720000000000 | |
| weight apple_weight=0.43 1528116780000000000 | |
| weight apple_weight=0.52 1528116840000000000 | |
| weight apple_weight=0.6 1528116900000000000 | |
| weight apple_weight=0.16 1528116960000000000 | |
| weight apple_weight=0.61 1528117020000000000 | |
| weight apple_weight=0.89 1528117080000000000 | |
| weight apple_weight=0.04 1528117140000000000 | |
| weight apple_weight=0.89 1528117200000000000 | |
| weight apple_weight=0.55 1528117260000000000 | |
| weight apple_weight=0.58 1528117320000000000 | |
| weight apple_weight=0.07 1528117380000000000 | |
| weight apple_weight=0.77 1528117440000000000 | |
| weight apple_weight=0.15 1528117500000000000 | |
| weight apple_weight=0.24 1528117560000000000 | |
| weight apple_weight=0.31 1528117620000000000 | |
| weight apple_weight=0.95 1528117680000000000 | |
| weight apple_weight=0.59 1528117740000000000 | |
| weight apple_weight=0.56 1528117800000000000 | |
| weight apple_weight=0.46 1528117860000000000 | |
| weight apple_weight=0.56 1528117920000000000 | |
| weight apple_weight=0.5 1528117980000000000 | |
| weight apple_weight=0.95 1528118040000000000 | |
| weight apple_weight=0.94 1528118100000000000 | |
| weight apple_weight=0.34 1528118160000000000 | |
| weight apple_weight=0.13 1528118220000000000 | |
| weight apple_weight=0.99 1528118280000000000 | |
| weight apple_weight=0.49 1528118340000000000 | |
| weight apple_weight=0.1 1528118400000000000 | |
| weight apple_weight=0.25 1528118460000000000 | |
| weight apple_weight=0.44 1528118520000000000 | |
| weight apple_weight=0.69 1528118580000000000 | |
| weight apple_weight=0.26 1528118640000000000 | |
| weight apple_weight=0.2 1528118700000000000 | |
| weight apple_weight=0.7 1528118760000000000 | |
| weight apple_weight=0.19 1528118820000000000 | |
| weight apple_weight=0.6 1528118880000000000 | |
| weight apple_weight=0.49 1528118940000000000 | |
| weight apple_weight=0.94 1528119000000000000 | |
| weight apple_weight=0.84 1528119060000000000 | |
| weight apple_weight=0.63 1528119120000000000 | |
| weight apple_weight=0.57 1528119180000000000 | |
| weight apple_weight=0.47 1528119240000000000 | |
| weight apple_weight=0.41 1528119300000000000 | |
| weight apple_weight=0.86 1528119360000000000 | |
| weight apple_weight=0.15 1528119420000000000 | |
| weight apple_weight=0.9 1528119480000000000 | |
| weight apple_weight=0.57 1528119540000000000 | |
| weight apple_weight=0.35 1528119600000000000 | |
| weight apple_weight=0.32 1528119660000000000 | |
| weight apple_weight=0.81 1528119720000000000 | |
| weight apple_weight=0.91 1528119780000000000 | |
| weight apple_weight=0.73 1528119840000000000 | |
| weight apple_weight=0.38 1528119900000000000 | |
| weight apple_weight=0.08 1528119960000000000 | |
| weight apple_weight=0.37 1528120020000000000 | |
| weight apple_weight=0.01 1528120080000000000 | |
| weight apple_weight=0.86 1528120140000000000 | |
| weight apple_weight=0.77 1528120200000000000 | |
| weight apple_weight=0.74 1528120260000000000 | |
| weight apple_weight=0.99 1528120320000000000 | |
| weight apple_weight=0.48 1528120380000000000 | |
| weight apple_weight=0.77 1528120440000000000 | |
| weight apple_weight=0.44 1528120500000000000 | |
| weight apple_weight=0.82 1528120560000000000 | |
| weight apple_weight=0.47 1528120620000000000 | |
| weight apple_weight=0.47 1528120680000000000 | |
| weight apple_weight=0.85 1528120740000000000 | |
| weight apple_weight=0.78 1528120800000000000 | |
| weight apple_weight=0.19 1528120860000000000 | |
| weight apple_weight=0.94 1528120920000000000 | |
| weight apple_weight=0.74 1528120980000000000 | |
| weight apple_weight=0.24 1528121040000000000 | |
| weight apple_weight=0.63 1528121100000000000 | |
| weight apple_weight=0.98 1528121160000000000 | |
| weight apple_weight=0.36 1528121220000000000 | |
| weight apple_weight=0.21 1528121280000000000 | |
| weight apple_weight=0.11 1528121340000000000 | |
| weight apple_weight=0.48 1528121400000000000 | |
| weight apple_weight=0.48 1528121460000000000 | |
| weight apple_weight=0.42 1528121520000000000 | |
| weight apple_weight=0.34 1528121580000000000 | |
| weight apple_weight=0.17 1528121640000000000 | |
| weight apple_weight=0.61 1528121700000000000 | |
| weight apple_weight=0.99 1528121760000000000 | |
| weight apple_weight=0.07 1528121820000000000 | |
| weight apple_weight=0.64 1528121880000000000 | |
| weight apple_weight=0.3 1528121940000000000 | |
| weight apple_weight=0.31 1528122000000000000 | |
| weight apple_weight=0.46 1528122060000000000 | |
| weight apple_weight=0.63 1528122120000000000 | |
| weight apple_weight=0.82 1528122180000000000 | |
| weight apple_weight=0.48 1528122240000000000 | |
| weight apple_weight=0.67 1528122300000000000 | |
| weight apple_weight=0.37 1528122360000000000 | |
| weight apple_weight=0.38 1528122420000000000 | |
| weight apple_weight=0.32 1528122480000000000 | |
| weight apple_weight=0.19 1528122540000000000 | |
| weight apple_weight=0.98 1528122600000000000 | |
| weight apple_weight=0.04 1528122660000000000 | |
| weight apple_weight=0.24 1528122720000000000 | |
| weight apple_weight=0.56 1528122780000000000 | |
| weight apple_weight=0.43 1528122840000000000 | |
| weight apple_weight=0.14 1528122900000000000 | |
| weight apple_weight=0.08 1528122960000000000 | |
| weight apple_weight=0.63 1528123020000000000 | |
| weight apple_weight=0.31 1528123080000000000 | |
| weight apple_weight=0.28 1528123140000000000 | |
| weight apple_weight=0.98 1528123200000000000 | |
| weight apple_weight=0.39 1528123260000000000 | |
| weight apple_weight=0.27 1528123320000000000 | |
| weight apple_weight=0.58 1528123380000000000 | |
| weight apple_weight=0.1 1528123440000000000 | |
| weight apple_weight=0.6 1528123500000000000 | |
| weight apple_weight=0.32 1528123560000000000 | |
| weight apple_weight=0.14 1528123620000000000 | |
| weight apple_weight=0.5 1528123680000000000 | |
| weight apple_weight=0.59 1528123740000000000 | |
| weight apple_weight=0.61 1528123800000000000 | |
| weight apple_weight=0.29 1528123860000000000 | |
| weight apple_weight=0.35 1528123920000000000 | |
| weight apple_weight=0.77 1528123980000000000 | |
| weight apple_weight=0.45 1528124040000000000 | |
| weight apple_weight=0.17 1528124100000000000 | |
| weight apple_weight=0.79 1528124160000000000 | |
| weight apple_weight=0.29 1528124220000000000 | |
| weight apple_weight=0.23 1528124280000000000 | |
| weight apple_weight=0.29 1528124340000000000 | |
| weight apple_weight=0.2 1528124400000000000 | |
| weight apple_weight=0.37 1528124460000000000 | |
| weight apple_weight=0.94 1528124520000000000 | |
| weight apple_weight=0.25 1528124580000000000 | |
| weight apple_weight=0.32 1528124640000000000 | |
| weight apple_weight=0.2 1528124700000000000 | |
| weight apple_weight=0.24 1528124760000000000 | |
| weight apple_weight=0.48 1528124820000000000 | |
| weight apple_weight=0.87 1528124880000000000 | |
| weight apple_weight=0.96 1528124940000000000 | |
| weight apple_weight=0.85 1528125000000000000 | |
| weight apple_weight=0.37 1528125060000000000 | |
| weight apple_weight=0.59 1528125120000000000 | |
| weight apple_weight=0.76 1528125180000000000 | |
| weight apple_weight=0.58 1528125240000000000 | |
| weight apple_weight=0.47 1528125300000000000 | |
| weight apple_weight=0.98 1528125360000000000 | |
| weight apple_weight=0.34 1528125420000000000 | |
| weight apple_weight=0.67 1528125480000000000 | |
| weight apple_weight=0.18 1528125540000000000 | |
| weight apple_weight=0.04 1528125600000000000 |