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

Looking for a good resource on improving my dashboard layouts.

4
3 comments
6

So I'm trying to create an animated map of cumulative counts of events by census tract, but can't seem to get the cumulative part to work, specifically when there are years with no events.

By putting the year on the Pages pane, the map only shows data for each year, effectively filtering the other years out. What I want is for each year to add onto the previous year. So if there are 6 events in 2009, 9 events in 2010, and 5 events in 2011 for census tract A and 3, 0, and 4 events for census tract B, I want the map to show 6, 15, and 20 events for A and 3, 3, and 7 for B. This is easily achieved using a running sum table calculation.

This all works fine when there are events EVERY year (a la census tract A), but that's not the case for almost every census tract. For census tract B, the map will show 3 for 2009, disappear from my map for 2010, then 7 for 2011. Is there a way I can retain the running sum so it displays even on years where there are no events?

Right now, I get a map that looks like this for my final year: https://i.imgur.com/21g6lzn.png

But I want to get something like this: https://i.imgur.com/225L21A.png

Any ideas?

6
4 comments
2

Hi

Is there a formula i can use to show data for the last prior week (sunday - thru monday) of last year?

Thanks,

Anna

2
8 comments
2

Hi

Is there a formula or calculated field I can use to look for the last two full weeks of data in Tableau? I want this to always show the last two FULL weeks regardless of what the current day is.

Thanks,

Anna

2
4 comments
1

I'm looking to implement a single date filter for my executive summary dashboard where the user would use the single value slider to filter through the last 7 days. I'm not sure how to implement it. Currently I have a single value slider but it includes all dates in my table. I want to restrict it to only the past 7 days. I know I can manually check box the dates, but when the next day comes, I want the 7-day set on the slider to update accordingly since my table has millions of records coming in daily. Also, I'd like to get rid of the (All) option on the slider. Any ideas how I can do this?

1
15 comments
0

I've been trying to get an excel document that uses Week numbers (ex. Week 17, 2018) to be recognized as weeks in Tableau. When I right click the date field-> default properties -> Date format..., It lists '2001 W11'. This is EXACTLY what i want as a date field, but Tableau refuses to recognize my fields. Even when I made all of my cells match this syntax, it pulls in as null values into Tableau. I've been searching all over google and I can only find things where people are trying to convert full dates INTO week format. I already have my data in a week format, but am having no luck finding the proper answer. Could this be something silly and simple that I am overlooking?

0
6 comments
0

Hey y'all,

I'm just wondering on the application integration within Tableau.

According to getapp, it's not possible but according to (https://www.equinox.co.nz/blog/integrating-tableau-into-your-application), it is possible.

Anyone have experience with this and if application integration isn't possible, any other software have easy and accessible app integration?

Thanks

0
3 comments
0

In my dashboard I have a sheet placed in that contains a bar graph with Years as the Column and SUM(Number of Records) as the Row.

There's a filter for car brands and whenever I select one say "Honda" and there's no data at all for the years of choice then the entire graph is gone with only the titles remaining, the sheet is all blank. I want to set alerts on the axis but since the axis disappears when there's no data then I basically have to wait till I see a data point.

Is there any way around this? Tried to change table layout, etc but no luck so far...

