Input Box should give required records

[#1]

Hi all,

i have a requirement with the input box. i have orders, order received date, order finish date,target hrs to finish the order and Actual No.of hrs to complete the orders as fields.

In this case Target hrs are 4.

Actual No. hrs are 0-99 hrs.

Now in an input box, when i enter actual 3hrs the table should show all the records 0-3 and

if i enter actual 5hrs the table should show all the records 0-5.

can someone please suggest me how to achieve this requirement.

Thanks

Regards,

Sridhar

[Anonymous]

Hello,

Assign this inputbox to a variable. And then filter your chart with the variable in a set expression. Something like (may not be exact):

sum ({<hour={<=$('myVariable')}>}ORDERS)

BR

Serhan