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.

Calculating ratios from filtered records in Interfaces

Topic Labels: Automations Formulas
381 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!