Tableau Analytics

Tableau filter to find Weekend or Weekday Create a calculated field using the date field with the case statement as shown below: CASE DATEPART('weekday',[Report Date])     WHEN 1 THEN 'Weekend'     WHEN 2 THEN 'Weekday'     WHEN 3 THEN 'Weekday'     WHEN 4 THEN 'Weekday'     WHEN 5 THEN 'Weekday'     WHEN 6 THEN 'Weekday'     WHEN 7 THEN 'Weekend' END Then drag this new dimension into filters pane and show filter. You can select the Weekend or Weekday option in the filter so that the data in the sheet which has the date field will change accordingly.

Sorting Filter Values in Tableau When you right click on a filter there is no option to sort it. Even the option is not available in filters pane. Here is a simple way to do so: From the Data pane (where the Dimensions and Measures are displayed) right-click the dimension that you want to sort, and then select  Default Properties  >  Sort . Select  Manual , adjust the sort order using up and down arrows, and then click  OK as shown below:

Tableau Error "Trend line cannot be computed" WIth the When you try to add trend lines to views, the following error might occur: A trend line cannot be computed. Typically, each axis should be either a number or a date. Refer to the Help for more information. To Fix the issue Right-click the date field on Rows or Columns, and select Continuous(usually date filed) as shown below. Now you can click on the mark(line or Bar) and select Trend Lines. You can see the trendline displayed.

Forecast Option Not Available in Tableau Desktop When you select  Analysis  >  Forecast , the options are not available (grayed out), and you are not able to use the forecasting functionality. Fix To fix the issue, take any one of the following steps that apply to your workbook. Remove table calculations. If the date field level is Exact Date, choose a different date level such as Week, Month, Qtr or Year which suits your requirements. Remove totals or percentages if they are displayed on the view.  Make sure that there are at least five entries in your time series. For example, if your date level is set to years, you must have at least five years of data, if months, at least five months. Remove measures from the Filters shelf. Make sure the data does not contain any nulls.  Cause A component of a data source or view that the forecasting functionality currently does not support is included in the view. More: In few instances, right...

Force to show dimension labels even if there are no values Show the Dimension (values even if there is no data for the dimension in the measures, Show all the dimension labels always, regardless of whether or not there is data. It is a simple setting in Tableau and no need to work on any complex sql side manipulations. Go to Tableau desktop Analysis Table Layout Select SHow Empty rows as shown That's it you will see the empty rows now.

Hiding Zero Value Labels In A Pie Chart By default Tableau shows the 0 values for the categories for which the data is not available. It is most requested by  users and is also common sense to hide these zero values. To Resolve the issue, change the measure calculation  to: IF [Measure Field] = 0 THEN NULL ELSE [ Measure   Field] END

Last 12 Months calculation in a Measure in Tableau Create a measure using the calculation below: IF ( [Report Date ] >=DATE(DATEADD('month',-11,Today() )) AND [Report Date] <=DATE(Today() )) THEN [ Total Sales ] END