

Contributor II
2018-08-21
10:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bug in Above() Function?
Above seems to not we working as expected. I thought it would just return the value in the row above the current one, but that does not seem to be the case. It only does so when the second column matches. Why don't above(name) and above(date) have values in all but the first row?
name | date | time | comments | above(name) | above(date) |
- | - | - | |||
apr | 7/1/2018 | 11:00 | comment one | - | - |
apr | 7/1/2018 | 12:00 | comment two | apr | 7/1/2018 |
apr | 7/3/2018 | 9:00 | comment three | - | - |
bcr | 7/1/2018 | 10:00 | comment four | - | - |
Please let me know if I am doing something wrong or if it is indeed a bug.
1,494 Views
1 Solution
Accepted Solutions

MVP
2018-08-21
10:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use TOTAL qualifier when you have multiple dimensions
above(TOTAL name)
above(TOTAL date)
3 Replies

MVP
2018-08-21
10:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use TOTAL qualifier when you have multiple dimensions
above(TOTAL name)
above(TOTAL date)


Contributor II
2018-08-21
10:23 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That fixed it. Not sure how one TOTALs text fields, but it works.
1,430 Views

MVP
2018-08-21
10:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check this link out
1,430 Views
