Calculate using json input in visualize

I have two fields. Per_id and newconndstic
I wanna calculate unique_count of per_id only newconndstic is 'y'
can i do this using json input?
Have not use any filter..
Plz help me

Use the Unique count aggregation on per_id and then use a filter on newconndstic = y

Thanks your kindness
But i want to use only json feature.
because i will use this on table visualize

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.