cancel
Showing results for 
Search instead for 
Did you mean: 

Previous 7 days average

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member183012
Active Contributor
0 Kudos

Hi Vee,

Try Exception and aggregation in your query(avg,MIn,MAX ect).

Hope it will help.

Regards,

Ganesh Bothe

Former Member
0 Kudos

Ganesh,

How to let the system calculate 7 days Average, for each day.

I tried exception aggregation options, It didn't work. Where should I say it's 7 days?


Thanks

VeeKay

former_member183012
Active Contributor
0 Kudos

You need to create KF which will have 7 days of data and then it will calculate avg..use offset in CALday variable.

Regards,

Ganesh Bothe

Former Member
0 Kudos

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,

Former Member
0 Kudos

Can creating Cell definitions help?

Former Member
0 Kudos

Cell definition worked. Thanks

former_member183012
Active Contributor
0 Kudos

Hi,

Its good to know your issue has been resolved.

Regards,

Ganesh Bothe

Answers (0)