I have a data set from where I am trying to apply the group by function on multiple columns. I tried stats with list and ended up with this output.
Whereas I am looking for something below ...
Any suggestions on the right query please!
Without a verbal description of the actual requirement, this is my speculation of the intention: country and state are uniquely determined by time, and #travel is added up.
| stats values(country) as country values(state) as state sum("#travel") as "#travel" by time