Forum Discussion

Frequent Visitor

7 years ago

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 s...

Icon for Super User rank

Super User

7 years ago

Hi PowerQA1,

This can be done with a calendar table and with measures.

Can you share a sample data so I can give you the measures that align with your needs.

Regards,
MFelix

Frequent Visitor

7 years ago

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....