Skip to Content

Rolling month Calculation view

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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 12, 2018 at 02:37 PM

    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.



    Add comment
    10|10000 characters needed characters exceeded