Average Length of Stay in Beastmode
I am trying to get the average length of stay using our admission date till our discharge date. I tried using the datediff function and got an error when validating, "Calculation error: whoops! something went wrong." I have flipped the discharge date and the admission date and the same error comes up. I feel like I am missing something.
Best Answer
-
@AshleySizemore Are both of your columns stored as date fields? If they aren't, then you will have to convert them to date. Otherwise I'd suggest closing out of Analyzer and trying again.
1
Answers
-
@AshleySizemore Are both of your columns stored as date fields? If they aren't, then you will have to convert them to date. Otherwise I'd suggest closing out of Analyzer and trying again.
1 -
Yes, both of my columns are date fields. I did try to close it and tried it again, and same error. I did get it to validate with: AVG(DATEDIFF(
discharge_date
,admission_date
))thank you
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 279 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 562 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 585 Beast Mode
- 13 App Studio
- 28 Variables
- 585 Automate
- 142 Apps
- 415 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 360 Distribute
- 98 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 9 Product Release Questions
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive