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?
Comments
-
@jordan_platinum An ETL update is likely your best bet in this case. I recommend using the ETL Rank & Window tile to add a count of non-null Procedures, partitioned by Appointment Number. This will tell you how many procedures are scheduled for that appointment. Then you can filter the drill view of your card to only show COUNT = 0 to show the appointments with no procedures scheduled.
0 -
Could you filter for only the D0330 procedure code in your main card and then have your drill path filter out the D0330 procedure code and have the user click on the appointment number to filter that specific appointment in the drill path?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive