Help

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

Re: Show Totals in List on Interface Dashboard

42 0
cancel
Showing results for 
Search instead for 
Did you mean: 
JulieO
4 - Data Explorer
4 - Data Explorer

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

 

4 Replies 4
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
4 - Data Explorer
4 - Data Explorer

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