Aggr Function

[himabinduch]

Hi All,

i have 3 fields as Item, Item_creation date and item_shipped date one item can have multiple Shipped date but only one creation date.

now i want the data as based on the quarter i need count of created items and shipped items the data is as below

Item	Item_creation	item_shipped
CD89	1/8/2016 15:46	11/22/2016 20:16
CD89	1/8/2016 15:46	12/6/2016 20:17
CD89	1/8/2016 15:46	12/13/2016 20:17
CD89	1/8/2016 15:46	12/20/2016 20:16
CD89	1/8/2016 15:46	3/21/2017 21:15
CD89	1/8/2016 15:46	3/21/2017 21:15
CD89	1/8/2016 15:46	6/20/2017 21:16
CD90	3/8/2017 10:54	7/11/2017 23:46
CD91	1/8/2016 15:46	8/3/2016 21:16
CD91	1/8/2016 15:46	8/23/2016 21:16
CD91	1/8/2016 15:46	9/7/2016 21:15
CD91	1/8/2016 15:46	9/12/2016 21:16
CD91	1/8/2016 15:46	9/21/2016 21:16
CD91	1/8/2016 15:46	10/12/2016 21:16
CD91	1/8/2016 15:46	11/1/2016 0:01
CD91	1/8/2016 15:46	11/1/2016 0:01
CD91	1/8/2016 15:46	11/29/2016 20:17
CD91	1/8/2016 15:46	12/5/2016 2:47
CD91	1/8/2016 15:46	12/18/2016 20:17
CD91	1/8/2016 15:46	12/20/2016 20:16
CD91	1/8/2016 15:46	12/28/2016 20:17
CD91	1/8/2016 15:46	3/1/2017 20:15
CD91	1/8/2016 15:46	4/7/2017 1:04
CD91	1/8/2016 15:46	7/5/2017 21:16
CD91	1/8/2016 15:46	7/14/2017 3:27

[himabinduch]

Hi Vikas,

thanks for the reply i want to get the shipped items created in the same year

thanks,

hima.

[vikasdesai]

Hello

Please use Following Expression

Count({<Quarter={$(=max(Quarter))}>}item_shipped)

Regards

Vikas

[Anonymous]

HELLO himabinduch ,

FROM THIS U WILL GET BY QUARTER

Count({<Quarter={$(=max(Quarter))}>}[FieldName])

FROM THIS U WILL GET COUNT OF SHIPPED PRODUCT

Count(DISTINCT{$<Event = {'Creation'}>}Item)

Count({$<Event = {'Shipped'}>}Item)

REGARDS

ROHIT LOHANI

[MarcoWedel]

please try to explain using a consistent example including sample data, expected result and method of calculating those results.

thanks

regards

Marco