Sorry to post this again as I haven’t received an appropriate solution yet.
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 the group, or vice versa?