Button to select current hour

[jordan1]

Hi,

I'm currently developing a dashboard which includes several buttons for users to make quick selections. One of these, for example, selects today's data using the simple expression =Today() on a  Date field.

My current problem is with attempting to create a similar button, but to select data from the last hour. I have a field available called "In Hour", which just shows each hour of the day in hh format. I have tried using several expressions to select the current hour from this field, currently  =Time(now(), 'hh'). However, nothing seems to trigger a selection, despite the fact that the same formula produces the correct value when placed on a KPI.

Does anybody know of a solution for this?

Thanks,

Jordan

[edwin]

is it possible your In Hour field is a number field and not a time field?  Time i believe will return a dual.  first i would try using a hard coded value in your action just to test the selection (make sure it is selectable from a list for In Hour), then maybe use num() function  to return the number component of your expression.  of course make sure your expression returns a selectable value