Drill Path - ignoring of certain filters
Hi All
i have a card which shows by employee actual % vs Target and the variance YTD (see below) i have added a quick filter to the card so a user can filter on employees who have a variance over a certain % so they can focus on the main drivers
i then wanted a drill path to show the trend by (actual vs target) by month for said individual - however when i drill through it retains the filter on the is greater than gap, meaning any months which have a variance less than the initial selected value are dropped - what i want to do is retain all the data in essence ignoring the initial filter applied
does any one have any suggestions - or perhaps a different approach other than drill path
Many Thanks
David
Best Answer
-
You can create a drill card showing the chart you want rather than relying on the default drill path which will always adhere to the filters imposed on the main card. Click the wrench then choose the "edit drill path" option. Click the trash can on the 2nd level to remove the default view, then choose "add a view" and create the view you're interested in the viewer drilling to. It will then be filtered only by the column they click through to the view on rather by any quick filters applied on the main card.
0
Answers
-
You can create a drill card showing the chart you want rather than relying on the default drill path which will always adhere to the filters imposed on the main card. Click the wrench then choose the "edit drill path" option. Click the trash can on the 2nd level to remove the default view, then choose "add a view" and create the view you're interested in the viewer drilling to. It will then be filtered only by the column they click through to the view on rather by any quick filters applied on the main card.
0 -
@Dverdon between variables and filters configured on the drill card I thought we could could implement the above but unfortunately it looks like the drill card will always initially default to what was selected on the parent card. Training them to remove the >25% option along the top of the drill view, or removing the range selector from the parent card entirely would be the only other alternatives I can think of.🤷♀️
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive