Nov 15, 2024 12:11 PM - edited Nov 15, 2024 01:10 PM
Hi,
I'm trying to display fractions and percents based on a cap/denominator of my choosing. Ex. x / 54.
The goal is to help the team know at a glance/status report that we are either at cap or below and by how much exactly. The same need is also needed in that if we're below by 3 for example, maybe 1 is in transition and only 2 is truly missing.
I fiddled with columns and formulas a little bit and found a way for a column to display a fraction by having a autocount row and a formula row returning a concat of the {autocount} +"/54" for x/54 but I cannot display that on a dashboard. Also learned formulas can't count records in the table, hence autocount as a workaround.
If anyone has thoughts on how to show fractions that would be great. OR display a count of "54" or "20000" without it ruining the table as a last resort, so that I can display a regular count as one field, and that "fake/determined" count as another field next to it.
Edit: Also found out after more fiddling, autocount does not update after a record gets deleted so that method doesn't work either.
Thanks
Nov 15, 2024 06:07 PM
Hmm, this depends a lot on how your data's set up and how your reporting looks. For example, here's how you could do it if you wanted the % of tasks that wasn't "Done"
And it works with a formula field that outputs the word "Pending" if the Status isn't "Done":
With a element setup of either "Percent empty" or "Percent filled"
Link to base
If you could provide some screenshots of your table set up and details on how your reporting works I can see what I can do to help!
Nov 18, 2024 10:15 AM - edited Nov 18, 2024 10:16 AM
I can't really screenshot the table. I've seen that solution and some other workarounds but that all relies on the total of current records. I need a fraction based on a defined denominator. If we have 20 children enrolled, but our capacity is 50, we would like to show 20/50. The status would then also separate the steps, so 20/50 could be currently enrolled, 5 is in transition, so 25 slots are empty. If fractions aren't possible, then have the ability to show the capacity (ex. 50) somewhere is enough. People who work the data consistently know the cap, but people like me who help periodically or read reports will not, so having a reference is nice.
In the image below, I would want Total 88, to be 50 for example - and stay that way no matter the amount of records that gets added or deleted.