Tableau(Dumbbell chart in tableau)

-

Dumbbell chart:

👉  Dumbbell charts use circles and lines to show changes over time. 

👉  This type of chart is ideal for illustrating and comparing change between groups.

👉   Specifically, the circles represent the starting and ending time periods, with a line between them, resembling a dumbbell.



Creating Dumbbell chart in tableau:

A dumbbell chart illustrates the change between two (or more) data points. To create a dumbbell chart on Tableau you will need to create a dual axis; one of the axes has a mark type of a line and the second axes has a mark type of a circle. Below is a step by step guide on how to create a dumbbell chart. In this example, I will use Sample – Superstore data to compare how regional category sales changes between 2015 to 2018.

1. Drag the Region and Category dimensions to rows and drag the Sales measure to columns

2. Change the default chart type on the marks shelf to a line

3. Then drag the Year(Order Date) dimension to Path on the mark shelf

4. Drag the Year(Order Date) dimension to the filters shelf, select Years and click 2015 and 2018

5. Drag the Sales measure to columns again, but this time change the second chart type to a circle

6. Left click on SUM(Sales) and select dual axis

7. Right click the top axis and deselect ‘show header’, then right click on the bottom axis to synchronise axis

8. On the marks shelf where the chart type is a circle, drag Year(Order Date) to colours

Comments

Post a Comment

Popular posts from this blog

String Functions in C Language(C Language)

-
  C String Functions There are many important string functions defined in "string.h" library. No. Function Description 1) strlen(string_name) returns the length of string name. 2) strcpy(destination, source) copies the contents of source string to destination string. 3) strcat(first_string, second_string) concats or joins first string with second string. The result of the string is stored in first string. 4) strcmp(first_string, second_string) compares the first string with second string. If both strings are same, it returns 0. 5) strrev(string) returns reverse string. 6) strlwr(string) returns string characters in lowercase. 7) strupr(string) returns string characters in uppercase. 8) strstr( st...
Read more

PHP Array Functions

-
  PHP  Array  Functions The array functions allow you to access and manipulate arrays. Simple and multi-dimensional arrays are supported. Function Description array() Creates an array array_column() Returns the values from a single column in the input array array_combine() Creates an array by using the elements from one "keys" array and one "values" array array_flip() Flips/Exchanges all keys with their associated values in an array array_pop() Deletes the last element of an array array_push() Inserts one or more elements to the end of an array array_replace() Replaces the values of the first array with the values from following arrays array_reverse() Returns an array in the reverse order array_search() Searches an array for a given value ...
Read more

Home Menu Options in Ms Word

-
Image
Microsoft Word Ribbon The following are the different options and tools listed in the Microsoft Word Ribbon for each of the tabs. Each section below is outlined first by the tab name, then by each section on the tab. Home tab                                    Undo Undo Typing  - Removes the last thing you typed. Repeat Typing  - If you accidentally hit undo typing, you can re-enter the previous text.                                      Clipboard Paste  - Pastes information from the  clipboard . Cut  - Removes information from the document and puts it in the clipboard. Copy  - Copies information from the document for the clipboard. Format Painter  - Applies formatting from another section of a docume...
Read more