Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Ratio in interface

Solved
Jump to Solution
1044 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jonaskarles
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.

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

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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?

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

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?

jonaskarles
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks