Asutosh Jha

How to sort the table on the calculated field which is not in the table?

To sort the table on the calculated field, which is not in the view, you can take the help of custom sorting. right-click on the diamond Sun and select sort. are in the drop-down select field and then select the field on which you want to sort the report.

Tableau

Answered Dec 11, 2019 · 1.6K Views Read answer →

I am having problems creating a pie chart in tableau. can someone help me with the requirement for a pie chart

The pie chart is a directly available chart in tableau. it is used to show the proportion of some measure. The pie chart is also being considered as an alternative to a bar chart. And so, when you have to display the proportions of the data, we majorly go ahead with the pie chart. in the pie chart instead of showing…

Tableau

Answered Dec 11, 2019 · 1.6K Views Read answer →

I have a line chart for months. I don't have any value for July and that is getting skipped. how to ensure July over there?

This is our default Behavior, Tableau follows while creating the report when you don't have data for some specific or date. That particular month will be escaped while developing the report in such cases. If you are looking to sort that month also where you don't have any that I have labeled all you have to do is…

Tableau

Answered Dec 11, 2019 · 1.6K Views Read answer →

I have a dimension with 10 values. I want to make a filter on that with just 2 values where each value will have 5-5 members, how to achieve this?

For this you can create a set of 5-5 members each or even you can achieve this with the help of a calculated field. Let’s say you have to create group 5 members from a subcategory field. So, I can quickly create a set on the field and will select the members of the sub-category needed to be part of the set. And here…

Tableau

Answered Dec 11, 2019 · 1.6K Views Read answer →

When I have just one parameter, how to create a dual-axis in this case.

First, think about whether you really need to create the dual-axis? If yes, you can duplicate that field and then can create the dual-axis as you do for other requirements.

Tableau

Answered Dec 11, 2019 · 1.6K Views Read answer →

How to pull CSV data from the tableau server using REST API?

With the help of REST API, you can manage and update the resources available on the Tableau server. use tabcmd, it's really easy to configure. You can use the trusted ticket API or REST API to get a ticket and then curl or equivalent and a specially constructed URL. Do it all in code, see this example from VizAlerts…

Tableau

Answered Dec 10, 2019 · 3.5K Views Read answer →

Can I use the same parameter to more than 1 worksheet?

Definitely, a parameter is an independent dynamic control and can be used in any number of places. Just make sure whatever value of parameter you select for one sheet, the same will be applied to remaining also where the same parameter has been used.

Tableau

Answered Dec 10, 2019 · 1.4K Views Read answer →

I have to recreate a Tableau visualization that is currently created with python (plotly). I have a dataset which contains

● OrderID,int ● OrderDate,DateTime ● LeadTime to order, days I would like to create a grouped bar chart (2 groups) containings the total orders received (count(orderID)) and also another group of orders which were done below 5 working days. I am a newbie to Tableau and I need some help. Let me know how I can produce a…

Tableau

Answered Dec 10, 2019 · 1.6K Views Read answer →

I have a dataset with 1 dimension and 3 measures. I would like to create a stacked bar chart using two of the measures, with another bar chart side by side with the last measure. But somehow, I…

Directly it won’t be done as you will end up creating side by side chart. Let’s consider the sample superstore dataset. Also, consider the dimension as Category and measures as Quantity, Sales, and Profit. To achieve this, we need to go to the data pane where we need to create a union to duplicate the data. Now create…

Tableau

Answered Dec 10, 2019 · 2.1K Views Read answer →

How to change the background color of the entire worksheet

Follow the below to achieve this- Right-click anywhere in the worksheet pane and select format Now a format pane will be opened at the left side Select sheet tab and color icon Then under the default section, click on the dropdown of the worksheet and select the color of your desire

Tableau

Answered Dec 4, 2019 · 2.1K Views Read answer →

Is there any option to start the day of the week from Sunday

Yes, can be done. Just right click on the dataset and select date properties. And from the popup, customize the week start day.

Tableau

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

how to make a group on bins. I have 100+ bins and further want to group it

It can be done with the help of a histogram instead of creating c. Create a histogram and then group the data. Also, as you cannot create a group on the Bin directly and so you need to use a calculated field group those intervals. You may check this article for the detailed steps to create groups on bins-…

Tableau

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