Asutosh Jha

Show the average value of the chart like a circle in the bar chart

You can achieve this with the help of the donut chart in tableau. Just follow the below steps and get it done- Drag the required dimension and measure in the row and column shelves Make the chart type as a pie chart Now add that measure again Make it dual-axis Again make that pie chart again Now adjust the sizing and…

Tableau

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

Can I use the color gradient with line chart

Yes, just drag the measure to the color shelf and it will be scattered on that as shown below-

Tableau

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

How to use the groups as a filter for a bar chart for category vs sales?

Let's say we have a bar chart for category versus sales like below-Now let's create a group on the category by selecting two of these categories-Now just right click on the created group and select show as a filter. you

Tableau

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

How can I make sure the axis start where there is actual data and not as much white space in a continuous plotted line chart.

This can be achieved with the help of functionality called a fixed axis. create your report and then right-click on the axis and select the edit axis. Hereby default, the range will be selected as automatic and you need to select the radio button called fixed. Once the fixed radio button is selected, you will get an…

Tableau

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

How to connect tableau with salesforce?

Tableau can be connected to Salesforce in the same way you connect it to any other server. Make sure you have an account on the Salesforce with valid authorization. Once done, go the data pane and follow to a server → More-->Salesforce This will open a pop-up for you. Here enter the details and connect. Now you will…

Tableau

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

Do I need to write level access on the dataset for the data to refresh on the server?

No this is not required. Even if you have the read-level access on the database then also you will be able to publish the report without any issue. Just publish the data source to the server and schedule it to the Tableau server and it will keep on refreshing as per the schedule you have defined.

Tableau

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

I have some reports on my desktop and I want to only publish those reports which have been updated. How do I do this?

I don’t think that can be done if you have all the dashboards in the same workbook. If you have those available in multiple workbooks, you can definitely publish all those separately. But if all those dashboards are in the same workbook, then it can’t be done.

Tableau

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

What all kind of combinations I can use in dual-axis

You can use combinations depending on your requirements. You can make the below combinations which are pretty popular and useful- ● Bar-bar ● bar-line ● Bar circle ● bar Gantt etc.

Tableau

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

Can I create a stacked bar chart in the dual-axis?

As we need to create a stacked bar chart in dual-axis and so consider that we are looking to show yearly sales which should be scattered on category and profit trend. To do that first drag order date and sales which should be bar chart and scattered on category as below- Then drag the profit after-sales and select…

Tableau

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

how to assign different colors to different bars

Depending on the dimension you have used in the report, you can use the same report to the color shelf and it will assign the different colors to different bars. Later if you want to change those colors, just follow the legend and select the desired color. For example, if I have a report for segment vs sales where the…

Tableau

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

Will there be any issue if I have converted a dimension to measure unintentionally

Although you won't get any error if you're converting a dimension to measure or vice versa. But be sure to understand your data while doing the conversion. If this conversion has been done by mistake, then you can always change it back just by right-clicking on it and select the required option- Dimension/Measure

Tableau

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

Why my extracts are not getting refreshed

There can be many reasons behind this. If your data is in any database, then please check the kind of permission you have. But when you have an excel sheet and the refresh is getting failed then there can be many reasons behind this. One common reason for this can be residing in the file locally. Make sure your excel…

Tableau

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