Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@adityavighne are you able to share your model? or share some data in text form of the 3 tables?
Proud to be a Super User!
@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 | D7VVPUVIQ5EHXLIRJOVI5I | ||
12/31/2018 | AdRoll | FU3ZFZVPERFJRL2E2N8PRO | |
12/31/2018 | 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 | 5YRZ3WJ2LBEPFGO2X68C4G | ||
1/2/2019 | 6GYEYJSZTBGGZFADMB8PRO | ||
1/2/2019 | FU3ZFZVPERFJRL2E2N8PRO | ||
1/2/2019 | RQSRTLO3ZVHKDMIKHO2ZX2 | ||
1/2/2019 | VBLXO7UMKVHLHINKNA6IJW | ||
1/2/2019 | WZJDYS66G5H5BD7KT4CMP3 | ||
1/2/2019 | 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 |
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.
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
66 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |