Forum Discussion
Double Slicer for Multiple Date Fields
Hi All,
I have a page which requres me to change two date fields to the same date value.
These date fields are in different purposes and impact different visuals on the page.
Is there a single slicer that allows multiple date fields to be impacted based on the date set in the slicer?
2 Replies
Thanks for your help!
There are two tables
One table has typical Defect data
One table has typical Execution data
Defect Data Table Sample
Defect ID Application Provder Project Release Priority Status System Summary Detected On 726 App 1 Comp 1 Changes Output February 3-High Closed Output Bad Output 1/31/2019 888 App 2 Comp 2 Input Changes May - 19 5-Urgent Closed Input Bad Input 3/12/19 Exectution Data Table Sample
Application Test ID Exec Date Test: Execution Status Name Project Release Status Subject App1 856531 1/23/2019 Passed Test 1 Project 1 Jan Passed Subject 1 App2 855625 1/10/2019 Passed Test 2 Project 2 18L-December+ Passed Subject 2 App3 854618 1/18/2019 Passed Test 3 Project 3 19B-February Passed Subject 3 One stacked column chart displays the number of defects written monthly
- Axis - Detected On Date (Date defect was found)
- Value - Count of Detected on Date (Count of Defects)
Second stacked column chart displays the number of test cases executed monthly
- Axis - Executed Date (Date cases were executed)
- Value - Test Case Count (Count of executed test cases)
I am trying to use one slicer to control both charts.
As the relationship I had setup do not work between these tables as there is no real common thread
If I have 2 slicers one set for Detected on and the other set to use Exec date it works fine but looks really dumb obviously
Thanks for your help....
