Ratio in interface

258 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

How can I display a ratio between two values in interface (dashboard)?

I have the field "hours" in a base.
In the dashboard I want to display the number of hours last week divided in a static number.

All records from last week.
Total amount of hours from those records.
Divided in 8.
Plot this on a chart so I can see progress over time.


I'm OK to go through a new table in the base to solve the problem

1 Reply 1

Does this look about right to you?

Screenshot 2024-03-05 at 9.57.46 PM.png

Screenshot 2024-03-05 at 9.57.41 PM.png

Screenshot 2024-03-05 at 9.57.34 PM.png

Link to base

If so, the idea is to use a formula field to "group" the records, and in the example above I grouped it by the week number of the year.  (You'd probably want to use the week number of the year + the actual year, so "10 2024" or something, or maybe something more human readable like a start date to end date?)

Then use an automation to paste the value from that field into a linked field to another table, then you can use a rollup to grab the hours from that week and display it like I did in the Interface, does that make sense?