Forum Discussion
Solved
Filter Unique
Hi All
sorry to ask what must be a simple question.
I have data that is collected by scaning in and out items from a stock. Each time it is scaned in, and then again out a new record is created. In the end i have lots of entireies with the same data but all collected at diffrent times.
I can filter by date and see the movments of items by day but it dose not give me what i need. I would like to count the amount of unquie items that are in my data set. Is there a way i can do this.
Also is it possibel to add a slicer that would filter to only unique values.
3 Replies
Here you go
4 0f6f2427-07a9-4f72-8922-38eecdbeb224 [email protected] 2018-07-01 13:54:51.000 PPE Kit Bag Check in / Out 27 01.07.2018._Check Out 0 NULL 2018-07-01 13:52:57.000 2018-07-01 13:54:51.000 NULL 2018-07-01 13:52:57.000 Check Out Assigned Gavin Fisher CPower Kit Bag 02 NULL Harness 40058 Frog 171918170885 Work Positioner 20810009 / 032 Fall Aresst 20814693 / 014 Life JKT R500304 NULL NULL NULL Immersion Suite 3841089055 2 5 cbaefadb-37bb-46b5-b891-da26043c8825 [email protected] 2018-07-01 14:00:46.000 PPE Kit Bag Check in / Out 27 01.07.2018._Check Out 0 NULL 2018-07-01 13:55:04.000 2018-07-01 14:00:46.000 NULL 2018-07-01 13:55:05.000 Check Out Assigned Jamie Walton CPower Kit Bag 14 NULL Harnress 38780 Frog 171918171447 Work Positioner 20745277 / 055 Fall Arrest 208146938 / 002 Life JKT R 501822 NULL NULL NULL Immersion Suite 3841082935 2 6 aa8d1c6c-93a6-478a-9e8c-e64e34af08d9 [email protected] 2018-07-01 14:09:23.000 PPE Kit Bag Check in / Out 27 01.07.2018._Check Out 0 NULL 2018-07-01 14:01:35.000 2018-07-01 14:09:23.000 NULL 2018-07-01 14:01:36.000 Check Out Assigned Craig Raffle CPower Kit Bag 10 NULL Harness 39971 Frog 171918171431 Work Positioner 20776496 / 037 Fall Arresst 20797196 / 029 Life JKT R493848 NULL NULL NULL Immersion Suite 3841082679 2 7 48f5726d-10c9-484e-8fec-79453029b516 [email protected] 2018-07-01 14:14:14.000 PPE Kit Bag Check in / Out 27 01.07.2018._Check Out 0 NULL 2018-07-01 14:09:49.000 2018-07-01 14:14:14.000 NULL 2018-07-01 14:09:53.000 Check Out Assigned Mark Instance CPower Kit Bag 1 NULL Harness 37331 Frog 171918171454 Work Positioner 20732946/098 Fall Arest 20750662/003 Life JKT R493849 NULL NULL NULL Immersion Suit 3841087857 2 8 4acc2081-11d8-4502-b86a-9380841b2bec [email protected] 2018-07-01 14:34:10.000 PPE Kit Bag Check in / Out 27 01.07.2018._Check Out 0 NULL 2018-07-01 14:30:13.000 2018-07-01 14:34:10.000 NULL 2018-07-01 14:30:13.000 Check Out Assigned Anthony Price Cpower Kit Bag 08 NULL Harness 38223 Frog 171918171085 Work Positioner 20727089 / 008 Fall Arrest 20750662 / 006 Life Jacket R500330 NULL NULL NULL Immersion Suite 3841089037 2 9 0f068299-e689-428b-97e6-24db79d1ca29 [email protected] 2018-07-01 14:35:53.000 PPE Kit Bag Check in / Out 27 01.07.2018._Check Out 0 NULL 2018-07-01 14:34:16.000 2018-07-01 14:35:53.000 NULL 2018-07-01 14:34:17.000 Check Out Assigned Craig Price Cpower Kit Bag 11 NULL Harness 37332 Frog 171918171462 Work Positioner 2072 7089 / 009 Fall Arrest 2075 0662 / 015 Life JKT R500302 NULL NULL NULL NULL 2 10 0e506f29-f8e2-4f99-89b3-c977f18edec4 [email protected] 2018-07-01 14:37:56.000 PPE Kit Bag Check in / Out 27 01.07.2018._Check Out 0 NULL 2018-07-01 14:36:05.000 2018-07-01 14:37:56.000 NULL 2018-07-01 14:36:05.000 Check Out Assigned Marc Asif CPower Kit Bag 04 NULL Harness 38225 Frog 171918171465 Work Positioner 20727089 / 015 Fall Arrest 20750662 / 008 Life JKT R493847 NULL NULL NULL Immersion Suite 3841082937 2 11 0f068299-e689-428b-97e6-24db79d1ca29 [email protected] 2018-07-01 14:45:06.000 PPE Kit Bag Check in / Out 27 01.07.2018._Check Out 1895328 NULL 2018-07-01 14:44:35.000 2018-07-01 14:45:06.000 NULL 2018-07-01 14:34:17.000 Check Out Assigned Craig Price Cpower Kit Bag 11 NULL Harness 37332 Frog 171918171462 Work Positioner 2072 7089 / 009 Fall Arrest 2075 0662 / 015 Life JKT R500302 NULL NULL NULL Immersion Suite 3841082680 2 12 2a977e69-b838-4829-bc26-ec11d4c7af88 [email protected] 2018-07-03 12:16:14.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 14_Check inJamie Walton 0 NULL 2018-07-03 12:13:49.000 2018-07-03 12:16:14.000 NULL 2018-07-03 12:13:49.000 Check in Assigned Jamie Walton CPower Kit Bag 14 NULL Harnress 38780 Frog 171918171447 Work Positioner 20745277 / 055 Fall Arrest 208146938 / 002 Life JKT R 501822 NULL NULL NULL Immersion Suite 3841082935 2 13 f1842123-5e04-4586-a8da-a326e3925f30 [email protected] 2018-07-03 12:18:22.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 1
_Check inMark Instance0 NULL 2018-07-03 12:16:39.000 2018-07-03 12:18:22.000 NULL 2018-07-03 12:16:39.000 Check in Assigned Mark Instance CPower Kit Bag 1 NULL Harness 37331 Frog 171918171454 Work Positioner 20732946/098 Fall Arest 20750662/003 Life JKT R493849 NULL NULL NULL Immersion Suit 3841087857 2 14 b890e44d-f91e-4707-a7f6-203d9210e4aa [email protected] 2018-07-03 12:24:46.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 04_Check inMarc Asif 0 NULL 2018-07-03 12:20:02.000 2018-07-03 12:24:46.000 NULL 2018-07-03 12:20:03.000 Check in Assigned Marc Asif CPower Kit Bag 04 NULL Harness 38225 Frog 171918171465 Work Positioner 20727089 / 015 Fall Arrest 20750662 / 008 Life JKT R493847 NULL NULL NULL Immersion Suite 3841082937 2 15 5eec4eaa-52e0-4934-aea5-832d9885ea57 [email protected] 2018-07-03 12:26:45.000 PPE Kit Bag Check in / Out 29 Cpower Kit Bag 11_Check inCraig Price 0 NULL 2018-07-03 12:24:59.000 2018-07-03 12:26:45.000 NULL 2018-07-03 12:25:00.000 Check in Assigned Craig Price Cpower Kit Bag 11 NULL Harness 37332 Frog 171918171462 Work Positioner 2072 7089 / 009 Fall Arrest 2075 0662 / 015 Life JKT R500302 NULL NULL NULL Immersion Suite 3841082680 2 16 a483f66d-bd4c-42f1-8ea2-da8384ef31e3 [email protected] 2018-07-03 12:29:16.000 PPE Kit Bag Check in / Out 29 Cpower Kit Bag 08_Check inAnthony Price 0 NULL 2018-07-03 12:26:57.000 2018-07-03 12:29:16.000 NULL 2018-07-03 12:26:57.000 Check in Assigned Anthony Price Cpower Kit Bag 08 NULL Harness 38223 Frog 171918171085 Work Positioner 20727089 / 008 Fall Arrest 20750662 / 006 Life Jacket R500330 NULL NULL NULL Immersion Suite 3841089037 2 17 4e7a3873-665d-4d1d-a9f3-2adac68b6381 [email protected] 2018-07-03 12:29:25.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 04_Check inMarc Asif 0 NULL 2018-07-03 12:18:30.000 2018-07-03 12:29:25.000 NULL 2018-07-03 12:18:30.000 Check in Assigned Marc Asif CPower Kit Bag 04 NULL Harness 38225 NULL NULL NULL NULL NULL NULL NULL NULL NULL 18 9ff928ba-026d-47e3-896a-107e0d04237b [email protected] 2018-07-03 12:34:15.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 10_Check inCraig Raffle 0 NULL 2018-07-03 12:32:38.000 2018-07-03 12:34:15.000 NULL 2018-07-03 12:32:39.000 Check in Assigned Craig Raffle CPower Kit Bag 10 NULL Harness 39971 Frog 171918171431 Work Positioner 20776496 / 037 Fall Arresst 20797196 / 029 Life JKT R493848 NULL NULL NULL Immersion Suite 3841082679 2 19 d1f125e5-7dea-4779-8062-a895f23db4e3 [email protected] 2018-07-03 12:37:39.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 02_Check inGavin Fisher 0 NULL 2018-07-03 12:35:39.000 2018-07-03 12:37:39.000 NULL 2018-07-03 12:35:39.000 Check in Assigned Gavin Fisher CPower Kit Bag 02 NULL Harness 40058 Frog 171918170885 Work Positioner 20810009 / 032 Fall Aresst 20814693 / 014 Life JKT R500304 NULL NULL NULL Immersion Suite 3841089055 2 20 7349bbbf-aec7-4946-8b66-b1b82ee25362 [email protected] 2018-07-04 11:36:44.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 10_Check OutRob Mackie 0 NULL 2018-07-04 11:33:12.000 2018-07-04 11:36:44.000 NULL 2018-07-04 11:33:12.000 Check Out Assigned Rob Mackie CPower Kit Bag 10 NULL Harness 39971 Frog 171918171431 Work Positioner 20776496 / 037 Fall Arresst 20797196 / 029 Life JKT R493848 NULL NULL NULL Immersion Suite 3841082679 2 21 6a4a3636-abaf-48e2-9101-a80466588db2 [email protected] 2018-07-04 12:42:32.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 19_Check OutWilliam Cook 0 NULL 2018-07-04 12:37:18.000 2018-07-04 12:42:32.000 NULL 2018-07-04 12:37:19.000 Check Out Assigned William Cook CPower Kit Bag 19 NULL Harness 39961 Frog 171918171467 Work POsitioner 20810009 / 037 Fall Arrest 20811932 / 024 Life Jacket R500330 NULL NULL NULL Immersion Suite 3841089143 2 22 bf997e5f-9508-4607-8bbe-e735756c2435 [email protected] 2018-07-04 12:47:00.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 03_Check OutScott Walton 0 NULL 2018-07-04 12:43:02.000 2018-07-04 12:47:00.000 NULL 2018-07-04 12:43:02.000 Check Out Assigned Scott Walton CPower Kit Bag 03 NULL Harness 39041 Frog 171918171291 Work Positioner 20727089 / 003 Fall Arresst 20750662 / 002 Life JKT R 501822 NULL NULL NULL Immersion Suite 3841082646 1 23 de71cacd-fee9-4c9c-83a5-d56cb359a30b [email protected] 2018-07-04 12:50:40.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 09_Check OutMartin Cosker 0 NULL 2018-07-04 12:49:02.000 2018-07-04 12:50:40.000 NULL 2018-07-04 12:49:03.000 Check Out Assigned Martin Cosker CPower Kit Bag 09 NULL Harrness 39952 Frog 171590170086 WOrk Positioner 20776496 / 025 Fall Arrest 20804105 / 026 Life JKT R493849 NULL NULL NULL Immersion Suit 3841089017 2 24 c95d6788-4219-4998-8aa8-9ac060aeb740 [email protected] 2018-07-04 12:58:47.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 24_Check OutKarl Glover 0 NULL 2018-07-04 12:55:04.000 2018-07-04 12:58:47.000 NULL 2018-07-04 12:55:04.000 Check Out Assigned Karl Glover CPower Kit Bag 24 NULL Harness 39968 Frog 171590170153 Work Positioner 207764964 / 030 Fall Aresst 20797196 / 032 Life JKT R500302 NULL NULL NULL Immersion Suite 3841088834 1 25 d2c771f7-0542-4b12-9293-264a96da63a7 [email protected] 2018-07-04 13:01:28.000 PPE Kit Bag Check in / Out 29 CPower Kit Bag 07_Check OutStu Macleod 0 NULL 2018-07-04 12:59:07.000 2018-07-04 13:01:28.000 NULL 2018-07-04 12:59:07.000 Check Out Assigned Stu Macleod CPower Kit Bag 07 NULL Harness 37333 Frog 171590170032 Work Positioner 20776496 / 023 Fall Arrest 20797196 / 003 Life JKT R493847 NULL NULL NULL Immersion Suit 3841088783 2 Hi Colinu,
Above data model is not readable to us as we are not familiar with your scenario. Please post some dummy data with each column name, but just contains necessary columns. And show us your desired output to help us better understand your requirement.
Regards,
Yuliana Gu
