Hi, welcome to the forums! I think you have two options that make sense to me. TSVB supports a filter ratio function which is able to do this, explained in more detail in this blog post. Another pretty common thing is to use the transforms feature to let you do a second level of aggregation.
1 Like