Hi,
I have created a table something like this.
Name, Place , Business, Value
Bob, NY, Retail, 1000
Alice, Boston, Transport, 2000
Amit, Delhi, E-commerce, 500
Bob, NY, Entertainment, 1500
Usha, Mumbai, Films, 800
Alice, NY, Films, 5000
Alice, Boston, FastFood, 900
I want to display only those results where a person having 2 different businesses in same city.
Bob, NY, Retail, 1000
Bob, NY, Entertainment, 1500
Alice, Boston, Transport, 2000
Alice, Boston, FastFood, 900
Thanks for your help.
Regards
Ashok
Try something like this
your current search giving first table | eventstats count by Name,Place | where count=2 | fields - count
Try something like this
your current search giving first table | eventstats count by Name,Place | where count=2 | fields - count
Wow!! Thanks a lot. I was trying to achieve the same result using subsearches.