Marketing Dashboard: Show Best Subject Line!

I’m making a dashboard for our marketing team :tada:. The marketing team is split among our 4 major verticals and each team has their own newsletter/content schedules.

I have the historical performance of each newsletter (open rates, click rates, etc.). The dashboard allows the viewer to select which newsletter’s performance they want to view. How do I display the best performing subject line depending on which newsletter is selected?

For instance, given Newsletter X is selected, how do I lookup the subject line that has the highest open rate?

Hi @Jeff_Withington - welcome to the community.

I built a little example for you here. Take a look and see if it helps.

The main formula here is -

thisTable.Filter(Newsletter.Matches([select 1])).Count.Max() = thisRow.Count