3 Replies Latest reply: Mar 30, 2018 3:46 AM by Nizam HM

# Count with a date filter applied

I'm trying to do the below formula with a date filter of 12/01/2017. Any assistance appreciated.

count([2])*2+count([3])*3+count([4])*4+count([5])*5+count([6])*6+count([7])*7+count([8])*8+count([9])*9+count([10])*10)/(Count([Employee_ID])

• ###### Re: Count with a date filter applied

What exactly you need help for? Can you share dimension, measures, sample data, expected output to respond appropriately.

• ###### Re: Count with a date filter applied

The same set expression would need to be added to each count():

count({\$<date={"12/01/2017")>} [2])

Note your date format setting would need to be "mm/dd/yyyy" and there can be no time in data. If there is, it gets a little more complex:

target_date = date#("12/01/2017");

count({\$<IDField={"=floor(date)=\$(target_date)"}>} [2])

• ###### Re: Count with a date filter applied

I am not sure what u r asking but i am giving an eg in what i understand

ID,Name,Amount

1,A,100

1,A,100

2,B,200

2,B,200

2,B,200

2,B,200

2,B,200

3,c,300

4,d,400

5,e,500

6,f,600

];

Measure1:=Count( ID)

Measure2:==Count(ID)* Sum(Aggr(Count(ID),ID))