iccube - Create dimension that filters by range -
How can I configure a dimension in ICQF to filter the values by that range bucket? For example, if I have many timestamps, how can I buckle the timestamp with an hour or a minute? Or if I have value between 1-20, how can I bucket it between 1-5, 6-10, 11-15, 16-20?
Is 'Range-to-Indexing' relevant?
Yes, this is the way to go with the dimension (see) with 'indexing by rage'.
It is the idea that icCube resolves the key using an algorithm which runs from the root using binary search. Note that all levels must be ordered from the same key type (like numeric). Hot [20, unbearable hot [35] very hot [30,35] lightly heated [25,30] Nice [20,25] cold cold cold [15,20] cold [5,15] Freezing 5)
Here 22.5 would be 'good'.
Comments
Post a Comment