Press J to jump to the feed. Press question mark to learn the rest of the keyboard shortcuts
1

Im trying to display information from a mongodb coordinates Column but it looks like tableau doesnt understand lat/lng in one column. Is that true?

1
2 comments
4

Is this possible?

Would like to highlight if our company's market share is lower than competitors (with products as dimensions) . What makes it more complicated is that our holding has 2 companies, so we'll need to compare each company with different competitor.

This is how I want it to look like:

https://imgur.com/97yf3Ft

I thought it was possible with Tableau 10.2 and up, but apparently I've got Tableau 2018.1

Come to think of it, what's the difference between Tableau 10 with 2018 exactly? Cant find any comparison online..

4
12 comments
2

I'm in the process of setting up 2018.2 with SAML and running into issues connecting from tableau desktop. I get a certificate error from tableau desktop but am able to connect via browser without any issues.

2
4 comments
1

Sorry if this has been asked before, when searching online I have found similar requests but not enough to get me there.

First of all, I have gathered that Tableau only wants to show line charts when dates are present. I want to show fiscal quarters (1 - 4) by week (1 - 13).

How do get my fiscal quarter weeks (already in the data) to show up as a date?

1
2 comments
1

I have some website data at the individual url level, but the way I'd like to analyze/visualize it is by rolling it up at each page path, so I can see which page paths are contributing the most to each metric.

For example:

URL Visits
example.com/a/b/c/d/1.html 100
example.com/a/b/c/d/2.html 100
example.com/a/b/e/f/1.html 100
example.com/a/b/e/f/2.html 100
example.com/a/b/g/h/1.html 100
example.com/a/b/g/h/2.html 100
example.com/w/x/n/m/1.html 100
example.com/w/x/o/p/2.html 100

What I would like to do is roll it up at each page path contained in the url.

So something like this

  • example.com/a/b/ | 600 visits
    • example.com/a/b/c/ | 200 visits
    • example.com/a/b/e/ | 200 visits
    • example.com/a/b/g/ | 200 visits
  • example.com/w/x/ | 200 visits
    • example.com/w/x/n/ | 100 visits
    • example.com/w/x/o/ | 100 visits

This is obviously a very simplified example, and not the greatest illustration, but the actual data is millions of urls that I'd like to group by their respective page paths and I'd preferably not have to continue doing it by hand.

Right now, the way I've been doing it is by creating a dimension called 'url rollup' and then writing a bunch of if/elseif statements to identify the various rollups like so...

IF STARTSWITH([URL],"https://www.example.com/a/b/c/") THEN "/a/b/c/"
ELSEIF STARTSWITH([URL],"https://www.example.com/a/b/d/") THEN "/a/b/d/"
ELSEIF STARTSWITH([URL],"https://www.example.com/a/b/g/") THEN "/a/b/g/"

Is there a simpler way to do this without hand coding a bunch of if/elseif statements?

1
2 comments
0

I am attempting to use a live connection through Tableau server. When i connect to my data sources (three excel files all stored in the same network folder) and save the .twbx file it creates copies to my local Tableau repository. Two of the files update on a subscription from a SQL server that I do not have direct access to, that is why I need the Live connection. I tried changing my repository to the network and it seemed to work, but Tableau keeps changing the data source to the local location. How can I get Tableau to use the network repository I told it to or get it to not use the local location?

I am relatively new to Tableau so forgive me if I am missing an pertinent information. This is also the first time my department is attempting a Live connection so even my normal resources are stumped.

0
10 comments
14

Finance guy looking to maybe learn tableau but I don’t work in big data, just traditional corporate finance

14
19 comments
2

For this worksheet

https://imgur.com/ma54KCz

All plants whether "m", mother or "d" daughter are of a particular variety and each has a unique ID, I'd like to know which varieties produced no daughters, or have no "d" on the [Mom/ Dot], and still view the ID of each plant on the viz.

I'm new to tableau and I assume I have to use COUNTD and IF together to get "0" as output, but keep getting syntax errors. Is there another way to know which varieties don't have a "d" mark and also know the ID of every plant.

Thanks in advance

2
3 comments
6

I've been browsing Tableau jobs for the past couple of weeks and most of them require SQL proficiency. I've got 2 years of experience working with Tableau but I'm only using excel and the automated API's as my data sources. Should I start looking for a more specific job title(i.e. visualization specialist)?

I'm open to learning SQL too if anyone has some resources on SQL for Tableau too.

Thanks!

