Unique filter, then sum?

1

Hello all,

First time caller. And I’d definitely still class myself as a beginner still, so go easy on me :slight_smile:

So, I’m trying to figure out how to count the number of Leads in any given month. So for example, in the empty Total Leads table below the Actual Leads table, I’d like it to show:

Month Number

October 2
November 1
December 1

…However, I can’t figure it out for the life of me.

I managed to figure out how to get the specific answer for one month by doing this:

Filter([Actual Leads],Month=October).Count()

But struggling to make it work in a table.

Any help would be much appreciated!

Thank so much,
Dan

01
Screenshot 2019-10-22 at 18.49.01.png876×962 56 KB

2

try this Actual Leads.filter(month = thisRow).count as a formula for Number column in Total Leads table

3

Thank you for your quick response Krunal :slight_smile:

That definitely did something, but gave me 0’s in the Number column. Do you have any other ideas?

Thanks!

image

4

oh i see it now your Month in Total Leads is also a lookup - try this Actual Leads.filter(month = thisRow.Month).count

if lookup on Total Leads is multi-select you would need Actual Leads.filter(thisRow.Month.contains(month)).count()

1 Like
5

You are a deity. It absolutely worked! Thanks so much! :facepunch:t6:

1 Like