Help trying to calculate a percentage

[DanVartanian]

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]

Thank you so much

[-werners- · Accepted solution]

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]

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