-
1. Re: Parameters/Calculated Fields to show Hospital Discharge Information for a certain area.
Jim DehnerJun 15, 2018 9:53 AM (in response to Hunter Branscome)
Hi Hunter
see the attached
see the d/b - sorry I messed up the format
but here is how the parameter and sheet swap work
first the parameter
Then a filter
on the part 1 sheet and part 2 sheet place the filter worksheet and set to True
on the Map set to False
then create the viz _ didn't know where to place the tital and origin - you will have to add
Then you right click the Title ("header" on each sheet and hide it (that way it will disappear when we switch from detail to overall)
this is the overall view
this is the detail view
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
Exercise2_v3_v10.2.twbx 38.7 MB
-
-
2. Re: Parameters/Calculated Fields to show Hospital Discharge Information for a certain area.
Hunter Branscome Jun 15, 2018 11:18 AM (in response to Jim Dehner)Hey Jim,
I'm afraid that's not what I'm looking for. But thank you for your efforts. I'll try and be more specific in what I'm asking.
I would like the parameter to toggle between two views:
- First view: Show all facilities (which are based on facility zip code in the data) - and have the heat map populate discharges by patient origin (represented by patient residential zip code in the data)
- Second view: Show facilities within a single zip code that exists within the Facility Zip Code dimension, and have the map populate where these patients come from.
The goal is build a dashboard that can toggle between the two conditions and show the relevant information.