I've been struggling with understanding what I believe is a partitioning-addressing problem. As I've researched P&A I've found a number of forum threads that have been helpful, but the struggle continues. It's somewhat comforting to read the likes of Richard_L, Jonathan_D, Alex_K, Andy_C, Matthew_L comment about not completely grasping table calculations. I wonder where that puts me..yikes...
I also enjoyed Richard's comment about only three people in the world ever really understanding General Relativity. I thought I had it long ago in school..but a Winston Churchill quote comes to mind, "I had a feeling once about Mathematics, that I saw it all—Depth beyond depth was revealed to me—the Byss and the Abyss. I saw, as one might see the transit of Venus—or even the Lord Mayor's Show, a quantity passing through infinity and changing its sign from plus to minus. I saw exactly how it happened and why the tergiversation was inevitable: and how the one step involved all the others. It was like politics. But it was after dinner and I let it go!"
I have a couple versions of parameter-driven radius maps that I use, portions of one originated with Richard I think(thank you for the leg-up). I came across another (see radius-filtering_original downld reference.twbx attached, author unknown) that has some aspects I like, if I can understand how to make some additions/changes and extend the functionality to an associated crosstab...and therein is where I'm have some issues.
Attached is a reverse-engineered version (the *.tab & *.xlsx source file) of the reference *.twbx workbook. Things like this help me learn & generalize various techniques.
Q1) If you look at the Map1 sheet you'll note the parameter 'zip code selector' has zip code 48043 selected. You'll see no center point identified on the map (it'll be black). Now set the zip code selector to 48044 or 48042..that's what it should look like. The missing center point zip code (48043) is a choice in the zip code selector parameter list and yet the Highlight Central Zip Dimension calculation doesn't evaluate to TRUE. Or the Distance Measure calculation(the distance between 48043 & 48043 = 0) fails to evaluate to equal zero. Zoom in, the selected 48043 zipcode mark isn't displayed on the map. Why? This is a specific example of many selected zip codes not displaying the centerpoint.
Q2) I added a couple categorical filters to the xlsx file ("Population Category" and "US Region") to simulate how I'd like to utilize the completed dashboard(categories could be done with groups in Tableau). In my *.tab file I included a conventional worksheet ("Detail_Conventional xtab") to illustrate how I'd like the "Detail1" crosstab to function (in terms of post-map-radius-selection filtering). The "Detail_Conventional xtab" filters down like any worksheet.
Q2, Endpoint I'm after: I'd like to select a zip code & mile-radius on Dashboard1, have the map reflect what I've selected, have the crosstab reflect the mile-radius selection(I have it doing both now), and then be able to filter the crosstab down (independent of the map) the same way I can filter down the "Detail_Conventional xtab" crosstab. I think (?) I know how to get a population total of the filtered down crosstab selection(a window_sum calc), however I haven't tried it yet. I've been trying a number of configurations for a couple days and researching partitioning/addressing I'm not there yet. Any ideas?
The Map2 worksheet is just an alternate map that I may use in the dashboard. It uses the Population category for color rather than a Distance gradient.
Forgive me if the answer is dumb-simple. Sometimes I dive in only to miss the forest for the trees.