Drill Path error

Jez
Jez Member
edited December 2024 in Datasets

Hello, need help if anyone knows the reason what could be the reason for this error message:

Screenshot 2024-11-26 at 4.28.10 PM.png

I am using drill path and this is the visualization I want to make:

Screenshot 2024-12-02 at 5.06.35 PM.png

This is what drill path in my DOMO looks like:

Screenshot 2024-12-02 at 5.08.02 PM.png

For Reports 1 and 2 - I use the same dataset which is "View of loss"
For Report 3 I changed the dataset and used "Policy"

I have both the Broker and Policy # columns in both datasets that I used.

For Reports 1 and 2 it is working properly, when I click the broker it will drill to report 2 which is the broker info, but when I click policy # I am getting the error message above.

Any suggestions, things to remember or tricks in using drill path please.

Thank you!

Best Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Double check that ALL columns used, not just for drilling, but included in use in the card are on both datasets. So if one is applied as a filter or sort or exists in use on the card it should be in both datasets.

    If I solved your problem, please select "yes" above

  • ggenovese
    ggenovese Coach
    Answer ✓

    A couple things to note from the knowledgebase article on drill paths that may be root cause of the issue:

    • Calculations you create using Beast Mode are inherited when you drill from one view to another using the same DataSet. However, calculations are not inherited when you drill to a different DataSet.
    • You cannot create Beast Mode calculations on any card in a Drill Path except the top-level card. Calculations created on any other cards in a drill path will disappear after they are saved. 

Answers

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

    Double check that ALL columns used, not just for drilling, but included in use in the card are on both datasets. So if one is applied as a filter or sort or exists in use on the card it should be in both datasets.

    If I solved your problem, please select "yes" above

  • ggenovese
    ggenovese Coach
    Answer ✓

    A couple things to note from the knowledgebase article on drill paths that may be root cause of the issue:

    • Calculations you create using Beast Mode are inherited when you drill from one view to another using the same DataSet. However, calculations are not inherited when you drill to a different DataSet.
    • You cannot create Beast Mode calculations on any card in a Drill Path except the top-level card. Calculations created on any other cards in a drill path will disappear after they are saved. 

Categories