I have some JSON that looks similar to this:     { "foo": "bar", "x": { "hello": "world", "y": { "A": 400, "B": 500, "C": 300 } } } { "foo": "baz", "x": { "something": "test", "y": { "A": 100, "D": 200, "E": 600 } } }      What I would like is to extract everything in x.y for a sum but the keys are dynamic and I won't know them all in advance: A 500 B 500 C 300 D 200 E 600   I have been stuck on this one for a while. Can anyone help me? ... View more

I have some data that's coming in as follows:   "data": { "a": 100, "b": 200 } "data": { "a": 50, "c": 75 } ...       I want to aggregate the values so I end up with a table of the sum of values by key:     <search> | chart sum(data.*) as *      This gives me the table: a b c 150 200 75   Now I want to sort the columns by value so that it is in the order b, a, c. It looks like the "sort" keyword sorts by rows and not columns. How would I do this? Note this is an extremely simplified example and the actual data will have tons of keys which are arbitrary uuids and there will be a lot of rows to sum. I need to aggregate and then sort by value to have the highest on the left-hand-side. I would also like to only keep the first n columns. It looks like "head" also works by rows and not columns. Any help would be greatly appreciated. Thanks. ... View more