Calculate percentage for items in the same column

We have a table that stores status field in a column. If the statuses are ‘A, B, C, D’, we want to know the percentage of A in every month. We were able to do it using a custom query, but, can we achieve this without using a custom query?

1 Like