I was trying to do the calculation in a formula tile on an ETL but I just read that I need to do it in a group by tile. Trying that now. I was basing the status off a status filed however sometimes that field is not updated when a discharge or death occurs so I am trying to get a true census based on people admitted who…

It worked THANK YOU SO MUCH!!

Grant thank you! I have never done a "group by" before. On my ETL where would I put the group by tile (connected to what?) and would I connect it back to "All State Resolutions" using an inner join? Thank you so much for your help

I yes, from the highlighted rows I want to keep the second row. I highliighted the column headings I would use to make this determination Note, there is not always a "closed" option, sometimes the two rows will both say "open" but then I would need the latest updated row. This is the ETL (don't judge I'm brand new at this…

Thank you I am a novice so I am not sure what this looks like-could you direct me to a tutorial or visual example?

That worked thanks again!😀

Thank you!