cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Input variable in webi report

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

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.

Thanks

Jothi