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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 655 Automate
- 170 Apps
- 438 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 383 Distribute
- 110 Domo Everywhere
- 267 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive