Advance with Assist Tag

Data

Advance with Assist: Mass Parameter Replacement

Dustin Wyers

December 13, 2018

Question: In my workbook, I’ve created my own problem. I have three parameters that are identical. I’d like to only need to update one, so is there a way to swap these without having to go to every calculation I’ve created with them? This scenario happens...

Data

Advance with Assist: Function Compatibility

Dustin Wyers

December 5, 2018

Question: I’m trying to remove the decimal from my report, but I’m getting unexpected results. With FLOOR or ROUND on my calculation, I still have a decimal. How can I remove it without formatting in the format menu all the time? Questions like this happen to...

Data

Advance with Assist: What You Need to Know About Aliases

Dustin Wyers

November 26, 2018

Question: I know I’m doing something wrong. When building views, my alias in one view overwrites my alias in another. I know I’m missing something here. Can you fill in what I’m missing? When building reports, sometimes you need a different header name. Right-clicking the header...

Data

Advance with Assist: Marking the Latest Date on Trend Line

Dustin Wyers

November 20, 2018

Question: I’ve been making updates to our Tableau visualizations, and I can’t seem to figure out how to create a mark on the latest date. I also would like to know whether that mark is more or less than the previous date. Is this possible?...

Data

Advance with Assist: Extracting Year from De-identified Text String

Dustin Wyers

November 12, 2018

Question: I have some de-identified data where the date is buried in different starting points within a text string. In Tableau, is there a way to find the year of participation without asking for help from my data engineers? Here’s an example of the string...

Data

Advance with Assist: Removing Options from Filter List

Dustin Wyers

November 5, 2018

Question: I have a long list of products in my data, but I no longer want the user to be able to select a certain few. I don’t want to exclude the data from my extract, so what other options do I have? This question could...

Data

Advance with Assist: Options for Calculating Percentages

Dustin Wyers

October 31, 2018

Question: My calculation for percentage isn’t returning the right values, but the data is there. I’m getting the sum of a single product, not the full sum. What do I need to do? Understanding what Tableau does with calculations and aggregations is important when building calculated...

Data

Advance with Assist: Changing Default Properties on Data

Dustin Wyers

October 22, 2018

The question is: We receive CSV files from our data provider which we pull into Prep. We then unionize them and output a Tableau online server file. Why can’t we edit the default properties? If you are familiar with this menu, it normally looks like this: Many...