Grouping metrics in QS

Question & Answer
, ,
1

Hello,

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

select
distinct count (metric) as xyz,
dimension1,
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

TIA

2

Hi @Ajinkya_Bangale
do you mean like that function?

BR

3

Distinct_count isn’t giving me the desired results.

4

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

1 Like
5

Do you used the group-level?

6

@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.