Skip to Content
0

Rolling month Calculation view

Jan 08 at 11:29 PM

51

avatar image

Hi Folks,

I am trying to develop a Cal view which will display "Rolling month, number of customers who bought a product".

Any idea how do I do "Rolling month" (rolling 30 days) calculations for a customer?

Regards,

R

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member May 12 at 02:37 PM
0

Hello Ricky,

If I understood your question correctly, you should have a date, customer and product number in your view.

If the above statement is true, then in your view bring only last 30 days record, and add a counter on Customer number, keeping the product as an input parameter, so every time a product is selected, it will create an exception aggregation on the customer field.

Option 2 : Add a measure field as 1 and set the aggregation flag for the Customer field as "true", it should work as well.

Hope it helps, otherwise please put a scenario to elaborate further.

Regards,

Abhi

Share
10 |10000 characters needed characters left characters exceeded