Hello all, hopefully you can assist me on an issue I'm having.
For a dashboard I'm putting together, I want to implement a more complex What-If analysis. Specifically, I have three fields corresponding to scores on pre-employment assessments (V1, V2, & V3) and three cutscore variables (v1cut, v2cut, & v3cut) that can be set by the user via an input box. What I want to show is the proportion of applicants who have scores which exceed all of the cutscores and have been fired from the job. Using the following expressions:
=Avg({<V1={">=$(v1cut)"}>}Fired)
=Avg({<V2={">=$(v2cut)"}>}Fired)
=Avg({<V3={">=$(v3cut)"}>}Fired)
I can show what the rate is considering each of the variables separately. However, I want a way to combine them and show the failure rate for folks whose V1 exceeds v1cut AND V2 exceeds v2cut AND V3 exceeds v3cut. I've tried calculating a field in the script and adding a reload button, but this doesn't work in the web view, which is how the app will be used. Any insight would be much appreciated. I've attached a .qvw just in case it helps to get a handle on things.
