cancel
Showing results for 
Search instead for 
Did you mean: 

how do i filter the records in analytic view by using variable/parameter for a time range

Former Member
0 Kudos

i have a analytic view which has a output column as date type. i want the user who use this view have the control to decided the output records based on a time range (from x to y).

i tried to create 2 variables, 1 for start_time, 1 for end_time. Ideally, i should have a expression for filtering data like this:

$$start_time <= date_column <= $$end_time

However, the variable windows doesn't seem to be feasible for the expression as above.

Does anyone has the same problem and get it solved?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

just figured out by my own. So the answer is using "variable" with "range" option.

Making a variable, then set the "selection type" to "range".

When preview the data, the variable input window pops up with operator on default "equal", use dropdown list to swtich it to "between", then you can enter the start_time and end_time as a range filter.

Answers (0)