Drill Down Functionality Fails at Deeper Data Levels

[Daence96]

Bug description

In version 4.0.2 of Superset, an issue has been identified with the drill down functionality in dashboards. As the data is drilled down into deeper levels, the drill down feature stops functioning correctly. While navigation works properly in the initial levels, when attempting to descend further, detailed data either fails to display or is shown incorrectly. This inconsistency impacts the users' ability to obtain a complete view of the data as they drill down through multiple levels.

The expected behavior is that, regardless of how many levels are drilled down, the data should be displayed continuously and accurately. However, the issue arises when drilling down beyond certain levels, where additional details become inaccessible, limiting the ability to perform in-depth data analysis.

This error has been observed in version 4.0.2 of Superset, and screenshots are attached to illustrate the irregular behavior as deeper levels are reached during the drill down.

Screenshots/recordings

DrillBy.docx

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[dosubot]

Hey @Daence96, I'm here to help you with any bugs, questions, or contributions. Let's squash those bugs together! 🤖

I found a similar unsolved discussion regarding the drill down functionality not working for widgets that do not have dimensions. You can view the discussion here ^[1].

Additionally, there is a known issue in Superset version 4.0.2 where the "Drill to detail truncates int64 IDs," which might be related to the problems you're experiencing. This issue is documented in the fix #29081 ^[2].

These might provide some context or insights into the issue you're facing with the drill down functionality at deeper data levels.

To continue talking to Dosu, mention @dosu.