Basiclly would like the y-axis to remain (# of Records with the tick marks) and the x-axis (Years) even if there's no data point at all (Filtered).

0
14 comments
0

Is there a way to make a dimension static? When I pull in a measure, if there is no data representing the dimension, the placeholder of the dimension disappears, I need the measure to read 0. I have tried some calculations, SUM(IIF(([Dimension]="Y"),1,0)) and I have also replaced the 1 with another dimension to count and still not returning a 0 value. Any help would be great!

0
5 comments
0

In Tableau 10.2, is there a way to compare whether the column data type and column names have remained the same, between two refreshes while it is connected to a database server?Also, is there a way to determine if new columns are added or previous ones dropped. All this is required without having to look at data repeatedly. An expression to check this would be great. It so happens that sometimes the column datatype or name has been changed between refreshes and it messes up with the entire dashboard. Is there any other way in tableau to detect such changes or screw ups? Thanks

0
3 comments
7

I obviously don’t want to lose $500 bucks. I got the Desktop 9 Qualified Associate in 2015 and then got certified with the new Qualified Associate test Dec 2017. Still a bit hesitant on whether I can pass the Certified Professional though.

Edited for clarification: The test isn’t 100% mandatory, I won’t get fired for not taking it. But my manager has said a couple of times that he wants me to take it. It’s optional but still being pushed on me, if that makes sense.

7
27 comments
3

We have millions of rows of business contact information (name, address, phone, category)  from multiple sources that we would like to combine into functioning datasets. We are looking for a replicable process to produce and manage clean datasets & a method of managing/storing data for future manipulation.

Must have expertise in:
-Joining, filtering, grouping, transforming and cleansing data across any number of sources
-Fuzzy matching, appending, find and replace, and data reformatting

A successful candidate will be able to create replicable processes for:
-Removing erroneous data
-Normalizing business names "IBM" vs "International Business Machine" vs "IBM co"
-Normalizing inconsistencies in any field (Name, Address, Phone, Category)
-Determining accurate fields (Name, Address, Phone, Category)
-Creating groups and subsets from data
-Etc...

3
13 comments
2

I have a standard line graph with a measure on the y axis and time (in months) on the x axis with a forecast at the end of the line. I'm trying to show mark labels in 4 month intervals. Is there a way to do this?

2
8 comments
1

https://community.tableau.com/thread/276089

This is the link to my post. If anyone could offer any guidance I would really appreciate it. This problem has been tormenting me for quite some time.

1
8 comments
2

I have a little over 2000 addresses that I would like to get the latitude and longitude for to put on my Excel spreadsheet so that I can get a nice map in Tableau.

Are there any free batch geocoding options out there? My search of google made things more confusing and frustrating because they said they were free but would make you input credit card information or they were too confusing for me to understand.

2
9 comments
1

Tableau newbie here...my data contains a ton of GL account numbers that I created groups for, "Salary" and "Non-Salary." Probably a simple solution here but I can't figure it out. If I'm already summarizing all expense in my sheet, and I just want it to separate that summation into 2 groups, salary and non-salary, how do I bring that into my sheet without it showing every single account that makes up each group?

1
1 comment
2

Hey Guys,

So I am stumped here.

I created two dashboards, (Dash 1) is of high level data and (Dash 2) is drill down data. I applied a dashboard action to Dash 1 where 'on select' my Dash 2 will filter based on the criteria selected, and this jumps to Dash 2 filtered data. Great. Step one done.

Now I want to be able apply a 2nd filter to Dash 2, filter 1 was the original dashboard action. The issue I am having is when I apply the second filter to Dash 2 my data resets and only applies the 2nd filter (disregarding the filter from the dashboard action).

So is there a way to apply a filter to Dash 2 on top of the filter from the dashboard action?

Hope this makes sense, and thanks!

2
6 comments
3

I have a dataset which looks somewhat like this;

email minutes date

[aaa@aaa.com](mailto:aaa@aaa.com) 40 10-01-18

[aaa@aaa.com](mailto:aaa@aaa.com) 60 10-01-18

[bbb@bbb.com](mailto:bbb@bbb.com) 10 10-01-18

[bbb@bbb.com](mailto:bbb@bbb.com) 40 10-02-18

[ccc@ccc.com](mailto:ccc@ccc.com) 60 10-02-18

I have created a calculated field to group the `minutes` by `date`, per `email`. This calculated field is named 'Minutes Worked' and looks like so;

{FIXED [email], [date] : SUM([minutes])}

I wish to visualize "complete days" which would be `Minutes Worked` > 80. Here's what I did;

  1. `YEAR(date) MONTH(date)` on columns.

  2. `SUM(Number of Records)` on rows.

  3. `SUM(Number of Records)` on text.

  4. `Minutes Worked` > 80 on filter.

The problem is that the viz seems to be looking at each row for `minutes` rather than the grouping per day. I thought my calculated field would handle this but it doesn't seem to be the case. How can I get around this?

3
7 comments
1

I'm attempting to create some visuals based on data in an excel file that is constantly being updated by multiple people. The issue that I'm facing is that the excel file is not savable while I am in Tableau. I think that the answer to that question is setting up the data as an extract but I am still facing that error. An error which is probably due to me setting up the extract incorrectly.


What I attempted to do:

  1. Create a new workbook.
  2. Added the excel file as the connected data source.
  3. Set the appropriate table as the source for the needed data.
  4. On the worksheet I extracted the data then set the "use extract" check mark.

The current problem that I am facing with this is that the excel file cannot be saved unless I first refresh the extracted data source. And the excel file cannot be saved at all if I am in the "Data Source" tab.


What I hope to achieve is that the excel file can be saved without intervention on the Tableau side or the excel side. Any help is greatly appreciated!

1
6 comments
1

let's say i have a list of values;

  1. cat
  2. dog
  3. rabbit

i want the user to see "rabbit" in the drop down. but when they issue the query, i want the generated sql to be

where animal_id = 3

instead of

where animal_type = 'rabbit'

is this possible?

1
7 comments
2

Hey guys. Could anyone tell me whats going on when I try and use the Top 10 by Number of Records?

I have a list of a few thousand failures across some product segments and I want to edit it down to just the top 10 most frequently occurring but when I right click into the pill and go to edit filter to apply a "Top 10" filter, the results that are generated aren't a top 10, sometimes there isn't even 10 items showing. It's basically a random selection of failures, #10 on the list only has 23 counts. When I sort the list manually, #10 has 2,633 counts.

2
4 comments
0

hi all,

As we store sensitive data, I wanted some insight on how secure the data we upload to tableau server really is.

Our server is stored on premise on a virtual machine, do you know how the data itself is protected on the virtual machine? Can any windows admin just log into the virtual machine and thus have access to all data that we upload to Tableau Server?

we just want to double check who could potentially have access to the data we publish apart from our users!

Any security insight is more than welcome.

Thanks

0
12 comments
1

I have a calculated field named `Complete Day` which looks like;

{FIXED [email], [date] : SUM([duration_minutes])}

This essentially allows me to see the total of minutes each email spent on each date. I want to build a box plot to get a handle of the data at a yearly - monthly level of granularity.

On columns I have `YEAR(date)` and on rows I haveCNTD(Complete Day). I then have\duration_minutes\ assigned to the Detail mark. This gives the following;

https://i.redd.it/ymx8fvryeha11.png

However this isn't what I need. I want the blue dots to be the calculated field i.e. the sum of `duration_minutes` for each date by email. This way I can see how many minutes each email per day.

1
1 comment
0

I created a Tableau extract using MS SQL, but now all of the calculations that include the TODAY function no longer work. Anyone know a workaround? Preferably a workaround that will allow some form of a TODAY function, so I don't have to manually change dates.

0
2 comments
Community Details

9.9k

Subscribers

56

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.