Help trying to calculate a percentage

DanVartanian · ‎01-20-2022

The image below shows what my source data is (HAVE) and what I'm trying to get to (WANT).

I want to be able to calculate the percentage of bad messages (where formattedMessage = false) by source and date.

I'm not sure how to achieve this in DatabricksSql. Any help appreciated.

DanVartanian · ‎01-20-2022

Thank you so much

-werners- · ‎01-21-2022

you could use a windows function over source and date with a sum of messagecount. This gives you the total per source/date repeated on every line.

Then apply a filter on formattedmessage == false and divide messagecount by the sum above.

DanVartanian · ‎01-21-2022

Thank you, I was able to get it following your instructions😀