Grouping metrics in QS


My use case involves aggregating the data for one of the field/metric:

distinct count (metric) as xyz,
date field (dimension 2)

FROM Table

group by
dimension1, date field

order by dimension 1

Can this be achieved in QS using an inbuilt function ? Please suggest


Hi @Ajinkya_Bangale
do you mean like that function?


Distinct_count isn’t giving me the desired results.

Please ignore → My dataset is at a different granularity. My bad!

1 Like

Do you used the group-level?

@Ajinkya_Bangale ,
Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.