Grouping value intervals

valpassos — Sat, 16 Nov 2024 18:53:48 GMT

Hi again community,

I've the following scenario:

I have a version field consisting of values 0.1, 0.1, 0.2,... 1.0, 1.1, 1.2,... 2.0

And I want to group these by saying that

from 0.1 version to 1.0, it's 1st review cycle. from 1.1 to 2.0, it's 2nd review cycle ...

...

And so on.

I will then group this by my dimension and use it as a filter on my application and on my metrics.

I want to do this on script, on my fact table - but I don't know how to group these values. Using IF's? Interval match? Class() ?

Thanks in advance!,

Lisa

Re: Grouping value intervals

lorenzoconforti — Wed, 25 Mar 2020 14:45:42 GMT

You can use the Ceil() function; see attached

valpassos — Wed, 25 Mar 2020 15:10:08 GMT

Oh, wow, that is a neat trick!