
Not applicable
2017-01-26
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
On the fly IntervalMatch (kind of)???
Hi everyone,
Need to build an expression that do something similar to a IntervalMatch, but on the front-end.
In other words, from a table like the one below:
Grade | Rate
0 | 1
4,5 | 2
4,6 | 3
4,7 | 4
So, if our grade is above 0 and less than 4,5 the rate is 1, if is above 4,5 and less than 4,6 the rate is 2, etc.
The grade metric depends on the selections, so it can not be calculated in advance.
At this point I can only assign it to the total value of the aggregation (the value of total row of the table). On the attachment you have a dummy data set to walk you through the problem.
Thanks in advance,
1,258 Views
1 Solution
Accepted Solutions

MVP
2017-01-26
12:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check the attached
2 Replies

MVP
2017-01-26
12:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check the attached

Not applicable
2017-01-26
01:43 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much!
1,007 Views
