Add 'if' conditions to set analysis

[leale1997]

Not good at Set Analytics AT ALL

I found a formula and adapted it for my needs and it is working, partly....

I have a set of data and I want to count every record in that table that is:

     - closed late in the current month.

     - Has a [project] field that = 'New' or 'Assessed'

     - Has a [status] field that = 'Late'

This is what I have so far that is working.  But it's just counting everything that closed in the month of October with no added variables applied.

=Count({<DateClosed = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} RecordID)

Any ideas or examples?

[sunny_talwar · Accepted solution]

You can try this

=Count({<DateClosed = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}, project = {'New', 'Assessed'}, status = {'Late'}>} RecordID)

[leale1997]

That worked!  Thanks!  Sorry for the delay.  Found issues in the data I was trying to solve..