Forum Discussion

KyleMartin's avatar
KyleMartin
Qrew Member
3 years ago

Issue with Report Filters Not Functioning Properly

Hey All, I am having an issue with my custom reports that I have created. I have about 18 different evaluations that I want to have their own report (where it only shows the responses to "Evaluatio...
reports and charts
ChristineSuarez's avatar
ChristineSuarez
Qrew Cadet
3 years ago
I probably should have led with this instead. So, every evaluation is going to have a value for all the "hidden variable" fields you created. For instance, when you create evaluation #2, Eval_Type_HealthProf will always contain the default value of "Health/Professional QA" regardless of the type of eval it actually is. In other words, every record you create with that setup with all contain all the default values for all the hidden variable fields, so they're all going to show up on every report. Hope that makes sense. ​

------------------------------
Christine Suarez
------------------------------
KyleMartin's avatar
KyleMartin
Qrew Member
3 years ago
Christine, I am not sure that I follow.

The only evaluation that contains the variable "Eval_Type_HealthProf" is "Health Professional QA". If looking at another evaluation, say "RCDP", it would contain the variable "Eval_Type_RCDP", which would be tied to the appropriate default value.

So I set my reports up for "Health Professional QA" to only show responses where "Eval_Type_HealthProf contains Health Professional QA" (which is the default value, also the name of the eval). Why is it all of a sudden acting as if the variable "Eval_Type_HealthProf" is a part of every evaluation, when it is not?

If I am completing the "RCDP" evaluation, I can see that the variable "Eval_Type_HealthProf" is not a part of that evaluation. Yet, when I go to the "Health Professional QA" report, that response from my "RCDP" eval pops up. It even tells me in the report that there is a response where  "Eval_Type_HealthProf contains Health Professional QA". Which is impossible because that variable does not exist in the "RCDP" evaluation.

------------------------------
Kyle Martin
------------------------------
  • ChristineSuarez's avatar
    ChristineSuarez
    Qrew Cadet
    3 years ago
    Just so we're on the same page - you have a single table called "Evaluations Settings," right? I assume that's where you store each Evaluation record (regardless of type)? And you've created 18 different variables (which I'm assuming you're actually referring to fields in the table) for each type of evaluation, each with a corresponding default value.

    Referring to this part in your last response: "Eval_Type_HealthProf contains Health Professional QA". Which is impossible because that variable does not exist in the "RCDP" evaluation."

    This is what I was getting at - your "RCDP" evaluation does in fact have a "Eval_Type_HealthProf" variable (I think what you mean is field here). Your "RCDP" has a value for every variable (field) you created. Every time you create a field, it exists for all records you create in your evaluations table. 

    Does that help? Happy to try to show you in another way. Try this: create a new report and include all of the fields you refer to as variables in it. I'd every record/evaluation, regardless of what type you intended them to be, will have a default value in every field.

    ------------------------------
    Christine Suarez
    ------------------------------