Search DISTINCT field

[xavi23]

Hello,

I want to load some healthcare data in my index, but i have some problems to visualize the data.

I have some jsons about the same patient, every json have different information but always all json have any fields that never change. Example : Name, birthdate, etc.

How I can to do to create a simple discover using a 'distinct' or similiar filter in the bar search?

Thanks.

[Stacey_Gammon]

You can do this by creating a Data Table Visualization and splitting on the field you wish to see the unique values for.

e.g.:

You can add sub buckets for additional columns.

[xavi23]

Thanks Stacey,

But the agregation no will resolve my problem because I don't like see the count field, unless that I can remove the count field ?

[Stacey_Gammon]

Hmm, it would be nice if you could get rid of the count column, but you can't. You can however change it to something else, but it looks like the only fields you can replace with are numeric fields. If you have a numeric field that doesn't change document to document and is numeric, then you could use max, min, or top hit to replace the count column with.

Unfortunately it does look like you have to select at least one metric column though.

[xavi23]

Thanks, don't worry, finally I was find a way to load my data without duplicate the data.