How to group by multiple fields?

[rsahoo]

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.

country	state	time	#travel
India	Bangalore	20220326023652	1
		20220326023652	1
		20220327023321	1
		20220327023321	1
		20220327023321	1

Whereas I am looking for something below ...

country	state	time	#travel
India	Bangalore	20220326023652	2
		20220327023321	3

Any suggestions on the right query please!

[yuanliu]

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