#community-help

Using 'Datetime' Field as Facet with Predefined Buckets

TLDR Vladimir asked how to use 'datetime' field as a facet with predefined buckets. Jason suggested using facet ranges.

Powered by Struct AI

1

2
3w
Solved
Join the chat
Nov 04, 2023 (3 weeks ago)
Vladimir
Photo of md5-c69dd267688ebbdde448e8e7f775aa80
Vladimir
11:03 PM
Is there any way of using "datetime" field as a facet with some predefined buckets?
I want to show a refinement menu with some predefined filters/buckets like this:
* Today
* Yesterday
* This week
* This month
* This quarter
* This year

Since "datetime" fields are stored as long , the default facet information returned by the engine does not make sense since the cardinality is too high.
Nov 05, 2023 (3 weeks ago)
Jason
Photo of md5-8813087cccc512313602b6d9f9ece19f
Jason
04:18 AM

1