Can i get following result in druid

my rows in druid are in the following pattern,

time user visited-city

123 hyderabad

456 hyderabad

123 bangalore

653 hyderabad

656 hyderabad

656 banglore

656 hyderabad

656 hyderabad

i want to get the result in following format:

who visited hyderabad 1 time, who visited hyderabad 2 times, who visited hyderabad 3 times i want the timeseries based in the count , and my user field is hyperunique, can i get the following result from druid

is there anyone to help me out of this

Hi, do you solved ur problem