Tagged with bucketing - Visokio Forums

Formulae: bracketing values using IF logic?

kantia8 — Wed, 05 Nov 2014 17:36:21 -0500

I am trying to do an analysis where I want to rename variables if they are between at set of numbers
i.e.: if the value of [Field1] is >10 and <20, then the value is changed to something like "Page2" in the [Formula Field1]

I know how to use the operators "=", ">" and "<", but I don't know how to do in between. I looked at the bucket function, but that seems to only work for dates and not other field types?

Formulae: Calculating Week Start - Week Ending dates?

Panos — Wed, 17 Sep 2014 13:48:34 -0400

Hi
Is there any formula so I can get the "week start" or "week end" for each week number?
Regards,
Panos

Idea: Formulae - Custom Bucket intervals?

starsky51 — Thu, 29 Aug 2013 11:00:48 -0400

I like the simplicity of the BUCKET function, but the buckets we require tend to be irregular (eg. 0 to 10, 10 to 25, 25 to 50, 50+). The only way I can see of creating these buckets is with nested IFs. Is there a better way of doing this? If not, could the BUCKET function be extended?

Aggregation: Grouping records by date?

nicci113 — Fri, 17 May 2013 06:09:27 -0400

Hi,

Is there a way to group dates within Data Manager? I'm creating a primary key, but need the group function ?

Bar/Line View: Y Axis bucketing?

davedunckley — Mon, 12 Mar 2012 10:43:07 -0400

Hello - I can't remember where we got to with Y axis. I know they are now available in 2.7.

But is it possible to change the bucket - so that we can fix the maximum value of the axis? As so that we can change the intitial axis, so make it go up in 2, or 25s of what every we pick?

Look forward to reply - Dave

Disabling or changing buckets in date bucketing - H1, Q1, W1

Alk — Tue, 26 Jul 2011 05:06:49 -0400

Hi, as of 2.6-alpha b699, there has been date bucketing added to Omniscope (experimental).

I've tried to use b713 to see the feature and it simply does not work for my situation, reason being, the H, Q and W I use is different to the conventional calendar H, Q and W - year and week starts at a different date/day and some years have 52 weeks, others, 53.

How do I disable date bucketing for the iok so dates look the same as older builds in b699+?