-
1. Re: Top ten sort and filter
lenaic.ridingerMar 2, 2016 7:20 AM (in response to mindy.hoftender.0)
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
mindy.hoftender.0 Mar 2, 2016 8:14 AM (in response to lenaic.ridinger)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.ridingerMar 2, 2016 8:34 AM (in response to mindy.hoftender.0)
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
mindy.hoftender.0 Mar 3, 2016 1:50 PM (in response to lenaic.ridinger)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!
-
tabex.twbx 15.9 KB
-
-
5. Re: Top ten sort and filter
lenaic.ridingerMar 4, 2016 10:36 AM (in response to mindy.hoftender.0)
Hey 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
-
tabex.twbx 24.0 KB
-
-
6. Re: Top ten sort and filter
mindy.hoftender.0 Mar 4, 2016 11:22 AM (in response to lenaic.ridinger)