Duplicate Fields

[mustafa_mohammed]

I have over 2000 records in my CSV file that I want to use to keep track of how many times we order a product. And each record has its own product ID, So a product could be ordered multiple times, so I want to know if there is a way to figure out how many products have been order where fields that have the same product ID are only counted 1 time. And also how to filter this chart by year.

Thank you for your help in advance.

[bhavyarm]

Hi,

Unique count aggregation on any of the fields in y-axis should be able to give you this on charts.
And then you can filter by the year on x-axis.

Thanks,
Bhavya