Drill Down issue
I have a summary level card (Table format). I tried to edit drill path and applied the correct filters , but when i test it, it only shows 1 value
Best Answer
-
Is your top level card a Pivot Table? Where are you clicking exactly to drill down? Do you have any filters on the top level card that come from Beast Modes rather than actual values from the dataset? These things can all affect how drilling works and yield different results. Something else that has often caused me headaches is that if your org has Fiscal Calendar enabled you need to ensure both the top level card and the drill path card have the same setting for it (either to use it or not), otherwise the drilling goes awry.
2
Answers
-
@shreeyab Here are a few things to check if your drill path is not working as expected:
- Apply the same filters in the Data tab of the dataset to see which rows should be included in the drill
- Be sure that you are clicking on a dimension when you drill, not the measure, since that field is what is used to filter the drill path
- Verify that you are not aggregating any fields in the drill if you want it to show a detail view
- Check that there aren't any conflicting filters on the top level and drill views within Analyzer, since that could potentially exclude necessary data
1 -
I have a count(flag) column in my summary table. I want to drill down to the count.
So count(Flag) = 4 I want to see the 4 records.
Currently, I am getting only 1 record
0 -
I am seeing only one record that changes randomly, but shows 1 record while i want to drill down to the 6
0 -
Is your top level card a Pivot Table? Where are you clicking exactly to drill down? Do you have any filters on the top level card that come from Beast Modes rather than actual values from the dataset? These things can all affect how drilling works and yield different results. Something else that has often caused me headaches is that if your org has Fiscal Calendar enabled you need to ensure both the top level card and the drill path card have the same setting for it (either to use it or not), otherwise the drilling goes awry.
2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive