Filtering issue

[adityavighne]

Hi,

I have a filtering issue while representing data. when I select a calendar table it is filtering correctly but when i select another table paid media it is not filtering.

kindly provide a solution.

Working with calendar filter

Not working with both filters paid media

relationship details

[vanessafvg]

@adityavighne  are you able to share your model?   or share some data in text form of the 3 tables?

[adityavighne]

@vanessafvg  please find the dummy data 

Paid Media

UsageDate	MediaSource	CampaignID
12/31/2018	AdRoll	46R2YMNKPNHU7ORNI7MGFU
12/31/2018	AdRoll	5YRZ3WJ2LBEPFGO2X68C4G
12/31/2018	AdRoll	6GYEYJSZTBGGZFADMB8PRO
12/31/2018	LinkedIn	D7VVPUVIQ5EHXLIRJOVI5I
12/31/2018	AdRoll	FU3ZFZVPERFJRL2E2N8PRO
12/31/2018	LinkedIn	KX6RKRGJIRG4NHDFCE8C4G
12/31/2018	AdRoll	MTR2BEXWAVH6LOLWKQ8PRO
12/31/2018	Google Adwords	RQSRTLO3ZVHKDMIKHO2ZX2
12/31/2018	Google Adwords	WZJDYS66G5H5BD7KT4CMP3
12/31/2018	Google Adwords	XNGIIV2HSJF6PP7LOEL4ZT
12/31/2018	Google Adwords	XNGIIV2HSJF6PP7LOEL4ZT
12/31/2018	Google Adwords	YSMNXMJIBND5ZOCKVPR2L5
1/1/2019	Google Adwords	FU3ZFZVPERFJRL2E2N8PRO
1/1/2019	Google Adwords	WZJDYS66G5H5BD7KT4CMP3
1/2/2019	Google Adwords	46R2YMNKPNHU7ORNI7MGFU
1/2/2019	Facebook	5YRZ3WJ2LBEPFGO2X68C4G
1/2/2019	Facebook	6GYEYJSZTBGGZFADMB8PRO
1/2/2019	Facebook	FU3ZFZVPERFJRL2E2N8PRO
1/2/2019	Facebook	RQSRTLO3ZVHKDMIKHO2ZX2
1/2/2019	Facebook	VBLXO7UMKVHLHINKNA6IJW
1/2/2019	Facebook	WZJDYS66G5H5BD7KT4CMP3
1/2/2019	Facebook	YRD6NJVYOJEALLGTI3LZJF
1/2/2019	Bing	YSMNXMJIBND5ZOCKVPR2L5
1/3/2019	Bing	46R2YMNKPNHU7ORNI7MGFU
1/3/2019	Bing	5YRZ3WJ2LBEPFGO2X68C4G
1/3/2019	Bing	6GYEYJSZTBGGZFADMB8PRO
1/3/2019	Bing	FU3ZFZVPERFJRL2E2N8PRO
1/3/2019	Bing	RQSRTLO3ZVHKDMIKHO2ZX2
1/3/2019	Bing	VBLXO7UMKVHLHINKNA6IJW

Sales contact'

Month	Tracking Code	Unique Visitors
01/01/2019	RT_ABC	12
01/01/2019	RT_ABC	9
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	5
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	3
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	2
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	1
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	1
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	0
01/01/2019	RT_ABC	0

[tex628]

I cant actually tell what values there are for UsageDate when you pick 'Facebook' so it's impossible to determine if theres anything wrong or not.

But from what i can see you are filtering the calendar table with your PaidMedia table. The calendar table is already filtered to month march so you're leaving the dates in march that can be found in PaidMedia filtered to 'Facebook'.

If you can show all the rows in the PaidMedia table that have the MediaSource = 'Facebook' I might be able to help.