Hello,
In the included screenshot I am trying to filter by "Medical Condition" to show how much of each "Opioid" is being used.
I created a Medical Condition Parameter, so we can choose the option, but I don't know how to get it to work. As you can see I have the Measure values displaying by Measure Name for the Opioids but I cannot figure out how to get them to display by Medical Condition. Any help would be greatly appreciated. I am also attaching a test export
Thank you!!!
I think you'll also need some additional data source prep. It looks like it's two data sources with no relation between the two. So right now the medication numbers and all of the medical diagnoses are their separate rows. What you want to see is a medication column and diagnosis column, with data on each row, in a long form like Jim mentions.
Once you do that, you can just add a filter (right-click diagnosis group and show filter) without the need for a parameter. Parameters only work when you access the selection in a calculated field.
Your data right now, where it seems to change from one data source to another ...
So for all medication, there is no Diagnosis Group.
