No data when drilling down into a different dataset
I created a card with 2 drill path cards. The top two levels are from the same dataset, while the bottom level is from a different dataset. While they are compatible, the 2nd drill path doesn't show any data. But if I simply pass the same conditions to filter using that dataset, there are expected data returned. How can I troubleshoot to find out why the drill path did not work?
My card looks like this (made-up data):
From a dataset with all Summary info:
Total Team Count: 3
Level 2: (on Name = Q3)
Total Task Count: 2
Total Task Count: 6
Total Task Count: 3
Level 3: (on Name = Q3 and Team = "A"), from a different dataset containing more details
Expected to have something like below returned, but nothing returns. If I use (Name = Q3 and Team = "A") directly applying on the details dataset, then I get the result. But why are the conditions not being passed (?) when the dataset is a drillpath?
How can I troubleshoot?