This extension adds 10+ visualization types to your Tableau toolkit that are not present in the “Show Me” function of Native Tableau.

Create stunning Sankey Diagrams in minutes, enable your dashboard designers to use Radar Charts or compare sets using super attractive Venn Diagrams and many many more! All with the flexible power and interactivity of Tableau!

Introduction

A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values. These intermediate values can either be time based or category based. The waterfall chart is also known as a flying bricks chart or Mario chart due to the apparent suspension of columns (bricks) in mid-air. Often in finance, it will be referred to as a bridge.

A waterfall chart can be used for analytical purposes, especially for understanding or explaining the gradual transition in the quantitative value of an entity that is subjected to increment or decrement. Often, a waterfall or cascade chart is used to show changes in revenue or profit between two time periods.

Possible Use Cases for Waterfall Chart

Aggregate First category

Compare the differences in sales, per dimension, to the previous year.
Our viz is comparing all product categories sales from one year to the previous year. The size of the bars within the Waterfall Chart represent the value difference from the previous year. We have colored the bars to show whether it is positive or negative with respect to the previous years sales. This will show which category has had the best growth as well as showing which categories contributed less to current year sales.

Comparison

This dashboard shows a Waterfall chart where two measures are used in the visualization. In this particular use case, we configured our datasheet to use “Measure Names” and “Measure Values” to visualize the decomposition in product categories of the difference between Budget and actual Sales. The graph shows the contribution of each product category to the actual sales with respect to the budget (over budget is in blue, under budget is in pink)

Subtotal

This dashboard shows a Waterfall chart where Sub Totals can be part of your Waterfall Chart. The chart below shows an example of the conversion of Gross Sales to Net Sales. All cost components are shown, and a subtotal of transport (shipping and return) costs is visualized as well.

Preparing your data

The ShowMeMore extension can connect to an existing visualization (or table) in your dashboard to retrieve the data. Best practice and performance wise however we recommend creating a dedicated datasheet for the Waterfall Chart. To create a dedicated datasheet we recommend dropping all dimensions and measures you want to use in your Waterfall Chart on the details of the marks pane in the datasheet. This will enable the best performance and allows dashboard actions to act on this dedicated Waterfall Chart, read more in our BLOG. Your marks pane should look similar to this.  

You need to add the datasheet to your dashboard since the ShowMeMore extension is a Dashboard Object that retrieves data from a sheet that is present on your dashboard. Once you added the blue squared datasheet to your dashboard you can hide it by making it a floating container and resizing the container size to 1×1 pixel. The datasheet has to remain on the dashboard!

Setting up your Waterfall Chart

Once you have added your datasheet to your dashboard you drag the extensions object to the dashboard and locate your ShowMeMore ‘trex’ file, supplied by AppsforTableau. Using the extension dropdown open the configure screen. Select your datasheet and Waterfall chart from the ShowMeMore Gallery. Note: At least 1 Dimension & Measure is required.

Configure Screen

Choose the dimensions and measure you wish to be displayed in your Waterfall Chart. Be sure to add any missing dimension or measure to your data worksheet and reload the extension.

Category

The category will be the starting and ending point of the series. In our example this will show us which category produced the biggest sales in each particular year. Other categories could be revenue to net income , the waterfall chart will portray how your initial value is affected by a series of intermediate positive or negative values.

X Axis

The X Axis should be the series of dimensions that are being measured by your chosen measure. For example the profit and loss per department of your organisation, over a year. The series will show all departments and the effect they have on your companies revenue.

Measure

Use the Waterfall Chart to show the total sales through the year or just the profit to see which department or item is bringing in the best value. Add your measure here.

Tooltips

Format your link and node tooltip. Use the shortcodes and/or free text. You will see the list of available shortcodes you can use. How they are displayed in the box will be how you will see them in your tooltip.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234.

Font Size – Dimension

Use the dropdown menu to change the size of the font from 50% – 150%. Changing the font size will affect all fonts within your Waterfall Chart.

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Text Color & Header Color

Open the color palette to change the color of the text of the labels as well as all headers using the separate palette.

Node Label

Within the text box, enter what you wish to be displayed within your node labels. Format to get the best look for your Waterfall Chart. See above for tips.

Dashboard Actions

Dashboard actions are available within your Waterfall Chart! Choose one or multiple target sheets. Dashboard actions are supported to and from the extension.

Color

Click the ‘Use new color formatting’ checkbox to use the new color options. This will allow you to color by the values shown in your waterfall chart. Have the positive and negative stand out as well as coloring the totals.

Background color

Use the circle to open the color palette to change the background color of your Waterfall Chart. Use this to best match your dashboard color style.

Mark Colors

Use the circles to open the color palette to change the colors of the marks. The order they are in will be the order of your levels.

Format

Aggregate first category to a total

Total your first category by aggregating. This will give you your starting point to run through the series. This could be the total of the previous years sales to then compare to the current year. If you want to just see the progressive sales from the start, show all values with a separate total.

Show cumulative values

Here you have the options to show cumulative values of your dimension through your series of dimensions or to compare the values in the series to the previous category. You may need insight over one series of which products or departments are performing well or may need to see how those performed compared to the series before. Both possible here.

Options for totals

Show or hide totals within your Waterfall Chart. It may not be important to have a total in the view. A super cool feature is if any measure name or measure value is named ‘total’ they will be shown in the view.

Y-Axis Min (%)

Show Labels/X Axis/Y Axis

Show or hide your measure labels in your viz. Turn off the X and Y axis too.

Show Growth Percentages

A very useful feature of the Waterfall Chart is the growth percentages shown at the top of each dimension. Each is This can be shown or hidden if you just want the bar charts to show you the differences.

Rotate X-axis Label

Use the scroll bar to rotate the labels of your dimensions. Get your waterfall chart looking just how you want it.

X-Axis & Y Axis spacing

Condense or spread out the waterfall chart for a clearer chart or to save that valuable dashboard space 

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

Introduction

A Sankey Diagram visualizes the proportional flow between variables (or nodes) within a network. It is an excellent tool to get insights into the major transfers of flows within a system. However, what if we can add geographical attributes to the Sankey Diagram and visualize the flows on top of a map? It gives unprecedented insights into your data. This is the question triggered the development process of the Geo-Sankey.  The new ShowMeMore Geo-Sankey can provide you with a birds-eye view for better insights into your data.

How does it work?

The Geo-Sankey requires 6 dimensions and a measure. The measure shows the flow (value in the links) and the dimensions include source, target names and the coordinates. The width of the links and the radius of the nodes can be configured to represent the value. 

Example Use Case

We have created an example use to demonstrate how you can use the Geo-Sankey.  The large map on the left side of the screen is an instance of ShowMeMore with Geo-Sankey, on the right you have a bar chart with represents freight movement from different cities around the globe. The map above the bar chart shows country wise aggregated information of origin of freight movement.

All the visualizations are interactive with the Geo-Sankey where you can click on a country to see the freight movements from that country to different destinations.

