+4How 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.
Like:
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
Best answer by TheTimeSavingCo
Does this look about right to you?
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?
+31Does this look about right to you?
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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.