Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You can try this
=Count({<DateClosed = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}, project = {'New', 'Assessed'}, status = {'Late'}>} RecordID)
You can try this
=Count({<DateClosed = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}, project = {'New', 'Assessed'}, status = {'Late'}>} RecordID)
That worked! Thanks! Sorry for the delay. Found issues in the data I was trying to solve..