set analysis fieldvalue in certain time range

[#1]

Hello,

I am struggling using the set analysis in order to count only fieldvalues that fall into a specified time range. Two variables are used Test_Start and Test_End. They define the time range.

The following formula does not work. The time range will be ignored:

count(  {< datereported = {">=$(Test_Start)"},  datereported = {"<=$(Test_End)"}>} ID)

Using only one variable works just fine:

count(  {< datereported = {">=$(Test_Start)"} >} ID)

Can anybody give me a hint why the combination of Start and End does not work?

Thanks for your help!

[swuehl · Accepted solution]

The combination should work, like

count(  {< datereported = {">=$(Test_Start)<=$(Test_End)"}>} ID)

[Miguel_Angel_Baeyens]

Hi,

Feel free to download this application that shows among many other things how this works. You need to ensure that the format is the same in the variables as well as in the fields. Then, you have to take care of your set analysis syntax.

Hope that helps.

Miguel

[#4]

Perfect, thank you!