This way of data visualization, with Geo-Spatial attributes, helps you tell a story by curating data in an easy-to-understand way, by highlighting trends and outliers, thereby unlocking the hidden insights in the available data. The visual reports generated by Geo-Sankey can be extremely interactive and allow for easy investigation of stopgaps and concerns of the business.

Configure the extension

Customize Geo-Sankey

Here is where we will be choosing the dimensions and measure you wish to see visualized in your Geo-Sankey. The dimensions will be the Source and Target with their Longitude and Latitude coordinates. Add a measure you wish to see shown represented in the flow. See how we’ve set ours up. Naming your fields correctly will help when configuring your data. 

Tooltips

Give your measure a suffix, for example adding a currency symbol. Add this here to see displayed in the tooltip.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234.

Font Size

Use the dropdown menu to change the size of the font from 50% – 150%

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Font Color

Clicking on the circle shapes will open the color palette. Customize your nodes, links and headers separately.

Node Labels

You can give your nodes a label to give users more insight, show the name of the dimension shown and the percentage of the source for example.

Dashboard Actions

Dashboard actions are available within your Geo-Sankey! Filter down on a dimension by clicking a node and see that interact instantly with your dashboard. It’s also possible to filter back from your tableau dashboard. Choose your target sheet(s) you wish to interact with.

Color

Here is where you colorize your Geo-Sankey. Set your Target and Source nodes using the color palette and decide how you will to color the links between them.

Format

Geo Sankey allows for many formatting options, here we will explain what each one offers.

Maximum link width

If you were to have many links within your viz it may be a good idea to reduce the maximum width of the links. Use the slider to choose your ideal maximum width.

Maximum Node Radius

Set the maximum size for your nodes. If there’s a condensed area of nodes, these may overlap and you’ll not be able to get clear insight from the view. Reduce the radius using the slider.

Horizontal node padding

Change the padding between nodes horizontally here. This will help with the spacing between nodes preventing as much overlapping as possible.

Link/Node Opacity

Change the link and node opacity separately using the sliders. The lower the number the more transparent they’ll be.

Node Border

Enable or disable a border on your nodes.

Zoom Level

Set the level you wished to be zoomed when the Geo-Sankey reloads. If your data is focused in a small area, increase the zoom level.

Show Paths

An important change will be whether to show the links from nodes at all time or just when you click on your desired node. A great formatting option use for different use cases.

Legend

Add a legend to your viz to show your users what the colors represent by using a legend. The clearer your viz, the better the user experience will be.

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

In the past we have been looking into ways to improve ShowMeMore Network Diagram, we found many customers who are extremely happy with the existing diagrams, and we have been receiving so many new ideas and suggestions to make it more amazing. So instead of completely revamping the existing Network Diagram we decided to go with a new one with more custom features for the ones who need little more. Here is Network Diagram 2.0!

Setting up your worksheet

For the best practice we recommend dropping all dimensions and measures on to the marks card. This will enable the best performance. The main components of the dataset will be a ‘source’, ‘target’ and a measure. For example your source may be the managers in your organization, the target being the employees they manage and the measure being the total sales. Group your dimensions and set them as your color. This will allow you to have a clear understanding of your network. See screenshot showing how our demo workbook has been set up.

Configure Screen

Select Data Sheet

Select the worksheet you want to retrieve data from. This worksheet will be the input for the visualization you pick in the next step.

Customize Network Diagram

This is where we will be connecting to your datasheet.

From Source

Choose your dimension from the dropdown menu to be your source. Within your network, these may be your managers for example who will then have links to their employees for example as their ‘target’. Fill ‘From Image URL’ with your source images.

To Target

Choose your dimension from the dropdown menu to be the target of your links with the source dimension. Fill ‘To Image URL’ with your Target images.

Color By

From the dropdown menu choose a dimension that will color the nodes in your Network diagram. You may, for example, have a certain group or department in your datasheet where certain employees are employed, these can be colored per group here. Colors can be chosen in the color segment of the configuration screen under ‘Mark Colors’ which will be discussed later on.

Group 

This is an optional dimension. If you have a group attribute for your nodes you can use this dimensions field to assign it to the network diagram. The group information will be used to create the convex hull (bubble-like polygons around the nodes belonging to the same group).

Measure

Choose your measure from the dropdown. Here you may wish to show how many employees are under a manager’s name, the larger the value the larger the node will be in the view.

Analytics Options

Store Custom Views! Network Diagram allows dashboard creators to store their custom view in their workbook settings or within a Tableau parameter. 

Custom View in settings

When activating storing custom view in settings, you will notice a save symbol appear on your viz. Save your diagram in your workbook settings once you’ve got it looking how you desired. Once saved this will be the default view every time you open your workbook, until you save again. 

Custom View in a Parameter

When choosing this option make sure you have a dedicated parameter created! Create a parameter of type string and name it so it’s recognizable when configuring here! Connect to your parameter, now all changes will be stored without having to save. 

When any changes to the viz are changed, they’ll be automatically saved to the parameter, if you wish to wipe the slate clean and start afresh you will see the unpin symbol, click here to reset your view.

Enable Analytics

Enable drill direction option

Here you can specify the drill direction. Drill direction determines the path the drill through action will take. The default is both ways. If you want to drill through the data in a different direction, you can change the drill direction here ( Available options are inward, outward and both ways)

Enable drill depth option

Here you can set the depth of your drill action, the depth determines how far your drill through action travels down the network diagram.

Dashboard Actions

Dashboard actions are available within your Network Diagram! Filter down on a dimension by clicking a node and seeing that interact instantly with your dashboard. It’s also possible to filter back from your tableau dashboard. You can do this as you would with your dashboard, by selecting ‘use as filter’ on your container.

Target sheets

Decide which sheets you wish the extension to trigger, all sheets that are available on your dashboard will be shown here. Multiple sheets can be triggered with a dashboard action.

Selected fields

Which field would you like the extension to trigger on? This can be the dimension chosen as your source or the target dimension. Decide which is the field you wish to be the trigger of the extension.

Refresh

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Network Diagram will reset including color palette, measures and columns. 

Color

Click the ‘Use new color formatting’ checkbox to use the new color options.

Background color

Use the circle to open the color palette to change the background color of your Network Diagram. Use this to best match your dashboard color style.

Color Mode

Choose between Color Nodes or Color Nodes and Links. Coloring just the nodes will leave the links grey.

Mark Colors

Use the circles to open the color palette to change the colors of the marks. The order they are in will be the order of your levels.

Select colors for dimensions: (New color formatting only)

Click on the color palette that’s alongside your chosen dimensions to choose their color. The new coloring format will improve your ease of use by seeing which dimension is represented by which color.

Format

Animations

Enable or disable animations in your diagram. Liven up your dashboard with animations in your Network Diagram. Grab a node to move and see all the target nodes linked.

Curved Lines

Choose between curved and straight lines by enabling or disabling curved lines. Decide which looks better in your dashboard.

Arrows

Arrows will show the direction of source to target. Enable or disable here. This may help with the direction of the link between each of the nodes.

Size Node

