I have a directory of newsletter emails which is stored in my database.
For each email, I have a date field and a ‘Yes/no’ field which tells whether the email was promotional or not.
Now I want to create a chart where on the X axis I want to plot different dates and on the Y axis I want to plot % total of email where promotional email is "Yes"
Can somebody please help me understand how can I achieve this?
Hey mate,
So you can use bubbles google charts plugins or any other chart plugin.
You want to use a “do a search” action which filters all the emails by the condition by the date field and the “Yes/No” field, this will give you your list of dates and then you can use your “Display field” and your calculated field.
I actually use HTML elements rather than the plugins but I can show you what that looks like
Because I am using HTML, mine is slightly different but the concept is the same. Let me know if you need more help
Connect with me
This topic was automatically closed after 70 days. New replies are no longer allowed.
