Drill Path Filter to show Specific Apt's without a Specific Procedure
Hey guys,
I'm afraid that the answer to my question is that I need to do it in ETL, but I was hoping that it could be done via a beast mode instead. Basically I have a list of procedures done by our dentists that looks similar to below:
Dentist | Procedure | Procedure Date| Appointment Number | Patient
Dr B | D0330 | 4/1/22 | 80362 | I. M. Madeup
Dr B | D0261 | 4/1/22 | 80362 | I. M. Madeup
So an appointment number will have multiple procedures listed under it. I want to create a drill path that shows only the patients who don't have a specific procedure scheduled in their appointment.
So basically I want to look at the case when an appointment number has the Procedure D0330 scheduled during it, and then I want to exclude it in that drill path view. Is this possible using a beast mode or would I have to set it up in magic ETL?
If it does need to be done in ETL what would be the best way to tie that procedure code to every row of the appointment number?
Answers
-
You should be able to filter that out in your card on the drill path using the card filter in analyzer.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
So I can filter out those specific Procedures, but that Patient and their aptnum will still show up in the drill path, because those procedures only take up one row of what is normally 4-5 rows associated with that appointment if that makes sense.
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive