Calculating daily totals from cumulative totals
Summary:
I want to subtract a previous day's numeric field from the current day's numeric field and display the result in a column in a view. The catch is, I do not want this based on the record ID or even the built-in add date Zoho pulls - I need this based on the Date field in the form.
Details:
I need a daily record of activity for several different web properties, that can be exported to excel and/or viewed as charts. So I have created a form (Activity_Entry). While it should be submitted every day, there will be some days that will be missed, so some entries will have to be postdated (user will fill in the form on Friday for Wed and Thurs activity). I have built the form with a Date field that is required, and checks for duplicates.
In the form is the numeric field Total_Views, in which the user enters the cumulative number of views of specific site (the only number we receive). However, I need to be able to chart the daily views over a set number of days. So, I believe I would need the form to pull the Total_Views entry in the previous day's record (based on the Date field), and subtract this cumulative number from the cumulative number just entered into the Total_Views field of the record that is currently open. But this would need to be done in a way that will allow me to display it in a view.
Please let me know what additional info I need to provide... thanks!!