Asutosh Jha

I am having 3 measures. How I can create the dual-axis with these 3 measures

To do that we have alternative options available. Let’s say we want to accommodate sales, quantity, and profit. So, we can put measure names including sales and profit and quantity separately. Then measure names and quantity will be in dual-axis as shown below-FILTERS

Tableau

Answered Nov 7, 2019 · 1.7K Views Read answer →

how to show running total in case of the stacked bar chart

By default, when you scatter the bar chart, individual bar text will be shown to you. If you want to show total numbers at the top then you need to add a reference line. To do that, right-click on axis and select reference line as shown below. Here depending on the calculation, you can select the options like per cell…

Tableau

Answered Nov 7, 2019 · 2.3K Views Read answer →

When to use live and when to use extract connection

Live can be used when- 1. You need data in real-time 2. Your source is optimized for the performance 3. You don't have a lot of data at the backend 4. Not many transformations are involved which can slow the performance The extract is preferred when- 1. When a database is not optimized for performance 2. You don't…

Tableau

Answered Nov 7, 2019 · 1.4K Views Read answer →

Why I am unable to get the custom shapes

If you have added the custom shapes in the shape folder in the repository and still not getting it while use, follow the below. Marks Shapes More Shapes Reload shapes This should load the added shapes in the repository. If still not found, check whether you have added the shape at the correct location or not. Data…

Tableau

Answered Nov 7, 2019 · 1.5K Views Read answer →

How to put an image in the worksheet?

To add an image to the worksheet, you need to take the help of the marks card in the worksheet. Follow the below steps to add an image to the worksheet. Put the image in the shapes folder which can be found in C:Users\My DocumentsMy Tableau RepositoryShapesMy Image Now create a calculated field with the formula…

Tableau

Answered Nov 6, 2019 · 1.7K Views Read answer →

What is the difference between bin and histogram?

Technically, BIN is a part of the histogram. For example-Here the age range that you see is nothing but the BIN size and those intervals are the BINs.

Tableau

Answered Nov 6, 2019 · 1.7K Views Read answer →

How to find a running total of sum and so in the tabular chart?

Let's say you have a tabular report for product name and profit. and you want to show the running sum of profit. to do that just click on the profit drop down And go to quick table calculation. Here select running total.

Tableau

Answered Nov 5, 2019 · 1.5K Views Read answer →

Is it possible to create an animation where I can show a 2 line graphs grow and then end up showing the complete chart?

Yes, This can be done. You need to take the help of the pages in this case and you also have to change the mark type from line to Circle. if you also want to get a longer timeline you need to drag an instance of order date in terms of year and another instance of order date in terms of the month. Also, on the page,…

Tableau

Answered Nov 5, 2019 · 1.6K Views Read answer →

can we draw a line between two values that are from different months and there are no continuous dates between them?

Yes, this can be achieved with the help of a line chart. Usually, what happens when you drag these Dimensions & Measures into the self, Tableau will automatically select the best chart for your data. All you have to do over here is go to the March self and from the chart type, select the line chart. by default, it…

Tableau

Answered Nov 5, 2019 · 1.5K Views Read answer →

How to convert a dimension to measure or vice versa?

Dimension can be converted to measure just by right-clicking on it and selecting the option convert to measure.Similarly, you can convert a measure to dimension by right-clicking on it and selecting the option to convert to dimension.

Tableau

Answered Nov 5, 2019 · 2.0K Views Read answer →

How to rename the columns in the dataset in tableau?

You can clear the aliasing to remove it. This can be done from the data pane and either you can remove aliasing from one value or even from all the values of the columns. The value for which aliasing has been made, you will find * over there. Just click on clear to remove all the aliasing from that column.

Tableau

Answered Nov 5, 2019 · 1.5K Views Read answer →

How to create a binary datatype result in the dataset

The binary data type can have only 2 values. Usually, those will be either a 0 or 1. For example, let’s say you have a sales column that has multiple values. Now let’s say you have a threshold of $5000 and you want all the values less than 5000 then it should be 0 else it is 1. To do that you can create a calculated…

Tableau

Answered Nov 5, 2019 · 1.6K Views Read answer →