Group by range results

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Group by range results

Mikhail Ibraheem
Hi,

Can we group by ranges? something like:

facet=true
stats=true
stats.field={!tag=piv1 min=true max=true}price
facet.range={!tag=r1}manufacturedate_dt
facet.range.start=2006-01-01T00:00:00Z
facet.range.end=NOW/YEAR
facet.range.gap=+1YEAR
facet.pivot={!stats=piv1}r1

 

Where I want the max price and min price for each range of manufacturedate_dt.

Please advise.





Thanks
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Group by range results

Mikhail Ibraheem
Any help on this please?

 

From: Mikhail Ibraheem
Sent: 15 مارس, 2017 08:53 م
To: [hidden email]
Subject: Group by range results

 

Hi, 

Can we group by ranges? something like:

facet=true
stats=true
stats.field={!tag=piv1 min=true max=true}price
facet.range={!tag=r1}manufacturedate_dt
facet.range.start=2006-01-01T00:00:00Z
facet.range.end=NOW/YEAR
facet.range.gap=+1YEAR
facet.pivot={!stats=piv1}r1

 

Where I want the max price and min price for each range of manufacturedate_dt.

Please advise.

 

Thanks
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Group by range results

Zheng Lin Edwin Yeo
You can try using JSON Facet.
It has Range Facet, which you can use it to group in by the date range.

http://yonik.com/json-facet-api/#Range_Facet

Regards,
Edwin


On 16 March 2017 at 21:32, Mikhail Ibraheem <[hidden email]>
wrote:

> Any help on this please?
>
>
>
> From: Mikhail Ibraheem
> Sent: 15 مارس, 2017 08:53 م
> To: [hidden email]
> Subject: Group by range results
>
>
>
> Hi,
>
> Can we group by ranges? something like:
>
> facet=true
> stats=true
> stats.field={!tag=piv1 min=true max=true}price
> facet.range={!tag=r1}manufacturedate_dt
> facet.range.start=2006-01-01T00:00:00Z
> facet.range.end=NOW/YEAR
> facet.range.gap=+1YEAR
> facet.pivot={!stats=piv1}r1
>
>
>
> Where I want the max price and min price for each range
> of manufacturedate_dt.
>
> Please advise.
>
>
>
> Thanks
>
Loading...