Display Percentage of total value on graph chart

[heyshivamkr]

I have a data type called “email.” For each email, there is a “Yes/No” field called “promotional email.”

I want to display the percentage of promotional emails (out of all emails) on daily and weekly graphs (two separate graphs).

Usually, to find the percentage, I simply divide the number of emails with “promotional email” set to “Yes” by the total count of emails.

However, I am not able to do this before grouping the data by day.

Can you help me understand how to find the percentage first and then group, or vice versa?

An example would help.

[Newed]

Try to filter first, then group by date, creating an aggregation, so for each one, divide by the total.

[heyshivamkr]

Are you suggesting something like this? It is not working though.