Tableau(Control chart in tableau)

-

 

control charts in Tableau:

Control chart is a statistical tool used to determine if a manufacturing or business process is in a state of control. Control chart uses standard deviations above and below the mean, which are displayed as bands - with outliers identified using color.

Standard deviation is used to show how far a way data is from the mean. In this chart, the measure of standard deviation is used to identify outliers in the data. (Data points that differ significantly from other observations).

A control chart consists of:

  • Points representing measurements in samples taken from a process at different times.

  • The mean of all measurements in the sample.

  • A center line is drawn at the mean.

  • The control limits – UCL – the upper control limit and LCL – the lower control limit.

  • Signals – Outliers (any point outside the control limits)

  • Example of a control chart

    example of a control chart

    How to create a control chart in Tableau

    Create a simple timeline by dragging WEEK(Order Date) to the columns and SUM(Sales) to the rows shelf.

    Choose Line chart under marks card.

    simple timeline view

    Right-click on the y-axis and add a reference line showing the average value.

    adding a reference line at average

    Next, right click on the y-axis and add a reference distribution of +2 and -2 standard deviation.

    Alternatively, you can also use +3 and -3 or +1 and -1 standard deviation.

    adding a reference distribution

    Executing these results to.

    resulting control chart

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