Multiple alternate states expression/comparison question
I have a view where I have 7 different alternate states. The user can find a population of patients in each 'state' then I have a chart that compares the 7 states and shows how many states each patient falls into.
Here are the column headers:
Each column (C1, C2, etc) has an expression like this:
There will be a 1 if the patient is in that state or a zero if not.
Then I have a 'Sum' column that reports how many states each patient falls into:
My final column is a link to the chart in our electronic health record. Right now I am getting some blank values at random points and I can't figure out why. Here is the expression I am using for that column:
Since I have to put this hyperlink as an expression (I wish we could do dimensions as expressions) I have to use an expression so I don't get every patient. This chart is NOT in an alternate state since I need it to ready all the states. Everything works well except that last column. Does anyone have an neat ideas on this?
One additional wrinkle to this question, how do I omit any selections from the stateless portion of the app when this expression? If only certainly patients are selected in the main, only those links will appear in my chart so I need to omit all selections in this expression.
The patient MRN and patient hyperlink are actually coming from the stateless portion of the application. Thus selections that are applied to each state don't apply to those two fields. I'm probably doing a great job of explaining this but each population (C1, C2, etc) has different selections applied to it but those two values that we are using above are not filtered based on any of those states. Does that help?
Not entirely sure I understand... I am not sure what you are getting right now and what do you expect to get.... May be if you can show what you are getting through screenshots and explain what is needed, I might be able to help you