Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a table:
MODIFIED_MONTH | count({<EMAIL_PERMISSION_STATUS_={'I'} >} distinct RIID_) | count({<EMAIL_PERMISSION_STATUS_={'O'} >} distinct RIID_) |
Nov 2012 | 168 | 0 |
Dec 2012 | 67,108 | 2,524 |
Jan 2013 | 3,998 | 2,184 |
Feb 2013 | 2,247 | 1,999 |
Mar 2013 | 2,083 | 1,731 |
Apr 2013 | 2,164 | 1,918 |
May 2013 | 1,944 | 1,430 |
Jun 2013 | 2,679 | 1,778 |
Jul 2013 | 2,442 | 1,288 |
Aug 2013 | 1,921 | 1,717 |
Sep 2013 | 2,022 | 2,209 |
Oct 2013 | 2,048 | 1,881 |
Nov 2013 | 2,090 | 1,764 |
Dec 2013 | 1,866 | 1,555 |
the second column is the count of "opt-ins" and the third column is the number of "opt-outs"
I would like to add one additional column to calculate the "Total Optins" overtime, which would be "Previous Optins + Current Optins - Current Optouts". Can that be possibly done in the front end? or any idea for the backend?
Thanks,
Samuel
Hi,
You can use the above function to get the previous value from the chart.
Below are some useful links.
Regards,
Kaushik Solanki
Hi Samuel,
This might help you :
=RangeSum(Above(expression,0,RowNo()))-Above(expression,0)
Regards,
Nitin.