Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings All,
I am looking to make a more dynamic table that alters based off of a slider provided to the user. I currently have a variable set up (vHoursCompleted) which it's value is set by default to 2, but can be changed by the slider anywhere from 1 to 10. An old set analysis line I wrote used to display the counts of all interviews that took 2 hour or less, written as such:
count({<[Interview Type] = {'OD video'}, [Time to Complete (Hr)] = {"<=2"}>} InterviewID)
However, I would now like to remove the "2" and input the variable vHoursCompleted so the set analysis will update with the choice of the reader, via the slider. How would I go about inputting the variable in the set analysis, as well as keep the <= ?
Found the resolve! Dug around in older posts, but for those who may wanna know:
count({<[Interview Type] = {'OD video'}, [Time to Complete (Hr)] = {"<=$(=vHoursDone)"}>} InterviewID)
Found the resolve! Dug around in older posts, but for those who may wanna know:
count({<[Interview Type] = {'OD video'}, [Time to Complete (Hr)] = {"<=$(=vHoursDone)"}>} InterviewID)