Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi Vikas,
thanks for the reply i want to get the shipped items created in the same year
thanks,
hima.
Hello
Please use Following Expression
Count({<Quarter={$(=max(Quarter))}>}item_shipped)
Regards
Vikas
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)
please try to explain using a consistent example including sample data, expected result and method of calculating those results.
thanks
regards
Marco