Re: Counting in facet results

[Samuel García Martínez]

Hi, i think what you are looking for is "*nested facets*" or *
HierarchicalFaceting *
*
*
Category A - Subcategory A1
Category A - Subcategory A1
Category B - Subcategory A1
Category B - Subcategory B2
Category A - Subcategory A2

Faceting by Category:
 A: 3
 B: 2

In addition, pivoting this query:
Cat: A=3
  SubCat: A1=2 and A2=1
Cat: B=2
  SubCat: A1=1 and B2=1

This makes sense?

On Mon, Nov 14, 2011 at 11:02 AM, LT.thomas  wrote:

> Hi,
>
> By counting in facet results I mean resolve the problem:
>
> I have 7 documents:
>
> A1   B1   C1
> A2   B1   C1
> A3   B2   C1
> A4   B2   C2
> A5   B3   C2
> A6   B3   C2
> A7   B3   C2
>
> If I make the facet query by field B, get the result: B1=2, B2=2, B3=3.
> A1   B1   C1
> A2   B1   C1 2 - facing by B
> --===
> A3   B2   C1
> A4   B2   C2 2 - facing by B
> --===
> A5   B3   C2
> A6   B3   C2
> A7   B3   C2 3 - facing by B
>
> I wont to get additional information, something like count in results, by
> field C. So, how can I query to get a result similar to the following:
> A1   B1   C1
> A2   B1   C1 2, 1 - facing by B, count C in facet results
> --=
> A3   B2   C1
> A4   B2   C2 2, 2 - facing by B, count C in facet results
> --=
> A5   B3   C2
> A6   B3   C2
> A7   B3   C2 2, 1 - facing by B, count C in facet results
>
>
> Thanks
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Counting-in-facet-results-tp3506382p3506382.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>



-- 
Un saludo,
Samuel García.

Re: Counting in facet results

[LT.thomas]

I use Solandra that integrates Solr 3.4 with Cassandra. So, is there any way
to solve this problem with Solr 3.4 (without pivots)?

Your results are:
Cat: A=3
  SubCat: A1=2 and A2=1
Cat: B=2
  SubCat: A1=1 and B2=1

but I would like to have:
Cat: A=3
  SubCat: 2 (losing information about the numbers within A1 and A2, only
distinct count of subcategories)
Cat: B=2
  SubCat: 2 (losing information about the numbers within A1 and B2, only
distinct count of subcategories)

--
View this message in context: 
http://lucene.472066.n3.nabble.com/Counting-in-facet-results-tp3506382p3506848.html
Sent from the Solr - User mailing list archive at Nabble.com.