Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to count how many visits took place between 07:00 - 15:00
I have been using the following expression :
=Count({$<Time={">=07:00<=15:00)"}>} Visit)
but it keeps coming up with all the visit and not just between 07:00-15:00
Thanks,
Sharbel
@Sharbel Make sure that the Time input format matches with actual time format of field. Also, check that your time field is in proper time format.
If your time column values are in hh:mm format then try setting below variable in same format and reload your app
SET TimeFormat='hh:mm';
You have an left parenthesis in your expression that you might need to remove. Right after the <=15:00.
=Count({$<Time={">=07:00<=15:00"}>} Visit)
I'm also concerned if your expression will interpret your modifier values as time values.
You might need to adjust it to
=Count({$<Time={">='07:00'<='15:00'"}>} Visit)
OR
=Count({$<Time={">=$(=maketime(7))<=$(=maketime(15))"}>} Visit)