Set Analysis for Between timings

Fri, 20 Jun 2014 17:28:43 GMT

Hi ,

I have "Name" field and "time" field. I m calculating Count of names in between 30 mins to 1 hour and using "Client" Field as Dimension

i have written expression like this:

Count({<Time1={'>=(00:30:00) <=(01:00:00)'},Category={'MPLS'}>}Name)

it is not working.

Any Suggestions Would be greatly appreciated

Regards,

Divya

Re: Set Analysis for Between timings

swuehl — Fri, 20 Jun 2014 17:33:32 GMT

If your time format is 'hh:mm:ss', try

=Count({<Time1={">=00:30:00<=01:00:00"},Category={'MPLS'}>} Name)

or post a small sample app or some lines of sample data.