Hi ,
I want to calculate measures between days ex(1-30 days,31-60days, 61-90days like...) in webi report for user given date.
now i am using relative position to implementing above requirement but not sure it ll give right data . if you have any other logic please provide solution.
1-30days Name called V1
=RelativeDate([vUser Date];-30)
31-60days V2
=RelativeDate([V1];-60)
1- 30 days measure calculation
=[Hours Worked] Where ([Pay Period Ending Date]<=[vUser Date] And [Pay Period Ending Date]>[V1])
31- 60 days measure calculation
=[Hours Worked] Where ([Pay Period Ending Date]<=[vUser Date] And [Pay Period Ending Date]>[V2])
Thanks,
S Suryateja.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |