Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Show Totals in List on Interface Dashboard

Topic Labels: Interface Designer
Solved
Jump to Solution
356 6
cancel
Showing results for 
Search instead for 
Did you mean: 
JulieO
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a list to show the previous month orders and would like to total the number and currency fields. I do not see any way to show totals in a list on an Interface dashboard. Is this possible?

JulieO_0-1727885241461.png

 

1 Solution

Accepted Solutions
JulieO
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for the replies.  I guess my options are to add another interface page that is a list or use the number fields in a dashboard. It would be great to be able to show totals in a list within a dashboard.

See Solution in Thread

6 Replies 6
Mike_AutomaticN
7 - App Architect
7 - App Architect

Hey! This is def possible. You will want to use a "Number" interface. For getting a sum of total amount, use "Field Summary" and select the Total License Fees field.
For total count of transactions, you could use "Record Count"

JulieO
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to show the totals within the list. I know how to do it with numbers, but I would rather have the list show the totals at the top or bottom.

I don't think so I'm afraid.  You could try using hierarchies for this?  You'd link each order to a record in another table that represented that month year, and then you'd use rollup / count fields to get the totals
Screenshot 2024-10-03 at 10.55.33 AM.png

Screenshot 2024-10-03 at 10.55.36 AM.png

Screenshot 2024-10-03 at 10.56.11 AM.png

 

 

Link to base

Dan_Montoya
Community Manager
Community Manager

I prefer to use Dashboards when something in the list needs to be summed.Screenshot 2024-10-02 at 8.11.30 PM.png

JulieO
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for the replies.  I guess my options are to add another interface page that is a list or use the number fields in a dashboard. It would be great to be able to show totals in a list within a dashboard.

ScottWorld
18 - Pluto
18 - Pluto

I agree that this is a much-needed feature. Be sure to submit it as a feature request to support@airtable.com 

- ScottWorld, Expert Airtable Consultant