Is there any alternatives for extracting the distinct count in the aggregate function

General
,
2

hi @sandeep_gajula !!

Welcome to our community :hugs:

Can you elaborate more?

Or maybe share a data sample and the outcome you want.

Thanks!

3

Sorry for the delay,

I have tried to extract the distinct count of the property but it has not worked properly.

In Weaviate, Iā€™m trying to get distinct counts for specific fields grouped by another field. For example, how many unique entries exist for itemType grouped by categoryName. Currently, the Aggregate query provides total counts but not distinct counts. Is there a way to retrieve only unique values in this setup, or an alternative approach within Weaviate?

4

Hi!

Is this what you want? From one of our recipes:

response = collection.aggregate.over_all(group_by="source")
for group in response.groups:
    print(group.grouped_by.value, group.total_count)

and it would output:

netherlands-wikipedia-article-text.pdf 274
brazil-wikipedia-article-text.pdf 247

More info here: