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!?