-
1. Re: Top ten sort and filter
lenaic.ridinger
Mar 2, 2016 7:20 AM
Hello mindy.hoftender.0,
Could you please provide us with the workbook (.twbx)?
I'd be happy to help you solve this problem.
-
2. Re: Top ten sort and filter
If I extract the data and only include variables used (which are all the de-identified variables), would a .txbx be safe to provide? Can the data I have hidden be unhidden? Does a .txbx give access to my data source?Lénaïc Riédinger
-
3. Re: Top ten sort and filter
lenaic.ridinger
Mar 2, 2016 8:34 AM
A .twbx save everything in your workbook, so everyone with the file can read and interact with it easily.
It would give access to what is in the file only. If things are hidden, it will stay hidden.
If needed, you can create a new workbook with your datasources and re-create the above image you provided us with. So we would only have access to this.
-
4. Re: Top ten sort and filter
Technically, zip code is PHI so I cannot attach a workbook that the public could access.
So I created some fake data and remade the worksheet! Luckily, or maybe not...the problem still occurs. I have attached the txbx!
-
5. Re: Top ten sort and filter
lenaic.ridinger
Mar 4, 2016 10:36 AM
1 of 1 people found this helpfulHey mindy.hoftender.0,
We can simply do this with a LOD calculation. Please find the workbook attached.
({Exclude[Gender]: Count(Patients)})
is the LOD calculation you are looking for. It will work for the split on screen, of Gender.
If the top n will always be on Zip code, then this will work as well:
({Fixed [Pat Zip]: Count(Patients)})
Is it what you were looking for?
Lenny
-
6. Re: Top ten sort and filter
Yes, your workbook does look like what I'm trying to do. For some reason, when I do it though, the rank by zip skips around instead of being based off count.
