How do I create a rate with 1 row of data then filter it by unique cells of another row?
I'm pretty new to Domo and work in healthcare but essentially I have an excel style sheet of data. In 1 of the rows is the list of different admitting providers and in another row it specifies if the patient was inpatient or observation. There is a column/unique account number for every patient in this data sheet.
I am wanting to 1st create a rate percentage of patients admitted via observation over all admitted. So the total sum of observation patients divided into the sum of all admissions inpatient and observation. I then want that rate filtered down to each unique provider so essentially the "Observation admission percentage" for each provider. I cannot figure out how to modify my ETL or create a beast mode to calculate the 1 row of data then filter it by each provider in the other row. I am very new to DOMO so maybe this is easier than I am making it, can someone please help!?
Best Answer
-
For your percentage of patients admitted via observation, you can use a beast mode like the following:
SUM(case when 'Enc status' = "Observation" then 1 else 0 end)/COUNT('Enc status')
This will get you the total observation patients divided by the total patients. To get it broken out by provider, you can just let Domo do the work. If you do a table and put the providers as a column, or a chart with providers on the axis, you can use your beast mode as your other column and it will just do the calculations for each one.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2
Answers
-
For your percentage of patients admitted via observation, you can use a beast mode like the following:
SUM(case when 'Enc status' = "Observation" then 1 else 0 end)/COUNT('Enc status')
This will get you the total observation patients divided by the total patients. To get it broken out by provider, you can just let Domo do the work. If you do a table and put the providers as a column, or a chart with providers on the axis, you can use your beast mode as your other column and it will just do the calculations for each one.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
2 -
Thanks a bunch that did the trick!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 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