Skip to Content

Custom Input variable in webi report

May 12 at 11:07 AM


avatar image

Hi All,

I have a requirement as similar to below.

In webi report console, user will select the input date.

I want to display report for how many students have joined in a college in that particular date. show the results at 1hour frequency. say suppose,

i select 10th May. result should be x members at 9am, y members at 10am till 4pm for the selected date.

here i cannot use =,!=,<=,>=,<,>,<> conditions in query panel as the exact matching timing may not be available in database. so take a input from user then check in database for the display.

any idea to achieve this would be much appreciated.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A May 16 at 08:25 PM


Create a prompt on Year and Month for the user to select.

Use FormatDate([Date];"dd/MM/yyyy hh:mm:ss") to show date and time if your Date field doesn't bring Time.

When the user selects Year and Month in the prompt, report will display only that particular Month and your Date time field will show Enrollment Date and Time in the report.

Post sample data or mock up.



10 |10000 characters needed characters left characters exceeded