Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table in Sense as below.
How can I count 'Closed' and 'Cleared' in 'Org_status' (the result should be '3')?
Try this
Count({<[Org Status] = {'Closed', 'Cleared'}>} DISTINCT [Ticket ID])
Try this
Count({<[Org Status] = {'Closed', 'Cleared'}>} DISTINCT [Ticket ID])