
Creator III
2020-03-24
08:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Grouping value intervals
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
759 Views
1 Solution
Accepted Solutions


Specialist II
2020-03-25
10:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
713 Views
2 Replies


Specialist II
2020-03-25
10:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can use the Ceil() function; see attached
714 Views

Creator III
2020-03-25
11:10 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oh, wow, that is a neat trick!
Thanks @lorenzoconforti 🙂
709 Views
