Tableau (highlight tables in tableau)

-

 

Highlight Tables


👉   Highlight tables display data in a text table. Using color, they speed up how you identify the most important numbers within a range of values. These tables also have rows and columns to depict different dimensions.

Highlight Tables 
  • The highlight table allows us to use conditional formatting to a view of a normal table.
  • Tableau will automatically apply a color scheme in either endless or stepped array of colors from highest to lowest.
  • It’s great for comparing a field’s values within a row or column.
  • Use highlight tables to match categorical data using color.
  • Highlight tables are often outstanding as they help users quickly spot the foremost interesting values during a table of numbers.
  • In cases where multiple variables are displayed, Measure Values are often used to apply one color scheme to all or any of the values in a table.
  • Unless the variables are very similar, highlighting multiple variables is typically not helpful and can mislead.
Creating Highlight table:

👉   In Tableau, you create a highlight table by placing one or more dimensions on the Columns shelf and one or more dimensions on the Rows shelf. You then select Square as the mark type and place a measure of interest on the Color shelf.

👉   To create a highlight table to explore how profit varies across regions, product sub-categories, and customer segments, follow these steps:

  1. Connect to the Sample - Superstore data source.

  2. Drag the Segment dimension to Columns.

  3. Drag the Region and Sub-Category dimensions to Rows, dropping Sub-Category to the right of Region.

  4. Drag the Profit measure to Color on the Marks card.


  5. Click Color on the Marks card to display configuration options. In the Border drop-down list, select a medium gray color for cell borders, as in the following image:

    Now it's easier to see the individual cells in the view:

  6. The default color palette is Orange-Blue Diverging. A Red-Green Diverging palette might be more appropriate for profit. To change the color palette and to make the colors more distinct, do the following:

    • Hover over the SUM(Profit) color legend, then click the drop-down arrow that appears and select Edit Colors.

    • In the Edit Colors dialog box, in the Palette field, select Red-Green Diverging from the drop-down list.

    • Select the Use Full Color Range check box and click Apply and then click OK.

      Output

Comments

Post a Comment

Popular posts from this blog

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

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

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