Grouping value intervals

[valpassos]

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

[lorenzoconforti · Accepted solution]

You can use the Ceil() function; see attached

[valpassos]

Oh, wow, that is a neat trick!

Thanks @lorenzoconforti 🙂