WHEN “Quantity – East” THEN DATETRUNC(‘month’,) We need to create a Date Field (Date axis) labeling to display the months. Now we have Pivot field ( MeasureName and MeasureValue), Sales and Quantity. Let’s create two calculated fields which gives us “Quantity” for Bar chart and “ Sales”for Line chart. Side by Side bar combined with Line chart Via Custom Sql SELECT To the file, and in the Open dialog box, click the Open drop-down menu,Īnd then select Open with Legacy Connection.

To connect to Excel or text files using the legacy connection, connect Option is available only in workbooks that were created before Tableauĭesktop 8.2 or when using Tableau Desktop on Windows with the legacy connection. Note: For Excel and text file data sources, this To achieve the side by side bar chart along with the Line chart, I will be using Custom SQL.You can use custom SQL to union your data across tables, recastįields to perform cross-database joins, restructure or reduce the size Dont forget to check Jonathan Drummey post which describes a generic approach for solving this type of problem. If you tried, you would have come to know that you will end up creating Stacked Bar chart in one axis and Line Chart in another axis.

Many of you are thinking that this can be easily achieved by using the Dual Axis. Order Quantity for the East and West regions should display as side-by-side bars and Sales amount for the East and West regions should be displayed as lines. Now as per above challenge we need to create “Side by side bar chart combined with the line chart”. I was checking #Workoutwednesday challenge the other night and came across the following challenge. Let us follow the steps in the following recipe to quickly create a Side by Side Bar chart. This is an extension of the Blended axes chart. The side-by-side bar chart is just like the stacked bar chart except we’ve un-stacked them and put the bars side by side along the horizontal axis. On the contrary, substantial efforts are required to build it in Tableau. Grouped bars and lines combo graph is just a couple of clicks away when in Excel.

Side-by-side (grouped) bar chart is one of them. There are vizzes labeled “easy in Excel, hard in Tableau”.

Double bar histogram maker