Decide whether the incoming or outbound values will size your node. For example it may be important to see how many employees report to a manager, here you would choose incoming values.

Node Distance

Change the distance from one node to another using the scroll bar. 300 being the biggest distance.

Node Size

Increase or decrease the size of your nodes, with 1 being the smallest & 5 the largest. All nodes will change in proportion. With less nodes available it may be beneficial to increase their size.

Link Size

Increase or decrease the width of your link, with 1 being the smallest & 5 the largest. Increase the stroke size to show clearer links.

Number of iterations when animations are disabled

Decide on how many iterations there will be when disabled. The iterations will help with the look by avoiding overlaps for example. To improve the performance try reducing the iterations.

Node/Link Opacity

Use the sliders to change the opacity of the Nodes and Links separately. Having a more transparent link will give a clearer view from your source to your target.

Border Width & Opacity

Change the style of your borders here by changing the width and opacity of the border. Style your nodes exactly how you want them.

Show Labels

Have labels shown always in your view, only when selected or always hidden. Labels give users more insight to what they’re seeing but it may not always be of use to have them in the viz at all times. Use the ‘Label Y Offset’ to change the position of the label.

Default Zoom Level

Some Network Diagrams may contain a large number of members. Change the default zoom level to ensure no members get cut off.

Show Image As

Choose from the many options to decide how you wish to see your URL image in the Network Diagram. Follow our GIF to see how the options effect our Network Diagram.

Position groups in quadrants

This option lets you choose different positioning types in your network diagram.

• Use Simulation will let the simulation mechanism choose the node size.
• Position on X-axis will expand the network diagram on the x-axis, and group attributes will be used to decide the order of nodes. 
• Similarly, position on Y-axis will expand the network diagram on the y-axis 

Analytics

The Network diagram 2.0 offers multiple features to analyse the network diagram like a highlighter and a drill through.

Highlighter

A fantastic new feature has dropped with our highlighter! In the top right corner, you can see the highlighter feature which you can use to highlight the nodes and links through a text search bar. Simply typing the name will highlight the node along with the connecting links. In a busy viz the highlighter will allow users to highlight their intended node whilst staying in the flow.

Drill-through

