4 Replies Latest reply on May 15, 2018 12:19 AM by Prabu Deivendran

# Display Aggregated value in disaggrecation

Hi All,

I need help to show the view based on the requirement. PFA Sample Date and workbook.

I have made an View like below.

Purchase Bucket Calculation : str({ FIXED [Customer ID]:COUNTD([Order ID])})+ ' Purchase'

 Purchase bucket # of Customers 3 Purchase 1 5 Purchase 1 7 Purchase 1 10 Purchase 1 11 Purchase 2

One customer made three orders in specific date range.

 Purchas Bucket # of Customers Expected # of Customers 3 Purchase 1 6 5 Purchase 1 5 7 Purchase 1 4 10 Purchase 1 3 11 Purchase 2 2 Sum 6

Final Output:

 Purchas Bucket # of Customers 1 Purchase 6 2 Purchase 6 3 Purchase 6 4 Purchase 5 5 Purchase 5 6 Purchase 4 7 Purchase 4 8 Purchase 3 9 Purchase 3 10 Purchase 3 11 Purchase 2

Regards,

Prabu

• ###### 1. Re: Display Aggregated value in disaggrecation

Hi Prabhu,

BR,

bharat

• ###### 2. Re: Display Aggregated value in disaggrecation

Hi Prabu,

Maybe I misread your question but if you want to put the customers into purchase buckets depending on count of customers during a particular date range, then all you need to do is add the date filter to context. See example screenshot below. The first screenshot shows the summary and the second shows the details.

Hope this helps.

Ossai

• ###### 3. Re: Display Aggregated value in disaggrecation

Thank For the replay Bharat. This link calculation based on the datediff of month.

But in my case i have calculate based countd(Orderid). Please let me is there any other way to achieve this.

• ###### 4. Re: Display Aggregated value in disaggrecation

Hi Ossai,

In the above case, we have 1 to 7 Purchase Summary.

1. The client want to see 2 & 4 th purchase in Purchase bucket.

2. For 1 Purchase Bucket, The # of Customers Count would be 9 (Aggregation of below purchase bucket)

Thanks,

Prabu