on 04-22-2014 10:14 PM
Hello Guru's
I'm learning Bex. Struck here and need little push, Please help.
Our requirement is to display 2 KF's.
1. Last 30 days Sales Volume and
2. Last 7 day Average of Sales Volume for 30 day's.
Last 30 day Sales is directly from KF and I'm restricting date's in Query to get 30 dates.
I have no clue, how to get Last 7 day Average for 30 days - Any help is highly appreciated.
Thank You
Karthik
Hi Vee,
Try Exception and aggregation in your query(avg,MIn,MAX ect).
Hope it will help.
Regards,
Ganesh Bothe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ganesh
My first Key Figure "Sale Volume" is restricted by 0DAT(Current Cal Day), with offset range of -31 to -1. This gave me the previous 30 days results. I'm good here.
I created 2nd Key Figure exactly as 1st, and I have offset of -8 to -1.
3rd is CKF with exception aggregation - Average.
i'm getting values only for the last 7 days and not above. (as offset).
Please check attachment and advice,
User | Count |
---|---|
84 | |
24 | |
11 | |
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.