on 11-08-2012 5:41 PM
I am in need of a RelativeTime function just like RelativeDate functions. This way I can say give me something in the last 8 hours based on a timestamp field. If we can put this in the universe, even better but for now in Webi at least. Does this exist for 4.0 or later and is it coming?
Hi,
you can use the relativeDate function of webi to calculate hours on a timestamp, e.g. with following function you can add 8 hours:
=RelativeDate([Sale Date];0.834)
Afterwards you can do the filtering with some variables.
You can also use the corresponding database function of the DB behind your universe to create a predefined filter on the universe.
BR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.