Tableau (gnatt chart in tableau)

-

 

Gantt Chart:

👉  A Gantt chart is a project management tool that illustrates work completed over a period of time in relation to the time planned for the work. 
👉  It typically includes two sections: the left side outlines a list of tasks, while the right side has a timeline with schedule bars that visualize work.

Creating a Gantt Chart:

👉  Use Gantt charts to show the duration of events or activities.

👉  In a Gantt chart, each separate mark (usually a bar) shows a duration. For example, you might use a Gantt chart to display average delivery time for a range of products.

👉  To create a Gantt chart that shows how many days elapse on average between order date and ship date, follow these steps:

  1. Connect to the Sample - Superstore data source.

  2. Drag the Order Date dimension to Columns.

  3. On the Columns shelf, click the Year (Order Date) drop-down arrow, and then select Week Number.

    The column headers change. Individual weeks are indicated by tick marks because there are 208 weeks in a four-year span—too many to show as labels in the view.

  4. Drag the Sub-Category and Ship Mode dimensions to the Rows shelf. Drop Ship Mode to the right of Sub-Category.


  5. In the toolbar menu, click Analysis > Create Calculated Field. You can also right-click (Control-click on Mac) any field in the Data pane and select Create > Calculated Field.

  6. In the calculation dialog box, name your calculated field OrderUntilShip.

  7. Clear any content that's in the Formula box by default.

  8. In the Formula box, enter the following formula and then click OK:

    DATEDIFF('day',[Order Date],[Ship Date])

    The formula creates a custom measure that captures the difference between the Order Date and Ship Date values, in days.

  9. Drag the OrderUntilShip measure to Size on the Marks card.

  10. Right-click (Control-click on Mac) the SUM(OrderUntilShip) field on the Marks card, and then select Measure (Sum) > Average.

    We can make our data more readable by filtering down to a smaller time window.

  11. Hold down the Ctrl key (Option key on the Mac) and drag the Week(Order Date) field from the Columns shelf to the Filter shelf.


  12. In the Filter Field dialog box, select Range of Dates and then click Next.

  13. Set the range to a three-month time interval, such as 1/1/2013 to 3/31/2013, and then click OK.

  14. Drag the Ship Mode dimension to Color on the Marks card.


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

Object Instance Working with Strings

-
  Classes are nothing without objects.We can create multiple objects from a class. Each object has all the properties and methods defined in the class, but they will have different property values. An object of a class is created using the new keyword. Example: $bsc and $bzc is instances of the class Group: <?php class Group { public $name; function set_name($name) {     $this->name=$name; } function get_name; {     return $this->name; } } $bsc=new Group(); $bzc=new Group(); $bsc->set_name('BSC'); $bzc->set_name('BZC'); echo $bsc->get_name(; echo "<br>"; echo $bzc->get_name(); ?>
Read more