Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use TOTAL qualifier when you have multiple dimensions
above(TOTAL name)
above(TOTAL date)
Use TOTAL qualifier when you have multiple dimensions
above(TOTAL name)
above(TOTAL date)
That fixed it. Not sure how one TOTALs text fields, but it works.
Check this link out