Apply the result of a measure as a date filter (between dates)

[Kaos]

Greetings all,

I've been wrestling with this for a while now so I'm hoping you can help, or at least state catogorically that it is impossible (currently).

I am using two measures to find the maximum and minimum dates within a table. I can then display these min/max dates on a card visualization within a page. I am then using a table visualization to display the same data from the table on that page. When I select a line, or multiple lines, on the table visualization the MIN/MAX dates update on the card visualization correctly.

What I then want to do is use these dates to filter another table on the same page to limit the visible records to those that fall within the MIN/MAX date range. There seems to be no way to force these dates into a date slicer, or a way to filter the 2nd table using the measures against the dates within the table. However I am certainatly no expert and may be missing an obvious/easy method to achieve my aims.

I would like to allow my users to be able select multiple rows as above as they see fit, then those from/to dates would be applied to my second table automatically.

Any advice greatly appreciated.

K

[Greg_Deckler]

There may actually be a way to do this, but it is going to depend on your data model. Can you share some sample/example data in a form that can be copied and pasted so we can create an example model?

[Kaos]

Spoiler

Ref	Date Raised		Job Type	Equip#	Status
611541	01/06/2018 17:02	Planned		019	Open
611540	01/06/2018 17:02	Planned		012	Open
611527	01/06/2018 17:02	Planned		011	Open
611492	01/06/2018 17:02	Planned		020	Open
611479	01/06/2018 17:02	Planned		010	Open
611478	01/06/2018 17:02	Planned		010	Open
611451	01/06/2018 16:55	Reactive2	012	Closed
611441	01/06/2018 15:23	Reactive1	012	Closed
611439	01/06/2018 15:04	Reactive1	009	Open
611438	01/06/2018 15:04	Reactive1	016	Open
611430	01/06/2018 12:38	Reactive1	015	Open
611428	01/06/2018 12:00	Planned		015	Open
611425	01/06/2018 10:53	Planned		008	Open
611422	01/06/2018 08:20	Reactive1	016	Closed
611419	01/06/2018 03:25	Reactive2	001	Closed
611418	01/06/2018 02:24	Reactive2	012	Closed
611399	31/05/2018 16:45	Planned		013	Open
611398	31/05/2018 16:45	Planned		008	Open
611304	31/05/2018 14:46	Planned		017	Open
611303	31/05/2018 14:46	Planned		017	Open
611302	31/05/2018 14:46	Planned		016	Open
611301	31/05/2018 14:46	Planned		015	Open
611300	31/05/2018 14:46	Planned		015	Open
611295	31/05/2018 14:46	Planned		013	Open
611294	31/05/2018 14:46	Planned		008	Open
611293	31/05/2018 14:46	Planned		007	Open
611264	31/05/2018 14:46	Planned		001	Open
611263	31/05/2018 14:46	Planned		001	Open
611253	31/05/2018 11:20	Reactive2	007	Closed
611239	31/05/2018 08:11	Reactive2	009	Closed
611238	31/05/2018 08:10	Reactive2	012	Closed
611236	31/05/2018 03:20	Reactive2	007	Closed
611163	30/05/2018 15:07	Planned		009	Open
611162	30/05/2018 15:07	Planned		014	Open
611095	30/05/2018 15:06	Planned		019	Closed
611094	30/05/2018 15:06	Planned		019	Open
611093	30/05/2018 15:06	Planned		012	Closed
611083	30/05/2018 15:06	Planned		020	Closed
611075	30/05/2018 15:06	Planned		010	Closed
611042	30/05/2018 10:23	Reactive2	020	Closed
611027	29/05/2018 15:18	Reactive1	008	Open
610873	29/05/2018 10:46	Reactive1	001	Open
610868	29/05/2018 10:33	Planned		011	Closed
610744	29/05/2018 06:36	Reactive1	014	Open
610706	27/05/2018 15:37	Reactive2	007	Closed
610694	26/05/2018 22:08	Reactive2	015	Closed
610689	26/05/2018 20:53	Reactive2	012	Closed
610688	26/05/2018 19:54	Reactive1	015	Open
610687	26/05/2018 19:50	Reactive2	012	Closed
610686	26/05/2018 19:30	Reactive2	007	Closed
610681	26/05/2018 14:44	Reactive2	014	Closed
610637	26/05/2018 14:42	Reactive2	013	Closed
610636	26/05/2018 14:38	Reactive2	008	Closed
610630	26/05/2018 12:56	Reactive2	007	Closed
610629	26/05/2018 11:58	Reactive2	015	Closed
610627	26/05/2018 08:11	Reactive2	015	Closed
610622	25/05/2018 23:15	Reactive2	009	Closed
610619	25/05/2018 20:16	Reactive2	012	Closed
610616	25/05/2018 19:17	Reactive1	012	Closed
610605	25/05/2018 14:22	Reactive1	001	Closed
610588	25/05/2018 08:27	Reactive2	015	Closed
610585	25/05/2018 06:15	Reactive1	013	Open
610584	25/05/2018 06:15	Reactive1	013	Open
610583	25/05/2018 06:13	Reactive1	008	Open
610582	25/05/2018 06:12	Planned		007	Open
610581	25/05/2018 06:12	Reactive1	007	Open
610561	24/05/2018 12:17	Reactive1	015	Open
610529	24/05/2018 03:45	Reactive2	015	Closed
610516	23/05/2018 17:01	Reactive2	019	Closed
610513	23/05/2018 15:02	Planned		010	Open
610507	23/05/2018 11:46	Reactive1	012	Closed
610405	23/05/2018 10:21	Planned		001	Open
610404	23/05/2018 10:21	Planned		001	Open
610322	21/05/2018 14:36	Planned		013	Open
610321	21/05/2018 14:36	Planned		008	Open
610320	21/05/2018 14:36	Planned		008	Open
610319	21/05/2018 14:36	Planned		007	Open
610318	21/05/2018 14:36	Planned		007	Open
610209	20/05/2018 04:04	Reactive2	015	Closed
610082	18/05/2018 16:23	Planned		009	Closed
610081	18/05/2018 16:23	Planned		014	Closed
609983	18/05/2018 16:23	Planned		019	Closed
609982	18/05/2018 16:23	Planned		012	Closed
609981	18/05/2018 16:23	Planned		012	Closed
609970	18/05/2018 16:23	Planned		011	Open
609969	18/05/2018 16:23	Planned		011	Closed
609938	18/05/2018 16:23	Planned		020	Closed
609937	18/05/2018 16:23	Planned		020	Closed
609930	18/05/2018 16:23	Planned		010	Closed
609828	17/05/2018 21:50	Reactive2	001	Closed
609705	17/05/2018 07:31	Planned		013	Closed
609704	17/05/2018 07:31	Planned		013	Closed
609702	17/05/2018 07:31	Planned		008	Closed
609701	17/05/2018 07:31	Planned		008	Closed
609700	17/05/2018 07:31	Planned		007	Closed
609699	17/05/2018 07:31	Planned		007	Closed
609672	17/05/2018 07:31	Planned		001	Open
609671	17/05/2018 07:31	Planned		001	Open
609661	16/05/2018 23:20	Reactive2	001	Closed
609522	15/05/2018 06:27	Reactive2	020	Closed
609504	14/05/2018 16:50	Reactive2	016	Closed
609386	13/05/2018 04:18	Reactive1	015	Closed
609385	13/05/2018 04:17	Reactive1	016	Closed
609382	12/05/2018 21:23	Reactive2	016	Closed
609380	12/05/2018 19:04	Reactive2	015	Closed
609366	12/05/2018 02:23	Reactive2	007	Closed
609235	11/05/2018 17:02	Planned		009	Closed
609234	11/05/2018 17:02	Planned		014	Closed
609050	11/05/2018 17:02	Planned		019	Closed
609041	11/05/2018 17:02	Planned		011	Closed
609040	11/05/2018 17:02	Planned		011	Open
608989	11/05/2018 17:02	Planned		020	Closed
608983	11/05/2018 17:02	Planned		010	Closed
608961	11/05/2018 17:02	Planned		013	Closed
608960	11/05/2018 17:02	Planned		012	Closed
608959	11/05/2018 17:02	Planned		008	Closed
608958	11/05/2018 17:02	Planned		007	Closed
608938	11/05/2018 17:02	Planned		001	Closed
608937	11/05/2018 17:02	Planned		001	Closed
608916	11/05/2018 13:25	Planned		020	Open
608903	11/05/2018 08:40	Reactive1	019	Closed
608897	11/05/2018 08:22	Planned		015	Closed
608878	10/05/2018 22:59	Reactive2	019	Closed
608857	10/05/2018 13:13	Reactive2	016	Closed
608759	09/05/2018 14:39	Reactive1	013	Closed
608757	09/05/2018 14:38	Reactive1	008	Closed
608736	09/05/2018 11:58	Reactive2	013	Closed
608735	09/05/2018 11:57	Reactive2	008	Closed
608724	09/05/2018 08:54	Reactive1	011	Closed
608723	27/04/2018 08:52	Reactive2	011	Open
608600	08/05/2018 12:08	Planned		014	Closed
608497	08/05/2018 12:07	Planned		011	Closed
608486	08/05/2018 12:07	Planned		017	Closed
608485	08/05/2018 12:07	Planned		016	Closed
608484	08/05/2018 12:07	Planned		015	Closed
608451	08/05/2018 12:07	Planned		010	Closed
608432	08/05/2018 12:07	Planned		013	Closed
608431	08/05/2018 12:07	Planned		008	Open
608430	08/05/2018 12:07	Planned		007	Closed
608349	08/05/2018 03:31	Reactive2	001	Closed
608345	07/05/2018 22:20	Reactive2	016	Closed
608261	06/05/2018 22:50	Reactive2	012	Closed
608258	06/05/2018 11:49	Reactive2	016	Closed
608254	06/05/2018 03:19	Reactive2	012	Closed
608253	06/05/2018 03:01	Reactive1	001	Open
608251	05/05/2018 21:06	Reactive2	016	Closed
608248	05/05/2018 18:45	Reactive1	001	Open
608242	05/05/2018 12:41	Reactive2	012	Closed
608241	05/05/2018 12:01	Reactive2	016	Closed
608238	05/05/2018 02:44	Reactive2	016	Closed
608236	04/05/2018 20:10	Reactive2	012	Closed
608232	04/05/2018 14:15	Planned		016	Closed
608222	04/05/2018 10:05	Reactive1	013	Open
608217	04/05/2018 09:20	Planned		013	Closed
608207	03/05/2018 19:58	Reactive2	020	Closed
608203	03/05/2018 15:58	Reactive1	014	Closed
608202	03/05/2018 15:57	Reactive1	009	Open
608201	03/05/2018 15:56	Reactive1	014	Open
608200	03/05/2018 15:54	Reactive1	014	Open
608196	03/05/2018 12:54	Reactive1	001	Open
608112	03/05/2018 12:42	Planned		013	Closed
608111	03/05/2018 12:42	Planned		012	Closed
608110	03/05/2018 12:42	Planned		012	Closed
608109	03/05/2018 12:42	Planned		008	Closed
608108	03/05/2018 12:42	Planned		007	Closed
608084	03/05/2018 12:42	Planned		001	Closed
608083	03/05/2018 12:42	Planned		001	Closed
608064	02/05/2018 16:00	Reactive2	012	Closed
608063	02/05/2018 15:31	Reactive1	007	Open
608044	02/05/2018 14:13	Reactive1	009	Closed
608007	02/05/2018 09:03	Reactive2	012	Closed
608006	02/05/2018 08:59	Reactive2	007	Closed
607998	02/05/2018 06:47	Reactive1	013	Closed
607980	01/05/2018 15:37	Reactive1	010	Closed
607975	01/05/2018 14:49	Reactive1	009	Closed
607972	01/05/2018 14:01	Reactive1	019	Closed
607967	26/04/2018 12:26	Reactive2	012	Closed
607914	30/04/2018 18:07	Reactive2	016	Closed
607815	30/04/2018 14:50	Planned		013	Closed
607810	30/04/2018 10:35	Reactive1	013	Open
607809	30/04/2018 09:55	Reactive1	015	Closed
607808	30/04/2018 09:50	Reactive1	008	Closed
607807	30/04/2018 09:48	Reactive2	008	Closed
607721	30/04/2018 08:11	Reactive1	008	Closed
607712	29/04/2018 21:56	Reactive2	015	Closed
607710	29/04/2018 20:27	Planned		013	Closed
607707	29/04/2018 17:02	Reactive2	001	Closed
607704	29/04/2018 12:33	Reactive1	007	Open
607702	29/04/2018 08:37	Reactive2	001	Closed
607692	28/04/2018 15:53	Reactive1	007	Closed
607683	28/04/2018 10:06	Reactive2	015	Closed
607677	28/04/2018 03:47	Reactive2	016	Closed
607654	27/04/2018 17:26	Planned		009	Open
607653	27/04/2018 17:26	Planned		014	Open
607519	27/04/2018 17:26	Planned		011	Closed
607449	27/04/2018 16:00	Reactive1	015	Closed
607439	27/04/2018 13:20	Planned		014	Open
607427	27/04/2018 09:46	Reactive1	020	Closed
607400	27/04/2018 06:04	Planned		012	Closed
607384	26/04/2018 14:33	Reactive1	019	Closed
607337	26/04/2018 14:07	Reactive2	009	Closed
607310	26/04/2018 12:27	Planned		013	Closed
607309	26/04/2018 12:27	Planned		012	Closed
607308	26/04/2018 12:27	Planned		008	Closed
607307	26/04/2018 12:27	Planned		007	Closed
607281	26/04/2018 11:19	Planned		001	Closed
607280	26/04/2018 11:19	Planned		001	Closed
607270	26/04/2018 09:15	Reactive1	007	Open
607264	25/04/2018 18:39	Reactive2	012	Closed
607256	25/04/2018 13:26	Planned		017	Closed
607255	25/04/2018 13:26	Planned		015	Closed
607244	25/04/2018 09:40	Reactive2	012	Closed
607241	25/04/2018 09:06	Reactive1	013	Closed
607240	25/04/2018 09:05	Reactive1	012	Closed
607178	25/04/2018 08:40	Reactive1	001	Closed
607154	25/04/2018 06:48	Reactive2	001	Closed
607152	25/04/2018 06:00	Reactive2	016	Closed
607151	25/04/2018 02:57	Reactive2	014	Closed
607150	25/04/2018 02:29	Reactive2	014	Closed
607149	25/04/2018 00:45	Reactive2	014	Closed
607148	24/04/2018 23:11	Reactive2	008	Closed
607147	24/04/2018 19:23	Reactive2	001	Closed
607146	24/04/2018 18:01	Reactive2	014	Closed
607120	23/04/2018 20:07	Reactive2	012	Closed
607119	23/04/2018 19:08	Reactive2	016	Closed
607075	23/04/2018 10:08	Reactive1	008	Closed
607018	23/04/2018 08:14	Reactive2	012	Closed
607017	23/04/2018 08:11	Reactive2	008	Closed
606906	21/04/2018 00:37	Reactive1	008	Closed
606902	20/04/2018 17:33	Reactive2	014	Closed
606877	20/04/2018 17:01	Planned		019	Closed
606870	20/04/2018 17:01	Planned		020	Closed
606863	20/04/2018 17:01	Planned		010	Open
606853	20/04/2018 16:36	Planned		019	Closed
606770	20/04/2018 15:55	Planned		011	Closed
606754	20/04/2018 15:55	Planned		016	Closed
606546	20/04/2018 14:23	Planned		008	Closed
606545	20/04/2018 14:23	Reactive1	008	Closed
606544	20/04/2018 13:09	Reactive1	009	Closed
606542	20/04/2018 12:46	Reactive1	008	Open
606527	20/04/2018 11:16	Reactive2	012	Closed
606524	20/04/2018 08:57	Reactive2	013	Closed
606521	20/04/2018 03:21	Reactive1	012	Closed
606520	20/04/2018 00:17	Reactive2	012	Closed
606518	19/04/2018 20:08	Reactive1	012	Closed
606517	19/04/2018 19:46	Reactive1	013	Open
606511	19/04/2018 17:00	Reactive2	012	Closed
606510	19/04/2018 15:45	Reactive2	009	Closed
606505	19/04/2018 13:22	Reactive2	009	Closed
606490	19/04/2018 09:16	Reactive2	001	Closed
606488	19/04/2018 08:57	Reactive2	001	Closed
606410	19/04/2018 08:07	Planned		013	Closed
606409	19/04/2018 08:07	Planned		012	Closed
606408	19/04/2018 08:07	Planned		008	Closed
606407	19/04/2018 08:07	Planned		007	Closed
606382	19/04/2018 08:07	Planned		001	Closed
606381	19/04/2018 08:07	Planned		001	Closed
606370	18/04/2018 16:35	Reactive2	001	Closed
606364	18/04/2018 14:48	Reactive2	020	Closed
606338	18/04/2018 13:11	Reactive1	008	Open
606337	18/04/2018 12:39	Reactive2	013	Closed
606332	18/04/2018 11:57	Planned		017	Closed
606316	18/04/2018 06:59	Reactive2	007	Closed
606313	18/04/2018 02:12	Reactive2	019	Closed
606305	17/04/2018 18:24	Reactive2	019	Closed
606218	16/04/2018 19:18	Reactive2	012	Closed
606209	16/04/2018 13:44	Reactive1	012	Closed
606177	16/04/2018 11:00	Reactive2	013	Closed
606109	16/04/2018 08:12	Reactive2	007	Closed
606108	16/04/2018 08:12	Reactive2	013	Closed
606029	16/04/2018 08:10	Planned		011	Closed
606028	16/04/2018 08:10	Planned		011	Closed
606015	16/04/2018 08:10	Planned		015	Closed
605971	16/04/2018 07:22	Reactive2	012	Closed
605968	16/04/2018 03:04	Reactive2	012	Closed
605893	15/04/2018 16:56	Reactive2	019	Closed
605878	14/04/2018 22:47	Reactive1	016	Open
605875	14/04/2018 19:13	Reactive2	008	Closed
605864	13/04/2018 20:41	Reactive2	012	Closed
605862	13/04/2018 17:26	Reactive2	016	Closed
605854	13/04/2018 14:45	Planned		001	Closed
605847	13/04/2018 13:08	Reactive2	010	Closed
605843	13/04/2018 12:25	Planned		009	Closed
605840	13/04/2018 12:17	Reactive1	012	Closed
605838	13/04/2018 12:02	Reactive1	013	Closed
605837	13/04/2018 12:02	Reactive1	012	Closed
605836	13/04/2018 12:00	Reactive1	012	Closed
605835	13/04/2018 11:57	Planned		007	Closed
605834	13/04/2018 11:57	Reactive1	007	Closed
605833	13/04/2018 11:48	Reactive1	014	Closed
605815	13/04/2018 08:50	Planned		015	Closed
605783	12/04/2018 17:07	Planned		009	Open
605782	12/04/2018 17:07	Planned		014	Open
605734	12/04/2018 14:50	Reactive1	013	Closed
605639	12/04/2018 08:46	Reactive2	016	Closed
605638	12/04/2018 08:45	Reactive2	015	Closed
605543	12/04/2018 06:59	Reactive2	016	Closed
605542	12/04/2018 03:01	Reactive2	010	Closed
605539	11/04/2018 21:02	Reactive2	001	Closed
605497	11/04/2018 07:26	Reactive2	008	Closed
605473	10/04/2018 14:49	Planned		013	Closed
605472	10/04/2018 14:49	Planned		013	Closed
605471	10/04/2018 14:49	Planned		013	Closed
605470	10/04/2018 14:49	Planned		012	Closed
605469	10/04/2018 14:49	Planned		008	Closed
605468	10/04/2018 14:49	Planned		008	Closed
605467	10/04/2018 14:49	Planned		007	Closed
605441	10/04/2018 09:55	Planned		001	Closed
605440	10/04/2018 09:55	Planned		001	Closed
605428	10/04/2018 07:48	Reactive1	012	Closed
605427	09/04/2018 18:56	Reactive2	010	Closed
605425	09/04/2018 18:50	Reactive2	013	Closed
605325	08/04/2018 21:18	Reactive1	013	Closed
605264	08/04/2018 01:20	Reactive2	001	Closed
605258	07/04/2018 10:39	Reactive2	016	Closed
605200	07/04/2018 07:17	Reactive1	019	Closed
605198	07/04/2018 03:20	Reactive2	016	Closed
605117	06/04/2018 21:03	Planned		013	Closed
605116	06/04/2018 21:03	Planned		012	Closed
605115	06/04/2018 21:03	Planned		012	Closed
605114	06/04/2018 21:03	Planned		008	Closed
605113	06/04/2018 21:03	Planned		007	Closed
605084	06/04/2018 21:03	Planned		001	Closed
605083	06/04/2018 21:03	Planned		001	Closed
605082	06/04/2018 21:03	Planned		001	Closed
605070	06/04/2018 19:08	Reactive2	013	Closed
605069	06/04/2018 19:00	Reactive2	008	Closed
605068	06/04/2018 18:58	Reactive2	007	Closed
605044	06/04/2018 17:04	Planned		014	Closed
604992	06/04/2018 12:39	Reactive2	012	Closed
604990	06/04/2018 12:16	Reactive2	013	Closed
604982	06/04/2018 11:01	Reactive1	020	Closed
604971	06/04/2018 08:28	Reactive2	016	Closed
604964	06/04/2018 04:17	Reactive2	019	Closed
604962	06/04/2018 02:20	Reactive2	016	Closed
604950	30/03/2018 22:05	Reactive2	001	Closed
604942	29/03/2018 21:35	Reactive2	012	Closed
604843	05/04/2018 17:25	Planned		011	Closed
604786	05/04/2018 13:33	Reactive1	017	Closed
604783	05/04/2018 11:11	Reactive1	012	Closed
604782	05/04/2018 11:10	Reactive1	012	Closed
604716	04/04/2018 18:07	Reactive2	017	Closed
604715	04/04/2018 18:06	Reactive2	016	Closed
604714	04/04/2018 16:39	Reactive1	012	Closed
604711	04/04/2018 16:04	Reactive1	012	Closed
604707	04/04/2018 15:58	Reactive1	013	Closed
604706	04/04/2018 15:58	Reactive1	013	Closed
604705	04/04/2018 15:58	Reactive1	008	Closed
604704	04/04/2018 15:57	Reactive1	008	Closed
604703	04/04/2018 15:56	Reactive1	007	Closed
604693	04/04/2018 11:57	Reactive1	013	Open
604662	04/04/2018 10:57	Reactive1	017	Closed
604661	04/04/2018 10:56	Reactive1	016	Closed
604659	04/04/2018 10:54	Reactive1	015	Closed
604658	04/04/2018 10:29	Reactive1	017	Closed
604652	04/04/2018 09:52	Reactive1	019	Closed
604621	03/04/2018 23:38	Reactive2	014	Closed
604611	03/04/2018 15:06	Reactive1	017	Closed
604609	03/04/2018 15:00	Reactive1	017	Closed
604600	03/04/2018 13:20	Reactive2	014	Closed
604369	03/04/2018 07:20	Planned		011	Closed
604344	02/04/2018 10:21	Planned		017	Closed
604343	02/04/2018 10:21	Planned		017	Closed
604342	02/04/2018 10:21	Planned		017	Closed
604341	02/04/2018 10:21	Planned		016	Closed
604340	02/04/2018 10:21	Planned		015	Closed
604339	02/04/2018 10:21	Planned		015	Closed
604331	02/04/2018 10:13	Reactive1	010	Closed
604181	01/04/2018 20:18	Reactive2	019	Closed
604180	01/04/2018 19:27	Reactive2	013	Closed
604172	01/04/2018 13:43	Reactive2	013	Closed
604154	31/03/2018 17:27	Reactive2	001	Closed
604141	29/03/2018 16:56	Planned		009	Closed
604104	29/03/2018 16:56	Planned		010	Closed
604091	29/03/2018 15:58	Reactive1	014	Closed
604008	29/03/2018 15:37	Planned		013	Closed
604007	29/03/2018 15:37	Planned		012	Closed
604006	29/03/2018 15:37	Planned		008	Closed
604005	29/03/2018 15:37	Planned		007	Closed
603985	29/03/2018 15:37	Planned		001	Closed
603984	29/03/2018 15:37	Planned		001	Closed
603930	28/03/2018 06:10	Reactive2	001	Closed
603836	27/03/2018 13:14	Reactive2	013	Closed
603834	27/03/2018 12:35	Reactive1	013	Closed
603824	27/03/2018 10:48	Reactive1	016	Open
603823	27/03/2018 10:45	Reactive2	016	Closed
603820	27/03/2018 09:27	Reactive1	016	Closed
603809	26/03/2018 18:50	Reactive1	017	Closed
603787	26/03/2018 12:07	Reactive1	007	Open
603407	25/03/2018 17:33	Planned		013	Closed
603406	25/03/2018 17:33	Planned		012	Closed
603405	25/03/2018 17:33	Planned		008	Closed
603404	25/03/2018 17:33	Planned		007	Closed
603403	25/03/2018 17:33	Planned		007	Closed
603402	25/03/2018 17:33	Planned		007	Closed
603370	25/03/2018 17:33	Planned		001	Closed
603369	25/03/2018 17:33	Planned		001	Closed
603348	24/03/2018 02:17	Reactive2	001	Closed
603154	23/03/2018 17:06	Planned		011	Closed
603104	23/03/2018 16:11	Reactive1	001	Closed
603103	23/03/2018 16:07	Reactive2	001	Closed
603004	23/03/2018 13:50	Planned		013	Closed
603000	23/03/2018 10:39	Reactive2	017	Closed
602987	23/03/2018 04:32	Reactive2	017	Closed
602982	22/03/2018 19:19	Reactive2	017	Closed
602968	22/03/2018 12:31	Reactive2	007	Closed
602953	21/03/2018 22:32	Reactive1	009	Open
602951	21/03/2018 19:39	Reactive2	009	Closed
602943	21/03/2018 15:23	Reactive2	019	Closed
602938	21/03/2018 14:24	Reactive1	017	Closed
602937	21/03/2018 14:22	Reactive1	015	Closed
602904	20/03/2018 20:11	Reactive2	019	Closed
602767	20/03/2018 09:52	Reactive1	001	Closed
602765	20/03/2018 08:39	Reactive2	019	Closed
602757	19/03/2018 11:42	Reactive2	020	Closed
602753	19/03/2018 11:30	Reactive2	019	Closed
602644	19/03/2018 10:09	Reactive1	017	Closed
602640	19/03/2018 10:01	Reactive1	015	Closed
602457	18/03/2018 23:56	Reactive2	019	Closed
602399	18/03/2018 21:25	Planned		013	Closed
602398	18/03/2018 21:25	Planned		013	Closed
602397	18/03/2018 21:25	Planned		012	Closed
602396	18/03/2018 21:25	Planned		008	Closed
602395	18/03/2018 21:25	Planned		008	Closed
602394	18/03/2018 21:25	Planned		007	Closed
602372	18/03/2018 20:25	Planned		001	Closed
602371	18/03/2018 20:25	Planned		001	Closed
602358	18/03/2018 11:08	Reactive2	014	Closed
602357	18/03/2018 09:16	Reactive2	019	Closed
602351	17/03/2018 14:49	Reactive2	009	Closed
602348	17/03/2018 02:12	Reactive2	010	Closed
602332	16/03/2018 15:37	Reactive1	007	Open
602325	16/03/2018 11:31	Planned		020	Closed
602229	15/03/2018 11:55	Planned		001	Closed

Please see the above within the spoiler. I hope it copy/pastes OK.

[Kaos]

Just to explain a little further. I have 3 types of Job; Planned, Reactive1 and Reactive2. These are carried out agaist the various equipment numbers and are (status) Closed when complete.

I have a table visualization that is already filtered to show only Closed, Planned jobs for a single Equip# picked from a "ChicletSlicer".

What I want the user to then be able to do is select (as per my original post) two of the Planned jobs and see the Reactive1 and Reactive2 jobs that were completed between the associated (measured MIN/MAX) dates in the second table visualization.

Thanks for the reply Greg. Any guidance would be greatly appreciated.