I know this is for excel, but any Tableau experts here can let me know how to present my mixed (countries, states, provinces) data on a map. I’ve tried dual axis but still not where I want it to be.

like
Posting as :
works at
You are currently posting as works at

The only success I’ve had with this is via spatial (.shp) files. So hypothetically tableau could draw the contents of a .shp file’s “geometry” column, and I imagine the shapes for different entries could vary by country, state, province. I don’t know how to create such a file, but it’s a starting point. Maybe get mutiple spatial files for each geo type and union?

I have absolutely beat my head against a wall with dual axis - I think it’s still pretty limited. I’ve pulled off points +boundaries , but for multiple overlapping boundaries, things break down pretty quickly. IF you have boundaries that are subsets of larger boundaries (eg counties, states) things can work, but I’ve had no luck with mixed data like this I’m afraid.

Exactly what I’m going to say to my SM ^ haha. Thanks again!

like

Related Posts

28 years old, single. $250K net worth, $250K pre-tax annual income. Tips on how to save / invest for my future? Kind of a noob at this

like

What's a good vendor for retargeting-through-direct-mail? (User visits website, then we send them a postcard... relating to whatever they browsed, or maybe cart-abandoned). TIA!

like

Does anyone have experience using Microsoft Projects for large engagement management? Pros and cons?

like

What are y’all’s takes/advice about the UC Davis MBA?

like

Anyone married but still have feelings about your ex? Like you love your SO but still have lingering feelings?

like

Trump isn't doing sh*t until 6PM tonight

Post Photo
like

Looking for job in Deloitte .
Anyone can help

like

Looking for a skilled Account Manager to join my team! Hybrid schedule for a digital marketing agency that’s located just outside of Portland OR. Clients go from large to small businesses. DM me if you wanna learn more!

like

Hi , is there someone who can refer me for an open position?

like

Is it a fail of character leaving biglaw? I want to leave, but despite the constant stress and suffering, I can’t avoid feeling like it’s my fault or that maybe I’m over exaggerating how I feel. All my colleagues feel ridiculously happy, I’m the grinch one that’s never enjoying the grind (but the grind is hard and competitive, very competitive) :( any thoughts? Is there future after quitting biglaw so young?

like

Arnold & Porter Not matching Cravath. What is happening? Do we think they’ve decided not to match or is this just a hiccup? Do we expect more firms even in the V50 to not match?

like

Looking for suggestions on how to break into this space.

I'm a RN who's worked in sales for 14 years within the industrial and energy spaces. Yea, I know, super random for a nurse, but I excelled greatly.

I still work weekends as a nurse and would love to combine my business acumen with my education by working for a pharma, biotech, or medical device company.

I've applied for these types of jobs and get nowhere. But when I apply to engineering organizations I get called immediately.

like

Any good articles, notes , YouTube videos about intraday trading for newbie ?

like

Unpopular opinion - we inherently rank and cater to certain minority groups over other. We fail to recognize the struggles from these other minority groups and focus on the issues being pushed on social media and in the news.

like

Hi fishes, Will it be okay to quit in probation period like within 3 months if we get a better opportunity? What are the factors to be considered before making any decision.

like

Two offers for rising third year in London - for advisory/securities/M&A at Akin Gump or PE/M&A at Sidley but the latter with retention at 2nd year for 2022 with bump to 4th year (ie back to peer level) based on performance. Thoughts on the firms and offers?

like

Hi. I am a frontend developer (lead software engineer) working primarily on react. I am persuing an online masters in CS and want to shift to AI/ML domain in the upcoming year or 2. Please let me know what career paths are viable and profitable.
YOE: 7
CTC: 42 lpa +12l vested over 4 years
WLB: functional and want to keep it that way!

like

Is severance negotiable or is there some type of policy that dictates how much a company can pay out (eg maxes out at two months salary). A friend was just a casualty of a RIF.

like

I've been requested an expected salary range by a recruiter for a position in what I think is a lower cost of living area than the one I'm currently residing. How do you answer such a question?

like

Is there anyone working at HCL singapore around 12 years experience or senior here ?
I need some help and input.
Please feel free to DM me.

Additional Posts in Excel Genius

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

like

Anyone hit a manual on how to do EVERYTHING in excel 😭? PDF or something

like

What are your favorite excel macros to make you more efficient at work?

like

What’s everyone’s favorite keyboard? Thinking about switching mine up

Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

like

Does anyone know how you can create a pivot table that results in calculations being performed from that pivot table, where if the pivot table changes, resulting in more/fewer rows, it moves the formulas up or down depending on the additions/removals?
Basically, have a dataset, trying to select all rows where the answer in one column is Yes and answer in another column is (for example "X"), and multiplying the amount in another column by 16%.

like

Just here to praise the Unary Operator. Old school programming trick that’s still very relevant.

In Excel it’s =--(Range =or other logic op Condition)

like

Not Excel but Outlook: anyone know how to make it so others can’t recall messages from your inbox?

like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

Can anyone provide a reference to how to efficiently create and link an excel spreadsheet into a ppt (and make it dynamic). Thanks in advance!

like

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

like

Help!! Time-sensitive:
Please tell me how I can achieve this:

To create concatenation of every possible combination of Type to Price for every ID.
I provided an example below with the outcome I want in the second table. Would prefer if this be down without a macro.

Post Photo
like

Does anybody have a link to download the tts turbo macro? Sad that you can't download it anymore :/

like

I’m having a recurring problem of my data sets being too large and the number of calculations I need to do being too many (workbooks become so sluggish that more time is spent waiting than cleansing/analyzing).
What’s the switch I need to make to accomplish my analysis without the lag? I’m already using .xlsb, manual calcs, single source of data, no volatile formulas, etc.

like

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

like

Hello Excel champs , need your help with the below screenshot. First table contains the master data with Parent and Child item details. Agenda - is it find out all the child items pertaining to make 1 unit of the corresponding parent item. In this example I took Parent Item A and exploded all the Child items and the required units to make 1 unit. Now the challenge is that I have a master data of 250,000 line items and I am trying to figure out the exploded version of all the Parent items.

Post Photo
likesmart

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

like

Wait … xlookup is basically VLookup and Index/Match?

Is this seriously a viable alternative because what the hell have I been doing with my life?

likefunnysmart

I have a column of numbers with a “Special” format. I need these to be a date but when I select the date option from the drop down in the number dialog box it returns as all hashtags. I tried date value, substitute functions etc but nothing seems to work. Any suggestions?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal