Need to use group by with filter

[BhushanSolanki]

The data I am using to plot time series on Grafana is in different columns (the data from different sources are in different columns). on this data we need to use group by data based on timestamp column so we can plot the average value on timeseries graph. We need to use the filter on timestamp column ( like timestamp_field > $__timeFrom and timestamp_field < $__timeTo ) along with timestamp_field filter we need to add 1 more filter in query based on selection of Grafana dashboard variable (say city column; to plot data of selected/all cities).

1. But as per Cassandra to use group by I need to add the timestamp column in primary key, but then I am not able to apply greater that and less than range on timestamp column.
2. I need to user IN condition on City column but I can not use IN operation on City column as its not part of primary key (if I add City column in primary then then Cassandra asking me to use group by on City column as well which is not required.
3. Also need help in adding Variable as dropdown using Apache Cassandra data source. Need to list DISTINCT data from 1 column as a dropdown (Say City column.)

Can you help on the query?

[BhushanSolanki]

Here, we need to plot graph Active vs New cases. I have added additional column 'id' just to fetch data as its required by plugin.

SELECT
    id,
    AVG(active_cases_count) as Active,
    Time
FROM
  sampleTable
where
    City in ('City_1', 'City_2')
AND Time > 1609475957234
    and Time <1611229667494
GROUP by
    Time

SELECT
    id,
    AVG(new_cases_count) as New,
    Time
FROM
  sampleTable
where
    City in ('City_1', 'City_2')
AND Time > 1609475957234
    and Time <1611229667494
GROUP by
    Time