To display the count, just take the search for emails count as you have it in the beginning of the expression.
Doesn’t make any sense because the monthly average would imply you are looking at the entire YEAR and dividing by 12 to get the average monthly count of emails sent, but in your screenshots and explanation you are attempting to show an average daily count of emails sent if you are taking the number of emails sent within the range and dividing by 30.
What are you really trying to do and for what use case other than displaying the value?
So, basically, i am tracking the email newsletter of a brand sent on different dates.
Now, I want to display three metrics:
Total number of newsletters sent - self-explanatory, i have use count function and it worked.
Average number of monthly emails sent - I want to show the average monthly newsletter sent by an email based on the date range a user is looking to analyze the data. I know this can never be accurate unless someone has selected the whole months in the date range but the approximate number will also work.
Average email sent in a week: Similarly, I want to display the average number of newsletters sent by a brand in a week based on the date range a user is analyzing.
Need to force the date range pickers to be month based instead of single dates, because, how could you accurately provide a monthly average if the user selects dates that are just 1 week apart. But if you just want to keep the feature as is with two date pickers, then consider the idea that the user might just choose a week range, you need to know how many days in their selection (ie:7), then you take the count and divide by 7 and then multiply by 30 to get an assumed monthly average.
Same thing…if the user selects 3 days in the range, take the count and divide by the number of days in the range (ie: 3) and then multiply by 7