Jump to content
• 0

# daily calculations

## Question

I would like a table that can pull information from another and give me daily numbers

I know this would be a task to run every morning or possibly a pivot table

1. Give a total of new entries from the previous day

2. The total number of incomplete work items in total (from a check box field)

3. Number of projects completed the previous day (From a check box field)

4. The average time that work is out (From a calculated field run through a task

## Recommended Posts

• 0

I have a similar problem that I am trying to tackle. I want to perform calculations on a table everyday. Essentially, some of the records in my table will have the same reference number and I want to add up the columns of the records that have the same reference number.

Please let me know if you find a viable solution to this.

##### Share on other sites

• 0

Hello @Kurtmc,

Since I don`t know your table design, I will share an example based on my test tables.

Let`s say there is a Table that stores orders:

As you can see, there are 5 orders from yesterday, 2 of them are completed, and 3 of them are incompleted.

The Table to store totals from the previous day:

This Task populates the 'Orders_totals_daily' table on the daily basis.

Result:

Hope this helps.

##### Share on other sites

• 0

Hello @brennanpoit,

For your case, the Task design might be simpler.

First of all, you may want to check an article regarding Tasks:

https://howto.caspio.com/tasks/

For example, there is a table that stores unique invoices:

And there is a second table (the so-called Child table that can store multiple records related to the invoices):

As you can see, these tables have a relationship based on the ID field.

This is the Task example to count the number of each invoice and the sum of each invoice in the Invoices_tbl.

Result:

Feel free to update this thread if you have further questions.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
• #### Browse

×
• Create New...