Help

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

Calculating ratios from filtered records in Interfaces

Topic Labels: Automations Formulas
170 1
cancel
Showing results for 
Search instead for 
Did you mean: 
krysAphex
4 - Data Explorer
4 - Data Explorer

Hi there, below is a snippet of an interface I've set up. I have multiple filters that influence which records are used to sum the various metrics below. The next metric I'd like to implement is a ratio using the summed numbers, for example number of emails sent per user so 109167 / 51065 =  ~2:1. Is there any way I can do this? I'm happy with doing the actual calculations in a nocode tool if there's a way to send across the list of filtered records but I can't figure out a way to do this. If anyone has any ideas or perhaps alternative tools I could use for this exercise then please let me know, thanks in advance!

krysAphex_0-1727104834710.png

1 Reply 1

Not a great workaround, but I ended up hardcoding it and creating one record per filter to get around this issue.  That only worked because I only needed stuff in monthly, quarterly, and yearly though, and with this many filters that's probably not feasible; just wanted to float the possibility as a compromise somewhere!