How to perform aggregate on Half year data when I have three year data FInd Attached process for ref

sgnarkhede2016

Hello,
I have done all the aggregation month/quarter/yearly but in half-year am getting an issue because it's taking all customer record in all year in first half(1) and the same as the second half(2) during aggregation.

It should be like this
Year
2016 1
2

2017 1
2

Currently, I getting 2016 & 2017 sums in 1 as well as 2 half

Please find attached process

<参数键= " repository_entry " value = " . . /数据/dummy Data"/>

<操作符= " true " class = " date_to_numerica激活l" compatibility="9.0.001" expanded="true" height="82" name="Date to Numerical" width="90" x="45" y="34">

Extract Year

<操作符= " true " class = " date_to_numerica激活l" compatibility="9.0.001" expanded="true" height="82" name="Date to Numerical (2)" width="90" x="179" y="34">

Exract Quarter of Year

<操作符= " true " class = " date_to_numerica激活l" compatibility="9.0.001" expanded="true" height="82" name="Date to Numerical (3)" width="90" x="313" y="34">

Extract Month of Year

<操作符= " true " class = " date_to_numerica激活l" compatibility="9.0.001" expanded="true" height="82" name="Date to Numerical (4)" width="90" x="447" y="34">

Extract Week of Month

<操作符= " true " class = " date_to_numerica激活l" compatibility="9.0.001" expanded="true" height="82" name="Date to Numerical (6)" width="90" x="581" y="34">

Extract Half of Year

<操作符= " true " class = " date_to_numerica激活l" compatibility="9.0.001" expanded="true" height="82" name="Date to Numerical (15)" width="90" x="715" y="34">

Extract Day of Month

Data Preparation

<参数键= " repository_entry " value = " . . /数据/Config_ProfileOnBins"/>

<列出关键= " date_series_configuration " / >

<参数键= value =“old_name计数(客户)“/>

Type your comment

hbajpai

sgnarkhede2016Can you check theother threadof your question, I have tried to aggregate at both levels in the shared XML code.