The Drill through feature allows you to navigate your data in an interactive way. The feature will enable you to visualize more detailed information within the network diagram. Drill through analysis is often confused with drill-down analysis as both practices are very similar. But, there is one main factor that makes them different. While drilling down provides granular information (https://appsfortableau.infotopics.com/drilldowntree/ ) within a specific chart or data set, however, drill throughs display another aspect of the data that might be relevant.

Network Diagram 2.0 offers two options to select the drill level and drill direction. The drill level defines how far your drill action propagates from the selected node. Drill direction defines in which direction you want the drill action to propagate; inward, outward, or both. For example, as the name suggests, the “inward” option highlights the nodes and paths which are coming to the selected node, and “outward” highlights the opposite.

Drill through analysis lets you see data from different points of view and navigate through data, and analyze it with different options. This greatly enhances the users’ understanding of the data and of the reasons behind the figures.

The drill through option can be used in two ways, one by setting a default configuration where the user will only be able to drill through a predefined direction and depth. Two, using the analytics pane where the user can change the drill direction and drill depth and explore the network. 

Drill through actions

A radar chart is a graphical method of displaying multivariate data in the form of a two-dimensional chart of three or more quantitative variables represented on axes starting from the same point. Visualize a persons characteristics or plot your department security assessment results in the characteristic spider web plot.

Setting up your datasheet

The ShowMeMore extension can connect to an existing visualization (or table) in your dashboard to retrieve the data. For best practice and performance however we recommend creating a dedicated datasheet for the ShowMeMore extension by dropping all dimensions and measures you want to use in your visualization on the details of the marks card. This will enable the best performance and allows dashboard actions to act on this dedicated datasheet. See screenshot showing how our demo workbook has been set up. For tips and advice check out our BLOG.

You do need to add the datasheet to your dashboard before ShowMeMore can use it, since the ShowMeMore extension is a Dashboard Object that retrieves data from another sheet in the dashboard. Once you added the blue squared datasheet to your dashboard you can hide it by making its container a floating container and resizing that container to 1×1 pixel. The datasheet has to remain on the dashboard!

Configure Screen

Select Data Sheet

Once you start configuring ShowMeMore, the extension automatically scans the dashboard for available sheets. Make sure you added your datasheet to the dashboard before opening the configuration screen. Don’t panic If you forgot to add the datasheet to the dashboard. Just close the configuration, add the datasheet to your dashboard and start the configuration again. Select the worksheet you want to retrieve data from (preferably your blue squared datasheet). This worksheet will be the input for the visualization you pick in the next step.

Customize Radar Chart

Dimension

Choose a dimension from the dropdown menu. This will show all the dimensions from your linked worksheet you’ve made available. We suggest no more than 3.

Axis

Choose a dimension from the dropdown menu which will act as your Radar Charts Axis. The dimension label will be on the outside of the circle. We suggest no more than 10 factors on you axis.

Color By

Choose a dimension from the dropdown menu that will color your Radar Chart. Choose the colors from the color menu within your configure pane. Using the correct color will help you differentiate one from the other.

Measure

Choose a measure you wish to use in your Radar Chart. The measure will show you how a dimension is doing in what areas allowing you to compare easily.

Tooltips

Format your link and node tooltip. Use the short codes as well as free text. You will see the list of available short codes you can use. How they are displayed in the box will be how you will see them in your tooltip.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234

Font Size Axis 

Change the size of the font within the axis of your Radar Chart. When you have multiple dimensions within your axis it may be useful to reduce the font size.  

Font Size Dimension 

Make your Dimension stand out around your Radar Chart by increasing the size of the font.  

Font Family 

Use the dropdown menu to change the font best to suit your dashboard. 

Font Color 

Clicking on the circles alongside the labels will open the color palette. Here you can separately change the font colors of your Axis, Dimension and Header! 

Dashboard Actions

Dashboard actions are available within your Radar Chart! Filter down on a dimension by clicking a node and see that interact instantly with your dashboard. Click the centre of your Radar chart to filter all nodes or click on nodes individually to filter. It’s also possible to filter back from your tableau dashboard.  

Refresh

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Radar Chart will reset including color palette, measures and columns. 

Color

Click the ‘Use new color formatting’ checkbox to use the new color options. This will allow you to color your dimensions, individually. When not using the new color formatting option, the Mark Colors will be colored by sorting order. This will allow you to customize your dashboard greatly!

Background color

Use the circle to open the color palette to change the background color of your Radar Chart. Use this to best match your dashboard color style.

Mark Colors

Use the circles to open the color palette to change the colors of the marks. The order they are in will be the order of your levels.

Select colors for dimensions: (New color formatting only)

Click on the color palette that’s alongside your chosen dimensions to choose their color. The new coloring format will improve your ease of use by seeing which dimension is represented by which color.

Format

Axis Labels

Enable the axis label to be shown in the view. It may be beneficial to have these turned off in the view for a larger chart in your dashboard.

Axis Measure Labels

Enable or disable your axis measure labels. Take these away will leave a clean chart where you may be able to compares your dimensions as an overview.

Tick Marks

Want a more detailed view of where you’re measures are in your Radar Chart? Add more tick marks by using the slider.

Background Opacity

Change the opacity of the gradient in your Radar Charts background. Allow your dimensions to stand out more.

Axis Opacity

Have the axis lines run clear through your chart, this may assist you in understanding your results better.

Area Opacity

Allow the measure labels to be shown through your axis by changing the opacity of the area for example.

Circles Radius

Change the size of the circle points.  With many points it may benefit you to have smaller circles in your view.

Stroke Width

Do you want thick or thin lines connecting your points? Change this here.

Axis Min Value

Set the minimum value to be shown in your view. It may be important to only show values at a certain level to get real value in your Radar Chart.

Axis Max Value

Set the maximum value to be shown in your view. You may want to compare over a range, you can easily do this here.

Reverse Axis

By default the values of the axis will start at 0 (zero) and show the numbers increasing to each axis, this can now be reversed to show the 0 (zero) value outside with the values increasing towards the centre. 

Show Average

An average can be shown in your viz, this will show the average of all of the values present in your viz to give you more insight to your viz. The average color can be changed to make it stand out.

Legend

To have a legend in your Radar Chart, tick the ‘Show legend’ button. When having a large selection of dimensions, it may be of benefit to use a color legend to display.

Legend Position

Choose where your legend will be. Left, Right, Top & Bottom. Every Radar Chart could be different, change to give your dashboard the best look.

Number of columns

Decide how many columns the color legend should show in your view. This will help with the look of your Radar Chart.

Horizontal shift

Use the slider to adjust the position horizontally of your Legend. Use this to get it in the perfect position.

Vertical shift

Use the slider to adjust the position vertically. This could allow you to have more text shown in your view. 

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

Tutorial

Click on this link for a tutorial on how to use the Radar Chart

A Venn Diagram is a diagram that visually displays all the possible logical relationships between a collection of sets. Each set is typically represented with a circle. Contained within each set is a collection of objects or entities that all have something in common. When sets overlap, it’s known as the intersection area. This is where entities that have all the qualities of the overlapping sets.

Setting up your datasheet

The Venn Diagram uses Tableau Sets to visualize overlap between sets. For tips and advice check out our BLOG. To get started you need to create two or more sets. In the example dashboard we used the Tableau Superstore demo dataset to create three sets:

1. My Top 30 customers based on Sales
2. My Top 45 customers based on Profit
3. My Top 25 customer based on Quantity

In Tableau these sets are created based on Customer ID like shown below

Drag these sets to the detail of your Marks pane and also add the countD of your Customer name or Customer ID as a measure. You will end up with a datasheet that looks like this

Configure Screen

Select Data Sheet

Select the worksheet you want to use as datasheet for your Venn diagram. This worksheet will be the input for the visualization (Venn Diagram) you pick in the next step.

Customize Venn Diagram

Choose the levels to be view in your Venn Diagram. Here you select the sets you want to be part of your Venn diagram (Top customers Sales, Top customers Profit and Top customers Quantity). The dimensions chosen will be visualized by overlapping spheres where its size is according by the measure chosen (number of unique customers). Use the dropdown menus to choose the specific sets and measure. Use the green ‘Add’ button if you want to add an extra set in your Venn Diagram.

Tooltips

Format your link and node tooltip. Use the short codes as well as free text. You will see the list of available short codes you can use. How they are displayed in the box will be how you will see them in your tooltip.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234.

Font Size

Use the dropdown menu to change the size of the font from 50% – 150%. Changing the font size will affect all fonts within your Venn Diagram.

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Font Color

Clicking on the circle shapes will open the color palette. Customise your nodes, links and headers separately.

Example configuration for Labels:

Aliases

Using aliases, it is possible to rename nodes to clearly communicate their definition without having to edit the name of the measure. Leaving a row empty will default to the measure name taken from de datasource.

Dashboard Actions

Dashboard actions are available within your Venn Diagram! Filter down on a dimension by clicking a node and see that interact instantly with your dashboard. It’s also possible to filter back from your tableau dashboard.

In the example dashboard I configured the Dashboard action like shown below:

This will trigger selection of a sphere or overlapping segment of the VENN diagram and act as a filter on the Target sheet (the Bar Chart with all customers).

Let’s say there is a dataset of customers who bought a car, a motorbike or a bicycle, and some of them bought more than 1 vehicle. When the checkbox is selected, clicking the outside part of the “car” dataset will select only the customers that bought a car, and no other vehicles. When the checkbox is not selected, clicking the “car” dataset will select all customers who bought a car, even those who also bought a motorbike and/or bicycle.

In the example below you can see that selecting a sphere or an overlapping segment of spheres will filter my customers to the ones that are part of the sets involved in my selection.

Refresh

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Venn Diagram will entirely reset including color palette, measures and columns. 

Color

Click the ‘Use new color formatting’ checkbox to use the new color options. This will allow you to color your dimensions, individually. When not using the new color formatting option, the Mark Colors will be colored by sorting order. This will allow you to customize your dashboard greatly!

Background color

Use the circle to open the color palette to change the background color of your Venn Diagram to blend it in perfectly with the rest of your dashboard.

Mark Colors

Use the circles to open the color palette to change the colors of the marks. The order they are in will be the order of your levels.

Select colors for dimensions: (New color formatting only)

Click on the color palette that’s alongside your chosen dimensions to choose their color. This will ensure that the set/dimension you choose always has the same coloring in the dashboard

Format

Circle Opacity

Set up the opacity to see all the overlaying circles clearly. Use the slider to change the opacity of the circles. 100 being full opacity 0 being no opacity.

Text Opacity

The text may stand out too much, here you can blend in to your diagram. Use the slider to change the opacity of the text. 100 being full opacity 0 being no opacity.

Border Width

Having a wider border may help to show each level clearer. Change the width of your boarder. 0 being the smallest, 10 being the biggest.

Border Opacity

Use the slider to change the opacity of the border. 100 being full opacity 0 being no opacity.

Legend

Add a legend to your viz to give some meaning to the colors displayed. Here you can change the layout, title and position of the legend to best suit your viz.

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

Tutorial

Click on this link for a tutorial on how to use the Venn Diagram

This type of visualisation shows how things are interconnected through the use of nodes / vertices and link lines to represent their connections and help illuminate the type of relationships between a group of entities. Start connecting the dots in your customer base or visualize team relationships with this viz type.

Setting up your worksheet

For the best practice we recommend dropping all dimensions and measures on to the marks card. This will enable the best performance. The main components of the dataset will be a ‘source’, ‘target’ and a measure. For example your source may be the managers in your organisation, the target being the employees they manage and the measure being the total sales. Group your dimensions and set them as your color. This will allow you to have a clear understanding of your network.  See screenshot showing how our demo workbook has been set up. For tips and advice check out our BLOG.

Configure Screen

Select Data Sheet

Select the worksheet you want to retrieve data from. This worksheet will be the input for the visualization you pick in the next step.

Customize Network Diagram

Source

Choose your dimension from the dropdown menu to be your source. Within your network these maybe your managers for example who will then have links to their employees for example as their ‘target’.

Target

Choose your dimension from the dropdown menu to be your target of your links with the source dimension.

Color By

From the dropdown menu choose a dimension that will color the nodes in your Network diagram. You may for example have certain group or department in your datasheet where certain employees are employed, these can be colored per group here. Colors can be chosen in the color segment of the configuration screen under ‘Mark Colors’ which will be discussed later on.

Measure

Choose your measure from the dropdown. Here you may wish to show how many employees are under a managers name, the larger the value the larger the node will be in the view.

Tooltips

Format your link and node tooltip. Use the shortcodes as well as free text. You will see the list of available shortcodes you can use. How they are displayed in the box will be how you will see them in your tooltip.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234

Font Size

Use the dropdown menu to change the size of the font from 50% – 150%

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Font Color

Clicking on the circle shapes will open the color palette. Nodes, Links and Headers can all be changed separately using their own palette.

Dashboard Actions

Dashboard actions are available within your Network Diagram! Filter down on a dimension by clicking a node and see that interact instantly with your dashboard. It’s also possible to filter back from your tableau dashboard. You can do this as you would with your dashboard, by selecting ‘use as filter’ on your container.

Target sheets

Decide which sheets you wish the extension to trigger, all sheets that are available on your dashboard will be shown here. Multiple sheets can be triggered with a dashboard action.

Selected fields

Which field would you like the extension to trigger on? This can be the dimension chosen as your source or the target dimension. Decide which is the field you wish to be the trigger of the extension.

Refresh

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Network Diagram will reset including color palette, measures and columns.

Color

Click the ‘Use new color formatting’ checkbox to use the new color options.

Background color

Use the circle to open the color palette to change the background colour of your Network Diagram. Use this to best match your dashboard color style.

Color Mode

Choose between Color Nodes or Color Nodes and Links. Coloring just the nodes will leave the links grey.

Mark Colors

Use the circles to open the color palette to change the colors of the marks. The order they are in will be the order of your levels.

Select colors for dimensions: (New color formatting only)

Click on the color palette that’s alongside your chosen dimensions to choose their color. The new coloring format will improve your ease of use by seeing which dimension is represented by which color.

Format

Animations

Enable or disable animations in your diagram. Liven up your dashboard with animations in your Network Diagram. Grab a node to move and see all the target nodes linked.

Curved Lines

Choose between curved and straight lines by enabling or disabling curved lines. Decide which looks better in your dashboard.

Arrows

Arrows will show the direction of source to target. Enable or disable here. This may help with the direction of the link between each of the nodes.

Size Node

Decide whether the incoming or outbound values will size your node. For example it may be important to see how many employees report to a manager, here you would choose incoming values.

Node Distance

Change the distance from one node to another using the scroll bar. 300 being the biggest distance.

Force

The force pushes the nodes from its closest node away. The larger the node, the stronger the push it will have. Adjust the slider to increase the force!

Node Size

Increase or decrease the size of your nodes, with 1 being the smallest & 5 the largest. All nodes will change in proportion. With less nodes available it may be beneficial to increase their size.

Link Size

Increase or decrease the width of your link, with 1 being the smallest & 5 the largest. Increase the stroke size to show clearer links.

Number of iterations when animations are disabled

Decide on how many iterations there will be when disabled. The iterations will help with the look by avoiding overlaps for example. To improve the performance try reducing the iterations.

Legend

To have a legend in your Network Diagram, tick the ‘Show legend’ button. When having a large selection of dimensions, it may be of benefit to use a color legend to display.

Legend Position

Choose where your legend will be. Left, Right, Top(color only) & Bottom (color only)

Number of columns

Add more columns in the text box to get the best look for your Network Diagram.

Horizontal shift

Use the slider to adjust the position or your legend horizontally

Vertical shift

Use the slider to adjust the position of your legend vertically

This type of visualization shows hierarchy through a series of rings, that are sliced for each category node. Each ring corresponds to a level in the hierarchy, with the central circle representing the root node and the hierarchy moving outwards from it. Rings are sliced up and divided based on their hierarchical relationship to the parent slice. The angle of each slice is either divided equally under its parent node or can be made proportional to a value.

Setting up your worksheet

For the best practice we recommend dropping all dimensions and your measure on to the marks card. This will enable the best performance. Your data should be organized with your hierarchical data. See screenshot showing how our demo workbook has been set up. For tips and advice check out our BLOG.

Configure Screen

Select Data Sheet

Select the worksheet you want to retrieve data from. This worksheet will be the input for the visualization you pick in the next step.  

Customize Sunburst Diagram

Choose the dimensions you wish to show in your Sunburst Diagram. Use the dropdown menu to select your dimension. The first chosen dimension will fill out the inner part of your Sunburst Diagram. Assign your chosen measure by clicking on the measure dropdown menu. Example: A book store would use a Sunburst Diagram to see sales per genre. The hierarchy could be ‘Genre’, ‘Sub-Genre’, ‘Topic’ etc. This is an ideal way of showing which genres have the best sales.

Tooltips

Format your link and node tooltip. Use the short codes as well as free text. You will see the list of available short codes you can use. How they are displayed in the box will be how you will see them in your tooltip.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234.

Font Size

Use the dropdown menu to change the size of the font from 50% – 150%. Changing the font size will affect all fonts within your Sunburst Diagram.

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Font Color

Clicking on the circle shapes will open the color palette. Nodes, Links and Headers can all be changed separately using their own palette.

Dashboard Actions

Dashboard actions are available within your Sunburst Diagram! Filter down on a dimension by clicking a node and see that interact instantly with your dashboard. It’s also possible to filter back from your tableau dashboard.

Target Sheet

Decide which sheets are triggered when using the extension. Multiple sheets may be chosen. It be important to target just a single sheet on the dashboard so this will offer huge value.

Refresh

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Sunburst Diagram will reset including color palette, measures and columns. 

Color

Click the ‘Use new color formatting’ checkbox to use the new color options. This will allow you to color your dimensions, individually. When not using the new color formatting option, the Mark Colors will be colored by sorting order. This will allow you to customize your dashboard greatly!

Background color

Use the circle to open the color palette to change the background color of your Chord Diagram.

Color By

Choose either having all values the same color or all to be colored by the ‘level 1’ values

Mark Colors

Use the circles to open the color palette to change the colors of the marks. The order they are in will be the order of your levels.

Select colors for dimensions: (New color formatting only)

Click on the color palette that’s alongside your chosen dimensions to choose their color. The new coloring format will improve your ease of use by seeing which dimension is represented by which color.

Format

Show Values

Have the values shown on your Sunburst Diagram. Some occasions it may be useful to only show certain labels in your view, disabling will allow you to hide the value.

Show labels below values

Format the labels by having them below the values. This may be useful if the values are the most important component of your diagram.

Show total in centre

Have a grand total shown in the centre of your Sunburst! A fantastic feature to see the total values within your Sunburst Diagram

Legend

To have a legend in your Sunburst Diagram, tick the ‘Show legend’ button. When having a large selection of dimensions, it may be of benefit to use a color legend to display.

Legend Position

Choose where your legend will be from the 6 options! Your Sunburst Diagram will autosize to fit the legend in the view.

Number of columns

Add more columns in the text box to get the best look for your Sunburst Diagram. You may prefer to have them in a row or on top of each other.

Horizontal shift

Use the slider to adjust the position horizontally of your Legend. Use this to get your legend in the perfect position.

Vertical shift

Use the slider to adjust the position vertically. This could allow you to have more text shown in your view. 

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

Tutorial

Click on this link for a tutorial on how to use the Sunburst Diagram

This type of diagram visualizes the inter-relationships between entities. The connections between entities are used to display that they share something in common. This makes Chord Diagrams ideal for comparing the similarities within a dataset or between different groups of data.

Setting up your worksheet

For the best practice we recommend dropping all dimensions and measures on to the marks card. This will enable the best performance. For tips and advice check out our BLOG. This visualization requires matrix data to work. For example A -> B, B ->A, A->A & B->B.  See screenshot showing how our demo workbook has been set up.

Configure Screen

Select Data Sheet

Select the worksheet you want to retrieve data from. This worksheet will be the input for the visualization you pick in the next step.

Customize Chord Diagram

Source

Choose your dimension from the dropdown menu to be your source. The source will link to your target dimension around the axis.

Target

Choose your dimension from the dropdown menu to be your target of your source dimension.

Measure

Choose your measure from the dropdown menu. Have a selection of measures loaded, once changed you will see an instant change to the Chord Diagram.

Tooltips

Format your link and node tooltip. Use the short codes as well as free text. You will see the list of available short codes you can use. How they are displayed in the box will be how you will see them in your tooltip.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234.

Font Size

Use the dropdown menu to change the size of the font from 50% – 150%. Changing the font size will affect all fonts within your Chord Diagram.

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Font Color

Clicking on the circle shapes will open the color palette. Nodes, Links and Headers can all be changed separately using their own palette.

Dashboard Actions

Dashboard actions are available within your Chord Diagram! Filter down on a dimension by clicking a node and see that interact instantly with your dashboard. It’s also possible to filter back from your tableau dashboard.

Refresh

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Chord Diagram will reset including color palette, measures and columns. 

Color

Click the ‘Use new color formatting’ checkbox to use the new color options. This will allow you to color your dimensions, individually. When not using the new color formatting option, the Mark Colors will be colored by sorting order. This will allow you to customize your dashboard greatly!

Background color

Use the circle to open the color palette to change the background color of your Chord Diagram.

Color By

Choose between having one color throughout your diagram or to colorize using the color palette.

Colorize Borders

Edit the border in your Chord Diagram. Change the color of your borders by colorizing them using the color palette or making them black or white.

Mark Colors

Use the circles to open the color palette to change the colors of the marks. The order they are in will be the order of your levels.

Select colors for dimensions: (New color formatting only)

Click on the color palette that’s alongside your chosen dimensions to choose their color. This will ensure that the set/dimension you choose always has the same coloring in the dashboard

Format

Axis

Have an axis shown around your Chord Diagram. Format the labels of your axis below.

Axis Step Size

Decide how many steps of the axis you wish to be shown in your view. 0 will show no labels with 10 showing the most possible. No labels will overlap.

Link Opacity

Change the opacity of your links. 100 being full opacity, 0 being no opacity.

Node Opacity

Change the opacity of your nodes. 100 being full opacity, 0 being no opacity.

Border Width

Change the width of your border.  10 being the widest, 0 will show no border.

Border Opacity

Change the opacity of your border.  100 being full opacity, 0 being no opacity.

Axis Opacity

Change the opacity of your axis.  100 being full opacity, 0 being no opacity.

Legend

To have a legend in your Chord Diagram, tick the ‘Show legend’ button. When having a large selection of dimensions, it may be of benefit to use a color legend to display.

Legend Position

Choose where your legend will be. Top Left, Top Right, Bottom Left & Bottom Right. Every Chord Diagram could be different, change to give your dashboard the best look.

Number of columns

Add more columns in the text box to get the best look for your Chord Diagram.

Horizontal shift

Use the slider to adjust the position of your legend horizontally.

Vertical shift

Use the slider to adjust the position vertically

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

Tutorial

Click on this link for a tutorial on how to use the Chord Diagram

A Ridgeline plot (sometimes called Joyplot) shows the distribution of a numeric value for several groups. Distribution can be represented using histograms or density plots, all aligned to the same horizontal scale and presented with a slight overlap.

Setting up your worksheet

For the best practice we recommend dropping all dimensions and measures on to the marks card. This will enable the best performance. See screenshot showing how our demo workbook has been set up. For tips and advice check out our BLOG.

Configure Screen

Select Data Sheet

Select the worksheet you want to retrieve data from. This worksheet will be the input for the visualization you pick in the next step. See setting up your worksheet to see the necessary components needed.

Customize Ridgeline Plot

Series

Choose the date series such as days or weeks that will be used in your view.

Category

Which category will be shown in the view? Use the dropdown to choose your dimension. These will be shown as rows displayed in your viz.

Measure

Use the dropdown to choose your measure. Example: SUM(Number of  records)

Tooltips

Format your link and node tooltip. Use the short codes as well as free text. You will see the list of available short codes you can use. How they are displayed in the box will be how you will see them in your tooltip.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234.

Font Size

Use the dropdown menu to change the size of the font from 50% – 150%. Changing the font size will affect all fonts within your Ridgeline Plot.

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Font Color

Clicking on the circle shapes will open the color palette. Nodes, Links and Headers can all be changed separately using their own palette.

Dashboard Actions

Dashboard actions are available within your Ridgeline Plot! Filter down on a dimension by clicking a node and see that interact instantly with your dashboard. It’s also possible to filter back from your tableau dashboard.

Refresh

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Ridgeline Plot will reset including color palette, measures and columns. 

Color

Click the ‘Use new color formatting’ checkbox to use the new color options. This will allow you to color your dimensions, individually. When not using the new color formatting option, the Mark Colors will be colored by sorting order. This will allow you to customize your dashboard greatly!

Background color

Use the circle to open the color palette to change the background color of your Ridgeline Plot.

Color By

Colorize Borders

Change the color of the borders using color, black or white.

Select colors for dimensions: (New color formatting only)

Click on the color palette that’s alongside your chosen dimensions to choose their color. This will ensure that the set/dimension you choose always has the same coloring in the dashboard

Format

Kernel bandwidth

Use the slider to change the Kernel bandwidth. Changing the bandwidth changes the shape of the kernel: a lower bandwidth means only points very close to the current position are given any weight, which leads to the estimate looking squiggly; a higher bandwidth means a shallow kernel where distant points can contribute.

Density Scale

Decide how sense you would like your scale to be by moving the slider. The peaks may not be seen as clear with low density, increasing the scale may help you.

Padding Top

The spikes in your Ridgeline Plot may be too large and will disappear off the top of your view. Change the padding using the slider to get the best fit.

Area Opacity

Use the slider to change the opacity. It’s likely many rows will overlap so get the best look using the slider to change the opacity. It’s possible to have full or no opacity.

Border Width

Change the width of your borders using the slider. You may use this to have no border in your plot.

Border Opacity

You may wish to have a strong border around your axis, change the opacity here using the slider.

Axis Opacity

The dimensions shown on your axis can have their opacity changed here by using the slider.

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

Tutorial

Click on this link for a tutorial on how to use the Ridgeline Plot

Horizon charts are an alternative to ridgeline plots and small-multiple area charts that allow greater precision for a given vertical space by using colored bands. These charts can also be used with diverging color scales to differentiate positive and negative values.

Data should also include the metric that you are monitoring.

For the best practice we recommend dropping all dimensions and measures on to the marks card. This will enable the best performance. A horizon chart relies on a date field, a dimension and a measure.  See screenshot showing how our demo workbook has been set up. For tips and advice check out our BLOG.

Configure Screen

Select Data Sheet

Select the worksheet you want to retrieve data from. This worksheet will be the input for the visualization you pick in the next step.

Customize Horizon Plot

DAY(Date)

Choose the dimension which holds the date field. Example: Years, Months.

Category

Use the dropdown to choose your category.  Example: State.

Measure

Use the dropdown to choose your measure. Example: (Sum)Difference from average.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234.

Font Size

Use the dropdown menu to change the size of the font from 50% – 150%. Changing the font size will affect all fonts within your Horizon Chart.

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Font Color

Clicking on the circle shapes will open the color palette. Nodes, Links and Headers can all be changed separately using their own palette.

Refresh

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Horizon Chart will reset including color palette, measures and columns. 

Color

Click the ‘Use new color formatting’ checkbox to use the new color options.

Background color

Use the circle to open the color palette to change the background colour of your Horizon Chart.

Select diverging color scheme: (New color formatting only)

Click on one of the schemes to color format your Horizon Chart. These are stored within your Horizon chart for you to choose.

Format

The amount of overlapping layers

Limit the number of overlapping layers across your Horizon Chart (maximum 5)

Labels

Choose to enable or disable the labels to be shown in view. The labels shown will be your chosen category in the view. These will be shown at the start of your chart rows.

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

Tutorial

Click on this link for a tutorial on how to use the Horizon Chart

The Circular Sankey Diagram visualizes the flow of a measure over multiple dimensions with internal loops. Sankey diagrams are a type of flow diagram in which the width/height of the arrows is proportional to the flow rate.

Setting up your worksheet

For the best practice we recommend dropping all dimensions and measures on to the marks card. This will enable the best performance. Your data should have a two dimensions (your source and target of the source) and a measure.  Your See screenshot showing how our demo workbook has been set up. For tips and advice check out our BLOG.

Configure Screen

Select Data Sheet

Select the worksheet you want to retrieve data from. This worksheet will be the input for the visualization you pick in the next step.

Customize Circular Sankey Diagram

Choose the dimensions you wish to show in your Sankey Diagram. Use the dropdown menu to select your dimension. The levels will be the order, from left to right, shown in your Sankey Diagram. Use the ‘Add’ button to add more levels. Assign your chosen measure by clicking on the measure dropdown menu.

Tooltips

Format your link and node tooltip. Use the short codes as well as free text. You will see the list of available short codes you can use. How they are displayed in the box will be how you will see them in your tooltip.

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.

Display Units (Decimal only)

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234.

Font Size

Use the dropdown menu to change the size of the font from 50% – 150%. Changing the font size will affect all fonts within your Circular Sankey Diagram.

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Font Color

Clicking on the circle shapes will open the color palette. Nodes, Links and Headers can all be changed separately using their own palette.

Label Editing

Format what is shown on your nodes, to and from them. You may add free text as well as using short codes from your data (Example: )  For extra formatting try using HTML like H1, IMG tags or Bold. Bold a word and reduce text sizing is available.

Node Label

Within the text box, enter what you wish to be displayed within your node labels. Format to get the best look for your Circular Sankey Diagram. See above for tips.

From Link Label

Next to each of your node labels, you will be able to display a label which can be entered within the text box. An example would to show the percentage of target. Example .

To Link Label

Have a label shown before your node labels. This could be useful to show a percent of your target. Use the text box to enter your information and see animated gif on how this will look when displayed.

Dashboard Actions

Dashboard actions are available within your Circular Sankey Diagram! Filter down on a dimension by clicking a node and see that interact instantly with your dashboard. It’s also possible to filter back from your tableau dashboard.

Refresh

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Sankey Diagram will reset including color palette, measures and columns. 

Color

Click the ‘Use new color formatting’ checkbox to use the new color options. This will allow you to color your dimensions, individually. When not using the new color formatting option, the Mark Colors will be colored by sorting order. This will allow you to customize your dashboard greatly!

Background color

Use the circle to open the color palette to change the background color of your Sankey Diagram.

Color By

Same values have the same colors

Where your dataset shows the same value, your Circular Sankey Diagram will display the same color. This can be helpful to show exact matches, within different categories.  When choosing this you will be presented with all the dimension members available, click on each palette to edit.

One color

Have a single color running through your diagram instead of multiple. The first color on your ‘Mark colors’ will be the color shown.

Color Links By

Here you can decide how you would like the links from your nodes to be colored by.

Circular – None Circular

The links will be greyed out

Input – Output (Gradient)

Links will show a gradient from input color to output.

Input

Links will be colored with the input nodes color.

Output

Links will be colored with the output nodes color.

Mark colors

The mark colors can be changed individually by clicking on each one to open the color palette. The order of the mark colors will be the order of the color of the nodes.

Select colors for dimensions: (New color formatting only)

Click on the color palette that’s alongside your chosen dimensions to choose their color. (This will only work when having ‘Same values have the same colors’ option selected.

Format

Node Width

Increase and decrease the width of your nodes using the slider. This will also change the size and shape of your links to in the view.

Vertical Node Padding

Increase and decrease the vertical padding using the slider. This will give the same space between each node (vertically)

Horizontal Node Padding

Increase and decrease the horizontal padding using the slider. This will give the same space between each node and the link.

Link Opacity

Increase and decrease the link opacity using the slider. 100 will give no opacity, 0 will give the most opacity.

Node Opacity

Increase and decrease the node opacity using the slider. 100 will give no opacity, 0 will give the most opacity.

Node Border

Hit ‘Enabled’ to give all your nodes a border.

Labels position

Decide the position of your nodes label being inside or outside your node.

Hide Nulls

Have the ability to hide all nulls by hitting ‘disabled’. The image is showing how you can have flows from column 1 to column 4 with nulls in columns 2 & 3. Nodes can also start and end on different levels.

Legend

To have a legend in your Sankey Diagram, tick the ‘Show legend’ button. When having a large selection of dimensions, it may be of benefit to use a color legend to display.

Legend Type

Choose between Color or Scale. Color will show the dimension alongside their color. The legend shows a reference bar with a specific value for referential purposes.  

Legend Position

Choose where your legend will be. Left, Right, Top(color only) & Bottom (color only). Every Circular Sankey Diagram could be different, change to give your dashboard the best look.

Legend order (Scale only)

Have the scale showing from High – Low or Low – high

Color (Scale only)

Use the circle to open the color pallet to change your scale color.

Number of columns

Decide how many columns the color legend should show in your view. This will help with the look of your Sankey Diagram.

Horizontal shift

Use the slider to adjust the position horizontally of your Legend. Use this to get it in the perfect position.

Vertical shift

Use the slider to adjust the position vertically. This could allow you to have more text shown in your view. 

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

Tutorial

Click on this link for a tutorial on how to use the Circular Sankey

The organization chart is a diagram showing graphically the relation of one official to another, or others, of a company. It is also used to show the relation of one department to another, or others, or of one function of an organization to another, or others. This chart is valuable in that it enables one to visualize a complete organization, by means of the picture it presents.

Setting up your worksheet

For the best practice we recommend dropping all dimensions and measures on to the marks card. This will enable the best performance. See screenshot showing how our demo workbook has been set up. For tips and advice check out our BLOG.

Configure Screen

Select Data Sheet

Select the worksheet you want to retrieve data from. This worksheet will be the input for the visualization you pick in the next step.

Customize Organization Chart

Choose the dimensions you wish to show in your Organization Chart. Use the dropdown menu to select your dimension. Add more dimensions to show more levels of your organization. Choose a measure to show within your chart.

Tooltips

Format your link tooltip & your node tooltip. Use the short codes as well as free text. Example: of to of

Labels

Number format

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes.

Display Units (Decimal only)

Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K

Use the tick box to include thousands separators. Example: 1234 – 1,234

Font Size

Use the dropdown menu to change the size of the font from 50% – 150%

Font Family

Use the dropdown menu to change the font best to suit your dashboard.

Font Color

Clicking on the circle shapes will open the color palette. Customize your nodes, links and headers separately.

Dashboard Actions

Choose which sheet(s) will be triggered when interacting with your Organization chart.

Refresh

Click refresh to retrieve the latest features! Refresh will reset your columns, measures and color palette

Color

Click the ‘Use new color formatting’ checkbox to use the new color options.

Background color

Use the circle to open the color palette to change the background color of your Organization Chart.

Color Mode

Color just your nodes or your links and nodes.

Mark Colors

Use the circles to open the color palette to change the colors of the marks. The order they are in will be the order of your levels.

Select colors for dimensions: (New color formatting only)

Click on the color palette that’s alongside your chosen dimensions to choose their color. This will ensure that the dimension you choose always has the same coloring in the dashboard.

Format

Layout

Decide between having a horizontal layout or a vertical.

Align

Change the alignment of the nodes! Centre, Left or right

Rotate labels

Starting at 0 use the slider to rotate your labels. Your label will turn clockwise 0 through 360.

Padding between nodes

Space out those nodes by using the slider 1-50. 1 being the closest and 50 being the farthest.

Node Size

Change the size of the node from 1-100. 1 being the smallest and 50 being the largest.

Link Size

Change the size of the node from 1-5. 1 being the smallest and 5 being the largest.

Node Opacity

Change the opacity of the node from 1-100. 1 having the most opacity and 100 having the least.

Link Opacity

Change the opacity of the link from 1-100. 1 having the most opacity and 100 having the least.

Zoom & Drag

Organizations can be large, with many hierarchies and even more personnel. Use the scroll wheel on your mouse to zoom in and out. There’s no issue in getting your whole organization in your visualization with easy zoom. Click anywhere away from the nodes and have free movement, to reset click the icon in the top right of your viz. 

Other

Export your visualization as a SVG. This will open a prompt box explaining how to export.

Tutorial

Click on this link for a tutorial on how to use the Organization Chart

Calendars as a visual tool are used to display periods of time and to display the organization of events. Periods of time are often displayed and divided into units such as days, weeks, months and years. A date is the designation of a single, specific day within such a system. 

Setting up your worksheet 

For the best practice we recommend dropping all measures on to the marks card. This will enable the best performance. It’s necessary to have a date field, add other measures which you can decide to show on your Calendar chart. See screenshot showing how our demo workbook has been set up. For tips and advice check out our BLOG.

Configure Screen 

Select Data Sheet 

Select the worksheet you want to retrieve data from. This worksheet will be the input for the visualization you pick in the next step. 

Customize Calendar Chart 

DAY(Date) 

Choose the measure that holds the dates from the dropdown list. 

Measure 

Decide the measure to be shown in your calendar. Change the measure to see the changes in your calendar instantly.   

Tooltips 

Format your link and node tooltip. Use the short codes as well as free text. You will see the list of available short codes you can use. How they are displayed in the box will be how you will see them in your tooltip.  

Labels 

Number format 

Format your measure to a decimal or a percentage using the dropdown menu. Enter the amount of decimal spaces shown under ‘decimals’. Add a ‘Prefix’ and/or a ‘Suffix’ in the text boxes. A prefix will go before the word and the suffix after. A prefix for example could add a currency ‘$’ and a Suffix could add a ‘%’.  

Display Units (Decimal only)  

Within your data there could be large values. Here you can format using separators. Use the dropdown menu to display numerical units. Example: 6,744 – 6.74K. Use the tick box to include thousands separators. Example: 1234 – 1,234.  

Font Size 

Use the dropdown menu to change the size of the font from 50% – 150% 

Font Family 

Use the dropdown menu to change the font best to suit your dashboard. 

Font Color 

Clicking on the circle shapes will open the color palette. Customize your nodes, links and headers separately. 

Dashboard Actions 

Dashboard actions are available within your Calendar Chart! Filter down on a dimension by clicking a node and see that interact instantly with your dashboard. It’s also possible to filter back from your tableau dashboard.  

Refresh 

Warning! We are continuously looking to improve our solutions, clicking refresh will give you the latest release with all the new features. Your Calendar Chart will reset including color palette, measures and columns.  

Color 

Click the ‘Use new color formatting’ checkbox to use the new color options. 

Background color  

Use the circle to open the color palette to change the background color of your Calendar Chart. 

Color Mode 

Color just your nodes or your links and nodes.  

Mark Colors 

Use the circles to open the color palette to change the colors of the marks. The order they are in will be the order of your levels. 

Select colors for dimensions: (New color formatting only) 

Click on the color palette that’s alongside your chosen dimensions to choose their color. In ‘Format’ when selecting ‘Diverging palette’ here you can decide the colors that will diverge.  

Format 

Color Palette 

Change the palette style between continuous and diverging. 

Other 

Export your visualization as a SVG. This will open a prompt box explaining how to export. 

Tutorial

Click on this link for a tutorial on how to use the Calendar Chart