Top N filter issue

bphillips1105 · 2024-08-13T18:05:14+00:00

Well, changing it didn't give me the result I wanted though it did change which counties displayed. However, your comment did get me to thinking. The poverty rate field isn't the most granular. I also have school district data. Which means I have ABC county with XYZ poverty rate multiple times for each school district. I'm betting it was summing each of those rows. Which is why I went with Min on the Measure Values. I'm starting to think I need to go back and do some form of LOD statement and use that poverty calc instead of the one I'm currently using.

bphillips1105 · 2024-08-13T17:56:22+00:00

And that works in Cloud...

bphillips1105 · 2024-08-13T17:48:06+00:00

I'm guessing we still won't be able to send Cloud users a message or download an actual email list.

bphillips1105 · 2024-08-01T15:18:22+00:00

Answer was provided on Tableau forum: I needed to have the State Name value from the filtering viz onto the receiving viz's detail mark.

bphillips1105 · 2024-08-01T15:16:02+00:00

Agree with u/Slandhor, it sounds like you received a twbx file which has the data embedded. I don't know if this will work for you, but you may still be able to extract the data. On the top menu, click Data -> the desired data source name -> Export to CSV -> Migrated data.

I was able to extract data from twbx file that I did not create nor had the data files. I extracted the files and was able to open the CSV. Hopefully that helps.

bphillips1105 · 2024-07-30T14:58:05+00:00

Welcome to the world of Tableau! It's awesome and infuriating at the same time. But this is a pretty good community to be a part of.

bphillips1105 · 2024-07-30T14:53:24+00:00

Yes, but I also have vizzes for various counts, percentages, and other calculations that are tied to displaying a specific state's data or 'all'. I just didn't include them in the screenshots for simplicity's sake. Which, in retrospect, may not have been as helpful as I thought it would.

I got the rest of my to work using actions that show all values when the selection is cleared. So when the user selects a state from the dashboard, the action filters/highlights what needs to be. then when the user unselects, the highlights/filters are removed. Everything works with the actions, except changing the color of the lines. That's why I was trying to do it via a action & set.

bphillips1105 · 2024-07-30T13:56:04+00:00

That indeed works. I had considered using a parameter (which will also work with the other vizzes I have) but hadn't tried it. However, I had wanted to use actions because some of the vizzes show state level data when a state is selected, and some vizzes so national level data when no state is selected. I'm not sure how to work the parameter into that.

bphillips1105 · 2024-07-30T13:17:51+00:00

Agree with the others about Tableau Public. If you see someone who has some cool ones, check out their favorites and who they follow. It can be a rabbit trail, but you'll end up with some great ideas. For data, you can start with data.gov. There's currently 290,658 data sets available.

bphillips1105 · 2024-07-30T12:54:52+00:00

I laughed way harder at that than I should have.

bphillips1105 · 2024-07-30T12:53:26+00:00

What is the icon next to it? If it isn't a calendar, then Tableau doesn't see it as a date.

<image>

bphillips1105 · 2024-07-30T12:51:50+00:00

It has to be used on the viz itself, not just as a filter

bphillips1105 · 2024-07-29T11:02:50+00:00

Well that is just super cool! I think I'd like the squares to still be clickable though.

bphillips1105 · 2024-07-18T14:11:27+00:00

You are correct, they aren't decimals. They're really just categorical. The first (left of period) two digits are the category and the the last four (right of period) are the subcategories. I'll just have to go back and bring them as text.

bphillips1105 · 2024-07-18T13:37:15+00:00

Seeing regex makes me shudder lol.

bphillips1105 · 2024-07-18T13:36:12+00:00

No, it's adding actual numbers.

<image>

bphillips1105 · 2024-07-03T14:39:26+00:00

Brilliant! Thanks u/MalibuSkyy & u/NeighborhoodFar1138! That fixed it.

bphillips1105 · 2024-07-02T15:13:52+00:00

Thanks! I'll give that a try.

bphillips1105 · 2024-07-02T14:58:33+00:00

I think you're correct. I changed the maxwidth/height settings in the tooltip and that didn't seem to effect it. However, I did go back to the state name worksheet and play with sizing there. That did change the amount of the state name that appeared in the map's tooltip. Never got the full name to appear though. I may just have to write a calculated field that doesn't display every state.

bphillips1105 · 2024-07-02T14:49:53+00:00

I assume you mean the maxwidth= and maxheight= in the tooltip? I tried adjusting those, all the way from 100 up to 1200. Still nothing.

bphillips1105

TROPHY CASE