edit: I've got my first interview at Red Hat on Monday. Not quite sure how to handle the SQL question that I will be getting.

6
31 comments
4

Hi!

This will be my first Tableau Conference. It looks like it's Mon. Oct 22-Thurs. Oct 25. Does this mean I have to attend all four days, meaning I would arrive to NOLA on Monday and depart Friday (so 4 nights)?

I know it's last minute, but my employer just registered me for this and I'm getting anxious trying to plan and figure this out, especially for my hotel stays.

Thanks in advance!

4
18 comments
1

What I realized today, is that it seems that sheets that are created using Measure Names and Measure Values are not able to perform dashboard filter action and you will not be able to use those sheets as filters on a dashboard like you would if you would use regular fields for rows and columns. You can set the action up, but nothing will happen on click.

Pic is what I currently have: https://i.imgur.com/qfCC1AP.png

Is there a workaround to get the same desired result without using Measure Names and Measure Values?

1
4 comments
1

Has anyone tried to create something like Strava where you see where you rank with +- 2 riders above and below you and then the top n riders? Example:

Top 5 Riders
1. Bob: 10 min
2. Tim: 11 min
3. Rocko: 15 min
4. Baltasar: 16 min
5. Clint: 17 min

Where I rank:
255. Harold: 22 min
256: Erik: 23 min
257: "ME" 24 min
258: Bo: 25 min
259: Bob Saget: 26 min

Basically does anyone know how to find the rank of an individual and show +- n ranks above/below that?

1
4 comments
2

https://imgur.com/lSgZzRC

In the above, how do I count and filter just the varieties that do not have a "d" in the "mom/dot" column, like Bean, Carpathian and Feliz--"m" stands for mother (which they will have) and "d" stands for daughter which not all "m" s will have.

Also, how do you find the total number of rows there are after any type of filtering like the Excel average, count, sum indicator on the bottom right of each sheet?

2
2 comments
1

I have a dataset on crimes. I have individuals, their ID #s, case ID #s, types of charge (4 categories), and verdicts. I can have multiple people with the same case ID if they committed the crime together. This creates a huge problem, because I only want to see the distinct count of cases for each category which resulted in a guilty verdict and the count of those for each category that resulted in a non guilty. When I do a distinct count based on case ID it still double counts because the people could have different charges and different outcomes with the same case ID. what do I do? I thought about only counting the most severe outcomes, but I'm not sure how to do a distinct count based on that.

1
10 comments
12

Looking for some general guidance on what I should include on dashboards for mobile use. Make the simple, have the basic information and not much more. But what else?

12
7 comments
1

I have one row header that is much smaller than the others. I can't shrink the size of that row without shrinking all of the rows since the height of the rows is fixed to be uniform. Any suggestions?

1
comment
1

Hey everyone, I wasn't really sure which subreddit to post in but this seems probably best.

I've just landed a new job which is half supporting the company's marketing team with ad hoc jobs, half preparing reports on marketing, customer data using tableau and some SQL.

I've seen from the subreddit people saying that Tableau-focussed careers are a thing so that's put my mind at rest a little. But my question is, what should I learn? What books should I read? And what extra skills should I pick up?

I'm good at presenting data, it's just been a long time since I've used any math. I don't want to get into any heavy coding or database management because I know without a math, stats etc. degree I'm well behind fresh graduates. So what would be your advice for someone who has landed this kind of job? How do I prove my worth and maybe open up other opportunities in other areas in the future?

I've taken some online courses in Tableau and plan to continue learning that. I also might brush up on my stats skills if it will be useful?

Im really hoping for some good book recomendations as well as ideas for what to branch out into.

Thanks in advance

1
12 comments
2

Album

I am working on creating a table of strings and numbers. Currently, I am hoping to orientate my row of dimensions (no measures) vertically, like this table with measures.

When I swap the rows and columns, I get this mess.

Any way I can get it looking like this type of table, but with strings instead of numbers?

2
3 comments
1

Hello,

New to tableau, so be nice Reddit! Is there a way to use an apply button instead of the pause button when using multiple filters for your dashboard. I want to go through all my filters, then apply the changes at once, instead of updating as I choose each filter.

Thank you!

1
8 comments
Community Details

10.6k

Subscribers

34

Online

Tableau makes software for data analysis and visualization that is easy to use and produces beautiful results. /r/Tableau is a place to share news and tips, show off visualizations, and get feedback and help.

Create Post
Cookies help us deliver our Services. By using our Services or clicking I agree, you agree to our use of cookies. Learn More.