Shouldn't td have s2=1 also? Try this: facet.pivot=vi,vk
> On Nov 4, 2015, at 03:23, Mugeesh Husain <muge...@gmail.com> wrote: > > i am facing issue of how to get below response from solr query. > > In my table, i have a two column vi and vk which has below values: > > row1: vi:["ta"] ,vk:["s1"] > row2: vi:["tb"] ,vk:["s2"] > row3: vi:["tc"] ,vk:["s0"] > row4: vi:["td"] ,vk:["s2"] > row5: vi:["ta"] ,vk:["s1"] > row5: vi:["tc"] ,vk:["s0"] and so on. > > I want to facet in below way > > ta-[so=0,s1=2,s2=0] > tb-[so=0,s1=1,s2=0] > tc-[so=2,s1=0,s2=0] > td-[so=0,s1=0,s2=0] > > how i create query which i can get such response ? > > Please suggestion > > Thanks, > Mugeesh > > > > > > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Solr-facet-query-critical-solr-query-response-tp4238135.html > Sent from the Solr - User mailing list archive at Nabble.com.