How to calculate number of days when certain text appears in a field

[Anonymous]

Hello,

I need to calculate number of days when certain value (value "Test" in my example) appears in a field.

Any suggestion how to do this?

Below is an example of the data and the result should be 4.

Date	Text
1.4.2015	Test
1.4.2015	x
5.4.2015	Test
10.4.2015	x
10.4.2015	Test
10.4.2015	Test
20.4.2015	Test
20.4.2015	Test
31.4.2015	x
31.4.2015	x

Thanks,

Risto

[maxgro · Accepted solution]

count({$ <Text={Test}>} distinct Date)