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:
Level 1:
Name | Summary |
Q3 | Total Team Count: 3 |
Level 2: (on Name = Q3)
Team | Team Summary |
A | Total Task Count: 2 |
B | Total Task Count: 6 |
C | 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?
Task | Status |
TA#1 | InProgress |
TA#2 | Completed |
How can I troubleshoot?
Thanks,
Hua